[mysql] socket = /tmp/mysql.sock auto-rehash [mysqld] port = 3306 socket = /tmp/mysql.sock datadir = /DATA tmpdir = /tmp/ pid-file = /DATA/mysqld.pid log-bin = mysql-bin log-slave-updates = 0 skip-name-resolve skip-locking key_buffer = 32M max_allowed_packet = 8M table_cache = 64 net_buffer_length = 8K myisam_sort_buffer_size = 8M sort_buffer_size = 2M read_buffer_size = 2M read_rnd_buffer_size = 2M server-id = 98765 innodb_buffer_pool_size = 1500M innodb_log_file_size = 256M innodb_log_buffer_size = 16M innodb_lock_wait_timeout = 10 innodb_max_dirty_pages_pct = 50 innodb_flush_log_at_trx_commit = 0 innodb_thread_concurrency = 4 innodb_data_home_dir = /DATA innodb_data_file_path = ibdata1:1G:autoextend:max:50G innodb_log_group_home_dir = /var/log/mysql innodb_autoextend_increment = 100M # performance measures innodb_flush_method = O_DIRECT innodb_doublewrite = 0 innodb_checksums = 0 innodb_support_xa = 0