I recently reset replication on one of my servers and since then my relay_log_space_limit=8G setting has stopped working since the relay log files continue to grow beyond the 8G limit (currently 15G).
Has anyone else experienced this before? Why would it suddenly stop honoring the relay log space limit?
Hey Frank,
ReplyDeleteDoes it show correctly when you look at if from within the client? Try something like:
show variables like '%relay%';
Just curious if it's something with the server not picking up options in the my.cnf or if there is a problem within mysqld of it not being respected.
Mike
Hi Mike,
ReplyDeleteI should have included the output earlier but here it is:
mysql> SHOW variables like '%relay%';
+-----------------------+------------+
| Variable_name | Value |
+-----------------------+------------+
| max_relay_log_size | 0 |
| relay_log_purge | ON |
| relay_log_space_limit | 8589934592 |
+-----------------------+------------+
3 rows in set (0.00 sec)
mysqld is recogizing the limit but not enforcing it as I see 18 log files (18G) already.
To prevent running out of disk space, I have turned off SLAVE IO_THREAD.
Thanks for any insight you can provide.
Frank
If you want manage the database you should check the MySQL Turbo Manager product.
ReplyDeleteProduct page:
www.mentattech.com
Kind regards,
Teksure
If you want to manage, tune or develop MySQL you should check MySQL Turbo Manager.
ReplyDeleteProduct page:
www.mentattech.com
Regards,
Teksure