Add more information from LOG section to SHOW STATUS
Bug #693269 reported by
Vadim Tkachenko
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
Fix Released
|
Medium
|
Unassigned |
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
available in
SHOW STATUS
For both 5.5 and 5.1
Changed in percona-server: | |
assignee: | nobody → Yasufumi Kinoshita (yasufumi-kinoshita) |
importance: | Undecided → Medium |
milestone: | none → 5.5-20beta |
status: | New → Confirmed |
description: | updated |
Changed in percona-server: | |
status: | Confirmed → In Progress |
Changed in percona-server: | |
status: | Fix Committed → Fix Released |
To post a comment you must log in.
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: kinoshita) kinoshita) /bugs.launchpad .net/bugs/ 693269
>
> 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-
> 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-
>
> --
> You received this bug notification because you are a member of Percona
> developers, which is the registrant for Percona Server.
> https:/
>
> 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 www.percona. com/training/
http://