Support » Fixing WordPress » Server Overload Caused by WP Database

  • Hello,

    I’ve been suffering from this issue for ever. It has been 7 month now since this problem appeared and couldnt resolve the problem.

    I own a server and here are some spec.

    Quad Core Xeon® X3430 Processor
    4 x 2.4 GHz Cores
    8 MB L3 Cache, 1333 MHz FSB
    4 GB 1333MHz DDR3 Memory
    500 GB Usable Storage
    6 TB Monthly Transfer
    100 Mbps Uplink Port
    4 IP Addresses
    CentOS 5 Operating System

    But I keep getting full load to the resources.

    The support team of the company that is monitoring my server says that the overload is caused by wordpress.

    The following is a mysql processlist showing the query that is causing the issue.

    | 77 | wordpress_admin | localhost | wordpress_database | Query | 2979 | Copying to tmp table | SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER J |
    | 234 | wordpress_admin | localhost | wordpress_database | Query | 1821 | Copying to tmp table | SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER J |
    | 243 | wordpress_admin | localhost | wordpress_database | Query | 1719 | Copying to tmp table | SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER J |
    | 247 | wordpress_admin | localhost | wordpress_database | Query | 1721 | Copying to tmp table | SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER J |
    | 276 | wordpress_admin | localhost | wordpress_database | Query | 1643 | Copying to tmp table | SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER J |
    | 441 | wordpress_admin | localhost | wordpress_database | Query | 1730 | Copying to tmp table | SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER J |
    | 524 | wordpress_admin | localhost | wordpress_database | Query | 1660 | Copying to tmp table | SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER J |
    | 562 | wordpress_admin | localhost | wordpress_database | Query | 1707 | Copying to tmp table | SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER J |
    | 578 | wordpress_admin | localhost | wordpress_database | Query | 1718 | Copying to tmp table | SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER J |
    | 579 | wordpress_admin | localhost | wordpress_database | Query | 1730 | Copying to tmp table | SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER J |
    | 582 | wordpress_admin | localhost | wordpress_database | Query | 1727 | Copying to tmp table | SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER J |
    | 588 | wordpress_admin | localhost | wordpress_database | Query | 1722 | Copying to tmp table | SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER J |
    | 626 | wordpress_admin | localhost | wordpress_database | Query | 1647 | Copying to tmp table | SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER J |
    | 628 | wordpress_admin | localhost | wordpress_database | Query | 1722 | Copying to tmp table | SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER J |
    | 632 | wordpress_admin | localhost | wordpress_database | Query | 985 | Locked | SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = |
    | 671 | wordpress_admin | localhost | wordpress_database | Query | 1731 | Copying to tmp table | SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER J |
    | 701 | wordpress_admin | localhost | wordpress_database | Query | 1715 | Copying to tmp table | SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER J |
    | 710 | wordpress_admin | localhost | wordpress_database | Query | 1728 | Copying to tmp table | SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER J |
    | 713 | wordpress_admin | localhost | wordpress_database | Query | 1730 | Copying to tmp table | SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER J |
    | 726 | wordpress_admin | localhost | wordpress_database | Query | 1715 | Copying to tmp table | SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER J |
    | 737 | wordpress_admin | localhost | wordpress_database | Query | 1722 | Copying to tmp table | SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER J |
    | 740 | wordpress_admin | localhost | wordpress_database | Query | 1735 | Copying to tmp table | SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER J |
    | 741 | wordpress_admin | localhost | wordpress_database | Query | 1715 | Copying to tmp table | SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER J |
    | 742 | wordpress_admin | localhost | wordpress_database | Query | 1717 | Copying to tmp table | SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER J |
    | 744 | wordpress_admin | localhost | wordpress_database | Query | 1214 | Locked | UPDATE wp_term_taxonomy SET count = 206 WHERE term_taxonomy_id = 178 |
    | 748 | wordpress_admin | localhost | wordpress_database | Query | 1714 | Copying to tmp table | SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER J |
    | 753 | wordpress_admin | localhost | wordpress_database | Query | 1722 | Copying to tmp table | SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER J |
    | 755 | wordpress_admin | localhost | wordpress_database | Query | 1730 | Copying to tmp table | SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER J |
    | 757 | wordpress_admin | localhost | wordpress_database | Query | 1716 | Copying to tmp table | SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER J |
    | 761 | wordpress_admin | localhost | wordpress_database | Query | 1154 | Locked | SELECT SUM(count) FROM wp_term_taxonomy WHERE taxonomy = ‘category’ AND parent = 12 |
    | 764 | wordpress_admin | localhost | wordpress_database | Query | 1717 | Copying to tmp table | SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER J |
    | 765 | wordpress_admin | localhost | wordpress_database | Query | 1728 | Copying to tmp table | SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER J |
    | 766 | wordpress_admin | localhost | wordpress_database | Query | 1722 | Copying to tmp table | SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER J |
    | 769 | wordpress_admin | localhost | wordpress_database | Query | 1678 | Copying to tmp table | SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER J |
    | 774 | wordpress_admin | localhost | wordpress_database | Query | 1722 | Copying to tmp table | SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER J |
    | 775 | wordpress_admin | localhost | wordpress_database | Query | 1730 | Copying to tmp table | SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER J |
    | 777 | wordpress_admin | localhost | wordpress_database | Query | 1700 | Copying to tmp table | SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER J |
    | 778 | wordpress_admin | localhost | wordpress_database | Query | 1716 | Copying to tmp table | SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER J |
    | 780 | wordpress_admin | localhost | wordpress_database | Query | 1717 | Copying to tmp table | SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER J |
    | 785 | wordpress_admin | localhost | wordpress_database | Query | 1730 | Copying to tmp table | SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER J |
    | 786 | wordpress_admin | localhost | wordpress_database | Query | 1702 | Copying to tmp table | SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER J |
    | 788 | wordpress_admin | localhost | wordpress_database | Query | 1682 | Copying to tmp table | SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER J |
    | 791 | wordpress_admin | localhost | wordpress_database | Query | 1717 | Copying to tmp table | SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER J |
    | 792 | wordpress_admin | localhost | wordpress_database | Query | 1687 | Copying to tmp table | SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER J |
    | 793 | wordpress_admin | localhost | wordpress_database | Query | 1684 | Copying to tmp table | SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER J |
    | 795 | wordpress_admin | localhost | wordpress_database | Query | 1070 | Locked | SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = |
    | 803 | wordpress_admin | localhost | wordpress_database | Query | 1629 | Copying to tmp table | SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER J |
    | 806 | wordpress_admin | localhost | wordpress_database | Query | 1628 | Copying to tmp table | SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER J |
    | 808 | wordpress_admin | localhost | wordpress_database | Query | 1627 | Copying to tmp table | SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER J |
    | 809 | wordpress_admin | localhost | wordpress_database | Query | 1625 | Copying to tmp table | SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER J |
    | 812 | wordpress_admin | localhost | wordpress_database | Query | 1628 | Copying to tmp table | SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER J |
    | 813 | wordpress_admin | localhost | wordpress_database | Query | 1628 | Copying to tmp table | SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER J |
    | 819 | wordpress_admin | localhost | wordpress_database | Query | 996 | Locked | SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = |
    | 824 | wordpress_admin | localhost | wordpress_database | Query | 1582 | Copying to tmp table | SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER J |
    | 825 | wordpress_admin | localhost | wordpress_database | Query | 1558 | Copying to tmp table | SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER J |
    | 826 | wordpress_admin | localhost | wordpress_database | Query | 1569 | Copying to tmp table | SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER J |
    | 828 | wordpress_admin | localhost | wordpress_database | Query | 1137 | Locked | SELECT SUM(count) FROM wp_term_taxonomy WHERE taxonomy = ‘category’ AND parent = 12 |
    | 829 | wordpress_admin | localhost | wordpress_database | Query | 1549 | Copying to tmp table | SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER J |
    | 830 | wordpress_admin | localhost | wordpress_database | Query | 1547 | Copying to tmp table | SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER J |
    | 840 | wordpress_admin | localhost | wordpress_database | Query | 1476 | Copying to tmp table | SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER J |
    | 849 | wordpress_admin | localhost | wordpress_database | Query | 1455 | Copying to tmp table | SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER J |
    | 859 | wordpress_admin | localhost | wordpress_database | Query | 1432 | Copying to tmp table | SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER J |
    | 862 | wordpress_admin | localhost | wordpress_database | Query | 996 | Locked | SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = |
    | 865 | wordpress_admin | localhost | wordpress_database | Query | 1411 | Copying to tmp table | SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER J |
    | 867 | wordpress_admin | localhost | wordpress_database | Query | 1393 | Copying to tmp table | SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER J |
    | 869 | wordpress_admin | localhost | wordpress_database | Query | 1368 | Copying to tmp table | SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER J |
    | 870 | wordpress_admin | localhost | wordpress_database | Query | 1371 | Copying to tmp table | SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER J |
    | 872 | wordpress_admin | localhost | wordpress_database | Query | 1346 | Copying to tmp table | SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER J |
    | 875 | wordpress_admin | localhost | wordpress_database | Query | 1346 | Copying to tmp table | SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER J |
    | 878 | wordpress_admin | localhost | wordpress_database | Query | 1341 | Copying to tmp table | SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER J |
    | 880 | wordpress_admin | localhost | wordpress_database | Query | 1333 | Copying to tmp table | SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER J |
    | 882 | wordpress_admin | localhost | wordpress_database | Query | 1176 | Locked | SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = |
    | 885 | wordpress_admin | localhost | wordpress_database | Query | 1251 | Copying to tmp table | SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER J |
    | 886 | wordpress_admin | localhost | wordpress_database | Query | 1243 | Copying to tmp table | SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER J |
    | 889 | wordpress_admin | localhost | wordpress_database | Query | 1240 | Copying to tmp table | SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER J |
    | 890 | wordpress_admin | localhost | wordpress_database | Query | 1240 | Copying to tmp table | SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER J |
    | 891 | wordpress_admin | localhost | wordpress_database | Query | 1253 | Copying to tmp table | SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER J |
    | 894 | wordpress_admin | localhost | wordpress_database | Query | 1241 | Copying to tmp table | SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER J |
    | 895 | wordpress_admin | localhost | wordpress_database | Query | 1240 | Copying to tmp table | SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER J |
    | 896 | wordpress_admin | localhost | wordpress_database | Query | 1240 | Copying to tmp table | SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER J |
    | 903 | wordpress_admin | localhost | wordpress_database | Query | 1221 | Copying to tmp table | SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER J |
    | 905 | wordpress_admin | localhost | wordpress_database | Query | 1216 | Copying to tmp table | SELECT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER J |
    | 906 | wordpress_admin | localhost | wordpress_database | Query | 1173 | Locked | SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = |
    | 907 | wordpress_admin | localhost | wordpress_database | Query | 1132 | Locked | SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNE |
    | 908 | wordpress_admin | localhost | wordpress_database | Query | 1122 | Locked | SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNE |
    | 910 | wordpress_admin | localhost | wordpress_database | Query | 1123 | Locked | SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNE |
    | 911 | wordpress_admin | localhost | wordpress_database | Query | 1124 | Locked | SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNE |
    | 912 | wordpress_admin | localhost | wordpress_database | Query | 1117 | Locked | SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = |
    | 913 | wordpress_admin | localhost | wordpress_database | Query | 1109 | Locked | SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNE |
    | 914 | wordpress_admin | localhost | wordpress_database | Query | 1108 | Locked | SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = |
    | 915 | wordpress_admin | localhost | wordpress_database | Query | 1078 | Locked | SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNE |
    | 916 | wordpress_admin | localhost | wordpress_database | Query | 1090 | Locked | SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHER |
    | 917 | wordpress_admin | localhost | wordpress_database | Query | 1075 | Locked | SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNE |
    | 918 | wordpress_admin | localhost | wordpress_database | Query | 1046 | Locked | SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNE |
    | 921 | wordpress_admin | localhost | wordpress_database | Query | 1033 | Locked | SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = |
    | 922 | wordpress_admin | localhost | wordpress_database | Query | 1020 | Locked | SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNE |
    | 931 | wordpress_admin | localhost | wordpress_database | Query | 536 | Locked | SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHER |

    Anyone knows how to solve this issue…..

    Please help…

Viewing 3 replies - 1 through 3 (of 3 total)
Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Server Overload Caused by WP Database’ is closed to new replies.