Tag - no copytruncate

Rotating MySQL Slow Logs Safely

mysql

This blog post is part two of two. Like part one, published Wednesday, this is a cross-post from long_query_time set to 0. Here are a some lessons we learned when logging a high volume of queries to the slow log.
Do not use copytruncate
bug 65481 explains that the HUP signal also flushes tables in addition […]

Read more