Monthly Archives: March 2012

Changes to long_query_time Not Changing

By | March 6, 2012

At work today I ran into a new reason for not keeping open MySQL connections for a long time. It involves dynamic session variables like long_query_time. I wanted to capture a couple of hours worth of all queries in the slow query log so I could analyze them with pt-query-digest from the excellent Percona Toolkit.… Read More »