Working on some performance tuning for MySQL today. Here are by far the best resources I have found: Best General Tuning Guide: http://www.mysqlperformanceblog.com/2006/09/29/what-to-tune-in-mysql-server-after-installation/ Expanded point from that Guide: http://www.mysqlperformanceblog.com/2007/11/03/choosing-innodb_buffer_pool_size/ I ran into an issue when I adjusted a log file size (MySQL wouldn’t start), this was the fix: http://dba.stackexchange.com/questions/1261/how-to-safely-change-mysql-innodb-variable-innodb-log-file-size In my case MySQL was running […]