max_statement_time not see in the global STATUS:Max_statement_time_exceeded
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_
mysql> show variables like '%max_statement
+------
| Variable_name | Value |
+------
| max_statement_time | 1 |
+------
mysql> show status like '%max_st%';
+------
| Variable_name | Value |
+------
| Max_statement_
| Max_statement_
| Max_statement_
+------
3 rows in set (0.00 sec)
mysql> select * from information_
ERROR 1886 (70101): Query execution was interrupted, max_statement_time exceeded
mysql> show status like '%max_st%';
+------
| Variable_name | Value |
+------
| Max_statement_
| Max_statement_
| Max_statement_
+------
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_
| Max_statement_
| Max_statement_
+------
mysql> show global status like '%max_st%';
+------
| Variable_name | Value |
+------
| Max_statement_
| Max_statement_
| Max_statement_
+------
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) |
tags: | added: max-statement-time |
verified as described in bug description.