Guest Posted April 24, 2016 Share Posted April 24, 2016 Olá senhores e senhoras... tenho um problema que é o seguinte. Em todos meus clientes que possuem WP, especificamente a versão 4.5 está sendo gerado um arquivo de erro_log bastante grande com a seguinte mensagem; Quote PHP Warning: Error while sending QUERY packet. PID=199682 in /home/XXXXXXXXX/public_html/wp-includes/wp-db.php on line 1803 Alguém ja percebeu isso e se sim sabe como resolve-lo ? 0 Quote Link to comment Share on other sites More sharing options...
lyra Posted April 25, 2016 Share Posted April 25, 2016 Como está o "max_allowed_packet" em seu my.cnf? Eleve e veja se novos alertas serão gerados nas próximas horas. 0 Quote Link to comment Share on other sites More sharing options...
Guest Posted April 25, 2016 Share Posted April 25, 2016 Está assim: Quote [mysqld] bulk_insert_buffer_size = 8M concurrent_insert = 2 connect_timeout = 10 external-locking = FALSE key_buffer_size = 512M local-infile = 0 log-error max_allowed_packet=268435456 max_connect_errors = 10 max_connections = 512 max_heap_table_size = 128M max_user_connections = 64 max_write_lock_count = 8 myisam_sort_buffer_size = 64M net_buffer_length = 16384 open_files_limit = 32768 query_alloc_block_size = 65535 query_cache_limit = 5M query_cache_size = 128M query_cache_type = 1 query_prealloc_size = 262144 read_buffer_size = 1M read_rnd_buffer_size = 786432 slow_query_log table_open_cache = 4096 thread_cache_size = 384 tmp_table_size = 256M transaction_alloc_block_size = 8192 transaction_prealloc_size = 4096 wait_timeout = 20 innodb_buffer_pool_size=134217728 [mysqld_safe] [mysqldump] max_allowed_packet = 16M quick [isamchk] key_buffer = 384M read_buffer = 256M sort_buffer = 384M write_buffer = 256M [myisamchk] key_buffer = 384M read_buffer = 256M sort_buffer = 384M write_buffer = 256M join_buffer_size = 1M sort_buffer_size = 1M thread_stack = 192K 0 Quote Link to comment Share on other sites More sharing options...
lyra Posted April 25, 2016 Share Posted April 25, 2016 [mysqld] max_allowed_packet=268435456 Está em bytes. Coloque: [mysqld] max_allowed_packet=300M E vá aumentando gradativamente até encontrar um valor que atenda a demanda. 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.