| # Example MySQL config file for small systems.
|
| |
| # |
| # |
| # This is for a system with little memory (<= 64M) where MySQL is only used |
| # This group is read both both by the client and the server |
| # from time to time and it's important that the mysqld daemon |
| # use it for options that affect everything |
| # doesn't use much resources.
|
| |
| # |
| # |
| # You can copy this file to |
| [client-server] |
| # /etc/my.cnf to set global options,
|
| |
| # mysql-data-dir/my.cnf to set server-specific options (in this
|
| |
| # installation this directory is /var/lib/mysql) 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/run/mysql/mysql.sock |
| |
|
|
| |
| # Here follows entries for some specific programs
|
| |
|
|
| |
| # The MySQL server
|
| |
| [mysqld]
|
| |
| port = 3306 |
| |
| socket = /var/run/mysql/mysql.sock |
| |
| bind-address = 192.168.1.5 |
| |
| skip-external-locking
|
| |
| #skip-locking
|
| |
| key_buffer_size = 16K
|
| |
| max_allowed_packet = 1M
|
| |
| table_open_cache = 4
|
| |
| sort_buffer_size = 64K
|
| |
| read_buffer_size = 256K
|
| |
| read_rnd_buffer_size = 256K
|
| |
| net_buffer_length = 2K
|
| |
| thread_stack = 128K
|
| |
|
|
| |
| # 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
|
| |
| # (using the "enable-named-pipe" option) will render mysqld useless!
|
| |
| #
|
| |
| #skip-networking
|
| |
| server-id = 1 |
| |
|
|
| |
| # Uncomment the following if you want to log updates
|
| |
| #log-bin=mysql-bin
|
| |
| |
| |
| # binary logging format - mixed recommended
|
| #
|
| #binlog_format=mixed |
| # include all files from the config directory |
|
|
| #
|
| # Uncomment the following if you are using InnoDB tables |
| !includedir /etc/my.cnf.d |
| #innodb_data_home_dir = /var/lib/mysql/
|
| |
| #innodb_data_file_path = ibdata1:10M:autoextend
|
| |
| #innodb_log_group_home_dir = /var/lib/mysql/
|
| |
| # 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
|
| |
|
|
| |
| [myisamchk]
|
| |
| key_buffer_size = 8M
|
| |
| sort_buffer_size = 8M
|
| |
| |
| |
| [mysqlhotcopy]
|
| |
| interactive-timeout
|
| |
| |
| |