If I have an InnoDB table, how can I optimize it (like OPTIMIZE TABLE for MyISAM tables)? I've seen previous posts from Heikki saying to use ALTER TABLE, as that effectively dumps and reimports the table, but is that true with the new 3.23.50 version that actually has a working ALTER TABLE?
I ask because I have a long-running database and as records are getting inserted and deleted, system CPU usage is slowly climbing, presumably because MySQL is doing more work to look up information. Thanks, Philip * Philip Molter * Texas.net Internet * http://www.texas.net/ * [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
