How many records do you have in your users table? How long does indexing take? And what are the smallest and largest ids? SELECT MIN(id), MAX(id) FROM users
-- Pat On 22/01/2011, at 12:42 AM, Z@M wrote: > > Mysql is taking 100% memory when i do rake ts:rebuild > also when i save the user model from console. > it eats up the /tmp memory and the system shows warning and ask for > disk cleanup > i am really worried about this behavior. > some body please help. > > > On Jan 20, 4:38 pm, "Z@M" <[email protected]> wrote: >> indexing index 'users_core'... >> ERROR: index 'users_core': sql_range_query: Incorrect key file for >> table '/tmp/#sql_ff2_0.MYI'; try to repair it (DSN=mysql:// >> root:***@localhost:3306/myname) >> >> What does this means ? >> I can't find the file '/tmp/#sql_ff2_0.MYI' >> How do i repair it ? > > -- > You received this message because you are subscribed to the Google Groups > "Thinking Sphinx" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/thinking-sphinx?hl=en. > -- You received this message because you are subscribed to the Google Groups "Thinking Sphinx" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/thinking-sphinx?hl=en.
