slowlog rotation and expiration doesn't work with the default slow query log name
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS | Status tracked in 5.7 | |||||
5.5 |
Triaged
|
Medium
|
Unassigned | |||
5.6 |
Triaged
|
Medium
|
Unassigned | |||
5.7 |
Triaged
|
Medium
|
Unassigned |
Bug Description
Slowlog rotation and expiration feature doesn't work with the default slow query log name.
Default value for slow_query_log_file in PS-55 is /var/lib/
If the max_slowlog_size is enabled (set to >0) this feature will not work.
If the logname is changed to /var/lib/
mysql> show variables like 'slow_query_
+------
| Variable_name | Value |
+------
| slow_query_log_file | /var/lib/
+------
1 row in set (0.00 sec)
While the correct filename will be:
/var/lib/
This feature is currently available only in: PS-5.5.36-34.0 and PS-5.6.16-64.0
I think it doesn't work when log name has extension. "ps55-slow.log" will not work. But "ps55-slow" should. By default slow log name has ".log" extension.