Re: optimizing indexes -mysql
| From: | Miles Thompson | Date: | Thu, 04 May 2006 17:02:55 +0000 |
| Subject: | Re: optimizing indexes -mysql | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-41817@lists.php.net to get a copy of this message | ||
At 08:44 AM 5/4/2006, blackwater dev wrote:
I just doubled the size of my MySQL db, is there a command I should run to re-index everything or is that automatic? Thanks!Well, it is automatic and MySQL does not need a lot of attention. Having said that, what table type(s) are you using, and what version of MySQL? And in the process of doubling were there a lot of deletions? If you have a lot of DELETEs in a MyISAM table, for instance, that space is maintained as a linked list until it can be re-used. Running OPTIMIZE TABLE against that will reclaim the space. This is really a question that should be asked on a list dedicated to MySQL. Regards - Miles Thompson -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.1.392 / Virus Database: 268.5.3/331 - Release Date: 5/3/2006