Does Mysql provide any variable through which I can get the number of read and write queries served since server restart? Just want to estimate the Requests per second served by my db.
+1
A:
SHOW GLOBAL STATUS WHERE Variable_name = 'Com_insert';
SHOW GLOBAL STATUS WHERE Variable_name = 'Com_select';
More information can be found here.
Vitalii Fedorenko
2010-08-30 06:58:23
thanks. that helps
Pigol
2010-08-30 07:59:28