# Example mysql config file for small systems. # # This is for a system with little memory (<= 64M) where MySQL is only used # from time to time and it's important that the mysqld daemon # doesn't use much resources. # # You can copy this file to /etc/my.cnf to set server options. # The MySQL server [mysqld] port = 3306 socket = /var/run/mysql.sock #datadir = /var/mysql skip-locking key_buffer = 1M max_allowed_packet = 1M thread_stack = 192K table_cache = 16 sort_buffer_size = 128K net_buffer_length = 2K server-id = 1 user = mysql thread_concurrency = 2 # binary logging is required for replication Master log-bin # We do not support Berkeley DB skip-bdb # comment out the folllowing line, if you want to use Innobase tables skip-innodb # Uncomment the following if you want to use Innobase tables # If you need transactions, you should enable it. # For more information, read: # http://www.mysql.com/documentation/mysql/bychapter/manual_Table_types.html#InnoDB #innodb_data_file_path = ibdata1:10M:autoextend #innodb_data_home_dir = /var/mysql/ #innodb_log_group_home_dir = /var/log/mysql/ #innodb_log_arch_dir = /var/log/mysql/ #innodb_mirrored_log_groups = 1 #innodb_log_files_in_group = 3 #innodb_log_file_size = 5M #innodb_log_buffer_size = 8M #innodb_flush_log_at_trx_commit = 1 #innodb_log_archive = 0 #innodb_buffer_pool_size = 16M #innodb_additional_mem_pool_size= 2M #innodb_file_io_threads = 4 #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 = 8M sort_buffer_size = 8M [myisamchk] key_buffer = 8M sort_buffer_size = 8M [mysqlhotcopy] interactive-timeout [client] #default-character-set = utf8 #default-character-set = latin1 #password = your_password port = 3306 socket = /var/run/mysql.sock