mysql>show global status like 'Questions';
show global status like 'Uptime';
show global status like ‘Com_commit';
show global status like 'Com_rollback';
show global status like 'Uptime';
show global status where Variable_name in('com_select','com_insert','com_delete','com_update');
-
show global status where Variable_name in('com_insert','com_delete','com_update');
开启慢查询日志:
mysql> set global slow-query-log=on #开启慢查询功能