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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
