-----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 more time for disk % operations. % % Details: http://www.mysql.com/doc/en/OPTIMIZE_TABLE.html Very interesting. A) Is this the sort of thing that people do from a cron job to make sure that they don't have too much fragmentation? Does it actually show up more than once in a milennium for most people? B) What about the postscript at that URL describing problems with this command? 1) Are there still problems? 2) Is there yet any concrete data on the problems? a) Is it repeatable and deterministic or still an unknown target? b) Is it better to OPTIMIZE more often, and thereby make little optimizations, to avoid such problems, or is any OPTIMIZE a game of roulette and so one should do it only when absolutely needed? 3) What does one do if one has a fragmented table and yet cannot optimize it because of said problems? TIA & HAND mysql query, :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, "Science and Health" http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE+SkVeGb7uCXufRwARAmgVAJ44GYFx97PSP1M91WLzM4QVtuhD6wCeIrv4 Fk3EjXnXauthotttSlAA5eA= =ciJb -----END PGP SIGNATURE----- --------------------------------------------------------------------- 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
