Thursday, July 20, 2006

SHOW INNODB STATUS: LOG


---
LOG
---
Log sequence number 1039 3161691821
Log flushed up to 1039 3161691821
Last checkpoint at 1039 2401802667
0 pending log writes, 0 pending chkp writes
222872631 log i/o's done, 56.99 log i/o's/second



  • Log sequence number is the number of bytes written to the buffer pool.

  • Log flushed up to is the number of bytes that has been flushed or unflush (sequence number - log flushed up to)
  • Last checkpoint is a fuzzy line of what was flushed to logs ie recovery line for a crash (from my understanding).



Then there is some cool stats on log writes which should remain low.

Tuning


If you see more than 30% of log buffer size being unflushed (Log flushed up to) increase it if possible.

No comments: