{"id":178,"date":"2009-08-27T06:00:54","date_gmt":"2009-08-27T04:00:54","guid":{"rendered":"http:\/\/www.shukko.com\/x3\/2009\/08\/27\/example-mysql-config-file-for-large-systems\/"},"modified":"2009-08-27T06:00:54","modified_gmt":"2009-08-27T04:00:54","slug":"example-mysql-config-file-for-large-systems","status":"publish","type":"post","link":"https:\/\/www.shukko.com\/x3\/2009\/08\/27\/example-mysql-config-file-for-large-systems\/","title":{"rendered":"Example MySQL config file for large systems."},"content":{"rendered":"<p># Example MySQL config file for large systems.<\/p>\n<p># The MySQL server<br \/>\n[mysqld]<br \/>\nuser=mysql<br \/>\ndatadir=\/var\/lib\/mysql<br \/>\nport            = 3306<br \/>\nsocket          = \/var\/lib\/mysql\/mysql.sock<br \/>\nold_passwords=1<br \/>\nskip-locking<br \/>\nkey_buffer = 256M<br \/>\nmax_allowed_packet = 1M<br \/>\ntable_cache = 256<br \/>\nsort_buffer_size = 1M<br \/>\nread_buffer_size = 2M<br \/>\nread_rnd_buffer_size = 4M<br \/>\nmyisam_sort_buffer_size = 64M<br \/>\nthread_cache_size = 8<br \/>\nquery_cache_size= 32M<br \/>\nlong_query_time = 4<br \/>\n# Try number of CPU&#8217;s*2 for thread_concurrency<br \/>\nthread_concurrency = 2<br \/>\nskip-bdb<\/p>\n<p>[mysqldump]<br \/>\nquick<br \/>\nmax_allowed_packet = 16M<\/p>\n<p>[mysql]<br \/>\nno-auto-rehash<br \/>\n# Remove the next comment character if you are not familiar with SQL<br \/>\n#safe-updates<\/p>\n<p>[isamchk]<br \/>\nkey_buffer = 128M<br \/>\nsort_buffer_size = 128M<br \/>\nread_buffer = 2M<br \/>\nwrite_buffer = 2M<\/p>\n<p>[myisamchk]<br \/>\nkey_buffer = 128M<br \/>\nsort_buffer_size = 128M<br \/>\nread_buffer = 2M<br \/>\nwrite_buffer = 2M<\/p>\n<p>[mysqlhotcopy]<br \/>\ninteractive-timeout<\/p>\n<p>[mysqld_safe]<br \/>\nlog-error=\/var\/log\/mysqld.log<br \/>\npid-file=\/var\/run\/mysqld\/mysqld.pid<\/p>\n","protected":false},"excerpt":{"rendered":"<p># Example MySQL config file for large systems. # The MySQL server [mysqld] user=mysql datadir=\/var\/lib\/mysql port = 3306 socket = \/var\/lib\/mysql\/mysql.sock old_passwords=1 skip-locking key_buffer = 256M max_allowed_packet = 1M table_cache = 256 sort_buffer_size = 1M read_buffer_size = 2M read_rnd_buffer_size = 4M myisam_sort_buffer_size = 64M thread_cache_size = 8 query_cache_size= 32M long_query_time = 4 # Try number [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-178","post","type-post","status-publish","format-standard","hentry","category-kategerisiz"],"_links":{"self":[{"href":"https:\/\/www.shukko.com\/x3\/wp-json\/wp\/v2\/posts\/178","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.shukko.com\/x3\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.shukko.com\/x3\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.shukko.com\/x3\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.shukko.com\/x3\/wp-json\/wp\/v2\/comments?post=178"}],"version-history":[{"count":0,"href":"https:\/\/www.shukko.com\/x3\/wp-json\/wp\/v2\/posts\/178\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.shukko.com\/x3\/wp-json\/wp\/v2\/media?parent=178"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.shukko.com\/x3\/wp-json\/wp\/v2\/categories?post=178"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.shukko.com\/x3\/wp-json\/wp\/v2\/tags?post=178"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}