mysql – Urban Giraffe

MAMP Slow Queries

Ever wanted to track down slow SQL queries while developing with MAMP on OS X? From the MAMP control panel edit the my.cnf template:

Track down the section starting with [mysqld] and add the following highlighted lines:

# The MySQL server
[mysqld]
log_slow_queries=/Applications/MAMP/logs/mysql_slow.log
long_query_time=1

Restart MAMP and any slow queries (queries over 1 second, configurable via the long_query_time option above) will be logged to /Applications/MAMP/logs/mysql_slow.log.

Now I have no excuse to forget this.

A few days after I wrote about Sequel Pro, a link from Daring Fireball leads me to Querious, a commercial MySQL management tool. At a glance it seems to offer everything that Sequel Pro has, along with the ability to manage users and permissions.

Hot on the heals of this The Apple Blog has a Sequel Pro vs. Querious showdown. The conclusion is similar, and the comments make for interesting reading with links to further tools.

Sequel Pro

Back in 2007 I wrote about CocoaMySQL, a small GUI for MySQL that allows you to manipulate and manage MySQL databases through a native Cocoa application. Since then development of CocoaMySQL died off and it has since been abandoned. A shame really as it did have several frustrating quirks that spoiled an otherwise great application.

Recently I came across Sequel Pro, a fork of CocoaMySQL that has big plans to stabilise the core code and turn it into a multi-engine database management tool (with support for SQLite and PostgresSQL scheduled for the future). Despite being available since early 2008 I’ve seen very little mention of Sequel Pro.