{"ok":true,"c":"[mysqld]\nperformance-schema=0\ninnodb_file_per_table=1 # Ensure that each innodb table is it's own binary data block just in case there's corruption.\nquery_cache_size=64M\nthread_cache_size=4 # can be increased on servers with large numbers of active users\nkey_buffer_size=32M\nmax_allowed_packet=16M # don't change unless required for large blobs\ntable_open_cache=512 # max 2048, can be increased if more Opened tables - SHOW STATUS LIKE 'Opened_tables';\nwait_timeout=300 # can be increased if using persistent connections\nmax_user_connections=25\nopen_files_limit=16384\n\nperformance-schema=0\n#delayed_insert_timeout=20 # Turn on if max_connections being reached due to delayed inserts\n#delayed_queue_size=300 # Turn on if max_connections being reached due to delayed inserts\n\nperformance-schema=0\nmyisam_sort_buffer_size=2M # can be increased per sessions if needed for alter tables (indexes, repair)\n\nperformance-schema=0\n#query_cache_limit=2M # leave at default unless there is a good reason\n#join_buffer=2M # leave at default unless there is a good reason\n#sort_buffer_size=2M # leave at default unless there is a good reason\n#read_rnd_buffer_size=256K # leave at default unless there is a good reason\n#read_buffer_size=2M # leave at default unless there is a good reason\n\nperformance-schema=0\ncollation_server=utf8_unicode_ci\ncharacter_set_server=utf8\n\nperformance-schema=0\n#innodb_flush_method=O_DSYNC # Do not enable this without a good reason - it doesn't work well on new dedis\ninnodb_buffer_pool_size=128M # check mysql -e \"SHOW GLOBAL STATUS LIKE 'Innodb_buffer_pool%';\" - free vs total\ninnodb_thread_concurrency=4 # Number of physical + virtual CPU's, be careful of adding more\n\nperformance-schema=0\ntmp_table_size=384M\nmax_heap_table_size=384M\nmax_connections=125 # Should be between 100-150, increase *slowly* because it causes MySQL to consume more memory!\n\nperformance-schema=0\ntable_definition_cache=512 # increase by the same factor as table_open_cache\ninnodb_flush_log_at_trx_commit=2\ninnodb_log_buffer_size=64M\n\nperformance-schema=0\ngeneral_log=0\nslow_query_log=0\nlog-output=TABLE # select * from mysql.general_log order by event_time desc limit 10;\nlong_query_time=20 # select * from mysql.slow_log order by start_time desc limit 10;\n\nperformance-schema=0\ninnodb_io_capacity=100\n\nperformance-schema=0\ndefault-storage-engine=MyISAM\n"}