My blog is "mostly" working after a recent move to a new hosting provider. I've been using/customizing WordPress for 2 years so I am fairly familiar with self-hosted configuration/setup/troubleshooting but am running into a strange database-oriented problem. The site is running slower than it should be. I have moved/started about 10 blogs on this new hosting provider (Media Temple) and all are fine and have been running well for months, but this recently-moved blog is seeing lost connection problems. Some pages show on the blog, others timeout due to the DB issue.
All my blogs are on the same grid, in the same SQL Server container, so I know it isn't a SQL Server issue since all the other blogs are fast and no errors.
This isn't the only query that has problems but is an example:
WordPress database error Lost connection to MySQL server during query for query SELECT DISTINCT YEAR(post_date) AS
year, MONTH(post_date) AS
month, count(ID) as posts FROM wp_posts WHERE post_type = 'post' AND post_status = 'publish' GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC made by require, require_once, include, get_header, locate_template, load_template, require_once, wp_get_archives ....
This is my most important blog, so any help or suggestions is greatly appreciated.