[MDEV-4690] FLUSH GLOBAL STATUS Created: 2013-06-21 Updated: 2020-10-29 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | None |
| Fix Version/s: | None |
| Type: | Task | Priority: | Minor |
| Reporter: | Jean Weisbuch | Assignee: | Unassigned |
| Resolution: | Unresolved | Votes: | 1 |
| Labels: | flush, status, upstream | ||
| Description |
|
It could be interresting to be able to reset some of the global statuts values in case some important changes has been made to the MariaDB configuration, on the OS or on the applications using the server and you want to monitor how MariaDB is behaving with the new settings without restarting MariaDB. For example, these variables could be reset with a FLUSH GLOBAL STATUS : Bytes_received, Bytes_sent, Com_%, Connections, Created_tmp_%, Handler_%, Opened_%, Sort_%, Rows_%, queries, Questions, Select_%. An old bug/feature request on MySQL for it : http://bugs.mysql.com/bug.php?id=22875. |
| Comments |
| Comment by Juan [ 2019-04-01 ] | |||||||||||||||||||||||||||
|
It would be great if every status variable that counts actions got flushed when running FLUSH GLOBAL STATUS, such as this sampling of status variables that are not flushed in 10.0.38, 10.1.38, 10.2.23, 10.3.13, 10.4.3:
| |||||||||||||||||||||||||||
| Comment by Geoff Montee (Inactive) [ 2019-04-02 ] | |||||||||||||||||||||||||||
|
https://mariadb.com/kb/en/library/flush/#global-status-variables-that-support-flush-status |