{"id":40,"date":"2006-07-05T00:49:33","date_gmt":"2006-07-04T22:49:33","guid":{"rendered":"http:\/\/www.nivas.hr\/blog\/2006\/07\/05\/tuning-mysql-performance\/"},"modified":"2006-07-05T01:54:31","modified_gmt":"2006-07-04T23:54:31","slug":"tuning-mysql-performance","status":"publish","type":"post","link":"https:\/\/www.nivas.hr\/blog\/2006\/07\/05\/tuning-mysql-performance\/","title":{"rendered":"Tuning mysql performance"},"content":{"rendered":"<p>The operating system your MySQL server runs on and the server&#8217;s configuration      can be just as important to your server&#8217;s performance as the indexes (let EXPLAIN be your best friend),      schema, or queries themselves. Be shure to check out  <a target=\"_blank\" href=\"http:\/\/dev.mysql.com\/books\/hpmysql-excerpts\/ch06.html\">High Performance MySQL &#8211;  Server Performance Tuning<\/a> from mySQL AB. In case you are stuck with badly performing cluster, check out <a href=\"http:\/\/dev.mysql.com\/tech-resources\/articles\/mysql_clustering_ch5.pdf\">MySQL Clustering &#8211; Performance<\/a>.<br \/>\nThe tool which will come into very handy is <a target=\"_blank\" href=\"http:\/\/hackmysql.com\/mysqlreport\">mysqlreport<\/a>. mysqlreport transforms    the values from SHOW STATUS into an easy-to-read report that provides a much more in-depth    understanding of how well MySQL is running.<br \/>\n<!--more--><\/p>\n<p>my.cnf<\/p>\n<blockquote><p><code>[mysqld]<br \/>\nback_log = 75<br \/>\nskip-innodb<br \/>\nmax_connections = 500<br \/>\nkey_buffer = 384M<br \/>\nmyisam_sort_buffer_size = 64M<br \/>\njoin_buffer_size = 1M<br \/>\nread_buffer_size = 1M<br \/>\nsort_buffer_size = 2M<br \/>\ntable_cache = 1800<br \/>\nthread_cache_size = 384<br \/>\nwait_timeout = 7200<br \/>\nconnect_timeout = 10<br \/>\ntmp_table_size = 64M<br \/>\nmax_heap_table_size = 64M<br \/>\nmax_allowed_packet = 64M<br \/>\nmax_connect_errors = 1000<br \/>\nread_rnd_buffer_size = 524288<br \/>\nbulk_insert_buffer_size = 8M<br \/>\nquery_cache_limit = 4M<br \/>\nquery_cache_size =128M<br \/>\nquery_cache_type = 1<br \/>\nquery_prealloc_size = 65536<br \/>\nquery_alloc_block_size = 131072<br \/>\ndefault-storage-engine = MyISAM<br \/>\n[mysqld_safe]<br \/>\nnice = -5<br \/>\nopen_files_limit = 8192<br \/>\n[mysqldump]<br \/>\nquick<br \/>\nmax_allowed_packet = 16M<br \/>\n[myisamchk]<br \/>\nkey_buffer = 64M<br \/>\nsort_buffer = 64M<br \/>\nread_buffer = 16M<br \/>\nwrite_buffer = 16M<\/code><\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>The operating system your MySQL server runs on and the server&#8217;s configuration can be just as important to your server&#8217;s performance as the indexes (let EXPLAIN be your best friend), schema, or queries themselves. Be shure to check out High Performance MySQL &#8211; Server Performance Tuning from mySQL AB. In case you are stuck with&#8230;<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[3],"tags":[],"_links":{"self":[{"href":"https:\/\/www.nivas.hr\/blog\/wp-json\/wp\/v2\/posts\/40"}],"collection":[{"href":"https:\/\/www.nivas.hr\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.nivas.hr\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.nivas.hr\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.nivas.hr\/blog\/wp-json\/wp\/v2\/comments?post=40"}],"version-history":[{"count":0,"href":"https:\/\/www.nivas.hr\/blog\/wp-json\/wp\/v2\/posts\/40\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.nivas.hr\/blog\/wp-json\/wp\/v2\/media?parent=40"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.nivas.hr\/blog\/wp-json\/wp\/v2\/categories?post=40"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.nivas.hr\/blog\/wp-json\/wp\/v2\/tags?post=40"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}