------=_Part_41574_9465410.1146743060398
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
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!
------=_Part_41574_9465410.1146743060398--
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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php