wok annotate mysql/stuff/etc/mysql/my.cnf @ rev 13187

Up: mysql to 5.5.27.
author Christopher Rogers <slaxemulator@gmail.com>
date Fri Aug 03 08:06:59 2012 +0000 (2012-08-03)
parents
children
rev   line source
slaxemulator@13187 1 # MySQL config file for medium systems.
slaxemulator@13187 2 #
slaxemulator@13187 3 # This is for a system with little memory (32M - 64M) where MySQL plays
slaxemulator@13187 4 # an important part, or systems up to 128M where MySQL is used together with
slaxemulator@13187 5 # other programs (such as a web server)
slaxemulator@13187 6 #
slaxemulator@13187 7 # MySQL programs look for option files in a set of
slaxemulator@13187 8 # locations which depend on the deployment platform.
slaxemulator@13187 9 # You can copy this option file to one of those
slaxemulator@13187 10 # locations. For information about these locations, see:
slaxemulator@13187 11 # http://dev.mysql.com/doc/mysql/en/option-files.html
slaxemulator@13187 12 #
slaxemulator@13187 13 # In this file, you can use all long options that a program supports.
slaxemulator@13187 14 # If you want to know which options a program supports, run the program
slaxemulator@13187 15 # with the "--help" option.
slaxemulator@13187 16
slaxemulator@13187 17 # The following options will be passed to all MySQL clients
slaxemulator@13187 18 [client]
slaxemulator@13187 19 #password = your_password
slaxemulator@13187 20 port = 3306
slaxemulator@13187 21 socket = /var/run/mysqld/mysqld.sock
slaxemulator@13187 22
slaxemulator@13187 23 # Here follows entries for some specific programs
slaxemulator@13187 24
slaxemulator@13187 25 # The MySQL server
slaxemulator@13187 26 [mysqld]
slaxemulator@13187 27 port = 3306
slaxemulator@13187 28 socket = /var/run/mysqld/mysqld.sock
slaxemulator@13187 29 datadir = /var/lib/mysql
slaxemulator@13187 30 skip-external-locking
slaxemulator@13187 31 key_buffer_size = 16M
slaxemulator@13187 32 max_allowed_packet = 1M
slaxemulator@13187 33 table_open_cache = 64
slaxemulator@13187 34 sort_buffer_size = 512K
slaxemulator@13187 35 net_buffer_length = 8K
slaxemulator@13187 36 read_buffer_size = 256K
slaxemulator@13187 37 read_rnd_buffer_size = 512K
slaxemulator@13187 38 myisam_sort_buffer_size = 8M
slaxemulator@13187 39
slaxemulator@13187 40 # Don't listen on a TCP/IP port at all. This can be a security enhancement,
slaxemulator@13187 41 # if all processes that need to connect to mysqld run on the same host.
slaxemulator@13187 42 # All interaction with mysqld must be made via Unix sockets or named pipes.
slaxemulator@13187 43 # Note that using this option without enabling named pipes on Windows
slaxemulator@13187 44 # (via the "enable-named-pipe" option) will render mysqld useless!
slaxemulator@13187 45 #
slaxemulator@13187 46 skip-networking
slaxemulator@13187 47
slaxemulator@13187 48 # Replication Master Server (default)
slaxemulator@13187 49 # binary logging is required for replication
slaxemulator@13187 50 log-bin=mysql-bin
slaxemulator@13187 51
slaxemulator@13187 52 # binary logging format - mixed recommended
slaxemulator@13187 53 binlog_format=mixed
slaxemulator@13187 54
slaxemulator@13187 55 # required unique id between 1 and 2^32 - 1
slaxemulator@13187 56 # defaults to 1 if master-host is not set
slaxemulator@13187 57 # but will not function as a master if omitted
slaxemulator@13187 58 server-id = 1
slaxemulator@13187 59
slaxemulator@13187 60 # Replication Slave (comment out master section to use this)
slaxemulator@13187 61 #
slaxemulator@13187 62 # To configure this host as a replication slave, you can choose between
slaxemulator@13187 63 # two methods :
slaxemulator@13187 64 #
slaxemulator@13187 65 # 1) Use the CHANGE MASTER TO command (fully described in our manual) -
slaxemulator@13187 66 # the syntax is:
slaxemulator@13187 67 #
slaxemulator@13187 68 # CHANGE MASTER TO MASTER_HOST=<host>, MASTER_PORT=<port>,
slaxemulator@13187 69 # MASTER_USER=<user>, MASTER_PASSWORD=<password> ;
slaxemulator@13187 70 #
slaxemulator@13187 71 # where you replace <host>, <user>, <password> by quoted strings and
slaxemulator@13187 72 # <port> by the master's port number (3306 by default).
slaxemulator@13187 73 #
slaxemulator@13187 74 # Example:
slaxemulator@13187 75 #
slaxemulator@13187 76 # CHANGE MASTER TO MASTER_HOST='125.564.12.1', MASTER_PORT=3306,
slaxemulator@13187 77 # MASTER_USER='joe', MASTER_PASSWORD='secret';
slaxemulator@13187 78 #
slaxemulator@13187 79 # OR
slaxemulator@13187 80 #
slaxemulator@13187 81 # 2) Set the variables below. However, in case you choose this method, then
slaxemulator@13187 82 # start replication for the first time (even unsuccessfully, for example
slaxemulator@13187 83 # if you mistyped the password in master-password and the slave fails to
slaxemulator@13187 84 # connect), the slave will create a master.info file, and any later
slaxemulator@13187 85 # change in this file to the variables' values below will be ignored and
slaxemulator@13187 86 # overridden by the content of the master.info file, unless you shutdown
slaxemulator@13187 87 # the slave server, delete master.info and restart the slaver server.
slaxemulator@13187 88 # For that reason, you may want to leave the lines below untouched
slaxemulator@13187 89 # (commented) and instead use CHANGE MASTER TO (see above)
slaxemulator@13187 90 #
slaxemulator@13187 91 # required unique id between 2 and 2^32 - 1
slaxemulator@13187 92 # (and different from the master)
slaxemulator@13187 93 # defaults to 2 if master-host is set
slaxemulator@13187 94 # but will not function as a slave if omitted
slaxemulator@13187 95 #server-id = 2
slaxemulator@13187 96 #
slaxemulator@13187 97 # The replication master for this slave - required
slaxemulator@13187 98 #master-host = <hostname>
slaxemulator@13187 99 #
slaxemulator@13187 100 # The username the slave will use for authentication when connecting
slaxemulator@13187 101 # to the master - required
slaxemulator@13187 102 #master-user = <username>
slaxemulator@13187 103 #
slaxemulator@13187 104 # The password the slave will authenticate with when connecting to
slaxemulator@13187 105 # the master - required
slaxemulator@13187 106 #master-password = <password>
slaxemulator@13187 107 #
slaxemulator@13187 108 # The port the master is listening on.
slaxemulator@13187 109 # optional - defaults to 3306
slaxemulator@13187 110 #master-port = <port>
slaxemulator@13187 111 #
slaxemulator@13187 112 # binary logging - not required for slaves, but recommended
slaxemulator@13187 113 #log-bin=mysql-bin
slaxemulator@13187 114
slaxemulator@13187 115 # Uncomment the following if you are using InnoDB tables
slaxemulator@13187 116 #innodb_data_home_dir = /var/lib/mysql
slaxemulator@13187 117 #innodb_data_file_path = ibdata1:10M:autoextend
slaxemulator@13187 118 #innodb_log_group_home_dir = /var/lib/mysql
slaxemulator@13187 119 # You can set .._buffer_pool_size up to 50 - 80 %
slaxemulator@13187 120 # of RAM but beware of setting memory usage too high
slaxemulator@13187 121 #innodb_buffer_pool_size = 16M
slaxemulator@13187 122 #innodb_additional_mem_pool_size = 2M
slaxemulator@13187 123 # Set .._log_file_size to 25 % of buffer pool size
slaxemulator@13187 124 #innodb_log_file_size = 5M
slaxemulator@13187 125 #innodb_log_buffer_size = 8M
slaxemulator@13187 126 #innodb_flush_log_at_trx_commit = 1
slaxemulator@13187 127 #innodb_lock_wait_timeout = 50
slaxemulator@13187 128
slaxemulator@13187 129 [mysqldump]
slaxemulator@13187 130 quick
slaxemulator@13187 131 max_allowed_packet = 16M
slaxemulator@13187 132
slaxemulator@13187 133 [mysql]
slaxemulator@13187 134 no-auto-rehash
slaxemulator@13187 135 # Remove the next comment character if you are not familiar with SQL
slaxemulator@13187 136 #safe-updates
slaxemulator@13187 137
slaxemulator@13187 138 [myisamchk]
slaxemulator@13187 139 key_buffer_size = 20M
slaxemulator@13187 140 sort_buffer_size = 20M
slaxemulator@13187 141 read_buffer = 2M
slaxemulator@13187 142 write_buffer = 2M
slaxemulator@13187 143
slaxemulator@13187 144 [mysqlhotcopy]
slaxemulator@13187 145 interactive-timeout