- 论坛徽章:
- 0
|
先谢谢各位的帮忙.
我今天将innodb_buffer_pool_size 设置为 8G,跑了一上午,慢速日志还是出现一样的语句,用show innodb status\G显示如下.
Pending normal aio reads: 0, aio writes: 0,
ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0
Pending flushes (fsync) log: 1; buffer pool: 0
71653 OS file reads, 426117 OS file writes, 27753 OS fsyncs
0.29 reads/s, 16384 avg bytes/read, 18.03 writes/s, 1.22 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 400, seg size 402,
2248 inserts, 2248 merged recs, 2158 merges
Hash table size 17700857, used cells 9397133, node heap has 19762 buffer(s)
2039.54 hash searches/s, 1236.95 non-hash searches/s
---
LOG
---
Log sequence number 221 3279157966
Log flushed up to 221 3279148514
Last checkpoint at 221 3276184945
1 pending log writes, 0 pending chkp writes
309906 log i/o's done, 11.63 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 9289587267; in additional pool allocated 16793600
Dictionary memory allocated 154840
Buffer pool size 524288
Free buffers 404194
Database pages 100332
Modified db pages 1836
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages read 100156, created 176, written 124764
0.29 reads/s, 0.02 creates/s, 7.98 writes/s
Buffer pool hit rate 1000 / 1000
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
1 read views open inside InnoDB
Main thread process no. 1481, id 1168406848, state: flushing log
Number of rows inserted 19906, updated 138892, deleted 0, read 175776998
0.63 inserts/s, 4.83 updates/s, 0.00 deletes/s, 2271.45 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================
从日志上看,将innodb_buffer_pool_size调大好像没什么用...至少对于我的查询没什么帮助.还是要麻烦各位.
[ 本帖最后由 my997559 于 2009-9-30 16:04 编辑 ] |
|
免费注册
楼主: my997559
发表于 2009-09-29 18:53
发表于 2009-09-30 16:03
