###################### [client] port = 3306 socket = /var/lib/mysql/mysql.sock ###################### [mysqld] datadir = /app01/mysql/data tmpdir = /app01/mysql/tmp/ log-update = /app01/mysql/log/ log-error = /var/log/mysqld.log socket = /var/lib/mysql/mysql.sock port = 3306 key_buffer = 256M max_allowed_packet = 1M max_connections = 300 table_cache = 256 sort_buffer_size = 1M read_buffer_size = 1M read_rnd_buffer_size = 4M myisam_sort_buffer_size = 64M thread_cache = 8 query_cache_size = 16M thread_concurrency = 8 #character_set_server = utf8 #collation_server = utf8_czech_ci skip-locking skip-bdb #skip-networking log-bin = /app01/mysql/log/log-bin server-id = 1 innodb_data_home_dir = /app01/mysql/data innodb_data_file_path = ibdata1:100M:autoextend innodb_log_group_home_dir = /app01/mysql/data/ innodb_log_arch_dir = /app01/mysql/data/ innodb_buffer_pool_size = 256M innodb_additional_mem_pool_size = 20M innodb_log_file_size = 64M innodb_log_buffer_size = 8M innodb_flush_log_at_trx_commit = 1 innodb_lock_wait_timeout = 50 innodb-safe-binlog ###################### [mysqldump] quick max_allowed_packet = 16M ###################### [mysql] no-auto-rehash #default_character_set = utf8 ###################### [isamchk] key_buffer = 128M sort_buffer_size = 128M read_buffer = 2M write_buffer = 2M ###################### [myisamchk] key_buffer = 128M sort_buffer_size = 128M read_buffer = 2M write_buffer = 2M ###################### [mysqlhotcopy] interactive-timeout ###################### [mysql.server] user = mysql basedir = /var/lib ###################### [mysqld_safe] err-log = /var/log/mysqld.log pid-file = /var/run/mysqld/mysqld.pid