show processlist：
| Id | User | Host | db | Command | Time | State | Info | Time_ms | Rows_sent | Rows_examined |
+-----+-----------------+---------------------+--------------------+---------+------+------------------------+------------------------------------------------------------------------------------------------------+---------+-----------+---------------+
| 8 | event_scheduler | localhost | NULL | Daemon | 2298 | Waiting on empty queue | NULL | 2297217 | 0 | 0 |
| 292 | root | 172.16.224.81:64748 | baiduzx_project | Sleep | 454 | | NULL | 453909 | 17 | 264 |
| 355 | root | 172.16.224.81:57173 | information_schema | Sleep | 354 | | NULL | 353411 | 0 | 0 |
| 383 | root | localhost | baiduzx_project | Query | 0 | init | show processlist | 0 | 0 | 0 |
| 392 | root | localhost | baiduzx_project | Query | 3 | executing | SELECT COUNT(*) FROM(select a.Acc_authorize ,a.Acc_SF_FirstName ,a.Acct_Cust_Name ,a.ID,a.Acc_ISTop | 2638 | 0 | 0 |
+-----+-----------------+---------------------+--------------------+---------+------+----
show engine innodb status\G：
I/O sum[96]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 61
Buffer pool size 81915
Buffer pool size, bytes 1342095360
Free buffers 4000
Database pages 77915
Old database pages 28741
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 1210, not young 235385
0.00 youngs/s, 0.00 non-youngs/s
Pages read 300, created 111123, written 162805
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 77915, unzip_LRU len: 0
I/O sum[96]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 62
Buffer pool size 81915
Buffer pool size, bytes 1342095360
Free buffers 4000
Database pages 77915
Old database pages 28741
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 930, not young 171179
0.00 youngs/s, 0.00 non-youngs/s
Pages read 131, created 104693, written 159256
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
No buffer pool page gets since the last printout
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 77915, unzip_LRU len: 0
I/O sum[96]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 63
Buffer pool size 81915
Buffer pool size, bytes 1342095360
Free buffers 4000
Database pages 77915
Old database pages 28741
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 1047, not young 180376
0.00 youngs/s, 0.00 non-youngs/s
Pages read 279, created 110115, written 164332
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
No buffer pool page gets since the last printout
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 77915, unzip_LRU len: 0
I/O sum[96]:cur[0], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS |
