Archive for the ‘mysql’ Category

Enable MySQL Slow Query Logging Without Server Restart

February 7th, 2012 No comments

When mysql stops responding…  You can usually bet on finding slow queries to be the culprit.

You can easily enable slow query logging without restarting the server.

Just run:

set global log_slow_queries = ON

Categories: mysql Tags:


April 27th, 2010 No comments

I’ve used phpMyAdmin for a while, but I find it to be a little heavyweight at times. Sometimes I just want to run a simple query. The MySQL client is obtuse to use sometimes. So I went on a search for alternatives.

I now use phpMiniAdmin almost exclusively. It’s extremely light weight, fast and has LOTS of neat features. It provides everything I need 99.9% of the time. And it’s easier to configure then phpMyAdmin.

Categories: mysql, php5, web Tags: