gist_content1

[mysqld]
datadir=/var/lib/mysql
log_slow_queries        = /var/lib/mysql/mysql-slow.log
long_query_time         = 10
loose-log_slow_verbosity = microtime,query_plan,innodb,profiling,profiling_use_getrusage
loose-slow_query_log_timestamp_always = true
loose-slow_query_log_timestamp_precision = microsecond
loose-slow_query_log_use_global_control = log_slow_filter,log_slow_rate_limit,log_slow_verbosity,long_query_time,min_examined_row_limit

loose-log_slow_slave_statements

server-id=529
log_bin                 = /var/lib/mysql/mysql-bin.log
max_binlog_size         = 100M
expire_logs_days        = 2
sync_binlog             = 1 

binlog_format           = MIXED
thread_stack            = 256K
thread_cache_size       = 512
tmp_table_size          = 32M
max_heap_table_size     = 32M
max_connections         = 10000
open-files-limit        = 65535
table_open_cache        = 8192
table_definition_cache  = 8192
query_cache_size        = 32M
key_buffer_size         = 64M
innodb_buffer_pool_size         = 500M
innodb_flush_method             = O_DIRECT
innodb_log_files_in_group       = 2
innodb_log_file_size            = 512M
innodb_file_per_table           = 1
innodb_lazy_drop_table           = 1
innodb_file_format               = barracuda
innodb_thread_concurrency        = 24
innodb_flush_log_at_trx_commit   = 1
innodb_io_capacity               = 1200
innodb_write_io_threads          = 4
innodb_read_io_threads           = 4

relay-log-space-limit   = 5G
relay_log_purge         = 0
max_allowed_packet      = 20M
query_cache_size        = 0
query_cache_type        = 0
skip-slave-start
skip-name-resolve


table_definition_cache  = 50000
table_open_cache        = 50000
open_files_limit        = 100000


loose-query_response_time_stats
userstat=1

concurrent_insert = 2
key_buffer_size = 4G
myisam_recover

[client]
user=root
password=test