[mysqld] ndbcluster ndb-connectstring=172.16.0.1 datadir=/var/lib/mysql socket=/usr/local/mysql/tmp/mysql.sock engine_condition_pushdown=0 ndb_use_exact_count=1 # Query Cache Config - set to 1 Gig - As per MySQL Engineer, with NDB it isn't as effective, leave it off or Maybe we should use SQL_CACHE by demand only #query_cache_type=2 #query_cache_limit=1M #query_cache_size=50M #standard Config Options basedir=/usr/local/mysql big-tables connect_timeout=5000 default-character-set=latin1 default-storage-engine=MyISAM # skip-innodb key_buffer_size=3G general-log #log-queries-not-using-indexes slow-query-log slow-query-log-file=/var/lib/mysql/slow-queries.log log-bin binlog-format=ROW expire_logs_days = 3 long_query_time=1 lower_case_table_names=1 max_allowed_packet=50000000 max_connections=2000 max-heap-table-size=100M max_prepared_stmt_count=500000 max_sp_recursion_depth=100 max_tmp_tables=500 max_user_connections=1000 max_write_lock_count=5000 net_read_timeout=5000 net_write_timeout=5000 slow_launch_time=5 sort_buffer_size=1000000 thread_cache_size=1 tmp_table_size=100M tmpdir=/usr/local/mysql/tmp wait_timeout=28800 [mysqld_safe] err-log=/var/log/mysqld.log pid-file=/usr/local/mysql/tmp/mysqld.pid [mysql_cluster] ndb-connectstring=172.16.0.1 [client] socket=/tmp/mysql.sock