[mysqld]
sql_mode=no_engine_substitution,no_unsigned_subtraction
default_tmp_storage_engine=MyISAM
sync_relay_log_info=100
relay_log_recovery=1
relay_log_info_repository=FILE
innodb_purge_threads=8
innodb_compression_pad_pct_max=37
innodb_compression_failure_threshold_pct=10
innodb_flush_neighbors=0
innodb_old_blocks_pct=50
innodb_max_dirty_pages_pct=75
innodb_max_dirty_pages_pct_lwm=0
innodb_adaptive_flushing=1
innodb_adaptive_flushing_lwm=10
innodb_adaptive_hash_index=0
innodb_flushing_avg_loops=30
innodb_max_purge_lag=0
innodb_max_purge_lag_delay=0
eq_range_index_dive_limit=1000
# block_create_myisam=1
gtid_mode=OFF
enforce_gtid_consistency=ON
lock_wait_timeout=60
# part_scan_max=1000
ssl=0
plugin_load=
skip_temp_pool=0
# block_ftwrl=1

long_query_time=10
#skip_partition=1
wait_timeout=10
interactive_timeout=120
max_allowed_packet=128M
slave_max_allowed_packet=256M
skip_name_resolve
back_log=4096
max_connections=5000
max_user_connections=4000
max_connect_errors=3000
key_buffer_size=16M
myisam_sort_buffer_size=256M
max_tmp_tables=64
read_buffer_size=1M
read_rnd_buffer_size=1M
sort_buffer_size=2M
table_open_cache=50000
table_definition_cache=60000
query_cache_limit=4M
query_cache_size=0
query_cache_type=0
thread_cache_size=500
thread_stack=196608
open_files_limit=32767
net_read_timeout=15
net_write_timeout=30
tmp_table_size=64M
max_heap_table_size=512M
# log_slow_extra=1
group_concat_max_len=1024
default_storage_engine=InnoDB
innodb_compression_level=1
# innodb_deadlock_detect=0
innodb_file_format=Barracuda
innodb_file_per_table=1
innodb_lock_wait_timeout=2
innodb_log_buffer_size=4M
innodb_log_compressed_pages=0
innodb_log_file_size=128M
innodb_old_blocks_time=1000
innodb_open_files=10240
innodb_read_io_threads=32
innodb_stats_on_metadata=0
innodb_thread_concurrency=256
innodb_write_io_threads=4
# innodb_zlib_wrap=0
# innodb_enable_slave_update_table_stats=1

innodb_io_capacity=1000
innodb_io_capacity_max=2000
innodb_lru_scan_depth=1024

innodb_flush_log_at_trx_commit=2
innodb_flush_method=O_DIRECT

innodb_doublewrite=0
# innodb_page_size=8K
innodb_buffer_pool_size=2G

datadir=/data/m/data
innodb_data_home_dir=/data/m/data
innodb_data_file_path=ibdata1:512M:autoextend

innodb_log_group_home_dir=/data/m/txlogs

#port=3307
# socket=/var/lib/mysql/mysql-3307.sock
# socket=/data/mysql/orig578/var/mysql.sock

# skip_log_bin
log_bin=/data/m/binlogs/bl
max_binlog_size=128M
binlog_cache_size=262144
max_binlog_cache_size=128M
sync_binlog=0
server_id=77

#init_file=/usr/facebook/scripts/db/generate_uuid.sql
tmpdir=/tmp
slave_load_tmpdir=/tmp

slow_query_log_file=/home/mdcallag/b/orig578/slow.log
slow_query_log=1
long_query_time=2
log_slow_slave_statements=1

secure_file_priv=""