I suddenly started receiving huge log entries for UPDATE db queries. Each line over 16 M Bytes with indication “Got a packet bigger than ‘max_allowed_packet’ bytes”.
Single debug entry here: https://drive.google.com/file/d/16KHTKNpvjFLqD6kgO-sWX9Xj5ZDH58PC/view?usp=sharing
System info:
### wp-core ###
version: 6.0.1
site_language: el
user_language: en_US
timezone: Europe/Athens
permalink: /%year%/%monthnum%/%postname%/
https_status: true
### wp-parent-theme ###
name: Newspaper (Newspaper)
version: 11.5.1
author: tagDiv
### wp-server ###
server_architecture: Linux 4.15.0-167-generic x86_64
httpd_software: Apache/2.4.52 (Debian)
php_version: 7.4.27 64bit
php_sapi: apache2handler
max_input_variables: 10000
time_limit: 300
memory_limit: 512M
max_input_time: -1
upload_max_filesize: 32M
php_post_max_size: 32M
curl_version: 7.74.0 OpenSSL/1.1.1k
suhosin: false
imagick_availability: true
pretty_permalinks: true
htaccess_extra_rules: true
### wp-database ###
extension: mysqli
server_version: 10.4.7-MariaDB-1:10.4.7+maria~bionic
client_version: mysqlnd 7.4.27
max_allowed_packet: 16777216
max_connections: 100
But is such a big query valid?
Hello!
Please check some tips here:
– https://wpartisan.me/tutorials/wordpress-database-queries-speed-sql_calc_found_rows
– https://css-tricks.com/finding-and-fixing-slow-wordpress-database-queries/
– https://wordpress.org/support/topic/slow-database-queries-from-mariadb-slow-query-log/
– https://www.rackaid.com/blog/wordpress-slow-speed-up/
Maybe your hosting provider can provide some advices as well.
Thank you!
I think I wasn’t very clear and as a result you have misunderstood here. My point is this. Isn’t a 16MB query too big for a WordPress theme? Isn’t there a more efficient way for the specific task? Is this a bad written query or not?
Hello!
In order to reduce the number of queries, our developers fixed some issues and rebuilt the code. Now, it depends on how many elements you use on the page. I recommend you start optimizing your website.
Thank you for understanding!
My understanding is that you don’t bother about performance issues. My website’s page size is way smaller than the 16Mb of 1 of your queries. Situation getting more nasty as you dive deeper in theme’s dev choices. Whatever. At the and of the day it is just 60 bucks for a theme for the masses. Not for critical mission websites. That is what I understand. Thanks for your time.
