{"id":84,"date":"2010-11-06T20:24:42","date_gmt":"2010-11-06T20:24:42","guid":{"rendered":"https:\/\/shan.info\/new\/virtualmin-mysql-%e8%ae%be%e7%bd%ae\/"},"modified":"2010-11-06T20:24:42","modified_gmt":"2010-11-06T20:24:42","slug":"virtualmin-mysql-%e8%ae%be%e7%bd%ae","status":"publish","type":"post","link":"https:\/\/shan.info\/new\/virtualmin-mysql-%e8%ae%be%e7%bd%ae\/","title":{"rendered":"virtualmin mysql \u8bbe\u7f6e"},"content":{"rendered":"<p>althlon 64\u00a0 2g\u5185\u5b58<\/p>\n<p>\u00a0<\/p>\n<p>\/etc\/mysql\/my.cnf<\/p>\n<p>\u00a0<\/p>\n<p><strong>MySQL server listening address<\/strong> <input id=\"bind_def_1\" class=\"ui_radio\" type=\"radio\" name=\"bind_def\" value=\"1\" \/> <label for=\"bind_def_1\">Any<\/label> <input id=\"bind_def_0\" class=\"ui_radio\" type=\"radio\" name=\"bind_def\" value=\"0\" checked=\"checked\" \/> <label for=\"bind_def_0\"> <\/label> <input class=\"ui_opt_textbox\" type=\"text\" name=\"bind\" value=\"127.0.0.1\" size=\"20\" \/><\/p>\n<p>\u9009\u62e9 any \u5141\u8bb8 \u8fdc\u7a0b\u8fde\u63a5<\/p>\n<p>\u00a0<\/p>\n<p>&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;<\/p>\n<p>VERSION 1<\/p>\n<p>&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;<\/p>\n<p>#<br \/># The MySQL database server configuration file.<br \/>#<br \/># You can copy this to one of:<br \/># &#8211; &#8220;\/etc\/mysql\/my.cnf&#8221; to set global options,<br \/># &#8211; &#8220;~\/.my.cnf&#8221; to set user-specific options.<br \/># <br \/># One can use all long options that the program supports.<br \/># Run program with &#8211;help to get a list of available options and with<br \/># &#8211;print-defaults to see which it would actually understand and use.<br \/>#<br \/># For explanations see<br \/># http:\/\/dev.mysql.com\/doc\/mysql\/en\/server-system-variables.html<\/p>\n<p># This will be passed to all mysql clients<br \/># It has been reported that passwords should be enclosed with ticks\/quotes<br \/># escpecially if they contain &#8220;#&#8221; chars&#8230;<br \/># Remember to edit \/etc\/mysql\/debian.cnf when changing the socket location.<br \/>[client]<br \/>port\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 = 3306<br \/>socket\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 = \/var\/run\/mysqld\/mysqld.sock<\/p>\n<p># Here is entries for some specific programs<br \/># The following values assume you have at least 32M ram<\/p>\n<p># This was formally known as [safe_mysqld]. Both versions are currently parsed.<br \/>[mysqld_safe]<br \/>socket\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 = \/var\/run\/mysqld\/mysqld.sock<br \/>nice\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 = 0<\/p>\n<p>[mysqld]<br \/>#<br \/># * Basic Settings<br \/>#<br \/>user\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 = mysql<br \/>pid-file\u00a0\u00a0\u00a0 = \/var\/run\/mysqld\/mysqld.pid<br \/>socket\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 = \/var\/run\/mysqld\/mysqld.sock<br \/>port\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 = 3306<br \/>basedir\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 = \/usr<br \/>datadir\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 = \/var\/lib\/mysql<br \/>tmpdir\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 = \/tmp<br \/>language\u00a0\u00a0\u00a0 = \/usr\/share\/mysql\/english<br \/>skip-external-locking<br \/>#<br \/># Instead of skip-networking the default is now to listen only on<br \/># localhost which is more compatible and is not less secure.<br \/>bind-address\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 = 127.0.0.1<br \/>#<br \/># * Fine Tuning<br \/>#<br \/>key_buffer = 384M<br \/>max_allowed_packet\u00a0\u00a0\u00a0 = 32M<br \/>thread_stack\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 = 128K<br \/>thread_cache_size\u00a0\u00a0\u00a0 = 8<br \/># This replaces the startup script and checks MyISAM tables if needed<br \/># the first time they are touched<br \/>myisam-recover\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 = BACKUP<br \/>#max_connections\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = 100<br \/>table_cache\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = 512<br \/>sort_buffer_size = 2M<br \/>read_buffer_size = 2M<br \/>read_rnd_buffer_size = 8M<br \/>myisam_sort_buffer_size = 64M<\/p>\n<p># Try number of CPU&#8217;s*2 for thread_concurrency<br \/>thread_concurrency\u00a0\u00a0\u00a0\u00a0 = 8<br \/>#<br \/># * Query Cache Configuration<br \/>#<br \/>query_cache_limit\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = 1M<br \/>query_cache_size\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = 32M<br \/>#<br \/># * Logging and Replication<br \/>#<br \/># Both location gets rotated by the cronjob.<br \/># Be aware that this log type is a performance killer.<br \/>#log\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 = \/var\/log\/mysql\/mysql.log<br \/>#<br \/># Error logging goes to syslog. This is a Debian improvement \ud83d\ude42<br \/>#<br \/># Here you can see queries with especially long duration<br \/>#log_slow_queries\u00a0\u00a0\u00a0 = \/var\/log\/mysql\/mysql-slow.log<br \/>#long_query_time = 2<br \/>#log-queries-not-using-indexes<br \/>#<br \/># The following can be used as easy to replay backup logs or for replication.<br \/># note: if you are setting up a replication slave, see README.Debian about<br \/>#\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 other settings you may need to change.<br \/>#server-id\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 = 1<br \/>#log_bin\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 = \/var\/log\/mysql\/mysql-bin.log<br \/>expire_logs_days\u00a0\u00a0\u00a0 = 10<br \/>max_binlog_size\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = 100M<br \/>#binlog_do_db\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 = include_database_name<br \/>#binlog_ignore_db\u00a0\u00a0\u00a0 = include_database_name<br \/>#<br \/># * BerkeleyDB<br \/>#<br \/># Using BerkeleyDB is now discouraged as its support will cease in 5.1.12.<br \/>skip-bdb<br \/>#<br \/># * InnoDB<br \/>#<br \/># InnoDB is enabled by default with a 10MB datafile in \/var\/lib\/mysql\/.<br \/># Read the manual for more InnoDB related options. There are many!<br \/># You might want to disable InnoDB to shrink the mysqld process by circa 100MB.<br \/>#skip-innodb<br \/>#<br \/># * Security Features<br \/>#<br \/># Read the manual, too, if you want chroot!<br \/># chroot = \/var\/lib\/mysql\/<br \/>#<br \/># For generating SSL certificates I recommend the OpenSSL GUI &#8220;tinyca&#8221;.<br \/>#<br \/># ssl-ca=\/etc\/mysql\/cacert.pem<br \/># ssl-cert=\/etc\/mysql\/server-cert.pem<br \/># ssl-key=\/etc\/mysql\/server-key.pem<\/p>\n<p>[mysqldump]<br \/>quick<br \/>quote-names<br \/>max_allowed_packet\u00a0\u00a0\u00a0 = 16M<\/p>\n<p>[mysql]<br \/>#no-auto-rehash\u00a0\u00a0\u00a0 # faster start of mysql but no tab completition<\/p>\n<p>[isamchk]<br \/>key_buffer\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 = 16M<\/p>\n<p>#<br \/># * NDB Cluster<br \/>#<br \/># See \/usr\/share\/doc\/mysql-server-*\/README.Debian for more information.<br \/>#<br \/># The following configuration is read by the NDB Data Nodes (ndbd processes)<br \/># not from the NDB Management Nodes (ndb_mgmd processes).<br \/>#<br \/># [MYSQL_CLUSTER]<br \/># ndb-connectstring=127.0.0.1<\/p>\n<p>#<br \/># * IMPORTANT: Additional settings that can override those from this file!<br \/>#\u00a0\u00a0 The files must end with &#8216;.cnf&#8217;, otherwise they&#8217;ll be ignored.<br \/>#<br \/>!includedir \/etc\/mysql\/conf.d\/<\/p>\n<p>\u00a0<\/p>\n<p>\u00a0<\/p>\n<p>\u00a0<\/p>\n<p>\u00a0<\/p>\n<p>\u00a0<\/p>\n<p>&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;<\/p>\n<p>\u00a0<\/p>\n<p>\u00a0<\/p>\n<p>[client]<br \/>port\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 = 3306<br \/>socket\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 = \/var\/run\/mysqld\/mysqld.sock<\/p>\n<p>[mysqld_safe]<br \/>socket\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 = \/var\/run\/mysqld\/mysqld.sock<br \/>nice\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 = 0<\/p>\n<p>[mysqld]<\/p>\n<p>user\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 = mysql<br \/>pid-file\u00a0\u00a0\u00a0 = \/var\/run\/mysqld\/mysqld.pid<br \/>socket = \/var\/run\/mysqld\/mysqld.sock<br \/>port = 3306<br \/>basedir\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 = \/usr<br \/>datadir = \/var\/lib\/mysql<br \/>tmpdir\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 = \/tmp<br \/>language\u00a0\u00a0\u00a0 = \/usr\/share\/mysql\/english<br \/>skip-external-locking<\/p>\n<p>key_buffer = 384M<br \/>max_allowed_packet\u00a0\u00a0\u00a0 = 32M<br \/>thread_stack\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 = 128K<br \/>thread_cache_size\u00a0\u00a0\u00a0 = 8<\/p>\n<p>myisam-recover\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 = BACKUP<\/p>\n<p>table_cache\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = 512<br \/>sort_buffer_size = 2M<br \/>read_buffer_size = 2M<br \/>read_rnd_buffer_size = 8M<br \/>myisam_sort_buffer_size = 64M<\/p>\n<p>thread_concurrency\u00a0\u00a0\u00a0\u00a0 = 8<\/p>\n<p>query_cache_limit\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = 1M<br \/>query_cache_size\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = 32M<\/p>\n<p>expire_logs_days\u00a0\u00a0\u00a0 = 10<br \/>max_binlog_size\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = 100M<\/p>\n<p>skip-bdb<br \/>set-variable = max_allowed_packet=32M<br \/>set-variable = key_buffer=400M<\/p>\n<p>[mysqldump]<br \/>quick<br \/>quote-names<br \/>max_allowed_packet\u00a0\u00a0\u00a0 = 16M<\/p>\n<p>[mysql]<\/p>\n<p>[isamchk]<br \/>key_buffer\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 = 16M<\/p>\n<p>!includedir \/etc\/mysql\/conf.d\/<\/p>\n<p>\u00a0<\/p>\n<p>\u00a0<\/p>\n<p>&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;-<\/p>\n","protected":false},"excerpt":{"rendered":"<p>althlon 64\u00a0 2g\u5185\u5b58 \u00a0 \/etc\/mysql\/my.cnf \u00a0 MySQL server listening address Any \u9009\u62e9 any \u5141\u8bb8 \u8fdc\u7a0b\u8fde\u63a5 \u00a0 &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211; VERSION 1 &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211; ## The MySQL database server configuration file.## You can copy this to one of:# &#8211; &#8220;\/etc\/mysql\/my.cnf&#8221; to set global options,# &#8211; &#8220;~\/.my.cnf&#8221; to set user-specific options.# # One can use all long options that the [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[31],"tags":[],"class_list":["post-84","post","type-post","status-publish","format-standard","hentry","category-debian"],"_links":{"self":[{"href":"https:\/\/shan.info\/new\/wp-json\/wp\/v2\/posts\/84","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=84"}],"version-history":[{"count":0,"href":"https:\/\/shan.info\/new\/wp-json\/wp\/v2\/posts\/84\/revisions"}],"wp:attachment":[{"href":"https:\/\/shan.info\/new\/wp-json\/wp\/v2\/media?parent=84"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/shan.info\/new\/wp-json\/wp\/v2\/categories?post=84"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/shan.info\/new\/wp-json\/wp\/v2\/tags?post=84"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}