> Yes you are right.... > We lock tables to run this but only when we have problems. > One more thing I would do is run 'show processlist' and mail it to my self > to see how thing are going. > Simon > PS have you tried mytop?
No, I did not try mytop, but I'll give it a try now :) Another question: Neverminding the way I do the CHECK, ANALYZE and OPTIMIZE - how often should I do that? Would running OPTIMIZE every hour increase performance? Peter mysql, query --------------------------------------------------------------------- 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