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 […]
I'm a Linux, Windows, Android, Drupal, MySQL, Apache, Wordpress, IIS, Security - Analyst, Admin, Technician, Developer Guy - and - I Need A Place to Write it All Down....