{"id":3921,"date":"2015-08-05T19:10:36","date_gmt":"2015-08-05T19:10:36","guid":{"rendered":"http:\/\/www.deuzebranaweb.com.br\/?p=3921"},"modified":"2015-08-05T19:10:36","modified_gmt":"2015-08-05T19:10:36","slug":"how-to-optimize-mysql-for-1gb-memory-vps","status":"publish","type":"post","link":"https:\/\/blog.deuzebranaweb.com.br\/index.php\/2015\/08\/05\/how-to-optimize-mysql-for-1gb-memory-vps\/","title":{"rendered":"How to optimize MySql for 1GB Memory VPS"},"content":{"rendered":"<pre>[mysqld]\nmax_connections=250\nmax_user_connections = 30\nkey_buffer_size = 4M\nmyisam_sort_buffer_size = 16M\njoin_buffer_size = 8M\nread_buffer_size = 8M\nsort_buffer_size = 8M\nrecord_buffer_size = 8M\nmax_allowed_packet = 300M\ntable_open_cache = 200\nthread_cache_size = 128\nwait_timeout = 15\nconnect_timeout = 20\ninteractive_timeout = 25\nmax_connect_errors = 20\nquery_cache_type = 1\nquery_cache_limit = 32\nquery_cache_size = 32M\nlog-slow-queries\n\n[mysqld_safe]\nopen_files_limit = 8192\n\n[mysqldump]\nmax_allowed_packet = 8M\n\n[myisamchk]\nkey_buffer_size = 32M\nsort_buffer_size = 16M\nread_buffer_size = 20M\nwrite_buffer_size = 20M\nlocal-infile=0\n\nhttps:\/\/forums.cpanel.net\/threads\/etc-my-cnf-optimization.237351\/\n\noutro exemplo:\n\n\n<\/pre>\n<pre>[mysqld]\nmax_connections = 400\nkey_buffer = 32M\nmyisam_sort_buffer_size = 32M\njoin_buffer_size = 1M\nread_buffer_size = 1M\nsort_buffer_size = 2M\ntable_cache = 1024\nthread_cache_size = 286\ninteractive_timeout = 25\nwait_timeout = 1000\nconnect_timeout = 10\nmax_allowed_packet = 16M\nmax_connect_errors = 10\nquery_cache_limit = 1M\nquery_cache_size = 16M\nquery_cache_type = 1\ntmp_table_size = 16M\n\n\n[mysqld_safe]\nopen_files_limit = 8192\n\n[mysqldump]\nquick\nmax_allowed_packet = 16M\n\n[myisamchk]\nkey_buffer = 64M\nsort_buffer = 64M\nread_buffer = 16M\nwrite_buffer = 16M\n\nlocal-infile=0\n<\/pre>\n<p>save.<\/p>\n<p>Restart mysql<\/p>\n<p>\/etc\/rc.d\/init.d\/mysql restart<\/p>\n<p>Restore old backup<br \/>\ncp \/etc\/my.cnf.old \/etc\/my.cnf<\/p>\n<p>\/etc\/rc.d\/init.d\/mysql restart<\/p>\n<p>&nbsp;<\/p>\n<p>http:\/\/www.maxwhale.com\/how-to-optimize-mysql-for-1gb-memory-vps\/<\/p>\n","protected":false},"excerpt":{"rendered":"<p>[mysqld] max_connections=250 max_user_connections = 30 key_buffer_size = 4M myisam_sort_buffer_size = 16M join_buffer_size = 8M read_buffer_size = 8M sort_buffer_size = 8M record_buffer_size = 8M max_allowed_packet = 300M table_open_cache = 200 thread_cache_size = 128 wait_timeout = 15 connect_timeout = 20 interactive_timeout = 25 max_connect_errors = 20 query_cache_type&#8230;<\/p>\n","protected":false},"author":2,"featured_media":3925,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_angie_page":false,"page_builder":"","footnotes":""},"categories":[13],"tags":[],"class_list":["post-3921","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-msql"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/blog.deuzebranaweb.com.br\/index.php\/wp-json\/wp\/v2\/posts\/3921","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.deuzebranaweb.com.br\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.deuzebranaweb.com.br\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.deuzebranaweb.com.br\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.deuzebranaweb.com.br\/index.php\/wp-json\/wp\/v2\/comments?post=3921"}],"version-history":[{"count":0,"href":"https:\/\/blog.deuzebranaweb.com.br\/index.php\/wp-json\/wp\/v2\/posts\/3921\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.deuzebranaweb.com.br\/index.php\/wp-json\/wp\/v2\/media\/3925"}],"wp:attachment":[{"href":"https:\/\/blog.deuzebranaweb.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=3921"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.deuzebranaweb.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=3921"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.deuzebranaweb.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=3921"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}