Re: mysql overhead

2003-02-12 Thread David T-G
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Stefan, et al -- ...and then Stefan Hinz said... % % MyISAM tables (the default table type in MySQL) become fragmented ... % % If you don't optimize fragmented MyISAM tables, they will become slow % to scan because the operating system will need mor

Re: mysql overhead

2003-02-11 Thread Stefan Hinz
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 da

mysql overhead

2003-02-11 Thread Ciprian I. Acatrinei
Hi, 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 overhea

MYSQL Overhead

2002-12-17 Thread John Chang
In some of my tables I see overheard. What does it mean and does it mean I have to optimize it every time? I seem to see it everyday. SQL - Before posting, please check: http://www.mysql.com/manual.php (the manual) http: