ต่อไป »

[arty7221]

โดนแจ้งเตือนแบบนี้อ่ะค่ะ ใครพอจะทราบช่วยแนะนำหน่อยค่ะ
ดูเหมือนว่าจะเป็นเรื่อง SQL แต่ไม่รู้จะแก้ไขยังไง
เค้าเมล์มาบอกตามนี้

Hello,

This message is to advise you of a temporary block placed on your database. The database was found to be consuming an inordinate amount of processor time, to the point of degrading overall system performance. While we do limit each account to no more than 25% of a system's CPU in our terms of service, we do not actively disable accounts until they greatly exceed that number, which is what happened in this case. Requests to this database may become degraded by limiting the maximum number of queries or connections for a limited amount of time, or if there are sustained issues, ultimately we may be forced to block access to this database until the issue has been resolved.

Resolving this situation may be as simple as adding additional indexes to your database, optimizing the queries used, or something equally easy. If not, it may simply be a matter of moving this database to dedicated services, as it may have outgrown a shared environment.

If you believe you have a solution to this overuse, we are happy to discuss the situation with you and possibly reinstate the database on the server. Otherwise, we will be happy to assist you with the upgrade process if a dedicated server is the most appropriate solution. Thank you, and we look forward to hearing from you shortly.

~~~
Excessive MySQL activity is caused by (a) a long-running process that locks a table, causing other queries to back up, (b) a query that is not optimized ][example: select all from ... and involving a large or complex query], (c) huge table copies/maintenance during peak hours.

NOTE:, the following are just possible fixes or suggestions, and are not endorsed or supported by HostGator. They are included in the hope that they may apply to your situation, and/or help you reduce the amount of resources your SQL queries consume. As always, it's best to backup any data before making any changes or adjustments.

First and foremost, you may need to optimize your tables. The frequency depends on the size and usage of the database, but most databases would benefit from doing something like this on a yearly basis: a) Enter your phpMyAdmin/MySQL control panel. Click on the database (not the table, the database name), and on the right hand column your tables should be listed. Scroll down till you see the .Check all. link. Click on that link, make sure all database tables are checked and then from the drop-down next to it, and carefully select .Optimize table..

Additionally, adding indexes to your table(s) may improve performance. If you're not sure what you're doing, it's best not to modify any table; caution is recommended. There are various articles (http://www.developer.com/db/ar...timize-Your-MySQL-Database.htm and http://www.databasejournal.com...-MySQL-Queries-and-Indexes.htm ). It may be best to Google for something like [Your Software Name] MySQL indexes for suggestions.

