Mysql - Where i can find Innodb_history_list_length variable in new versions of mysql

by Kislik   Last Updated April 16, 2018 12:06 PM - source

Mysql version: percona-server-server-5.7 5.7.21-20-1.stretch

What i get in new version of mysql when i try execute the query:

SELECT count FROM information_schema.innodb_metrics WHERE name = 'trx_rseg_history_len';

'INFORMATION_SCHEMA.GLOBAL_STATUS' feature is disabled: see the documentation for 'show_compatibility_56'

What i'm expecting get (only value):


Question: How i can execute the same query in newest versions mysql without using information_schema

Why i do it: From a long transaction grows undo-segment in the ibdata file, and this file can not be reduced in any way. And if i get a "big value" in my check i realize, that file is growing, and i find "hang" process and then kill it.

Related Questions

mySQL information_schema confusion

Updated June 16, 2017 23:06 PM

Querying MySQL sys schema shows truncated queries

Updated October 24, 2017 08:06 AM

Information_schema appearing in slow_log

Updated February 17, 2018 23:06 PM

Query to compare the structure of two tables in MySQL

Updated September 11, 2017 22:06 PM