Bug #71786 Add monitoring for slave_open_temp_tables

• Submitted: 21 Feb 2014 9:47
• Modified: 25 Aug 2016 13:05
• Reporter: Daniël van Eeden (OCA)
• Status: Verified
• Category: MySQL Enterprise Monitor: Advisors/Rules
• Severity: S4 (Feature request)
• Version: 3.0.6
• OS: Any
• CPU Architecture: Any

[21 Feb 2014 9:47] Daniël van Eeden

Description:
https://dev.mysql.com/doc/refman/5.6/en/replication-features-temptables.html

When there are open temp tables on a slave it can be very risky to stop the slave server. 

How to repeat:
See description

Suggested fix:
1. Add a graph for open temp tables on the slave or add it to the temporary tables graph.
2. Add an advisor which alerts when slave_open_temp_tables > 0

[21 Feb 2014 9:54] Daniël van Eeden

Advisor

Attachment: custom-export-20140221-1052.jar (application/jar, text), 1.28 KiB.

[21 Feb 2014 9:55] Daniël van Eeden

Graph

Attachment: slave_temp.xml (text/xml), 641 bytes.

[21 Feb 2014 10:31] Mark Leith

Verifying.

[22 Aug 2014 11:38] Daniël van Eeden

Advisor rule

(*) I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.

Contribution: Open_temp_tables_on_slave.xml (text/xml), 1.81 KiB.

[22 Aug 2014 11:38] Daniël van Eeden

graph

(*) I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.

Contribution: slave_temp.xml (text/xml), 641 bytes.

[25 Aug 2016 13:05] Daniël van Eeden

Related: https://bugs.mysql.com/bug.php?id=56355