If you reply back to this with your IP address (http://www.hostgator.com/ip.shtml ) we will be more than happy to go ahead enable HTTP access for you, so that you can safely work on the script without it causing further issues. Please let us know how you would like to proceed.


CPU_TIME:257 table_rows_read:55732785 SELECTS:1129 ROWS_UPDATED:563 ROWS_FETCHED:0 BUSY_TIME:1283 ONNECTED_TIME:1361 BYTES_SENT:11948536 BYTES_RECEIVED:499669 WAIT_TIME:1026


Top table row reads:
DB_USER: arty7221_wrdp4 -- TOTAL_CONNECTIONS: 63 -- CONNECTED_TIME: 1337 -- CPU_TIME: 257 -- TABLE_ROW_READS: 55730573 -- SELECT_COMMANDS: 789 -- UPDATE_COMMANDS: -- BUSY_TIME: 1282 -- BYTES_SENT: 8721038 -- BYTES_RECEIVED: 351773 -- WAIT_TIME (IO): 1025
DB_USER: arty7221_wrdp1 -- TOTAL_CONNECTIONS: 24 -- CONNECTED_TIME: 16 -- CPU_TIME: 0 -- TABLE_ROW_READS: 1454 -- SELECT_COMMANDS: 219 -- UPDATE_COMMANDS: -- BUSY_TIME: 0 -- BYTES_SENT: 2264029 -- BYTES_RECEIVED: 108611 -- WAIT_TIME (IO): 0
DB_USER: arty7221_wrdp2 -- TOTAL_CONNECTIONS: 3 -- CONNECTED_TIME: 3 -- CPU_TIME: 0 -- TABLE_ROW_READS: 351 -- SELECT_COMMANDS: 37 -- UPDATE_COMMANDS: -- BUSY_TIME: 0 -- BYTES_SENT: 213664 -- BYTES_RECEIVED: 10999 -- WAIT_TIME (IO): 0
DB_USER: arty7221_wrdp26 -- TOTAL_CONNECTIONS: 4 -- CONNECTED_TIME: 1 -- CPU_TIME: 0 -- TABLE_ROW_READS: 183 -- SELECT_COMMANDS: 34 -- UPDATE_COMMANDS: -- BUSY_TIME: 0 -- BYTES_SENT: 318042 -- BYTES_RECEIVED: 11438 -- WAIT_TIME (IO): 0
DB_USER: arty7221_wrdp25 -- TOTAL_CONNECTIONS: 2 -- CONNECTED_TIME: 3 -- CPU_TIME: 0 -- TABLE_ROW_READS: 120 -- SELECT_COMMANDS: 22 -- UPDATE_COMMANDS: -- BUSY_TIME: 1 -- BYTES_SENT: 117452 -- BYTES_RECEIVED: 6353 -- WAIT_TIME (IO): 1
DB_USER: arty7221_wrdp3 -- TOTAL_CONNECTIONS: 1 -- CONNECTED_TIME: 1 -- CPU_TIME: 0 -- TABLE_ROW_READS: 43 -- SELECT_COMMANDS: 12 -- UPDATE_COMMANDS: -- BUSY_TIME: 0 -- BYTES_SENT: 81681 -- BYTES_RECEIVED: 4030 -- WAIT_TIME (IO): 0
DB_USER: arty7221_wrdp8 -- TOTAL_CONNECTIONS: 1 -- CONNECTED_TIME: 0 -- CPU_TIME: 0 -- TABLE_ROW_READS: 42 -- SELECT_COMMANDS: 10 -- UPDATE_COMMANDS: -- BUSY_TIME: 0 -- BYTES_SENT: 136593 -- BYTES_RECEIVED: 3453 -- WAIT_TIME (IO): 0
DB_USER: arty7221_wrdp18 -- TOTAL_CONNECTIONS: 1 -- CONNECTED_TIME: 0 -- CPU_TIME: 0 -- TABLE_ROW_READS: 19 -- SELECT_COMMANDS: 6 -- UPDATE_COMMANDS: -- BUSY_TIME: 0 -- BYTES_SENT: 96037 -- BYTES_RECEIVED: 3012 -- WAIT_TIME (IO): 0



Top WAIT (IO) TIME:
DB_USER: arty7221_wrdp4 -- TOTAL_CONNECTIONS: 63 -- CONNECTED_TIME: 1337 -- CPU_TIME: 257 -- TABLE_ROW_READS: 55730573 -- SELECT_COMMANDS: 789 -- UPDATE_COMMANDS: -- BUSY_TIME: 1282 -- BYTES_SENT: 8721038 -- BYTES_RECEIVED: 351773 -- WAIT_TIME (IO): 1025
DB_USER: arty7221_wrdp25 -- TOTAL_CONNECTIONS: 2 -- CONNECTED_TIME: 3 -- CPU_TIME: 0 -- TABLE_ROW_READS: 120 -- SELECT_COMMANDS: 22 -- UPDATE_COMMANDS: -- BUSY_TIME: 1 -- BYTES_SENT: 117452 -- BYTES_RECEIVED: 6353 -- WAIT_TIME (IO): 1
DB_USER: arty7221_wrdp1 -- TOTAL_CONNECTIONS: 24 -- CONNECTED_TIME: 16 -- CPU_TIME: 0 -- TABLE_ROW_READS: 1454 -- SELECT_COMMANDS: 219 -- UPDATE_COMMANDS: -- BUSY_TIME: 0 -- BYTES_SENT: 2264029 -- BYTES_RECEIVED: 108611 -- WAIT_TIME (IO): 0
DB_USER: arty7221_wrdp26 -- TOTAL_CONNECTIONS: 4 -- CONNECTED_TIME: 1 -- CPU_TIME: 0 -- TABLE_ROW_READS: 183 -- SELECT_COMMANDS: 34 -- UPDATE_COMMANDS: -- BUSY_TIME: 0 -- BYTES_SENT: 318042 -- BYTES_RECEIVED: 11438 -- WAIT_TIME (IO): 0
DB_USER: arty7221_wrdp8 -- TOTAL_CONNECTIONS: 1 -- CONNECTED_TIME: 0 -- CPU_TIME: 0 -- TABLE_ROW_READS: 42 -- SELECT_COMMANDS: 10 -- UPDATE_COMMANDS: -- BUSY_TIME: 0 -- BYTES_SENT: 136593 -- BYTES_RECEIVED: 3453 -- WAIT_TIME (IO): 0
DB_USER: arty7221_wrdp3 -- TOTAL_CONNECTIONS: 1 -- CONNECTED_TIME: 1 -- CPU_TIME: 0 -- TABLE_ROW_READS: 43 -- SELECT_COMMANDS: 12 -- UPDATE_COMMANDS: -- BUSY_TIME: 0 -- BYTES_SENT: 81681 -- BYTES_RECEIVED: 4030 -- WAIT_TIME (IO): 0
DB_USER: arty7221_wrdp2 -- TOTAL_CONNECTIONS: 3 -- CONNECTED_TIME: 3 -- CPU_TIME: 0 -- TABLE_ROW_READS: 351 -- SELECT_COMMANDS: 37 -- UPDATE_COMMANDS: -- BUSY_TIME: 0 -- BYTES_SENT: 213664 -- BYTES_RECEIVED: 10999 -- WAIT_TIME (IO): 0
DB_USER: arty7221_wrdp18 -- TOTAL_CONNECTIONS: 1 -- CONNECTED_TIME: 0 -- CPU_TIME: 0 -- TABLE_ROW_READS: 19 -- SELECT_COMMANDS: 6 -- UPDATE_COMMANDS: -- BUSY_TIME: 0 -- BYTES_SENT: 96037 -- BYTES_RECEIVED: 3012 -- WAIT_TIME (IO): 0



arty7221 2086 2.6 0.3 49072 28440 ? SN 17:36 0:00 /usr/bin/php /home/arty7221/public_html/cheapbuydeal.com/index.php
arty7221 2108 3.0 0.3 49052 28372 ? SN 17:36 0:00 /usr/bin/php /home/arty7221/public_html/cheapbuydeal.com/index.php
arty7221 2173 5.5 0.3 49052 28368 ? SN 17:36 0:00 /usr/bin/php /home/arty7221/public_html/cheapbuydeal.com/index.php

Thu Feb 2 17:36:15 CST 2012
Running Processes:
arty7221 2086 2.6 0.3 49072 28440 ? SN 17:36 0:00 /usr/bin/php /home/arty7221/public_html/cheapbuydeal.com/index.php
arty7221 2108 3.0 0.3 49052 28372 ? SN 17:36 0:00 /usr/bin/php /home/arty7221/public_html/cheapbuydeal.com/index.php
arty7221 2173 5.5 0.3 49052 28368 ? SN 17:36 0:00 /usr/bin/php /home/arty7221/public_html/cheapbuydeal.com/index.php

Running Queries:
*************************** 1. row ***************************
USER: arty7221_wrdp4
DB: arty7221_wrdp4
STATE: Locked
TIME: 4
COMMAND: Query
INFO: select count(*) as count from wp_yarpp_related_cache where reference_ID = 27697
*************************** 2. row ***************************
USER: arty7221_wrdp4
DB: arty7221_wrdp4
STATE: Locked
TIME: 10
COMMAND: Query
INFO: insert into wp_yarpp_related_cache (reference_ID,ID,score) SELECT 37533, ID, (0+ (MATCH (post_content) AGAINST ('iron cast prices soup pot lid qt compare 25 free sellers shipping bayou 03 classic buy amazon 35 black home ')) * 1+ (MATCH (post_title) AGAINST ('iron cast pot lid buy deal soup bayou 7406 qt cheap classic ')) * 1+ COUNT( DISTINCT tagtax.term_taxonomy_id ) * 1+ COUNT( DISTINCT cattax.term_taxonomy_id ) * 1) as score
from wp_posts
left JOIN wp_term_relationships AS thistag ON (thistag.object_id = 37533 )
left JOIN wp_term_relationships AS tagrel on (tagrel.term_taxonomy_id = thistag.term_taxonomy_id
AND tagrel.object_id = wp_posts.ID)
left JOIN wp_term_taxonomy AS tagtax ON ( tagrel.term_taxonomy_id = tagtax.term_taxonomy_id
AND tagtax.taxonomy = 'post_tag')
left JOIN wp_term_relationships AS thiscat ON (thiscat.object_id = 37533 )
left JOIN wp_term_relationships AS catrel on (catrel.term_taxonomy_id = thiscat.term_taxonomy_id
AND catrel.object_id = wp_posts.ID)
left JOIN wp_term_taxonomy AS cattax ON ( catrel.term_taxonomy_id = cattax.term_taxonomy_id
AND cattax.taxonomy = 'category')
where (post_status IN ( 'publish', 'static' ) and ID != '37533') and post_password ='' and post_type = 'post'
group by id
having score >= 10.00 order by score desc limit 10 on duplicate key update date = now()
*************************** 3. row ***************************
USER: arty7221_wrdp4
DB: arty7221_wrdp4
STATE: Copying to tmp table
TIME: 10
COMMAND: Query
INFO: insert into wp_yarpp_related_cache (reference_ID,ID,score) SELECT 2482, ID, (0+ (MATCH (post_content) AGAINST ('braun shaver series technology hairs stroke shave skin head hair features pulsonic capture 000 blade worlds per minute cleans brauns ')) * 1+ (MATCH (post_title) AGAINST ('shaver pulsonic 790cc series braun ')) * 1+ COUNT( DISTINCT tagtax.term_taxonomy_id ) * 1+ COUNT( DISTINCT cattax.term_taxonomy_id ) * 1) as score
from wp_posts
left JOIN wp_term_relationships AS thistag ON (thistag.object_id = 2482 )
left JOIN wp_term_relationships AS tagrel on (tagrel.term_taxonomy_id = thistag.term_taxonomy_id
AND tagrel.object_id = wp_posts.ID)
left JOIN wp_term_taxonomy AS tagtax ON ( tagrel.term_taxonomy_id = tagtax.term_taxonomy_id
AND tagtax.taxonomy = 'post_tag')
left JOIN wp_term_relationships AS thiscat ON (thiscat.object_id = 2482 )
left JOIN wp_term_relationships AS catrel on (catrel.term_taxonomy_id = thiscat.term_taxonomy_id
AND catrel.object_id = wp_posts.ID)
left JOIN wp_term_taxonomy AS cattax ON ( catrel.term_taxonomy_id = cattax.term_taxonomy_id
AND cattax.taxonomy = 'category')
where (post_status IN ( 'publish', 'static' ) and ID != '2482') and post_password ='' and post_type = 'post'
group by id
having score >= 10.00 order by score desc limit 10 on duplicate key update date = now()

Current Site Requests:
157.55.16.87 cheapbuydeal.digitalcamcordervi /cheap-price-pentax-k-x-12-4-mp-digital-slr-with-2-7-inch-l
157.55.16.87 cheapbuydeal.digitalcamcordervi /cheap-price-pentax-k-x-12-4-mp-digital-slr-with-2-7-inch-l
157.55.17.143 digitalcamcorderviews.com /cheap-price-kodak-easyshare-c182-digital-camera-blue/?lang
174.120.105.226 cheapbuydeal.digitalcamcordervi /wp-cron.php?doing_wp_cron
174.120.105.226 cheapbuydeal.digitalcamcordervi /wp-cron.php?doing_wp_cron
180.76.5.151 beautyhealthsite.digitalcamcord /cheap-price-opi/
180.76.5.154 digitalcamcorderviews.com /cheap-buy-sony-hdr-cx110-hd-handycam%C2%A8-camcorder-red-4
180.76.5.162 cheapbuydeal.digitalcamcordervi /cheap-arkon-satradio-cup-holder-buy-deal/
180.76.5.162 cheapbuydeal.digitalcamcordervi /cheap-arkon-satradio-cup-holder-buy-deal/
180.76.5.172 digitalcamcorderviews.com /cheap-buy-nikon-coolpix-l100-10mp-digital-camera-with-15x-
180.76.5.175 cheapbuydeal.digitalcamcordervi /cheap-cureceuticals-fresh-me-up-foot-odor-manuka-honey-dai
180.76.5.175 cheapbuydeal.digitalcamcordervi /cheap-cureceuticals-fresh-me-up-foot-odor-manuka-honey-dai
180.76.5.51 digitalcamcorderviews.com /cheap-buy-nikon-d50-6-1mp-digital-slr-camera-with-18-55mm-
180.76.5.52 digitalcamcorderviews.com /cheap-buy-vivitar-vivicam-v8400-8-1-mp-waterproof-digital-
180.76.5.89 digitalcamcorderviews.com /cheap-buy-nikon-coolpix-l110-digital-camera-black-12-1-meg
180.76.6.20 beautyhealthsite.digitalcamcord /cheap-paul-mitchell-tea-tree-body-bar-5-3-oz-price-deal/
180.76.6.227 digitalcamcorderviews.com /cheap-buy-nikon-d3100-digital-slr-camera-18-55mm-vr-lens-w
199.168.142.166 cheapbuydeal.digitalcamcordervi /cheap-motorola-sb6121-surfboard-docsis-3-0-cable-modem-buy
199.168.142.166 cheapbuydeal.digitalcamcordervi /cheap-motorola-sb6121-surfboard-docsis-3-0-cable-modem-buy
199.168.142.166 cheapbuydeal.digitalcamcordervi /cheap-motorola-sb6121-surfboard-docsis-3-0-cable-modem-buy
199.168.142.166 cheapbuydeal.digitalcamcordervi /cheap-motorola-sb6121-surfboard-docsis-3-0-cable-modem-buy
199.168.142.166 cheapbuydeal.digitalcamcordervi /cheap-motorola-sb6121-surfboard-docsis-3-0-cable-modem-buy
199.168.142.166 cheapbuydeal.digitalcamcordervi /cheap-motorola-sb6121-surfboard-docsis-3-0-cable-modem-buy
199.21.99.116 cheapbuydeal.digitalcamcordervi /best-price-exilim-ex-z80-8-1-mp-digital-camera-green/
199.21.99.116 cheapbuydeal.digitalcamcordervi /best-price-exilim-ex-z80-8-1-mp-digital-camera-green/
199.21.99.116 cheapbuydeal.digitalcamcordervi /cheap-aroma-ahp-303-single-hot-plate-black-buy-deal/
199.21.99.116 cheapbuydeal.digitalcamcordervi /cheap-aroma-ahp-303-single-hot-plate-black-buy-deal/
199.21.99.116 cheapbuydeal.digitalcamcordervi /cheap-bayou-classic-7406-6-qt-cast-iron-soup-pot-with-cast
199.21.99.116 cheapbuydeal.digitalcamcordervi /cheap-bayou-classic-7406-6-qt-cast-iron-soup-pot-with-cast
199.21.99.116 cheapbuydeal.digitalcamcordervi /samsung-ln37b-550/
199.21.99.116 cheapbuydeal.digitalcamcordervi /samsung-ln37b-550/
207.46.13.100 cheapbuydeal.digitalcamcordervi /cheap-proraso-eucalyptus-and-menthol-shaving-cream-2-tubes
207.46.13.100 cheapbuydeal.digitalcamcordervi /cheap-proraso-eucalyptus-and-menthol-shaving-cream-2-tubes
207.46.204.232 cheapbuydeal.digitalcamcordervi /cheap-lanolin-heel-and-foot-balm-with-manuka-honey-buy-dea
207.46.204.232 cheapbuydeal.digitalcamcordervi /cheap-lanolin-heel-and-foot-balm-with-manuka-honey-buy-dea
207.46.204.232 cheapbuydeal.digitalcamcordervi /cheap-price-ben-wa-balls/feed/
207.46.204.232 cheapbuydeal.digitalcamcordervi /cheap-price-ben-wa-balls/feed/
220.181.94.228 digitalcamcorderviews.com /canon-xl-h1a-3ccd-hdv-high-definition-professional-camcord
220.181.94.228 digitalcamcorderviews.com /canon-xl-h1a-3ccd-hdv-high-definition-professional-camcord
220.181.94.228 digitalcamcorderviews.com /cheap-buy-jvc-gr-d275us-camcorder-680-kpix-optical-zoom-25
220.181.94.228 digitalcamcorderviews.com /cheap-buy-panasonic-hdc-dx1-hi-definition-3ccd-dvd-ram-cam
220.181.94.228 digitalcamcorderviews.com /cheap-price-mustek-dv-3500-digital-camera-wdigital-video-v
41.223.116.54 cheapbuydeal.digitalcamcordervi /all-clad-5000-9-stainless-9-piece-cookware-set/
41.223.116.54 cheapbuydeal.digitalcamcordervi /all-clad-5000-9-stainless-9-piece-cookware-set/
41.223.116.54 cheapbuydeal.digitalcamcordervi /all-clad-5000-9-stainless-9-piece-cookware-set/feed/
41.223.116.54 cheapbuydeal.digitalcamcordervi /all-clad-5000-9-stainless-9-piece-cookware-set/feed/
41.223.116.54 cheapbuydeal.digitalcamcordervi /braun-series-7-790cc-pulsonic-shaver/
41.223.116.54 cheapbuydeal.digitalcamcordervi /braun-series-7-790cc-pulsonic-shaver/
41.223.116.54 cheapbuydeal.digitalcamcordervi /feed/
41.223.116.54 cheapbuydeal.digitalcamcordervi /feed/
41.223.116.54 cheapbuydeal.digitalcamcordervi /save-23-philips-norelco-7310xl-mens-shaving-system/feed/
41.223.116.54 cheapbuydeal.digitalcamcordervi /save-23-philips-norelco-7310xl-mens-shaving-system/feed/
65.52.109.153 cheapbuydeal.digitalcamcordervi /best-buy-polaroid-t1232lc-12-0-megapixel-digital-camera-gr
65.52.109.153 cheapbuydeal.digitalcamcordervi /best-buy-polaroid-t1232lc-12-0-megapixel-digital-camera-gr
66.249.71.179 bestbodycleanse.cheapbuydeal.co /mac-naked-honey-body-wash-2/
66.249.71.83 cheapbuydeal.digitalcamcordervi /cheap-qwestar-15-watt-cd-receiver-qccd390-buy-deal/
66.249.71.83 cheapbuydeal.digitalcamcordervi /cheap-qwestar-15-watt-cd-receiver-qccd390-buy-deal/
66.249.71.83 cheapbuydeal.digitalcamcordervi /cheap-remanufactured-panasonic-rc-cd350-cd-clock-radio-wit
66.249.71.83 cheapbuydeal.digitalcamcordervi /cheap-remanufactured-panasonic-rc-cd350-cd-clock-radio-wit
66.249.71.83 cheapbuydeal.digitalcamcordervi /cheap-sangean-pr-d2-amfmtv-stereo-digital-q-radio-gold-buy
66.249.71.83 cheapbuydeal.digitalcamcordervi /cheap-sangean-pr-d2-amfmtv-stereo-digital-q-radio-gold-buy
66.249.71.83 cheapbuydeal.digitalcamcordervi /cheap-schick-quattro-titanium-power-razor-1-cartridge-with
66.249.71.83 cheapbuydeal.digitalcamcordervi /cheap-schick-quattro-titanium-power-razor-1-cartridge-with
66.249.71.83 cheapbuydeal.digitalcamcordervi /cheap-shania-starlight-perfume-for-women-by-stetson-buy-de
66.249.71.83 cheapbuydeal.digitalcamcordervi /cheap-shania-starlight-perfume-for-women-by-stetson-buy-de
66.249.71.83 cheapbuydeal.digitalcamcordervi /cheap-sound-storm-laboratories-gs252-5-25-inch-2-way-speak
66.249.71.83 cheapbuydeal.digitalcamcordervi /cheap-sound-storm-laboratories-gs252-5-25-inch-2-way-speak



Cordially,

Shaun L
Linux Systems Administrator
HostGator.com LLC
http://support.hostgator.com

[prachin149]

คาดว่าใช้ cpu เกิน 25% ครับ เลยโดน block การให้บริการ
สงสัยปั่นหนักไปหน่อย

[AbuseMan]

ปัญหาที่ Plugin Relate Content นั่นแหละครับ

Query ข้อมูลซะ

insert into wp_yarpp_related_cache (reference_ID,ID,score) SELECT 2482, ID, (0+ (MATCH (post_content) AGAINST ('braun shaver series technology hairs stroke shave skin head hair features pulsonic capture 000 blade worlds per minute cleans brauns ')) * 1+ (MATCH (post_title) AGAINST ('shaver pulsonic 790cc series braun ')) * 1+ COUNT( DISTINCT tagtax.term_taxonomy_id ) * 1+ COUNT( DISTINCT cattax.term_taxonomy_id ) * 1) as score
from wp_posts
left JOIN wp_term_relationships AS thistag ON (thistag.object_id = 2482 )
left JOIN wp_term_relationships AS tagrel on (tagrel.term_taxonomy_id = thistag.term_taxonomy_id
AND tagrel.object_id = wp_posts.ID)
left JOIN wp_term_taxonomy AS tagtax ON ( tagrel.term_taxonomy_id = tagtax.term_taxonomy_id
AND tagtax.taxonomy = 'post_tag')
left JOIN wp_term_relationships AS thiscat ON (thiscat.object_id = 2482 )
left JOIN wp_term_relationships AS catrel on (catrel.term_taxonomy_id = thiscat.term_taxonomy_id
AND catrel.object_id = wp_posts.ID)
left JOIN wp_term_taxonomy AS cattax ON ( catrel.term_taxonomy_id = cattax.term_taxonomy_id
AND cattax.taxonomy = 'category')
where (post_status IN ( 'publish', 'static' ) and ID != '2482') and post_password ='' and post_type = 'post'
group by id
having score >= 10.00 order by score desc limit 10 on duplicate key update date = now()

[arty7221]

ไม่ได้ปั่นค่ะ คาดว่ามันเป็นที่โดเมนหลักตัว cheapbuydeal ตัวเดียว เพราะปัจจุบันมีถึงห้าหมื่นกว่าโพสแล้ว
ทำมาตั้งแต่ปี 2009 โพสแบบออโต้ค่ะ แต่ทยอยโพสไม่ได้ตั้งโพส
เข้า wp-admin ไม่ได้มันฟ้องให้ install.php แต่เข้า file manager จาก hostgator ได้ค่ะ
อย่างนี้ถ้าเป็นที่ pulgin relate post จริงเราปลั๊กอินนี้ออก ก็แจ้งไปที่ gator ได้เลยใช่มั้ยว่าเราแก้ไขแล้ว

มีใครมีคำแนะนำเพิ่มเติมมั้ยคะ
ขอบคุณทุกคำแนะนำเลยค่ะ

[personloans]

วิธีที่ดีที่สุดคือ อัพเกรดแพลนครับ

[@StarexVIP]

ลงตัวช่วยแคชบ้างหรือยังครับ

[adventures]

ลงตัวช่วยแคชบ้างหรือยังครับ

มีตัวไหนน่าใช้บ้างครับ และใช้กับ 3.3 ได้บ้างครับ ผมก็เจอปัญหาแบบนี้เหมือนกันครับ

[arty7221]

ปลั๊กอินลงไม่กี่ตัวเองค่ะ ตามนี้
akismet
all-in-one-seo
contact-form
onlywire
sitemap-gen
stats
wp-super-cache
yet-another-related-post

แต่เมื่อสักครู่ก็เพิ่งเอาปลั๊กอิน related post ออกตามที่คุณ AbuseMan แนะนำค่ะ
แล้วก็ลบพวกไฟล์ tmp พวกไฟล์ที่คิดว่าไม่จำเป็นออก เท่านี้มันจะแก้ปัญหาได้หรือเปล่าก็ไม่รู้ค่ะ
ตอนนี้ต้องทำยังไงต่อคะ
เมื่อกี้ live chat ก็ดูเหมือนว่าจะติดต่อไม่ได้ ส่วน support ก็เข้าไปแต่ไม่เห็นมีเมล์แจ้ง ticket กลับมาเลย
เหลือแต่ส่งเมล์ไปแจ้งเค้าว่าแก้ไขแล้ว แต่เขียนเมล์ eng ไม่เป็น มีใครพอจะช่วยได้บ้างไหมคะ

ส่วนอัพเกรดแพลน ทาง gator เค้าก็แนะนำให้ใช้ didecate server
แต่ส่วนตัวคิดว่าคงยังไม่จำเป็นถึงขนาดนั้นค่ะ เพราะไม่ได้ปั่นซับ ปั่นเว็บ ทำอยู่ไม่กี่เว็บ แต่มีปัญหาเกิดจากเว็บหลักเว็บเดียว
ที่มีโพสมากถึงห้าหมื่นกว่าโพส (เคยใช้ stat press มันโหลดมากเลย เปลี่ยน stat ก็ดีขึ้นนิ๊ดนึง)
แล้วรายได้เดือน ๆ นึงก็ไม่เคยถึง $30 เลย คงไม่คุ้มอ่ะค่ะ

มีใครพอจะช่วยเขียนเมล์ eng แจ้งกลับไปว่าเราแก้ไขแล้วได้มั้ยคะ
แต่อยากได้คนฟันธงปัญหาที่แท้จริงอ่ะค่ะ เผื่อว่าเดี๋ยวกลับไปใช้เว็บได้ แต่สักพักก็จะมีปัญหาอีก

ขอบคุณสำหรับทุกคำแนะนำ และที่เพิ่มเติมด้วยค่ะ