Re: How to find the no of Inserts and selects

2006-08-28 Thread Praj
mysql> show status like 'com_update'; +---+---+ | Variable_name | Value | +---+---+ | Com_update| 0 | +---+---+ 1 row in set (0.00 sec) mysql> show status like 'com_insert'; +---+---+ | Variable_name | Value | +--

How to find the no of Inserts and selects

2006-08-28 Thread Ratheesh K J
Hello all, I need to find out to some point of accuracy the ratio of Number Inserts/Updates to that of Selects. This is because we are thinking of setting up a Replication sysytem with one master and one slave. Now replication would be optimal only if there if the Select queries are dominating,