fellowitoHello!!
I have a problem with WordPress since two or three months ago. I've also seen is an usual problem, but I couldn't find how to fix it.
I have a SQL server overload. When I enter in my site, I receive the next message: Error establishing a database connection. If I try to enter in myPHPadmin, I have problems to connect, when I'm lucky and I can write query: 'show full processlist', I see there are a big queue of queries.
For example :
Id User Host db Command Time State Info
16 dbo********* localhost db********* Query 24 Waiting for table SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND w...
17 dbo********* localhost db********* Query 24 Waiting for table SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND w...
18 dbo********* localhost db********* Query 24 Waiting for table SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND w...
19 dbo********* localhost db********* Query 24 Waiting for table SELECT post_modified_gmt FROM wp_posts WHERE post_...
20 dbo********* localhost db********* Query 24 Waiting for table SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND w...
23 dbo********* localhost db********* *0513*** Query 24 Waiting for table SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND w...
26 dbo********* localhost db********* Query 24 Waiting for table SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND w...
27 dbo********* localhost db********* Query 24 Waiting for table SELECT post_modified_gmt FROM wp_posts WHERE post_...
28 dbo********* localhost db********* Query 24 Waiting for table SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND Y...
29 dbo********* localhost db********* Query 23 Waiting for table SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND Y...
I've read that problem is due to a low memory of my hosting. I've contacted him (1and1), and they said they can't do anything. I have a dedicated server, so it has no sense.
I've tried deactivating plugins, but it didn't work.
What can I do?
I hope u can help me.
Thanks you very much.
