Edit file File name : my.cnf Content :[mysqld] disable-log-bin=1 performance-schema=0 #skip-grant-tables bind-address = 0.0.0.0 port=3306 wait_timeout = 28800 interactive_timeout = 28800 # Basic Settings datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock pid-file=/var/run/mysqld/mysqld.pid log-error=/var/log/mysqld.log symbolic-links=0 mysqlx=0 # Disabling X-protocol if you don't use it net_read_timeout = 120 net_write_timeout = 120 # Character Set character-set-server = utf8 collation-server = utf8_unicode_ci # Authentication default-authentication-plugin=mysql_native_password # SQL Mode for Data Integrity sql-mode="" #sql-mode="ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION" # Connection Handling max_connections = 200 connect_timeout = 60 max_allowed_packet=268435456 thread_cache_size=100 open_files_limit = 40000 table_open_cache = 4000 # Memory Configuration (Per-Session) join_buffer_size = 4M sort_buffer_size = 4M read_buffer_size = 2M read_rnd_buffer_size = 4M tmp_table_size=318M max_heap_table_size=318M # Query Logging slow-query-log = 1 slow-query-log-file = /var/log/mysql-slow.log long_query_time = 2 log-queries-not-using-indexes = 1 # InnoDB Engine Settings innodb_buffer_pool_size = 24G innodb_buffer_pool_instances=24 innodb_log_file_size=1G innodb_log_buffer_size = 64M innodb_file_per_table = 1 innodb_flush_method = O_DIRECT innodb_flush_neighbors = 0 # Best for SSDs innodb_io_capacity = 2000 innodb_io_capacity_max = 4000 innodb_read_io_threads = 8 innodb_write_io_threads = 8 innodb_thread_concurrency = 0 # Let InnoDB manage concurrency key_buffer_size=871M [client] default-character-set=utf8 [mysql] default-character-set=utf8 Save