max_statement_time not see in the global STATUS:Max_statement_time_exceeded

Bug #1430676 reported by william
6
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.1
Invalid
Undecided
Unassigned
5.5
Invalid
Undecided
Unassigned
5.6
Triaged
Medium
Unassigned
5.7
Invalid
Undecided
Unassigned

Bug Description

     when use the max_statement_time feature,the status :Max_statement_time_exceeded can only be seen by own session,other session can not see,Here is typical example for that:

mysql> show variables like '%max_statement_t%';
+--------------------+-------+
| Variable_name | Value |
+--------------------+-------+
| max_statement_time | 1 |
+--------------------+-------+

mysql> show status like '%max_st%';
+-------------------------------+-------+
| Variable_name | Value |
+-------------------------------+-------+
| Max_statement_time_exceeded | 1 |
| Max_statement_time_set | 12 |
| Max_statement_time_set_failed | 0 |
+-------------------------------+-------+
3 rows in set (0.00 sec)

mysql> select * from information_schema.tables where table_rows > 0 group by table_schema;
ERROR 1886 (70101): Query execution was interrupted, max_statement_time exceeded

mysql> show status like '%max_st%';
+-------------------------------+-------+
| Variable_name | Value |
+-------------------------------+-------+
| Max_statement_time_exceeded | 2 |
| Max_statement_time_set | 14 |
| Max_statement_time_set_failed | 0 |
+-------------------------------+-------+
3 rows in set (0.00 sec)

but,when i connect from another session,i can not see the status variables to be change:
mysql> show status like '%max_st%';
+-------------------------------+-------+
| Variable_name | Value |
+-------------------------------+-------+
| Max_statement_time_exceeded | 0 |
| Max_statement_time_set | 0 |
| Max_statement_time_set_failed | 0 |
+-------------------------------+-------+

mysql> show global status like '%max_st%';
+-------------------------------+-------+
| Variable_name | Value |
+-------------------------------+-------+
| Max_statement_time_exceeded | 0 |
| Max_statement_time_set | 0 |
| Max_statement_time_set_failed | 0 |
+-------------------------------+-------+
3 rows in set (0.00 sec)

so,this is very bad for the understanding of server state

Changed in percona-server:
assignee: nobody → Muhammad Irfan (muhammad-irfan)
Revision history for this message
Muhammad Irfan (muhammad-irfan) wrote :

verified as described in bug description.

Changed in percona-server:
assignee: Muhammad Irfan (muhammad-irfan) → nobody
status: New → Confirmed
tags: added: max-statement-time
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-3271

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

Other bug subscribers

Remote bug watches

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