Bug #39709 status variable 'Uptime_since_flush_status' missing
Submitted: 28 Sep 2008 10:54 Modified: 9 Feb 2009 8:53
Reporter: Peter Laursen (Basic Quality Contributor) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Compiling Severity:S2 (Serious)
Version:5.1.28, 6.0.6 OS:Any
Assigned to: CPU Architecture:Any
Tags: qc

[28 Sep 2008 10: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 10:58] Peter Laursen
and it is not in 6.06 either!
[28 Sep 2008 11: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 9: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 11:34] Tomer Ratz
Any news about this bug?
[8 Feb 2009 9:56] Daniel Fischer
Couldn't reproduce with more recent package.
[8 Feb 2009 21: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 2009 21: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 2009 21: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)!
[8 Feb 2009 23: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!
[8 Feb 2009 23: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 2009 8:50] Peter Laursen
Opening again.  Documentation is incorrect!
[9 Feb 2009 8: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.
[18 May 2011 9:24] Nikolay Pelov
It's missing in mysql v 5.0.92 (compiled from source), but it's available in 5.0.51a. Is it a configuration option?