Hello to All
This i grep from mysql with command show innodb status; is any
things error or have to modified ? user arround 2K with 8Gb ram Quad Core
CPU take this snapshot on peak time... and high traffic
--------
FILE I/O
--------
I/O thread 0 state: waiting for i/o request (insert buffer thread)
I/O thread 1 state: waiting for i/o request (log thread)
I/O thread 2 state: waiting for i/o request (read thread)
I/O thread 3 state: waiting for i/o request (write thread)
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: 0; buffer pool: 0
61168 OS file reads, 1123401 OS file writes, 568696 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 8.77 writes/s, 2.91 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 3, seg size 5,
277 inserts, 277 merged recs, 94 merges
Hash table size 10624987, used cells 1495954, node heap has 2379 buffer(s)
281.31 hash searches/s, 246.08 non-hash searches/s
---
LOG
---
Log sequence number 2 1887995420
Log flushed up to 2 1887995420
Last checkpoint at 2 1887978254
0 pending log writes, 0 pending chkp writes
397643 log i/o's done, 1.50 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 5986025278; in additional pool allocated 12776960
Buffer pool size 327680
Free buffers 0
Database pages 325301
Modified db pages 61
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages read 65491, created 376929, written 1256434
0.00 reads/s, 0.09 creates/s, 8.36 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. 8107, id 1173395776, state: sleeping
Number of rows inserted 1183858, updated 329127, deleted 142409, read
1310553240
2.55 inserts/s, 1.18 updates/s, 0.09 deletes/s, 3094.27 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================
_______________________________________________
DBmail mailing list
DBmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail
