Bug #39709 status variable 'Uptime_since_flush_status' missing
Submitted: 28 Sep 2008 12:54 Modified: 9 Feb 9:53
Reporter: Peter Laursen (Basic Quality Contributor)
Status: Closed
Category:Server: Compiling Severity:S2 (Serious)
Version:5.1.28, 6.0.6 OS:Any
Assigned to: Target Version:5.1+
Tags: qc
Triage: Triaged: D3 (Medium)

[28 Sep 2008 12:54] Peter Laursen
Description:
The server status variable 'Uptime_since_flush_status' does not exist in 5.1.28.  I find
it in 5.0.67.

I do not exactly know whne it was introduced (it is not in 4.1), but it is badly missing
in 5.1.

Interpreting SHOW (GLOBAL) STATUS is hopeless without knowing 'Uptime_since_flush_status'

How to repeat:
show global status like 'uptime%';
[28 Sep 2008 12:58] Peter Laursen
and it is not in 6.06 either!
[28 Sep 2008 13:46] Valeriy Kravchuk
It is missed even in 5.0.66a. Based on this page,
http://dev.mysql.com/doc/refman/5.0/en/releasenotes-cs-5-0-37.html, I assume it was added
by a patch from Jeremy Cole and may be available only in Community versions. 

Anyway, it should still be available in 6.0.x (and 5.1.28, that has no differentiation,
yet).
[2 Oct 2008 11:15] Tomer Ratz
Also, I can't find it in:
5.0.42
5.0.58
5.0.68
5.0.601

All are enterprise versions.
[6 Oct 2008 13:34] Tomer Ratz
Any news about this bug?
[8 Feb 10:56] Daniel Fischer
Couldn't reproduce with more recent package.
[8 Feb 22:01] Peter Laursen
OK .. I find it now in 5.1.31.

Anyway I open again becausee I find the term 'more recent version' used in the reply
non-professional.  Please always refer to *exact version no.'s*.  In which version did
YOU find it?

If I posted a report and I did not describe the exact version, I would be corrected!

GGRRRRR!!!
[8 Feb 22:03] Peter Laursen
.. and also please refer to where in changelogs this is documented!

This is critical for our application and for our customer support!
[8 Feb 22:39] Peter Laursen
This
(http://dev.mysql.com/doc/refman/5.1/en/server-status-variables.html#statvar_Uptime_since_f...)

"Uptime_since_flush_status 

The number of seconds since the most recent FLUSH STATUS statement. This variable was
added in 5.1.24"

.. is not true.  Or there was a regression between 5.1.24 and 5.1.28 that has been
corrected 'silently' (what means without proper documentation)!
[9 Feb 0:24] Peter Laursen
also 6.0 documentation is wrong - or also here there was a regression!

http://dev.mysql.com/doc/refman/6.0/en/server-status-variables.html:
"Uptime_since_flush_status ... This variable was added in 6.0.5" .. but bug was confirmed
with 6.0.6!

I am not impressed by the effort here that seems to be more focused on closing reports
rather than than doing proper research and provide correct information and documentation!
[9 Feb 0:29] Peter Laursen
... and I also think that Tomer would like to know (as I would) if this variable is/will
be implemented in ENTERPRISE servers!
[9 Feb 9:50] Peter Laursen
Opening again.  Documentation is incorrect!
[9 Feb 9:53] Daniel Fischer
Documentation is perfectly correct. It refers to when this feature was added to the source
code. There are no official production-ready packages that don't include it.