Comment 2 for bug 693269

Revision history for this message
Vadim Tkachenko (vadim-tk) wrote : Re: [Bug 693269] [NEW] Add more information from LOG section to SHOW STATUS

Because it requires good amount of time to have all that parsed and added.
If you can provide FULL list of status variables that should be added, that may
help to get this happened.

On Tue, Dec 21, 2010 at 9:41 PM, Peter Zaitsev <email address hidden> wrote:
> Vadim,
>
> As I understand we see MySQL 5.5 is released and it does not add a lot of
> status values from show innodb status to show status
>
> Why do not we go over show innodb status and get list of all items which we
> want exported ?  It is probably easy enough to do it at once instead
> of in many bits and pieces ?
>
>
> On Tue, Dec 21, 2010 at 9:21 PM, Vadim Tkachenko <email address hidden>
> wrote:
>
>> Public bug reported:
>>
>> I'd like to have this stats from SHOW ENGINE INNODB STATUS
>> ---
>> LOG
>> ---
>> Log sequence number 122736736141
>> Log flushed up to   122735266123
>> Last checkpoint at  121662927923
>> Max checkpoint age    6957135914
>> Checkpoint age target 6739725417
>> Modified age          1054186954
>> Checkpoint age        1073808218
>> 0 pending log writes, 0 pending chkp writes
>> 295762 log i/o's done, 3201.80 log i/o's/second
>>
>> available in
>> SHOW STATUS
>>
>> For both 5.5 and 5.1
>>
>> ** Affects: percona-server
>>     Importance: Medium
>>     Assignee: Yasufumi Kinoshita (yasufumi-kinoshita)
>>         Status: Confirmed
>>
>> ** Changed in: percona-server
>>   Importance: Undecided => Medium
>>
>> ** Changed in: percona-server
>>       Status: New => Confirmed
>>
>> ** Changed in: percona-server
>>    Milestone: None => 5.5-20beta
>>
>> ** Changed in: percona-server
>>     Assignee: (unassigned) => Yasufumi Kinoshita (yasufumi-kinoshita)
>>
>> --
>> You received this bug notification because you are a member of Percona
>> developers, which is the registrant for Percona Server.
>> https://bugs.launchpad.net/bugs/693269
>>
>> Title:
>>  Add more information from LOG section to SHOW STATUS
>>
>> Status in Percona Server with XtraDB:
>>  Confirmed
>>
>> Bug description:
>>  I'd like to have this stats from SHOW ENGINE INNODB STATUS
>> ---
>> LOG
>> ---
>> Log sequence number 122736736141
>> Log flushed up to   122735266123
>> Last checkpoint at  121662927923
>> Max checkpoint age    6957135914
>> Checkpoint age target 6739725417
>> Modified age          1054186954
>> Checkpoint age        1073808218
>> 0 pending log writes, 0 pending chkp writes
>> 295762 log i/o's done, 3201.80 log i/o's/second
>>
>> available in
>> SHOW STATUS
>>
>> For both 5.5 and 5.1
>>
>>
>>
>
>
> --
> Peter Zaitsev, CEO, Percona Inc.
> Tel: +1 888 401 3401 ext 501   Skype:  peter_zaitsev
> 24/7 Emergency Line +1 888 401 3401 ext 911
>
> Percona Training Workshops
> http://www.percona.com/training/
>
> --
> You received this bug notification because you are a direct subscriber
> of the bug.
> https://bugs.launchpad.net/bugs/693269
>
> Title:
>  Add more information from LOG section to SHOW STATUS
>
> Status in Percona Server with XtraDB:
>  Confirmed
>
> Bug description:
>  I'd like to have this stats from SHOW ENGINE INNODB STATUS
> ---
> LOG
> ---
> Log sequence number 122736736141
> Log flushed up to   122735266123
> Last checkpoint at  121662927923
> Max checkpoint age    6957135914
> Checkpoint age target 6739725417
> Modified age          1054186954
> Checkpoint age        1073808218
> 0 pending log writes, 0 pending chkp writes
> 295762 log i/o's done, 3201.80 log i/o's/second
>
> available in
> SHOW STATUS
>
> For both 5.5 and 5.1
>
> To unsubscribe from this bug, go to:
> https://bugs.launchpad.net/percona-server/+bug/693269/+subscribe
>

--
Vadim Tkachenko, CTO, Percona Inc.
Phone +1-888-401-3403,  Skype: vadimtk153
Schedule meeting: http://tungle.me/VadimTkachenko