{"id":2555,"date":"2015-08-14T04:41:36","date_gmt":"2015-08-14T04:41:36","guid":{"rendered":"https:\/\/qbytes.cloud\/?p=2555"},"modified":"2015-08-14T04:41:36","modified_gmt":"2015-08-14T04:41:36","slug":"mysql-large-cnf","status":"publish","type":"post","link":"https:\/\/www.qbytes.cloud\/index.php\/2015\/08\/14\/mysql-large-cnf\/","title":{"rendered":"mysql-large.cnf"},"content":{"rendered":"<pre class=\"brush: bash; title: ; notranslate\" title=\"\">\n# Example MySQL config file for large systems.\n#\n# This is for a large system with memory = 512M where the system runs mainly\n# MySQL.\n#\n# MySQL programs look for option files in a set of\n# locations which depend on the deployment platform.\n# You can copy this option file to one of those\n# locations. For information about these locations, see:\n# http:\/\/dev.mysql.com\/doc\/mysql\/en\/option-files.html\n#\n# In this file, you can use all long options that a program supports.\n# If you want to know which options a program supports, run the program\n# with the &quot;--help&quot; option.\n\n# The following options will be passed to all MySQL clients\n&#x5B;client]\n#password       = your_password\nport            = 3306\nsocket          = \/var\/lib\/mysql\/mysql.sock\n\n# Here follows entries for some specific programs\n\n# The MySQL server\n&#x5B;mysqld]\nport            = 3306\nsocket          = \/var\/lib\/mysql\/mysql.sock\nskip-external-locking\nkey_buffer_size = 256M\nmax_allowed_packet = 1M\ntable_open_cache = 256\nsort_buffer_size = 1M\nread_buffer_size = 1M\nread_rnd_buffer_size = 4M\nmyisam_sort_buffer_size = 64M\nthread_cache_size = 8\nquery_cache_size= 16M\n# Try number of CPU&#039;s*2 for thread_concurrency\nthread_concurrency = 8\n\n# Don&#039;t listen on a TCP\/IP port at all. This can be a security enhancement,\n# if all processes that need to connect to mysqld run on the same host.\n# All interaction with mysqld must be made via Unix sockets or named pipes.\n# Note that using this option without enabling named pipes on Windows\n# (via the &quot;enable-named-pipe&quot; option) will render mysqld useless!\n#\n#skip-networking\n\n# Replication Master Server (default)\n# binary logging is required for replication\nlog-bin=mysql-bin\n\n# binary logging format - mixed recommended\nbinlog_format=mixed\n\n# required unique id between 1 and 2^32 - 1\n# defaults to 1 if master-host is not set\n# but will not function as a master if omitted\nserver-id       = 1\n\n# Replication Slave (comment out master section to use this)\n#\n# To configure this host as a replication slave, you can choose between\n# two methods :\n#\n# 1) Use the CHANGE MASTER TO command (fully described in our manual) -\n#    the syntax is:\n#\n#    CHANGE MASTER TO MASTER_HOST=&lt;host&gt;, MASTER_PORT=&lt;port&gt;,\n#    MASTER_USER=&lt;user&gt;, MASTER_PASSWORD=&lt;password&gt; ;\n\n#\n#    where you replace &lt;host&gt;, &lt;user&gt;, &lt;password&gt; by quoted strings and\n#    &lt;port&gt; by the master&#039;s port number (3306 by default).\n#\n#    Example:\n#\n#    CHANGE MASTER TO MASTER_HOST=&#039;125.564.12.1&#039;, MASTER_PORT=3306,\n#    MASTER_USER=&#039;joe&#039;, MASTER_PASSWORD=&#039;secret&#039;;\n#\n# OR\n#\n# 2) Set the variables below. However, in case you choose this method, then\n#    start replication for the first time (even unsuccessfully, for example\n#    if you mistyped the password in master-password and the slave fails to\n#    connect), the slave will create a master.info file, and any later\n#    change in this file to the variables&#039; values below will be ignored and\n#    overridden by the content of the master.info file, unless you shutdown\n#    the slave server, delete master.info and restart the slaver server.\n#    For that reason, you may want to leave the lines below untouched\n#    (commented) and instead use CHANGE MASTER TO (see above)\n#\n# required unique id between 2 and 2^32 - 1\n# (and different from the master)\n# defaults to 2 if master-host is set\n# but will not function as a slave if omitted\n#server-id       = 2\n#\n# The replication master for this slave - required\n#master-host     =   &lt;hostname&gt;\n#\n# The username the slave will use for authentication when connecting\n# to the master - required\n#master-user     =   &lt;username&gt;\n#\n# The password the slave will authenticate with when connecting to\n# the master - required\n#master-password =   &lt;password&gt;\n#\n# The port the master is listening on.\n# optional - defaults to 3306\n#master-port     =  &lt;port&gt;\n#\n# binary logging - not required for slaves, but recommended\n#log-bin=mysql-bin\n\n# Uncomment the following if you are using InnoDB tables\n#innodb_data_home_dir = \/var\/lib\/mysql\n#innodb_data_file_path = ibdata1:10M:autoextend\n#innodb_log_group_home_dir = \/var\/lib\/mysql\n# You can set .._buffer_pool_size up to 50 - 80 %\n# of RAM but beware of setting memory usage too high\n#innodb_buffer_pool_size = 256M\n#innodb_additional_mem_pool_size = 20M\n# Set .._log_file_size to 25 % of buffer pool size\n#innodb_log_file_size = 64M\n#innodb_log_buffer_size = 8M\n#innodb_flush_log_at_trx_commit = 1\n#innodb_lock_wait_timeout = 50\n\n&#x5B;mysqldump]\nquick\nmax_allowed_packet = 16M\n&#x5B;mysql]\nno-auto-rehash\n# Remove the next comment character if you are not familiar with SQL\n#safe-updates\n\n&#x5B;myisamchk]\nkey_buffer_size = 128M\nsort_buffer_size = 128M\nread_buffer = 2M\nwrite_buffer = 2M\n\n&#x5B;mysqlhotcopy]\ninteractive-timeout\n\n\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p># Example MySQL config file for large systems. # # This is for a large system with memory = 512M where the system runs mainly # MySQL. # # MySQL programs look for option files in a set of # locations which depend on the deployment platform. # You can copy this option file to &#8230; <a title=\"mysql-large.cnf\" class=\"read-more\" href=\"https:\/\/www.qbytes.cloud\/index.php\/2015\/08\/14\/mysql-large-cnf\/\" aria-label=\"Read more about mysql-large.cnf\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[70],"tags":[],"class_list":["post-2555","post","type-post","status-publish","format-standard","hentry","category-mysql"],"_links":{"self":[{"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/posts\/2555","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/comments?post=2555"}],"version-history":[{"count":0,"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/posts\/2555\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/media?parent=2555"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/categories?post=2555"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/tags?post=2555"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}