# Trying to understand show innodb status

**URL:** <https://forums.percona.com/t/trying-to-understand-show-innodb-status/723>\
**Category:** Other MySQL® Questions\
**Created:** [April 19, 2008, 2:00am UTC](https://forums.percona.com/t/trying-to-understand-show-innodb-status/723 "2008-04-19T02:00:12Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![newtomysql](https://avatars.discourse-cdn.com/v4/letter/n/a183cd/32.png) [@newtomysql](https://forums.percona.com/u/newtomysql)\
**Post date:** [April 19, 2008, 2:00am UTC](https://forums.percona.com/t/trying-to-understand-show-innodb-status/723/1 "2008-04-19T02:00:12Z")

</div>

Dear All,  
I have typed this command of show innodb status. So I dont quite get the values as I am trying to understand the log section. My values are as below I dont understand for loq sequence, log flush and checkpoint got 2 number 0 and 76508130. So what does both that value reprsents ? Thanks.

Log sequence number 0 76508130  
Log flushed up to 0 76508130  
Last checkpoint at 0 76508130  
0 pending log writes,  
0 pending chkp writes  
8 log i/o’s done,  
0.00 log i/o’s/second

---

<div class="post-metadata">

**Author:** ![debug](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/debug/32/772_2.png) [@debug](https://forums.percona.com/u/debug)\
**Post date:** [April 28, 2008, 6:14am UTC](https://forums.percona.com/t/trying-to-understand-show-innodb-status/723/2 "2008-04-28T06:14:14Z")

</div>

Please see this post: [http://www.mysqlperformanceblog.com/2006/07/17/show-innodb-s](http://www.mysqlperformanceblog.com/2006/07/17/show-innodb-s) tatus-walk-through/  
Hope that it helps.

---

<div class="post-metadata">

**Author:** ![newtomysql](https://avatars.discourse-cdn.com/v4/letter/n/a183cd/32.png) [@newtomysql](https://forums.percona.com/u/newtomysql)\
**Post date:** [April 28, 2008, 8:30am UTC](https://forums.percona.com/t/trying-to-understand-show-innodb-status/723/3 "2008-04-28T08:30:25Z")

</div>

Dear Debug,  
I have gone through the site before. I have read through but I am still quite confuse. I would just like to check with you. So in my case Log sequence number 0 76508130 means 0 byte written to my log file is it? How about the value 76508130 what doest it represents? So when will the log file will be written ? Thanks.
