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 SystemBut 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 | UPDATEwp_term_taxonomy
SETcount
= 206 WHEREterm_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…
- The topic ‘Server Overload Caused by WP Database’ is closed to new replies.