Replicating a live setup, especially one running on the web is extremely
difficult if not near impossible. Assuming you don't have the freedom to
stop/start your mysqld for tuning/tweaking, here are some things you can
do:
- Enable slow-query-log
- Enable query log
- Query processlist periodically and save results where queries have been
processing for X amount of time
With this information you can profile your queries and use 'EXPLAIN
<query>' to optimize where needed, aka adding indexes, etc.
I simply haven't found it worth it to replicate live setups in order to
look for bottlenecks. It's much easier and less time consuming to do
things like above and generally being in tune with your system. Setting up
performance graphs based on your system or mysqld performance is worth the
time.
Atle
-
Flying Crocodile Inc, Unix Systems Administrator
