image-2022-07-12-15-15-04-430.png
[MDEV-29084] "SET GLOBAL slow_query_log=1;" is not ok Created: 2022-07-12 Updated: 2022-07-12 Resolved: 2022-07-12 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Configuration |
| Affects Version/s: | 10.3.34 |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Major |
| Reporter: | derry | Assignee: | Unassigned |
| Resolution: | Not a Bug | Votes: | 0 |
| Labels: | performance | ||
| Environment: |
ubuntu1~20.04.1 |
||
| Attachments: |
image-2022-07-12-15-15-04-430.png
|
| Description |
|
|
| Comments |
| Comment by Daniel Black [ 2022-07-12 ] |
|
slow_query_log is both a system global and session variable. Changing the global value only changes the session value of newly created sessions/connections, not the connections that already exist. As such the observed behaviour is consistent with every system variable that is both global and session. SHOW VARIABLES is session based. SHOW GLOBAL VARIABLES .. is global. |
