On Thu, Oct 25, 2001 at 08:27:00AM -0700, Bill Adams wrote: > > At http://www.mysql.com/doc/ do a search for multiple processors. There's > > a refence to http://www.mysql.com/Downloads/Patches/linux-fork.patch that > > might help. > > And don't forget to make sure you have good/needed indexes. > (e.g See the manual entry on "EXPLAIN", run myisamchk -a, etc..). And make sure you're logging slow queries. Then take each of the logged queries (I log anything that takes more than two seconds) and run them through EXPLAIN to see where you could modify the query and/or change indexes. -- Michael T. Babcock CTO, FibreSpeed Ltd.
--------------------------------------------------------------------- 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
