[MDEV-4499] innodb_status_file startup option lacks variable(s) and proper documentation Created: 2013-05-08  Updated: 2014-03-11  Resolved: 2014-03-11

Status: Closed
Project: MariaDB Server
Component/s: None
Fix Version/s: None

Type: Task Priority: Trivial
Reporter: Jean Weisbuch Assignee: Jan Lindström (Inactive)
Resolution: Won't Fix Votes: 0
Labels: innodb_status_file, status, variable


 Description   

This feature dumps every ~20secs the InnoDB engine status on a file on the datadir, on the official MySQL documentation it is documented as "writing periodically the output of SHOW ENGINE INNODB STATUS" without specifying its recurrence.

This startup variable also doesnt have a corresponding runtime variable and it is not possible to configure neither its output filename nor the delay between two dumps and having the ability to activate/deactivate the feature without having to restart the server could also be interresting.

The code that defines the delay between two dumps on 5.5.30 : http://bazaar.launchpad.net/~maria-captains/maria/5.5/view/3749/storage/innobase/srv/srv0srv.c#L2187

Another possibility would be to replace it with a non engine-specific variable as other storage engines might also have engine status inforations (its the case for TokuDB for example) or that could dump informations from P_S/I_S.

 Comments   
Comment by Elena Stepanova [ 2013-05-08 ]

I suppose the documentation part could be done now, and enhancements could go to 10.x if we choose to implement them.

Comment by Jan Lindström (Inactive) [ 2013-09-10 ]

Added following new configuration variables:

innodb_monitor_path_and_file
Path and file name for InnoDB monitor output.
User can change this file name on runtime and if file cant be created
default location and name will be used.

innodb_monitor_wait_delay
Minimum delay between two InnoDB monitor outputs to file (15s by
default) and 0 to disable output. User can change this on runtime.

Comment by Jan Lindström (Inactive) [ 2013-09-10 ]

Added more configuration parameters:

innodb_table_monitor_wait_delay
Minimum delay between two InnoDB table monitor outputs to file (60s by
default) and 0 to disable output. User can change this on runtime.

Comment by Jan Lindström (Inactive) [ 2014-03-11 ]

Reason for the decision: InnoDB status output on files will be deprecated because similar output can now be seen from information_schema.

Generated at Thu Feb 08 06:56:54 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.