Did you load your data via fixtures? Try adding the following to your
config/sphinx.yml file (create it if it doesn't exist):
development:
sql_range_step: 10000000
Cheers
--
Pat
On 24/01/2011, at 5:44 PM, Z@M wrote:
>
> 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.
>
--
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.
