Not the answer you need?
Register and ask your own question!

How to use "disable-tablestats" in PMM2

StaterosStateros ContributorCurrent User Role Patron
Hello. I need to disable this query on master. It's provide pretty high load. Is it some native way to configure monitoring?
SELECT t.table_schema,
t.table_name,
column_name, `auto_increment`,
pow(2, CASE data_type
WHEN 'tinyint' THEN 7
WHEN 'smallint' THEN 15
WHEN 'mediumint' THEN 23
WHEN 'int' THEN 31
WHEN 'bigint' THEN 63
end+(column_type LIKE '% unsigned'))-1 AS max_int
FROM information_schema.columns c straight_join information_schema.tables t ON binary t.table_schema = c.table_schema AND binary t.table_name = c.table_name
WHERE c.extra = 'auto_increment' AND t.auto_increment is NOT null

Comments

Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.