Tag: mysql

We work a lot with Rackspace Cloud Databases but the root user is disabled by default.

We ran into some character encoding issues with our automated tests on Travis recently. Luckily, it’s very easy to change the MySQL configuration in your test environment.

It can be difficult to make sense of the slow query log when investigating MySQL database performance. Fortunately, MySQL comes with a little tool to help you interpret those queries, called mysqldumpslow.

I regularly need to find out which queries are being executed while debugging or investigating application performance. I used to configure MySQL to log into a file and then search the output to see what’s happening.