mysql - Read For Learn

mysql running over 200% CPU according to atop – pt-query-digest suggests slow running query is a lookup in wp_options for ‘autoload’ = yes

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

Remove posts that start with similar words (like a delete duplicate posts plugin)

Global update of records after import WP All Import Pro

WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax [closed]

Understanding Redundant postmeta Tables in WordPress Database

Is it normal to have multiple postmeta tables in a WordPress database? No, each site has a single post/user/term and comment meta table. A multisite will have a set of those tables for each site in the multisite, plus network/site meta tables. What could be the reason behind this duplication? WP wouldn’t duplicate the tables … Read more

+ More

Admin backend is very slow to create or edit posts by core meta query

is it possible to get a list of URLs from post_content directly in a mysql query via phpadmin?

WordPress cannot detect (present, loaded) mysqli

select posts from sql except posts from specific category