i have very few records . < 50 On Jan 22, 6:46 am, Pat Allan <[email protected]> wrote: > 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 > > athttp://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.
