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: | |
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
[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