Tag - Kyle Oppenheim

Rotating MySQL Slow Logs Safely


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

Is your MySQL buffer pool warm? Make it sweat!

Today’s blog post diving into the waters of the MySQL buffer pool is a cross-post from Groupon’s engineering blog, and is Part 1 of 2. Thank you to Kyle Oppenheim at Groupon for contributing to this project and post. We’ll be posting Part 2 on Thursday. I’ll be at the Percona Live MySQL Conference […]

Read more