thanks for the answer.
this was because aspseek's tables were corrupted...
myisamchk corrected the tables and released that missing 30% of disk space, but... aspseek database became totally unusable :(
this time i will use _only_ innodb tables because of reliability.
one more question: how can i connect to mysql server through socket rather than tcp?
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.
