show 【session|global】 status;
mysql> show session status like 'Com_insert%'; +-------------------+-------+ | Variable_name | Value | +-------------------+-------+ | Com_insert | 0 | | Com_insert_select | 0 | +-------------------+-------+ 2 rows in set (0.00 sec) mysql> show session status like 'Com_select%'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | Com_select | 43 | +---------------+-------+ 1 row in set (0.00 sec) mysql> show session status like 'Com_update%'; +------------------+-------+ | Variable_name | Value | +------------------+-------+ | Com_update | 0 | | Com_update_multi | 0 | +------------------+-------+ 2 rows in set (0.00 sec) mysql> show session status like 'Com_delete%'; +------------------+-------+ | Variable_name | Value | +------------------+-------+ | Com_delete | 4 | | Com_delete_multi | 0 | +------------------+-------+ 2 rows in set (0.00 sec)
mysql> show global status like 'Com_delete%'; +------------------+-------+ | Variable_name | Value | +------------------+-------+ | Com_delete | 7 | | Com_delete_multi | 0 | +------------------+-------+ 2 rows in set (0.00 sec) mysql> show global status like 'Com_insert%'; +-------------------+-------+ | Variable_name | Value | +-------------------+-------+ | Com_insert | 8 | | Com_insert_select | 7 | +-------------------+-------+ 2 rows in set (0.00 sec) mysql> show global status like 'Com_update%'; +------------------+-------+ | Variable_name | Value | +------------------+-------+ | Com_update | 0 | | Com_update_multi | 0 | +------------------+-------+ 2 rows in set (0.00 sec) mysql> show global status like 'Com_select%'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | Com_select | 139 | +---------------+-------+ 1 row in set (0.00 sec)
mysql> show session status like 'InnoDB_rows%'; +----------------------+-------+ | Variable_name | Value | +----------------------+-------+ | Innodb_rows_deleted | 2 | | Innodb_rows_inserted | 4 | | Innodb_rows_read | 27 | | Innodb_rows_updated | 0 | +----------------------+-------+ 4 rows in set (0.00 sec) mysql> show global status like 'InnoDB_rows%'; +----------------------+-------+ | Variable_name | Value | +----------------------+-------+ | Innodb_rows_deleted | 2 | | Innodb_rows_inserted | 4 | | Innodb_rows_read | 27 | | Innodb_rows_updated | 0 | +----------------------+-------+ 4 rows in set (0.00 sec)
mysql> show global status like 'connections'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | Connections | 8 | +---------------+-------+ 1 row in set (0.00 sec) mysql> show session status like 'connections'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | Connections | 8 | +---------------+-------+ 1 row in set (0.00 sec)
mysql> show session status like 'Uptime'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | Uptime | 25002 | +---------------+-------+ 1 row in set (0.00 sec) mysql> show global status like 'Uptime'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | Uptime | 25014 | +---------------+-------+ 1 row in set (0.00 sec)
mysql> show global status like 'Slow_queries'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | Slow_queries | 0 | +---------------+-------+ 1 row in set (0.00 sec) mysql> show session status like 'Slow_queries'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | Slow_queries | 0 | +---------------+-------+ 1 row in set (0.00 sec)
如对本文有疑问, 点击进行留言回复!!
SSD原理及Pytorch代码解读——网络架构(二):特征提取网络及总体计算过程
集合类 ArrayList 和 LinkedList 直接用 Innodb(MySQL 5.0
网友评论