- 论坛徽章:
- 0
|
這是我部份的innodb status
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 1692, seg size 1694,
0 inserts, 0 merged recs, 0 merges
Hash table size 8850487, node heap has 469 buffer(s)
331.36 hash searches/s, 501.37 non-hash searches/s
---
LOG
---
Log sequence number 31 2167340869
Log flushed up to 31 2167339787
Last checkpoint at 31 1817278955
0 pending log writes, 0 pending chkp writes
880839 log i/o's done, 89.08 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 2330217576; in additional pool allocated 8331264
Dictionary memory allocated 853680
Buffer pool size 131072
Free buffers 63273
Database pages 67319
Modified db pages 17287
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages read 60643, created 6676, written 172809
0.67 reads/s, 1.45 creates/s, 1.93 writes/s
Buffer pool hit rate 1000 / 1000
--------------
ROW OPERATIONS
--------------
2 queries inside InnoDB, 0 queries in queue
2 read views open inside InnoDB
Main thread process no. 6620, id 685824912, state: sleeping
Number of rows inserted 2510707, updated 280021, deleted 2463653, read 871433433
303.64 inserts/s, 29.15 updates/s, 298.51 deletes/s, 1066971.10 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================
1 row in set, 1 warning (0.01 sec)
ERROR:
No query specified
是设了2G,但是top的时候,RES只有1.2G,VIRT是2387m
另外一台机器是RES 2.2G,VIRT是2385m,上面的那台比这台负载高很多 |
|