Comment 1 for bug 693269

Revision history for this message
Peter Zaitsev (pz-percona) wrote : Re: [Bug 693269] [NEW] Add more information from LOG section to SHOW STATUS

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/