SHOW GLOBAL STATUS blocks too much
Bug #1592290 reported by
Laurynas Biveinis
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS | Status tracked in 5.7 | |||||
5.5 |
Invalid
|
Undecided
|
Unassigned | |||
5.6 |
Invalid
|
Undecided
|
Unassigned | |||
5.7 |
Fix Released
|
Medium
|
Laurynas Biveinis |
Bug Description
In 5.7, SHOW GLOBAL STATUS calling srv_export_
S lock on 0th AHI latch
dict_sys->mutex
trx_sys->mutex
This might make SHOW GLOBAL STATUS unsuitable to be called with high frequency.
https:/ /github. com/percona/ percona- server/ pull/654, https:/ /github. com/percona/ percona- server/ pull/655, https:/ /github. com/percona/ percona- server/ pull/656