[MYSQLD] user=mysql basedir=/srv/mysql/ datadir=/srv/mysql/data pid-file=mysqld.pid socket=/srv/mysql/data/mysql.sock port=3306 ndb_cluster_connection_pool=16 ndbcluster default_storage_engine=NDBCLUSTER ndb_connectstring="172.21.0.201:1186;172.21.0.202:1186" ndb_force_send=1 ndb_use_exact_count=0 ndb_extra_logging=1 ndb_autoincrement_prefetch-sz=1024 engine_condition_pushdown=1 bind_address=0.0.0.0 skip_name_resolve skip_innodb safe_show_database long_query_time = 3 #max_connections = 100000 max_connections = 3500 join_buffer_size = 4M max_connect_errors = 100000 concurrent_insert = 2 table_lock_wait_timeout = 30 #log-err=error.log log #log-slow-queries key_buffer_size=768M max_allowed_packet = 128M sort_buffer_size = 24M read_buffer_size = 4M read_rnd_buffer_size = 1024000 bulk_insert_buffer_size = 16M #thread_cache_size=1024 thread_concurrency = 16 myisam_sort_buffer_size = 64M #memlock sysdate_is_now thread_cache_size=16384 net_buffer_length=1048576 query_cache_type = 1 query_cache_limit=4M query_prealloc_size=262144 query_alloc_block_size = 65536 query_cache_size = 512M table_open_cache=64000 lower_case_table_names=1 wait_timeout=20 tmp_table_size = 8192M max_heap_table_size = 8192M [MYSQL] socket=/srv/mysql/data/mysql.sock [client] socket=/srv/mysql/data/mysql.sock