Edit File: my.cnf
[mysqld] key_buffer_size = 256M max_allowed_packet=268435456 table_open_cache = 256 sort_buffer_size = 1M read_buffer_size = 1M read_rnd_buffer_size = 4M myisam_sort_buffer_size = 64M thread_cache_size = 8 query_cache_size = 32M # Increased from 16M log-error=/var/lib/mysql/141-98-115-242.cprapid.com.err performance-schema = ON # Changed to ON innodb_file_per_table = 1 open_files_limit = 80000 sql_mode = "NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" innodb_strict_mode = OFF default_storage_engine = InnoDB innodb_buffer_pool_size = 26G # Increased from 2G innodb_file_per_table = 1 innodb_flush_log_at_trx_commit = 0 innodb_flush_method = O_DIRECT innodb_log_buffer_size = 8M innodb_log_file_size = 256M # Increased to 256M open_files_limit = 10000 # Added configurations join_buffer_size = 512K tmp_table_size = 64M max_heap_table_size = 64M table_definition_cache = 60000 innodb_buffer_pool_instances = 2