{"id":38,"date":"2008-09-02T14:31:06","date_gmt":"2008-09-02T07:31:06","guid":{"rendered":"http:\/\/www.icez.net\/blog\/?p=38"},"modified":"2010-08-29T14:41:22","modified_gmt":"2010-08-29T07:41:22","slug":"mysql-mycnf","status":"publish","type":"post","link":"https:\/\/www.icez.net\/blog\/38\/mysql-mycnf","title":{"rendered":"0031 | MySQL: my.cnf"},"content":{"rendered":"<p>\u0e40\u0e2d\u0e32\u0e21\u0e32\u0e40\u0e01\u0e47\u0e1a\u0e44\u0e27\u0e49\u0e2e\u0e30 \u0e2a\u0e33\u0e2b\u0e23\u0e31\u0e1a\u0e41\u0e23\u0e21 4gb \u0e10\u0e32\u0e19\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e02\u0e19\u0e32\u0e14 1 gb<\/p>\n<blockquote>\n<pre>[mysqld]\r\ndatadir=\/var\/lib\/mysql\r\nsocket=\/var\/lib\/mysql\/mysql.sock\r\nuser=mysql\r\n# Default to using old password format for compatibility with mysql 3.x\r\n# clients (those using the mysqlclient10 compatibility package).\r\nold_passwords=1\r\nset-variable=local-infile=0\r\nskip-character-set-client-handshake\r\nskip-name-resolve\r\nskip-bdb\r\nmax_connections = 600\r\nkey_buffer = 512M\r\nmyisam_sort_buffer_size = 32M\r\njoin_buffer_size = 1M\r\nread_buffer_size = 2M\r\nsort_buffer_size = 4M\r\ntable_cache = 1536\r\nthread_cache = 8\r\nthread_concurrency = 4\r\nthread_cache_size = 256\r\nwait_timeout = 600\r\nconnect_timeout = 10\r\nmax_tmp_tables = 256\r\ntmp_table_size = 64M\r\nmax_allowed_packet = 16M\r\nmax_connect_errors = 10\r\nquery_cache_limit = 1M\r\nquery_cache_size = 32M\r\nquery_cache_type = 1\r\nquery_prealloc_size = 16384\r\nquery_alloc_block_size = 16384\r\nlog_slow_queries\r\nlog_queries_not_using_indexes\r\n\r\n[mysqld_safe]\r\nlog-error=\/var\/log\/mysqld.log\r\npid-file=\/var\/run\/mysqld\/mysqld.pid\r\nopen_files_limit = 8192<\/pre>\n<\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>\u0e40\u0e2d\u0e32\u0e21\u0e32\u0e40\u0e01\u0e47\u0e1a\u0e44\u0e27\u0e49\u0e2e\u0e30 \u0e2a\u0e33\u0e2b\u0e23\u0e31\u0e1a\u0e41\u0e23\u0e21 4gb \u0e10\u0e32\u0e19\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e02\u0e19\u0e32\u0e14 1 gb [mysqld] datadir=\/var\/lib\/mysql socket=\/var\/lib\/mysql\/mysql.sock user=mysql # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1 set-variable=local-infile=0 skip-character-set-client-handshake skip-name-resolve skip-bdb max_connections = 600 key_buffer = 512M myisam_sort_buffer_size = 32M join_buffer_size = 1M read_buffer_size = 2M sort_buffer_size = 4M table_cache = [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[61,5903,16],"class_list":["post-38","post","type-post","status-publish","format-standard","hentry","category-database","tag-configuration","tag-mysql","tag-optimize"],"_links":{"self":[{"href":"https:\/\/www.icez.net\/blog\/wp-json\/wp\/v2\/posts\/38","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.icez.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.icez.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.icez.net\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.icez.net\/blog\/wp-json\/wp\/v2\/comments?post=38"}],"version-history":[{"count":1,"href":"https:\/\/www.icez.net\/blog\/wp-json\/wp\/v2\/posts\/38\/revisions"}],"predecessor-version":[{"id":809,"href":"https:\/\/www.icez.net\/blog\/wp-json\/wp\/v2\/posts\/38\/revisions\/809"}],"wp:attachment":[{"href":"https:\/\/www.icez.net\/blog\/wp-json\/wp\/v2\/media?parent=38"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.icez.net\/blog\/wp-json\/wp\/v2\/categories?post=38"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.icez.net\/blog\/wp-json\/wp\/v2\/tags?post=38"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}