slowlog rotation and expiration doesn't work with the default slow query log name

[Hrvoje Matijakovic]

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/mysql/ps55-slow.log

If the max_slowlog_size is enabled (set to >0) this feature will not work.

If the logname is changed to /var/lib/mysql/ps55-slow feature will work but the slow_query_log_file will be providing the wrong information:

mysql> show variables like 'slow_query_log_file';
+---------------------+--------------------------+
| Variable_name | Value |
+---------------------+--------------------------+
| slow_query_log_file | /var/lib/mysql/ps55-slow |
+---------------------+--------------------------+
1 row in set (0.00 sec)

While the correct filename will be:
/var/lib/mysql/ps55-slow/ps55-slow.000001

This feature is currently available only in: PS-5.5.36-34.0 and PS-5.6.16-64.0

[Sergei Glushchenko (sergei.glushchenko)]

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.

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-1484