[mysqld_safe] socket = /var/run/mysqld/mysqld.sock nice = 0 [mysqld] user = mysql datadir=/var/lib/mysql socket=/var/run/mysqld/mysqld.sock port=3306 tmpdir=/var/tmp skip-name-resolve pid-file = /var/run/mysqld/mysqld.pid skip-external-locking bind-address = 0.0.0.0 !includedir /etc/mysql/conf.d/ #### INCLUDED FILE 1 [mysqld] event_scheduler = 1 performance_schema = 0 thread_stack=192K thread_cache_size=64 myisam-recover=BACKUP max_connections=151 back_log = 50 skip-symbolic-links local_infile = 0 max_prepared_stmt_count = 5000 secure-auth = 1 myisam-recover-options=FORCE,BACKUP character-set-server=utf8 collation-server=utf8_general_ci init_connect='SET collation_connection = utf8_general_ci' init-connect='SET NAMES utf8' max_connect_errors = 1000000 server-id = 1 log-warnings = 2 max_allowed_packet=16M net_read_timeout=120 net_retry_count=20 net_write_timeout=240 table_open_cache = 256 table_open_cache_instances = 4 max_heap_table_size = 64M tmp_table_size = 64M sort_buffer_size = 8097152 join_buffer_size = 16M key_buffer_size = 16M metadata_locks_hash_instances = 256 read_rnd_buffer_size = 16M transaction_isolation = READ-COMMITTED innodb_purge_threads = 1 innodb_stats_on_metadata = 0 innodb_buffer_pool_size = 1G innodb_write_io_threads = 4 innodb_data_file_path = ibdata1:10M:autoextend innodb_file_per_table innodb_file_format = Barracuda innodb_file_format_max = Barracuda innodb_doublewrite = 1 innodb_thread_concurrency = 32 innodb_flush_log_at_trx_commit = 2 innodb_support_xa = 0 innodb_log_buffer_size = 16M innodb_log_file_size = 128M innodb_log_files_in_group = 3 innodb_flush_method=O_DIRECT innodb_read_io_threads = 4 innodb_max_dirty_pages_pct = 90 innodb_lock_wait_timeout = 120 innodb_io_capacity = 2000 innodb_io_capacity_max = 6000 innodb_checksum_algorithm = crc32 innodb_stats_transient_sample_pages = 16 tokudb_cache_size=4G tokudb_directio=1 #### INCLUDED FILE 2 [mariadb] plugin-load-add=ha_tokudb.so