Bug #27238 InnoDB support for SHOW SESSION STATUS
Submitted: 17 Mar 2007 14:24 Modified: 20 May 2014 11:38
Reporter: Mark Leith Email Updates:
Status: Won't fix Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S4 (Feature request)
Version:5.0, 5.1, 5.2 OS:Any (All)
Assigned to: Jimmy Yang CPU Architecture:Any
Tags: innodb, show session status

[17 Mar 2007 14:24] Mark Leith
Description:
Currently InnoDB only supports global variables within SHOW SESSION STATUS, and reports these back for SHOW SESSION STATUS. 

The feature request is for InnoDB to track each SHOW STATUS variable on a per session level, as well as globally, and to pass back session based status variables to SHOW SESSION STATUS. 

How to repeat:
Nothing to repeat

Suggested fix:
Add session based tracking of status variables, and report these back for SHOW SESSION STATUS
[19 Mar 2007 12:18] Heikki Tuuri
Mark,

please give an example of a session status variable. I thought they are managed by MySQL.

Regards,

Heikki
[19 Mar 2007 12:54] Mark Leith
Hi Heikki,

Some examples are things like "key_reads" / "key_read_requests" - which we actually track per session as well as globally. The companion to this within InnoDB is innodb_buffer_pool_reads and innodb_buffer_pool_read_requests. 

It would be nice to take this even further to state variables such as Innodb_data_read, Innodb_data_fsyncs, Innodb_log_waits etc. 

Regards

Mark
[20 Mar 2007 12:37] Sergei Golubchik
this should be easy to do when WL#2936 wll be pushed
[20 May 2014 11:38] Erlend Dahl
[18 May 2014 19:34] Jimmy Yang

The current direction will be move all these status variable to P_S or
metrics. So we will not work any more on status variable mechanism