release/src/router/mysql/support-files/my-huge.cnf.sh

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