################################################################################################### # MySQL 5.1 SERVER CONFIGURATION FOR HIFLY ARCHIVE SUBSYSTEM # Version: 1.1 # # MARKS: @SECURITY@ Stands for options affecting security # @MEMORY@ Affects memory consumption versus performance # @ARCHIVE@ Configuration regarding archive features ################################################################################################### [client] user = neo_ops port = 6060 socket = /home/neo_ops/HF/mysql.sock ################################################################################################### # GENERAL SERVER OPTIONS ################################################################################################### [mysqld] user = neo_ops # Base dir for all mysql data datadir = /home/neo_ops/HF/ # Connection port. Should be changed for security improvement @SECURITY@ port = 6060 # Connection socket. Should be changed for security improvement @SECURITY@ socket = /home/neo_ops/HF/mysql.sock # Disable global locks. Improves bkp performance while working skip-locking # log-slow-queries = /home/neo_ops/HF/Queries-slow.log # long-query-time = 3 # log-output = file # big-tables # # log-queries-not-using-indexes # tmp_table_size =100M # max_heap_table_size =100M # open-files-limit = 10240 # skip-innodb ################################################################################################### # MEMORY AND CACHES ################################################################################################### # To optimize depending on the retrieval queries complexity @MEMORY@ key_buffer = 400M # Limits the total row size, should be adjusted to our data rows. @MEMORY@ max_allowed_packet = 10M # Size of the data tables cache @MEMORY@ table_cache = 512 # Size of the memory buffer for sorting results @MEMORY@ sort_buffer_size = 12M # Size of the memory buffer for caching query results @MEMORY@ read_buffer_size = 12M # Size of the memory buffer for caching query results @MEMORY@ read_rnd_buffer_size = 8M # Unused by InnoDB. I keep it for administration tables. myisam_sort_buffer_size = 64M #Allow concurrent inserts even for fragmented tables. concurrent_insert=2 # Cache for memory used by connection threads @MEMORY@ thread_cache_size = 10 #8 # General cache used by connection threads @MEMORY@ query_cache_size = 32M # Should be @MEMORY@ thread_concurrency = 4 ################################################################################################### # NETWORK ################################################################################################### # Do not listen external TCP/IP connections @SECURITY@ #skip-networking ################################################################################################### # REPLICATION ################################################################################################### # Replication Master Server (default). Binary logging is required for replication. # In a first review, replication is not the best solution for us. @ARCHIVE@ #log-bin=mysql-bin # Server ID for replication. 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. @ARCHIVE@ server-id = 1 # 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 (6060 by default). # # Example: # # CHANGE MASTER TO MASTER_HOST='125.564.12.1', MASTER_PORT=6060, # 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 = 2 # # The replication master for this slave - required #master-host = # # The username the slave will use for authentication when connecting # to the master - required #master-user = # # The password the slave will authenticate with when connecting to # the master - required #master-password = # # The port the master is listening on. # optional - defaults to 6060 #master-port = # # binary logging - not required for slaves, but recommended #log-bin=mysql-bin # Point the following paths to different dedicated disks #tmpdir = /tmp/ #log-update = /path-to-dedicated-directory/hostname ################################################################################################### # DUMP OPTIONS ################################################################################################### [mysqldump] # To dump tables row by row quick # Size for dumps (previously 16) max_allowed_packet = 16M ################################################################################################### # OTHER OPTIONS ################################################################################################### [mysql] no-auto-rehash #safe-updates [isamchk] key_buffer = 256M sort_buffer_size = 256M read_buffer = 2M write_buffer = 2M [myisamchk] key_buffer = 256M sort_buffer_size = 256M read_buffer = 2M write_buffer = 2M