{"id":146,"date":"2011-11-30T10:47:08","date_gmt":"2011-11-30T10:47:08","guid":{"rendered":"https:\/\/shan.info\/new\/mysql-mycnf-4g-centos-5-7-plesk-sb-panel\/"},"modified":"2011-11-30T10:47:08","modified_gmt":"2011-11-30T10:47:08","slug":"mysql-mycnf-4g-centos-5-7-plesk-sb-panel","status":"publish","type":"post","link":"https:\/\/shan.info\/new\/mysql-mycnf-4g-centos-5-7-plesk-sb-panel\/","title":{"rendered":"mysql mycnf 4g centos 5.7 plesk sb panel"},"content":{"rendered":"<p>[mysqld]<br \/>bind-address=127.0.0.1<br \/>set-variable=local-infile=0<br \/>datadir=\/var\/lib\/mysql<br \/>socket=\/var\/lib\/mysql\/mysql.sock<br \/>user=mysql<br \/># Default to using old password format for compatibility with mysql 3.x<br \/># clients (those using the mysqlclient10 compatibility package).<br \/>old_passwords=1<\/p>\n<p>\u00a0<\/p>\n<p><!--more--><\/p>\n<p>\u00a0<\/p>\n<p><p>[MySQLD]<\/p>\n<p>port=3306<\/p>\n<p>basedir=C:\\Program Files (x86)\\Parallels\\Plesk\\Databases\\MySQL<\/p>\n<p>datadir=C:\\Program Files (x86)\\Parallels\\Plesk\\Databases\\MySQL\\Data<\/p>\n<p>default-character-set=latin1<\/p>\n<p>default-storage-engine=INNODB<\/p>\n<p>skip-locking<\/p>\n<p>key_buffer = 500M<\/p>\n<p>join_buffer_size=8M<\/p>\n<p>sort_buffer_size=32M<\/p>\n<p>read_buffer_size=4M<\/p>\n<p>read_rnd_buffer_size=8M<\/p>\n<p>myisam_sort_buffer_size = 128M<\/p>\n<p>record_buffer=32M<\/p>\n<p>query_cache_size = 512M<\/p>\n<p>query_cache_type=1<\/p>\n<p>table_cache = 256<\/p>\n<p>innodb_additional_mem_pool_size=2M<\/p>\n<p>innodb_flush_log_at_trx_commit=1<\/p>\n<p>innodb_log_buffer_size=1M<\/p>\n<p>innodb_buffer_pool_size=16M<\/p>\n<p>innodb_log_file_size=10M<\/p>\n<p>innodb_thread_concurrency=8<\/p>\n<p>max_connections=600<\/p>\n<p>old_passwords=1<\/p>\n<p>max_user_connections=30<\/p>\n<p>thread_cache_size=4<\/p>\n<p>thread_stack=196608<\/p>\n<p>binlog_cache_size=32768<\/p>\n<p>net_read_timeout=30<\/p>\n<p>net_retry_count=10<\/p>\n<p>net_write_timeout=30<\/p>\n<p>thread_concurrency=10<\/p>\n<p>open_files_limit=0<\/p>\n<p>[client]<\/p>\n<p>port=3306<\/p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>[mysqld]bind-address=127.0.0.1set-variable=local-infile=0datadir=\/var\/lib\/mysqlsocket=\/var\/lib\/mysql\/mysql.sockuser=mysql# Default to using old password format for compatibility with mysql 3.x# clients (those using the mysqlclient10 compatibility package).old_passwords=1<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[67],"tags":[],"class_list":["post-146","post","type-post","status-publish","format-standard","hentry","category-centos-5"],"_links":{"self":[{"href":"https:\/\/shan.info\/new\/wp-json\/wp\/v2\/posts\/146","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/shan.info\/new\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/shan.info\/new\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/shan.info\/new\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/shan.info\/new\/wp-json\/wp\/v2\/comments?post=146"}],"version-history":[{"count":0,"href":"https:\/\/shan.info\/new\/wp-json\/wp\/v2\/posts\/146\/revisions"}],"wp:attachment":[{"href":"https:\/\/shan.info\/new\/wp-json\/wp\/v2\/media?parent=146"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/shan.info\/new\/wp-json\/wp\/v2\/categories?post=146"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/shan.info\/new\/wp-json\/wp\/v2\/tags?post=146"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}