Bug #55114 Create status variable for innodb_open_files
Submitted: 9 Jul 2010 8:02 Modified: 29 Jan 2011 0:53
Reporter: Sveta Smirnova Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S4 (Feature request)
Version:5.1, all OS:Any
Assigned to: Jimmy Yang CPU Architecture:Any

[9 Jul 2010 8:02] Sveta Smirnova
Description:
There is server variable innodb_open_files, but there is no status which shows how many files were currently open by InnoDB. Please create such status variable.

This can be used in monitoring tools so customers can decide if innodb_open_files is needed to be increased.

How to repeat:
See description.
[28 Jul 2010 6:42] Jimmy Yang
As requested, added a new status variable "innodb_num_open_files" and a monitor counter "fil_system_num_open_file" to account for the number of open files in InnoDB.
[2 Aug 2010 6:43] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/114817

3253 Jimmy Yang	2010-08-01
      Fix Bug #55114 Create status variable for innodb_open_files
      
      rb://412 approved by Sunny Bains
[13 Nov 2010 16:18] Bugs System
Pushed into mysql-trunk 5.6.99-m5 (revid:alexander.nozdrin@oracle.com-20101113155825-czmva9kg4n31anmu) (version source revid:alexander.nozdrin@oracle.com-20101113152450-2zzcm50e7i4j35v7) (merge vers: 5.6.1-m4) (pib:21)
[13 Nov 2010 16:28] Bugs System
Pushed into mysql-next-mr (revid:alexander.nozdrin@oracle.com-20101113160336-atmtmfb3mzm4pz4i) (version source revid:vasil.dimov@oracle.com-20100629074804-359l9m9gniauxr94) (pib:21)
[5 Dec 2010 12:37] Bugs System
Pushed into mysql-trunk 5.6.1 (revid:alexander.nozdrin@oracle.com-20101205122447-6x94l4fmslpbttxj) (version source revid:alexander.nozdrin@oracle.com-20101205122447-6x94l4fmslpbttxj) (merge vers: 5.6.1) (pib:23)
[29 Jan 2011 0:53] John Russell
Added to 5.6 Ref Man.