Bug #112004 json output of "SHOW ENGINE INNODB STATUS"
Submitted: 9 Aug 2023 8:35 Modified: 11 Aug 2023 9:49
Reporter: Tomoaki Otsuka Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S4 (Feature request)
Version:8.1.0 OS:Any
Assigned to: CPU Architecture:Any

[9 Aug 2023 8:35] Tomoaki Otsuka 
Description:
The output of "SHOW ENGINE INNODB STATUS" for operation of MySQL.
But it's hard to parse it.

How to repeat:
(Feature request)

Suggested fix:
I would appreciate it if mysqld print the result of "SHOW ENGINE INNODB STATUS" as json or other structured text.
[9 Aug 2023 9:08] MySQL Verification Team 
Hello Tomoaki Otsuka,

Thank you for the feature request.

regards,
Umesh
[10 Aug 2023 18:53] Kenny Gryp 
What data available in SHOW ENGINE INNODB STATUS would you like to see that is not available in either performance_schema tables or information_schema.INNODB_METRICS?
[11 Aug 2023 9:25] Tomoaki Otsuka 
Hello Umesh and Kenny Gryp.
Thank you for checking my request.

It' appreciated to monitor especially the "SEMAPHORES" section to check and understand internal locks(semaphores) wait, and the "BUFFER POOL AND MEMORY" section to tune buffer_pool_size without parsing current output.

Regards,
Otsuka