Bug #71057 Please expose session variables for all threads to enhance config management
| Submitted: | 3 Dec 2013 12:24 | Modified: | 23 Mar 2015 20:57 |
|---|---|---|---|
| Reporter: | Simon Mudd | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Performance Schema | Severity: | S4 (Feature request) |
| Version: | 5.7 and earlier | OS: | Any |
| Assigned to: | Marc ALFF | CPU Architecture: | Any |
[3 Dec 2013 12:24]
Simon Mudd
[3 Dec 2013 12:26]
Simon Mudd
Current reason for wanting to do this is I am changing the tx_isolation settings for a replication chain. It's possible to change the global settings but not to properly verify if the SQL thread has been adjusted to take the new value, something which requires knowing that it has been restarted.
[3 Dec 2013 12:27]
Simon Mudd
See also bug#27508
[10 Mar 2015 10:07]
Marc ALFF
This feature is now implemented in MySQL 5.7.6 See the table: performance_schema.variables_by_thread root@localhost [performance_schema] > set global show_compatibility_56=off; Query OK, 0 rows affected (0.00 sec) root@localhost [performance_schema] > describe variables_by_thread; +----------------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+---------------------+------+-----+---------+-------+ | THREAD_ID | bigint(20) unsigned | NO | | NULL | | | VARIABLE_NAME | varchar(64) | NO | | NULL | | | VARIABLE_VALUE | varchar(1024) | YES | | NULL | | +----------------+---------------------+------+-----+---------+-------+ 3 rows in set (0.00 sec) root@localhost [performance_schema] > select * from variables_by_thread where VARIABLE_NAME like "tx%"; +-----------+---------------+-----------------+ | THREAD_ID | VARIABLE_NAME | VARIABLE_VALUE | +-----------+---------------+-----------------+ | 20 | tx_isolation | REPEATABLE-READ | | 20 | tx_read_only | OFF | | 21 | tx_isolation | READ-COMMITTED | | 21 | tx_read_only | ON | +-----------+---------------+-----------------+ 4 rows in set, 2 warnings (0.00 sec)
[23 Mar 2015 20:57]
Paul DuBois
Implemented in 5.7.6. It is now possible to see session variables for all sessions using the variables_by_thread table: http://dev.mysql.com/doc/refman/5.7/en/performance-schema-system-variable-tables.html Access to this table requires the SELECT privilege.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.053 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.