As Tom J Nowell pointed out in the comments, this is a very specific situation, which makes the question rather difficult to answer. If the source system has suitable code for pushing data to other systems, then you could consider registering a custom REST endpoint at the WordPress end. The endpoint would receive, validate and … Read more
As discussed in comments, the problem was a missing prce2 package which meant preg_match(), used by $wpdb->db_version() to parse the MySQL version number out of SELECT VERSION(), didn’t work. Solved by sudo yum install pcre2
SELECT option_name, option_value FROM wp_options WHERE autoload = ‘yes’ always is running
Admin backend is very slow to create or edit posts by core meta query
WordPress cannot detect (present, loaded) mysqli
So the issue was actually a DDOS attack on our site. I used urlsnarf to see what requests were being placed and there were basically hundreds of POST request from about 20-30 or so IP addresses. Seems quite small scale for what I understood is a typical DDOS attack. It also explains why it took … Read more
$wpdb->get_results() query empty, but same query in phpmyadmin has results
It appears, at least in cPanel, the lines in question were not required in the export, with the unsurprising consequence of the other encapsulated sql statements defaulting to reference the current database only. Turns out to be convenient when more than one database is configured, so long as there are no statements that select objects … Read more
Looking at the source of class-wp-query.php (ie, the WP_Query code), I find this: /* * Ensure the ID database query is able to be cached. * * Random queries are expected to have unpredictable results and * cannot be cached. Note the space before `RAND` in the string * search, that to ensure against a … Read more
there is no simple general answer for this, as it depends on what is causing the issue. Best way is to check your page using some Insights tool: https://pagespeed.web.dev/ https://gtmetrix.com/ They will tell you where the issue is. Big images are commonly a big issue – there are many converters to WebP format, that will … Read more