Categorias

MySQL Server has gone away quando importando grandes arquivos sql 

[mysqld]
wait_timeout = 600
max_allowed_packet = 64M
innodb_lock_wait_timeout = 500

Outro exemplo :


max_allowed_packet      = 110M
innodb_buffer_pool_size=511M
innodb_log_file_size=500M
innodb_log_buffer_size = 800M
net_read_timeout        = 600
net_write_timeout       = 600