Need an InnoDB logs graph with checkpoint versus flush data

[GoogleCodeExporter]

I would love to have these three things on a graph by themselves:

Log sequence number 0 618313
Log flushed up to   0 618313
Last checkpoint at  0 618313

If the last checkpoint at slips behind a lot I know a few things:

* I have a lot of important work I'm not doing now, and could get into a
lot of trouble if I reach the end of a log file.
* I may need to configure innodb_io_capacity.
* A crash is going to be painful ;)

Original issue reported on code.google.com by toc...@gmail.com on 16 Oct 2009 at 12:10

[GoogleCodeExporter]

Right now we have "unflushed log" which is the difference between lsn and
log-flushed-to.  I see that we don't do anything with the checkpoint.

I think that rather than just having these three on the graph, we want 
LSN-checkpoint
as "uncheckpointed" (??? maybe it should be called something else?)

Original comment by baron.schwartz on 17 Oct 2009 at 7:02

• Changed state: Accepted

[GoogleCodeExporter]

This is done in r259.  The graph is called InnoDB Checkpoint Age and shows the 
number
of bytes written to the logs since the last checkpoint.  I'll release a new 
version
of the templates with this pretty soon.

Original comment by baron.schwartz on 25 Oct 2009 at 8:50

• Changed state: Fixed