>Please suggest how could I run benchmark on a live server. Please suggest if you have any alternatives.
Please don't run benchmarks on live master db servers, however you can use replication slave db server (if you have one) to run 'SELECTs' queries. You can you use mysqlslap to emulate client load for a MySQL server:
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.