MySQL DBA刚入职时如何快速拥抱新的环境(二)
------- ---------
20 0 0 0
NULL 1 1 0 0
--这部分的内容来自 show processlist 、我们先看看未经过统计的 show processlist的 内容、如下：
--
mysql> show processlist;
+------+---------+---------------------+------+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+------+---------+---------------------+------+---------+------+-------+------------------+
| 1508 | shaoyun | 130.84.225.124:4373 | cdio | Sleep | 3523 | | NULL |
| 1510 | shaoyun | 130.84.225.124:4385 | cdio | Sleep | 2322 | | NULL |
| 1513 | shaoyun | 27.161.68.106:2585 | NULL | Sleep | 7866 | | NULL |
| 1514 | shaoyun | 27.161.68.106:2586 | NULL | Sleep | 7866 | | NULL |
| 1522 | shaoyun | 27.161.68.106:3107 | NULL | Sleep | 6861 | | NULL |
| 1529 | root | localhost | cdio | Sleep | 4426 | | NULL |
| 1557 | root | localhost:59459 | cdio | Sleep | 7 | | NULL |
| 1579 | shaoyun | 165.77.122.42:56966 | cdio | Sleep | 433 | | NULL |
| 1580 | root | localhost | cdio | Sleep | 239 | | NULL |
| 1582 | shaoyun | 27.161.68.126:5640 | cdio | Sleep | 164 | | NULL |
| 1583 | root | localhost | NULL | Query | 0 | NULL | show processlist |
+------+---------+---------------------+------+---------+------+-------+------------------+
--不难看出、这是对每一列都做了统计
㈣ 第四部分
# Status Counters (Wait 10 Seconds) ##########################
Variable Per day Per second 295 secs
Bytes_received 90000000 1000 4000
Bytes_sent 600000000 7000 22500
Com_admin_commands 1
Handler_rollback 80
Handler_update 6000
Handler_write 20000 5
Innodb_buffer_pool_pages_flushed 2250 1
Innodb_buffer_pool_read_requests 2250000 25 125
Innodb_buffer_pool_reads 800
Innodb_buffer_pool_write_requests 10000 7
Innodb_data_fsyncs 1250
Innodb_data_read 15000000 175 100
Innodb_data_reads 900
Innodb_data_writes 2000 1
Innodb_data_written 40000000 450 25000
Innodb_dblwr_pages_written 1250
Innodb_dblwr_writes 150
Innodb_log_write_requests 1750 1
Innodb_log_writes 600
Innodb_os_log_fsyncs 700
Innodb_os_log_written 1000000 10 600
--这部分内容取自 show global status 、仅收集哪些变化的量
--比较有价值的应该是第三列、取自两张快照、除以变化量、算出每秒的变化
㈤ 第五部分
# Table cache ################################################
Size | 64
Usage | 100%
--显示表缓存的大小、Usage表示在用百分比、这是个近视值
㈥ 第六部分
# Plugins ####################################################
InnoDB compression | ACTIVE
--显示指定的插件程序