Bug #37651 The manual shows variables as session capacble which aren't
Submitted: 26 Jun 2008 2:52 Modified: 26 Jun 2008 6:06
Reporter: Eric Bergen (OCA) Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: CPU Architecture:Any

[26 Jun 2008 2:52] Eric Bergen
The innodb status variables listed on http://dev.mysql.com/doc/refman/5.0/en/server-status-variables.html are global only. The manual has them listed as session and global. I wasn't able to find anything in the source that sets the values on the session level. Bug #27238 is a feature request for enabling innodb to set session variables. I suspect other variables are incorrect as well since Prepared_stmt_count is the only one listed as exclusively global.  

How to repeat:
show global status like 'inno%';
show session status like 'inno%';

They both return the same values.

Suggested fix:
Update the manual until Bug #27238 is complete.
[26 Jun 2008 4:44] Paul DuBois
Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly, and will be included in the next release of the relevant products.

Corrected the Innodb_xxx status variables. Will fix others as they are reported.
[26 Jun 2008 4:46] Valeriy Kravchuk
Thank you for a reasonable documentation request. I'd just add third column for that table at http://dev.mysql.com/doc/refman/5.0/en/server-status-variables.html to explain if per session statistics is really available.