# Example MySQL config file for medium systems. # # This is for a system with little memory (32M - 64M) where MySQL plays # an important part, or systems up to 128M where MySQL is used together with # other programs (such as a web server) # # You can copy this file to # /etc/my.cnf to set global options, # mysql-data-dir/my.cnf to set server-specific options (in this # installation this directory is /usr/local/mysql/var) or # ~/.my.cnf to set user-specific options. # # In this file, you can use all long options that a program supports. # If you want to know which options a program supports, run the program # with the "--help" option. # The following options will be passed to all MySQL clients [client] #password = your_password port = 3306 socket = /var/lib/mysql/mysql.sock # Here follows entries for some specific programs # The MySQL server [mysqld] log-slow-queries = /var/log/mysqld.slow.log long_query_time = 1 port = 3306 socket = /var/lib/mysql/mysql.sock skip-locking skip-name-resolve key_buffer = 16M max_allowed_packet = 3M table_cache = 100 #table_cache updated from 64 to 100 by dvmodi on 11/6/2009 PST , 11/7/2009 IST during maintenance cycle. sort_buffer_size = 512K net_buffer_length = 8K read_buffer_size = 256K read_rnd_buffer_size = 512K myisam_sort_buffer_size = 8M group_concat_max_len = 2096128 expire_logs_days = 10 datadir = /var/lib/mysql # Don't listen on a TCP/IP port at all. This can be a security enhancement, # if all processes that need to connect to mysqld run on the same host. # All interaction with mysqld must be made via Unix sockets or named pipes. # Note that using this option without enabling named pipes on Windows # (via the "enable-named-pipe" option) will render mysqld useless! # #skip-networking # Replication Master Server (default) # binary logging is required for replication #log-bin = teak12-bin # required unique id between 1 and 2^32 - 1 # defaults to 1 if master-host is not set # but will not function as a master if omitted server-id = 12 #databases to be replicated binlog-do-db = cvt # Replication Slave (comment out master section to use this) # # To configure this host as a replication slave, you can choose between # two methods : # # 1) Use the CHANGE MASTER TO command (fully described in our manual) - # the syntax is: # # CHANGE MASTER TO MASTER_HOST=, MASTER_PORT=, # MASTER_USER=, MASTER_PASSWORD= ; # # where you replace , , by quoted strings and # by the master's port number (3306 by default). # # Example: # # CHANGE MASTER TO MASTER_HOST='125.564.12.1', MASTER_PORT=3306, # MASTER_USER='joe', MASTER_PASSWORD='secret'; # # OR # # 2) Set the variables below. However, in case you choose this method, then # start replication for the first time (even unsuccessfully, for example # if you mistyped the password in master-password and the slave fails to # connect), the slave will create a master.info file, and any later # change in this file to the variables' values below will be ignored and # overridden by the content of the master.info file, unless you shutdown # the slave server, delete master.info and restart the slaver server. # For that reason, you may want to leave the lines below untouched # (commented) and instead use CHANGE MASTER TO (see above) # # required unique id between 2 and 2^32 - 1 # (and different from the master) # defaults to 2 if master-host is set # but will not function as a slave if omitted # server-id = 9 # # The replication master for this slave - required #master-host = master-host = REMOVED Intentionaly # # The username the slave will use for authentication when connecting # to the master - required #master-user = master-user = REMOVED Intentionaly # # The password the slave will authenticate with when connecting to # the master - required #master-password = master-password = REMOVED Intentionaly # # The port the master is listening on. # optional - defaults to 3306 #master-port = master-port = 3306 # # binary logging - not required for slaves, but recommended #log-bin=mysql-bin replicate-do-db=cvt #replicate-wild-ignore-table=cvt.tmp% #replicate-wild-ignore-table=cvta0000.% #replicate-wild-ignore-table=cvta0001.% #replicate-wild-ignore-table=cvta0002.% #replicate-wild-ignore-table=cvta0003.% #replicate-wild-ignore-table=cvta0004.% #replicate-wild-ignore-table=cvta0005.% #replicate-wild-ignore-table=cvta0006.% #replicate-wild-ignore-table=cvta0007.% #replicate-wild-ignore-table=cvta0008.% #replicate-wild-ignore-table=cvta0009.% #replicate-wild-ignore-table=cvta0010.% #replicate-wild-ignore-table=cvta0011.% #replicate-wild-ignore-table=cvta0012.% #replicate-wild-ignore-table=cvta0013.% #replicate-wild-ignore-table=cvta0014.% #replicate-wild-ignore-table=cvta0015.% # Point the following paths to different dedicated disks #tmpdir = /tmp/ #log-update = /path-to-dedicated-directory/hostname # Uncomment the following if you are using BDB tables #bdb_cache_size = 4M #bdb_max_lock = 10000 # Uncomment the following if you are using InnoDB tables #innodb_data_home_dir = /usr/local/mysql/var/ #innodb_data_file_path = ibdata1:10000M:autoextend #parameter removed to segment database on 02/09/2010 innodb_data_file_path = ibdata1:2G;ibdata2:2G;ibdata3:2G;ibdata4:2G;ibdata5:2G;ibdata6:2G;ibdata7:2G;ibdata8:2G;ibdata9:2G;ibdata10:2G;ibdata11:2G;ibdata12:2G;ibdata13:2G;ibdata14:2G:autoextend #this line is for creating 14 segment of databases with size of 2gb each, the last segment is autoexetendable #size of last extend cross 2gb size than once again it is required to re-configure segments. # Set buffer pool size to # 50 - 80 % of your computer's # memory set-variable = innodb_buffer_pool_size=4000M set-variable = innodb_additional_mem_pool_size=512M # Set the log file size to about # 25 % of the buffer pool size set-variable = innodb_log_file_size=100M set-variable = innodb_log_buffer_size=25M # Set ..flush_log_at_trx_commit # to 0 if you can afford losing # some last transactions innodb_flush_log_at_trx_commit=1 set-variable = innodb_lock_wait_timeout=100 #innodb_log_group_home_dir = /usr/local/mysql/var/ #innodb_log_arch_dir = /usr/local/mysql/var/ # You can set .._buffer_pool_size up to 50 - 80 % # of RAM but beware of setting memory usage too high #innodb_buffer_pool_size = 16M #innodb_additional_mem_pool_size = 2M # Set .._log_file_size to 25 % of buffer pool size #innodb_log_file_size = 5M #innodb_log_buffer_size = 8M #innodb_flush_log_at_trx_commit = 1 #innodb_lock_wait_timeout = 50 [mysqldump] quick max_allowed_packet = 16M [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates [isamchk] key_buffer = 20M sort_buffer_size = 20M read_buffer = 2M write_buffer = 2M [myisamchk] key_buffer = 20M sort_buffer_size = 20M read_buffer = 2M write_buffer = 2M [mysqlhotcopy] interactive-timeout