Percona Server moved to https://jira.percona.com/projects/PS

SHOW GLOBAL STATUS blocks too much

Bug #1592290 reported by Laurynas Biveinis
8
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
Percona Server moved to https://jira.percona.com/projects/PS 5.7.14-7

Bug Description

In 5.7, SHOW GLOBAL STATUS calling srv_export_innodb_status will lock the following that upstream does not:

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.

Laurynas Biveinis (laurynas-biveinis)
tags: added: regression xtradb
Laurynas Biveinis (laurynas-biveinis)
tags: added: performance
Revision history for this message
Laurynas Biveinis (laurynas-biveinis) wrote :

https://github.com/percona/percona-server/pull/654, https://github.com/percona/percona-server/pull/655, https://github.com/percona/percona-server/pull/656

Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-1721

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.