Ciprian, > I am using PhpMyAdmin and today I got a red message saying that one > table has overhead and I need to optimize the table. > This is the first time I got this message, I looked online and I > understood why it shows. But my question is: can I do something to avoid > it? What effects daoe the overhead have on a table?
MyISAM tables (the default table type in MySQL) become fragmented when you delete records (this can even happen when you update records, if your table format is dynamic). You cannot avoid this effect if you're using MyISAM tables. If you don't optimize fragmented MyISAM tables, they will become slow to scan because the operating system will need more time for disk operations. Details: http://www.mysql.com/doc/en/OPTIMIZE_TABLE.html Regards, -- Stefan Hinz <[EMAIL PROTECTED]> iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 --------------------------------------------------------------------- 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
