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