各位好,我用drupal5.X架的站,但是最近因為系統負擔過高,被虛擬主機業者踢了出來,不知有沒有人碰過類似問題?如何解決?他們測試的結果如下:
------------
這是剛才開啟後的mysql連線,可以看到都lock term_node這個table
用檢查phpmyadmin該table,會出現主鍵 PRIMARY 及 索引鍵 INDEX 不應同時間設定欄位 `tid` 中的訊息
請用戶修正這個問題後,再來電通知.
| Id | User | Host | db | Command | Time | State | Info |
| 5069498 | vhost11204 | localhost | vhost11204 | Query | 17507 7 | Locked | DELETE FRO M term_node WHERE nid = 582 |
| 5069763 | vhost11204 | localhost | vhost11204 | Query | 17491 4 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5069770 | vhost11204 | localhost | vhost11204 | Query | 17490 9 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5071197 | vhost11204 | localhost | vhost11204 | Query | 17418 8 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5071313 | vhost11204 | localhost | vhost11204 | Query | 17414 4 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5071495 | vhost11204 | localhost | vhost11204 | Query | 17407 8 | Locked | SELECT COU NT(DISTINCT(n.nid)) FROM node n INNER JOIN term_node tn0 ON n.nid = tn0.nid WHE RE n.statu |
| 5071560 | vhost11204 | localhost | vhost11204 | Query | 17405 4 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5071913 | vhost11204 | localhost | vhost11204 | Query | 17389 0 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5072022 | vhost11204 | localhost | vhost11204 | Query | 17384 6 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5072382 | vhost11204 | localhost | vhost11204 | Query | 17370 2 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5072524 | vhost11204 | localhost | vhost11204 | Query | 17363 1 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5072687 | vhost11204 | localhost | vhost11204 | Query | 17357 0 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5072726 | vhost11204 | localhost | vhost11204 | Query | 17355 1 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5072990 | vhost11204 | localhost | vhost11204 | Query | 17345 0 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5073064 | vhost11204 | localhost | vhost11204 | Query | 17342 3 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5073741 | vhost11204 | localhost | vhost11204 | Query | 17314 6 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5074009 | vhost11204 | localhost | vhost11204 | Query | 17303 4 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5074146 | vhost11204 | localhost | vhost11204 | Query | 17297 4 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5074286 | vhost11204 | localhost | vhost11204 | Query | 17292 6 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5074448 | vhost11204 | localhost | vhost11204 | Query | 17283 1 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5074543 | vhost11204 | localhost | vhost11204 | Query | 17278 1 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5074656 | vhost11204 | localhost | vhost11204 | Query | 17271 9 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5074822 | vhost11204 | localhost | vhost11204 | Query | 17265 1 | Locked | SELECT COU NT(DISTINCT(n.nid)) FROM node n INNER JOIN term_node tn0 ON n.nid = tn0.nid WHE RE n.statu |
| 5074864 | vhost11204 | localhost | vhost11204 | Query | 17262 7 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5075397 | vhost11204 | localhost | vhost11204 | Query | 17232 7 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5075817 | vhost11204 | localhost | vhost11204 | Query | 17206 9 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5075963 | vhost11204 | localhost | vhost11204 | Query | 17200 9 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5075989 | vhost11204 | localhost | vhost11204 | Query | 17199 8 | Locked | SELECT COU NT(DISTINCT(n.nid)) FROM node n INNER JOIN term_node tn0 ON n.nid = tn0.nid WHE RE n.statu |
| 5076511 | vhost11204 | localhost | vhost11204 | Query | 17175 1 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5076823 | vhost11204 | localhost | vhost11204 | Query | 17160 0 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5076927 | vhost11204 | localhost | vhost11204 | Query | 17154 6 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5077050 | vhost11204 | localhost | vhost11204 | Query | 17147 8 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5077078 | vhost11204 | localhost | vhost11204 | Query | 17146 9 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5077092 | vhost11204 | localhost | vhost11204 | Query | 17146 3 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5077328 | vhost11204 | localhost | vhost11204 | Query | 17134 5 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5077416 | vhost11204 | localhost | vhost11204 | Query | 17130 0 | Locked | SELECT DIS TINCT(n.nid), n.sticky, n.title, n.created FROM node n INNER JOIN term_node tn0 ON n.nid |
| 5078348 | vhost11204 | localhost | vhost11204 | Query | 17078 6 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5078479 | vhost11204 | localhost | vhost11204 | Query | 17072 8 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5078524 | vhost11204 | localhost | vhost11204 | Query | 17070 5 | Locked | SELECT COU NT(DISTINCT(n.nid)) FROM node n INNER JOIN term_node tn0 ON n.nid = tn0.nid WHE RE n.statu |
| 5078804 | vhost11204 | localhost | vhost11204 | Query | 17056 7 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5079142 | vhost11204 | localhost | vhost11204 | Query | 17039 2 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5079333 | vhost11204 | localhost | vhost11204 | Query | 17030 2 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5080027 | vhost11204 | localhost | vhost11204 | Query | 16997 1 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5080157 | vhost11204 | localhost | vhost11204 | Query | 16991 4 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5080165 | vhost11204 | localhost | vhost11204 | Query | 16991 0 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5080386 | vhost11204 | localhost | vhost11204 | Query | 16981 5 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5080502 | vhost11204 | localhost | vhost11204 | Query | 16976 9 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5081020 | vhost11204 | localhost | vhost11204 | Query | 16954 6 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5081438 | vhost11204 | localhost | vhost11204 | Query | 16936 3 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5081449 | vhost11204 | localhost | vhost11204 | Query | 16935 6 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5081587 | vhost11204 | localhost | vhost11204 | Query | 16928 1 | Locked | SELECT COU NT(DISTINCT(n.nid)) FROM node n INNER JOIN term_node tn0 ON n.nid = tn0.nid WHE RE n.statu |
| 5081897 | vhost11204 | localhost | vhost11204 | Query | 16914 1 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5082349 | vhost11204 | localhost | vhost11204 | Query | 16890 6 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5082526 | vhost11204 | localhost | vhost11204 | Query | 16882 4 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5082656 | vhost11204 | localhost | vhost11204 | Query | 16875 8 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5082736 | vhost11204 | localhost | vhost11204 | Query | 16872 2 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5082755 | vhost11204 | localhost | vhost11204 | Query | 16871 4 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5082852 | vhost11204 | localhost | vhost11204 | Query | 16868 2 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5082958 | vhost11204 | localhost | vhost11204 | Query | 16863 7 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5083234 | vhost11204 | localhost | vhost11204 | Query | 16849 7 | Locked | SELECT t.t id, t.* FROM term_data t INNER JOIN term_node r ON r.tid = t.tid WHERE t.vid = 1 AND r.nid |
| 5084185 | vhost11204 | localhost | vhost11204 | Query | 16781 4 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5084212 | vhost11204 | localhost | vhost11204 | Query | 16779 1 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5084239 | vhost11204 | localhost | vhost11204 | Query | 16777 3 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5084417 | vhost11204 | localhost | vhost11204 | Query | 16764 3 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5084422 | vhost11204 | localhost | vhost11204 | Query | 16764 1 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5084495 | vhost11204 | localhost | vhost11204 | Query | 16758 6 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5084655 | vhost11204 | localhost | vhost11204 | Query | 16746 0 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5084668 | vhost11204 | localhost | vhost11204 | Query | 16744 5 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5084795 | vhost11204 | localhost | vhost11204 | Query | 16736 7 | Locked | SELECT DIS TINCT(n.nid), n.sticky, n.title, n.created FROM node n INNER JOIN term_node tn0 ON n.nid |
| 5084818 | vhost11204 | localhost | vhost11204 | Query | 16735 0 | Locked | SELECT COU NT(DISTINCT(n.nid)) FROM node n INNER JOIN term_node tn0 ON n.nid = tn0.nid WHE RE n.statu |
| 5084876 | vhost11204 | localhost | vhost11204 | Query | 16731 6 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5085044 | vhost11204 | localhost | vhost11204 | Query | 16718 7 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5085070 | vhost11204 | localhost | vhost11204 | Query | 16717 0 | Locked | SELECT COU NT(DISTINCT(n.nid)) FROM node n INNER JOIN term_node tn0 ON n.nid = tn0.nid WHE RE n.statu |
| 5085188 | vhost11204 | localhost | vhost11204 | Query | 16707 5 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5085236 | vhost11204 | localhost | vhost11204 | Query | 16703 5 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5085359 | vhost11204 | localhost | vhost11204 | Query | 16694 0 | Locked | SELECT DIS TINCT(n.nid), n.sticky, n.title, n.created FROM node n INNER JOIN term_node tn0 ON n.nid |
| 5085471 | vhost11204 | localhost | vhost11204 | Query | 16688 8 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5085701 | vhost11204 | localhost | vhost11204 | Query | 16677 2 | Locked | SELECT COU NT(DISTINCT(n.nid)) FROM node n INNER JOIN term_node tn0 ON n.nid = tn0.nid WHE RE n.statu |
| 5085903 | vhost11204 | localhost | vhost11204 | Query | 16665 6 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5086221 | vhost11204 | localhost | vhost11204 | Query | 16652 7 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5086387 | vhost11204 | localhost | vhost11204 | Query | 16640 2 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5086480 | vhost11204 | localhost | vhost11204 | Query | 16631 9 | Locked | SELECT COU NT(DISTINCT(n.nid)) FROM node n INNER JOIN term_node tn0 ON n.nid = tn0.nid WHE RE n.statu |
| 5086587 | vhost11204 | localhost | vhost11204 | Query | 16622 2 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5086901 | vhost11204 | localhost | vhost11204 | Query | 16591 6 | Locked | SELECT t.t id, t.* FROM term_data t INNER JOIN term_node r ON r.tid = t.tid WHERE t.vid = 1 AND r.nid |
| 5086984 | vhost11204 | localhost | vhost11204 | Query | 16583 7 | Locked | SELECT DIS TINCT(n.nid), n.sticky, n.title, n.created FROM node n INNER JOIN term_node tn0 ON n.nid |
| 5087123 | vhost11204 | localhost | vhost11204 | Query | 16571 5 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5087396 | vhost11204 | localhost | vhost11204 | Query | 16551 4 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5087475 | vhost11204 | localhost | vhost11204 | Query | 16546 5 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5087599 | vhost11204 | localhost | vhost11204 | Query | 16536 6 | Locked | SELECT COU NT(DISTINCT(n.nid)) FROM node n INNER JOIN term_node tn0 ON n.nid = tn0.nid WHE RE n.statu |
| 5087707 | vhost11204 | localhost | vhost11204 | Query | 16527 0 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5087796 | vhost11204 | localhost | vhost11204 | Query | 16518 5 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5087901 | vhost11204 | localhost | vhost11204 | Query | 16508 0 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5087970 | vhost11204 | localhost | vhost11204 | Query | 16504 0 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5088042 | vhost11204 | localhost | vhost11204 | Query | 16498 8 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5088162 | vhost11204 | localhost | vhost11204 | Query | 16489 1 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5088248 | vhost11204 | localhost | vhost11204 | Query | 16482 5 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5088468 | vhost11204 | localhost | vhost11204 | Query | 16465 9 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5088564 | vhost11204 | localhost | vhost11204 | Query | 16458 0 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5088778 | vhost11204 | localhost | vhost11204 | Query | 16444 0 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5088836 | vhost11204 | localhost | vhost11204 | Query | 16439 6 | Locked | SELECT cou nt(node.nid) FROM node node LEFT JOIN term_node term_node ON node.nid = term_no de.nid LEF |
| 5089096 | vhost11204 | localhost | vhost11204 | Query | 16417 7 | Locked | SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid |
| 5089680 | vhost11204 | localhost | vhost11204 | Query
...
Re: 被虛擬主機業者踢了出來
term_node用兩個index本來就是合理的
主機商豬頭...
--
from open mind to open source~
Re: 被虛擬主機業者踢了出來
看不出個所以然來,因為不過就是一般的 join selection ?
所以主機商的 mysql database load 過高囉?