MySQL is so easy to just "get running" and my applications are often quite basic. So, I only get around to actually "configuring" MySQL every couple of years, during which time I've forgotten the guidelines. So this is this year's refresher reading list:
http://www.mysqlperformanceblog.com/2006/05/17/mysql-server-memory-usage/
http://dev.mysql.com/doc/refman/5.0/en/innodb-configuration.html
http://www.mysqlperformanceblog.com/2011/03/21/what-causes-downtime-in-mysql/
http://www.mysqlperformanceblog.com/2011/02/17/how-to-syntax-check-your-my-cnf-file/
http://fts.ifac.cnr.it/cgi-bin/dwww/usr/share/doc/mysql-server-5.0/examples/my-large.cnf.gz
http://mysqldatabaseadministration.blogspot.com/2005/11/mysql-5-optimization-and-tuning-guide.html
http://brian.moonspot.net/2008/05/06/example-mycnf-files/
http://forge.mysql.com/tools/tool.php?id=138
http://forge.mysql.com/tools/tool.php?id=137
http://www.pythian.com/news/1067/difference-between-innodb_data_file_path-and-innodb_file_per_table/
http://forum.percona.com/index.php/t/1493/
More to follow...
http://www.mysqlperformanceblog.com/2006/05/17/mysql-server-memory-usage/
http://dev.mysql.com/doc/refman/5.0/en/innodb-configuration.html
http://www.mysqlperformanceblog.com/2011/03/21/what-causes-downtime-in-mysql/
http://www.mysqlperformanceblog.com/2011/02/17/how-to-syntax-check-your-my-cnf-file/
http://fts.ifac.cnr.it/cgi-bin/dwww/usr/share/doc/mysql-server-5.0/examples/my-large.cnf.gz
http://mysqldatabaseadministration.blogspot.com/2005/11/mysql-5-optimization-and-tuning-guide.html
http://brian.moonspot.net/2008/05/06/example-mycnf-files/
http://forge.mysql.com/tools/tool.php?id=138
http://forge.mysql.com/tools/tool.php?id=137
http://www.pythian.com/news/1067/difference-between-innodb_data_file_path-and-innodb_file_per_table/
http://forum.percona.com/index.php/t/1493/
More to follow...
No comments:
Post a Comment