• Hello!!

    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.

Viewing 1 replies (of 1 total)
  • Same problem here, since you posted this 8 months go anyone came with a solution?
    Maybe get a different script?

Viewing 1 replies (of 1 total)
  • The topic ‘SQL server overload’ is closed to new replies.