mysql数据库参数show status(2007-04-25)

最新推荐文章于 2023-12-20 10:27:09 发布

sunnyaa

最新推荐文章于 2023-12-20 10:27:09 发布

阅读量112

点赞数

分类专栏：互联网技术文章标签： MySQL Cache

本文链接：https://blog.csdn.net/pujinguu/article/details/83908317

版权

互联网技术专栏收录该内容

28 篇文章 0 订阅

订阅专栏

mysql> show status like '%table%';
+-------------------------+----------+
|Variable_name | Value |
+-------------------------+----------+
|Com_alter_table |0 |
|Com_backup_table |0 |
|Com_create_table |0 |
|Com_drop_table |0 |
| Com_load_master_table |0 |
|Com_lock_tables |0 |
|Com_rename_table |0 |
|Com_restore_table |0 |
| Com_show_create_table |0 |
|Com_show_open_tables |0 |
|Com_show_tables |0 |
|Com_unlock_tables |0 |
| Created_tmp_disk_tables |0 |
|Created_tmp_tables |1 |
|Open_tables |510 |
|Opened_tables |0 |
| Slave_open_temp_tables |0 |
| Table_locks_immediate |12645624 |
|Table_locks_waited |2605 |
+-------------------------+----------+
19 rows in set (0.00 sec)

mysql> show status like '%Qca%';
+-------------------------+----------+
|Variable_name | Value |
+-------------------------+----------+
|Qcache_free_blocks |9277 |
|Qcache_free_memory | 43576824 |
|Qcache_hits | 16606663 |
|Qcache_inserts | 5974860 |
|Qcache_lowmem_prunes | 165442 |
|Qcache_not_cached | 259237 |
| Qcache_queries_in_cache |13438 |
|Qcache_total_blocks | 36359 |
+-------------------------+----------+
8 rows in set (0.00 sec)

mysql> show status like '%read%';
+-----------------------------------+--------------+
|Variable_name |Value |
+-----------------------------------+--------------+
|Com_ha_read |0 |
|Delayed_insert_threads |0 |
|Handler_read_first |0 |
|Handler_read_key |0 |
|Handler_read_next |0 |
|Handler_read_prev |0 |
|Handler_read_rnd |0 |
|Handler_read_rnd_next |29 |
| Innodb_buffer_pool_read_ahead_rnd |37028 |
| Innodb_buffer_pool_read_ahead_seq |563419 |
| Innodb_buffer_pool_read_requests |1224957470 |
|Innodb_buffer_pool_reads |985422 |
|Innodb_data_pending_reads |0 |
|Innodb_data_read | 169279442944 |
|Innodb_data_reads |1637481 |
|Innodb_pages_read |10331864 |
|Innodb_rows_read | 1178904493 |
|Key_read_requests | 2895525276 |
|Key_reads |1840704 |
|Slow_launch_threads |5 |
|Threads_cached |0 |
|Threads_connected |22 |
|Threads_created |2396716 |
|Threads_running |1 |
+-----------------------------------+--------------+
24 rows in set (0.00 sec)