Amateur geek

After much pain, I've finally got MySQL installed on Snow Leopard including the MySQL 2.8.1 gem:

1) I installed the x86_64 package from:
http://dev.mysql.com/downloads/mysql/5.1.html#macosx-dmg

2) Then ran:

sudo env ARCHFLAGS="-arch x86_64" gem install mysql -- --with-mysql-config=/usr/local/mysql/bin/mysql_config --with-mysql-dir=/usr/local/mysql --with-mysql-lib=/usr/local/mysql/lib --with-mysql-include=/usr/local/mysql/include

This was to fix the following problems I was continually having:

Rails:
uninitialized constant MysqlCompat::MysqlRes

find . -name ".svn" -type d -exec rm -rf {} \;

This will remove all fragment cache files from the cache directory:

task :expire_cache => :environment do
ActionController::Base.new.expire_fragment(%r{/})
end

sudo nano /etc/mysql/my.cnf

log_slow_queries = /path/to/mysql-slow.log
long_query_time = 4


http://dev.mysql.com/doc/refman/5.0/en/slow-query-log.html