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.

Querious

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.

Continue reading “Sequel Pro”