You shouldn’t be blindly changing configs in my.cnf. Use rackerhacker/MySQLTuner-perl · GitHub to test and check your my.cnf configs. It will give suggestions for memory allocations and all other aspects of MySQL tuning. You also should configure httpd.conf for high loads. See Apache Performance Tuning – Apache HTTP Server
DISCLAIMER : Not a WordPress Developer, Just a MySQL DBA For a given table, say link_url mysql> show create table wp_links\G *************************** 1. row *************************** Table: wp_links Create Table: CREATE TABLE `wp_links` ( `link_id` bigint(20) unsigned NOT NULL auto_increment, `link_url` varchar(255) NOT NULL default ”, `link_name` varchar(255) NOT NULL default ”, `link_image` varchar(255) NOT NULL … Read more
WordPress plugin overloading with tmp tables
I needed this for a client recently (he wanted to do the same but be able to create a archive by himself in the wordpress backend) and couldn’t find a good plugin for it. It’s pretty easy to custom code this actually. You just need to make your install a network install and then place … Read more
Calculate average crossing post categories
Slow wp-admin due to “SELECT DISTINCT post_mime_type FROM wp_posts WHERE post_type=”attachment””
Your best bet would be to take DB and site backup and see if you can get it working on local server or any other server, if you do get it running the problem is with the way server probably changed some settings while upgrading. Also in the screenshot image isn’t loaded, but can you … Read more
Alter wp_post table vs. post_meta performance/speed
How to add a private user page populated from sql?
Regarding “Insert query error” in wordpress