WordPress database cause a load on server

  • I have a wordpress website that cause a slow server performance ,
    and it shows a huge difference when reading the CPU usage statistics , thats when that website is “suspended” , the CPU average usage is about 2% ,
    while its arrive to 90% after “unsuspended or activate” that website.
    there was a table in the database called “wp-posts”
    when I tried to delete that table
    the CPU average usage decrease to be about 5% ,,
    that was bit a weird , also I tried to check the database from the account’s cPanel
    it gave me reads of all tables status in that DB which shows that there is no problem with any of them including “wp-posts” and it doesn’t need to repair ,,
    now , the website is activate but it cause load on server , I don’t know how to fix that
    and Im sure that the wrong is with the database itself , but I don’t know where is that exactly , or how to fix it ..
    if anybody have had the same problem , please help …

Viewing 5 replies - 1 through 5 (of 5 total)
  • Matt Knowles

    (@aestheticdesign)

    Unless you know what you’re doing, deleting tables from the database is a really bad idea. Tables by themselves aren’t going to cause a performance problem. Activity by users or processes is what’s causing your problem.

    Most likely cause is a badly written theme or plugin. Try switching themes for awhile and disable the plugins one by one to see if the problem goes away.

    If MySQL is overloading the server, you should ask your host to provide list of queries which are being running long time. Based on this, it will help you troubleshoot your issue. Also, before you remove anything, you should secure full backup of your data.

    ——duplicate reply.. Moderator please remove this post —-
    If MySQL is overloading the server, you should ask your host to provide list of queries which are being running long time. Based on this, it will help you troubleshoot your issue. Also, before you remove anything, you should secure full backup of your data.

    Thread Starter zainab_d

    (@zainab_d)

    Matt Knowles ,,
    thank u for ur time ,,
    but actually , I have used the same theme with another wordpress website , and everything was working normally , with no load …
    I have checked the average CPU usage for the whole server which has more than 20 websites , and the average was about 2% – 3% , even with activating the other wordpress website which has the same theme and even has more plug-ins than the one Im asking about ,,
    so , I dont thing the problem is with the theme itself nor the plugins ,,
    it might be with the database or some activities by users that cause the load ,,

    Thread Starter zainab_d

    (@zainab_d)

    ok Kailash ,
    will do ..
    thank you for ur time

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘WordPress database cause a load on server’ is closed to new replies.