[aspseek-users] Re[2]: [aseek-users] Clearing database...

[Muzaffar M. <ad...@fl...>]

When you connect to localhost, it connects through socket by default.

-- 
 Muzaffar                            mailto:ad...@fl...

Friday, January 16, 2004, 8:17:25 PM, you wrote:


FK> thanks for the answer.
FK> this was because aspseek's tables were corrupted...
FK> myisamchk corrected the tables and released that missing 30% of disk
FK> space, but... aspseek database became totally unusable :(
FK> this time i will use _only_ innodb tables because of reliability.

FK> one more question: how can i connect to mysql server through socket
FK> rather than tcp?
FK> please answer if anyone knows, thank you.

>> Try optimizing the tables. At the mysql prompt type:
>>
>> optimize table xxxx;
>>
>> xxxx would be the table you want to optimize. There are a lot of 
>> tables. To get a list of tables for your aspseek simply login to mysql
>> with that user and type:
>>
>> show tables;
>>
>> Then just start going through the list.
>>
>> Regards,
>> John
>>
>>> Hello,
>>>
>>> When i partly clear the database with index -C -u 
>>> 'http://server.com%', size of the database does not decrease;
>>> even after i removed about 30% of total urls, size remained the same...
>>> why?
>>>
>>> thank you.
>>>
>>>
>>