All, MySQL is coming out with a new query analyzer and it's currently in beta/trial mode. It will be a commercial product, but the following link contains some very generally useful information on optimizing MySQL - or the "black art" as it's often called.
http://forums.mysql.com/read.php?166,219045 The trial version is also available. I'll be playing around with it as time permits, as well as reviewing the information provided at the above link. I'm interested in discussing people's thoughts and experiences in performance tuning, as this is something I'm faced on a regular basis as well. --- Hans Zaunere / Managing Member / New York PHP www.nyphp.org / www.nyphp.com _______________________________________________ New York PHP Community MySQL SIG http://lists.nyphp.org/mailman/listinfo/mysql NYPHPCon 2006 Presentations Online http://www.nyphpcon.com Show Your Participation in New York PHP http://www.nyphp.org/show_participation.php
