Re: Query statistics

[laalesh gurram]

Hi kalyan,

1) Total number of SELECT queries that hit to the server.
Check Com_select status variables

2) Total number of INSERT queries that hit to the server.
Check Com_Insert status variables
3) Total number of UPDATE queries that hit to the server.
Check Com_Update status variables

4) Total number of DELETE queries that hit to the server.
Check Com_Delete status variables

Add Global keyword to get the global count of queries. Unless you will get the session count.

Thanks & Regards
Laalesh.