Mysql and Innodb

http://forums.cpanel.net/f189/best-optimization-my-cnf-269391.html
part about query cache limit not right

Interesting take
http://www.trinitycore.org/f/topic/448-best-thread-cache-size-value/

http://dev.mysql.com/doc/refman/4.1/en/server-parameters.html


second paragraph
http://dev.mysql.com/doc/refman/4.1/en/table-cache.html

Usefull tool
http://www.mysqlcalculator.com/

skip-bdb

http://mysql.rjweb.org/doc.php/memory
http://www.tutorialspoint.com/mysql/mysql-database-tuning.htm


http://stackoverflow.com/questions/8665233/mysql-thread-cache-size-reduce-cpu-and-max-connection
http://dev.mysql.com/doc/refman/5.0/en/slow-query-log.html
http://jayant7k.blogspot.com/2009/09/innodb-configuration-and-optimization.html
http://www.tutorialspoint.com/mysql/mysql-database-tuning.htm
http://drupal.org/node/51263 - Tuning Mysql
http://www.highperfmysql.com/
http://serverfault.com/questions/354299/picking-the-right-innodb-buffer-pool-size?rq=1
http://serverfault.com/questions/316137/mysql-innodb-problem?rq=1  -> Very Goood
http://serverfault.com/questions/253059/mysql-innodb-optimisation?rq=1
http://serverfault.com/questions/220164/changing-innodb-buffer-pool-size-makes-error?rq=1


http://www.justin.my/2010/09/optimize-only-fragmented-tables-in-mysql/
http://dev.mysql.com/doc/refman/5.0/en/innodb-tuning.html
http://www.mysqlperformanceblog.com/2007/11/03/choosing-innodb_buffer_pool_size/
http://www.mysqlperformanceblog.com/2007/11/01/innodb-performance-optimization-basics/
http://mysqltuner.pl/mysqltuner.pl
http://openx.com/docs/whitepapers/performance-tuning
http://meinit.nl/optimize-only-fragmented-tables-mysql

MYSQL and TCP Wait isses

http://support.microsoft.com/kb/137984
http://blogs.technet.com/b/janelewis/archive/2010/03/09/explaining-close-wait.aspx
http://blogs.msdn.com/b/spike/archive/2008/10/09/tcp-connections-hanging-in-the-close-wait-and-fin-wait-2-state.aspx
http://bugs.mysql.com/bug.php?id=40662
http://books.google.com.jm/books?id=BL0NNoFPuAQC&pg=PA330&lpg=PA330&dq=net.ipv4.tcp_fin_timeout++mysql+tuning&source=bl&ots=COTOvpvG3U&sig=ID_ccSr1DHOePEjlkXiGaq_UuhA&hl=en&sa=X&ei=3jUuUMOgNLH7yAHRmICQCw&redir_esc=y#v=onepage&q=net.ipv4.tcp_fin_timeout%20%20mysql%20tuning&f=false