Details
Assignee
UnassignedUnassignedReporter
lpjirasynclpjirasync(Deactivated)Priority
LowFix versions
Details
Details
Assignee
Unassigned
UnassignedReporter
lpjirasync
lpjirasync(Deactivated)Priority
Fix versions
Smart Checklist
Smart Checklist
Smart Checklist
Created January 24, 2018 at 5:40 PM
Updated January 15, 2024 at 11:57 AM
**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)