LP #1642753: Collect information about variables from P_S

Description

**Reported in Launchpad by Sveta Smirnova last update 28-03-2017 17:10:25

Currently pt-stalk collects information from SHOW GLOBAL VARIABLES output, but this statement and tables in Information Schema are deprecated and will be replaced with Performance Schema. Also in version 8.0 there will be possibility to know where one or another global variable originated from which is very helpful for troubleshooting.

Please add P_S support to pt-stalk and collect variables information from it. You may use queries:

select * from performance_schema.variables_by_thread order by thread_id, variable_name;
select * from performance_schema.user_variables_by_thread order by thread_id, variable_name;
select * from performance_schema.status_by_thread order by thread_id, variable_name; (performance_schema_max_thread_instances must be -1 or very big)

Environment

None

Smart Checklist

Activity

Show:

Details

Assignee

Reporter

Priority

Fix versions

Smart Checklist

Created January 24, 2018 at 5:40 PM
Updated January 15, 2024 at 11:57 AM