If you are losing connection to mysql every so often on OSX (I’m using 10.5 Leopard), it’s probably because you do not have the native C ruby-mysql bindings. If your error looks like this:
Mysql::Error: Lost connection to MySQL server during query:
then try the following. Verify that the bindings are really not present. In a terminal window, open up the interactive ruby shell and type the following commands:
irb
>> require ‘mysql.bundle’
=> true
>> exit
If you do not get ‘true’, then you need the bindings. Back to your terminal window and type the following:
$ sudo -s
$ ARCHFLAGS="-arch i386" gem install mysql -- --with-mysql-dir=/usr/local/mysql
Try require ‘mysql.bundle’ again and this time you should get back true.
You can follow Anil on Twitter, email him at (anil.kumar/gmail) or explore more.