Does Mysql provide any variable through which I can get the number of read and write queries served since s开发者_开发技巧erver restart? Just want to estimate the Requests per second served by my db.
SHOW GLOBAL STATUS WHERE Variable_name = 'Com_insert';
SHOW GLOBAL STATUS WHERE Variable_name = 'Com_select';
More information can be found here.
精彩评论