Indexing hangs system shows memmory is full and ask for a disk cleanup then i will kill the process . if i wait for say 10 mts it shows this error 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)
When i created a new db and migrated the schema and start using it from scratch it works fine . i dont know whats created the problem last time . when the system says memmory full . i went and checked the db/sphinx folder size it was less than few mbs so i wonder where the sphinx is storing the index. On Jan 22, 4:24 pm, Pat Allan <[email protected]> wrote: > 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 > > 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.
