How have these records been created? Via fixtures? http://freelancing-god.github.com/ts/en/common_issues.html#slow_indexing
And how long does indexing take? -- Pat On 22/01/2011, at 6:24 PM, Z@M wrote: > 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. > -- 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.
