AndyII
Verified User
- Joined
- Oct 3, 2006
- Messages
- 576
a while ago I was having issues with high server loads, well at the end I discover that WordPress and or the plug-ins that go with it can cause the server to choke, I have done much research on the WP troubles and there are many, but in particular I see a plug-in called autoblogg (there are a few types of these out there),
what happens if a site is doing a "remove Duplicate" action, it will cause a heavy load on mysql and then Apache as well, if more than one fire off well the trouble compounds. I have the load monitor script watching the server load and I know its a "band-aid" fix but it will restart Apache, which in turns kills the mysql connections, most of the time it will hold its own and recover the server, I dont really like using this tactic but untill I can resolve the WP troubles, it will have to do.
I know what you wil say, "KICK OFF WordPress" but I have a good paying customer with probably 20 WP sites so I want to find a better answer, none of the Cache plug-ins work, I even tweaked my.cfg to better handle the requests from the DA knowledge base and also some tips from the author of WP.
Made the site owner hire a programmer to look at getting them under control, so far he hasnt come up with any resolution and perhaps the client needs to hire a WP guru instead.
just fo ha ha's I will add the database query so you can see what is going on, now this may not be the culprit, just the result of something else.
This trouble is world wide and if someone could find a resolve to the WP dilemma, it may be profitable.
By the author's own admission, WP is a coding nightmare, more time was put into the looks section and the admin area. (not a direct quote)
What am I asking? well 1st is just a possible "headsup" for server owners, your not being DDOS'ed just some scripting trouble,
then perhaps someone here has some tips, pointers experience on how to leash the WP problems. Don't want to "Ban" WP from the servers, it is a well known, widely used Blog script and there are hundreds of nice plug-ins available to use, most are free.
Here is the DB action that is causing the trouble (I think), the longer this hangs, the worse the load.
(This "taxonomy" is an integral part of WP, I believe )
what happens if a site is doing a "remove Duplicate" action, it will cause a heavy load on mysql and then Apache as well, if more than one fire off well the trouble compounds. I have the load monitor script watching the server load and I know its a "band-aid" fix but it will restart Apache, which in turns kills the mysql connections, most of the time it will hold its own and recover the server, I dont really like using this tactic but untill I can resolve the WP troubles, it will have to do.
I know what you wil say, "KICK OFF WordPress" but I have a good paying customer with probably 20 WP sites so I want to find a better answer, none of the Cache plug-ins work, I even tweaked my.cfg to better handle the requests from the DA knowledge base and also some tips from the author of WP.
Made the site owner hire a programmer to look at getting them under control, so far he hasnt come up with any resolution and perhaps the client needs to hire a WP guru instead.
just fo ha ha's I will add the database query so you can see what is going on, now this may not be the culprit, just the result of something else.
This trouble is world wide and if someone could find a resolve to the WP dilemma, it may be profitable.
By the author's own admission, WP is a coding nightmare, more time was put into the looks section and the admin area. (not a direct quote)
What am I asking? well 1st is just a possible "headsup" for server owners, your not being DDOS'ed just some scripting trouble,
then perhaps someone here has some tips, pointers experience on how to leash the WP problems. Don't want to "Ban" WP from the servers, it is a well known, widely used Blog script and there are hundreds of nice plug-ins available to use, most are free.
Here is the DB action that is causing the trouble (I think), the longer this hangs, the worse the load.
(This "taxonomy" is an integral part of WP, I believe )
Code:
Removing duplicates SELECT DISTINCT p.ID, p.post_title, p.post_date, p.comment_count, count( t_r.object_id ) AS cnt
FROM wp_term_taxonomy t_t, wp_term_relationships t_r, wp_posts p
WHERE t_t.taxonomy = 'post_tag'
AND t_t.term_taxonomy_id = t_r.term_taxonomy_id
AND t_r.object_id = p.ID
AND (
t_t.term_id
IN (
'28940', '409', '11136', '2471', '16584', '11027', '11192', '28939', '28938', '2034', ''
)
)
AND p.ID !=52880
AND p.post_status = 'publish'
AND p.post_date_gmt < '2009-12-28 02:05:14'
GROUP BY t_r.object_id
ORDER BY cnt DESC , p.post_date_gmt DESC
LIMIT 10