22 pointsStarting to get into this DEV thingI'm new here
uncobeth
Member
—
18th February 2009 (3 years ago)
Hi -
I have one user whose posts are crashing mySQL. This is happening on a shared hosting environment, and MySQL stops working for every other site as well. I have also noticed that when people read some posts or comment on some of her posts, MySQL crashes too! It doesn't exactly crash. The processes are running, but nobody can use it. I have to kill MySQL and start it back up again.
When I look in the mysql logs, it's always her editing or posting just before the trouble begins!
I have one user whose posts are crashing mySQL. This is happening on a shared hosting environment, and MySQL stops working for every other site as well. I have also noticed that when people read some posts or comment on some of her posts, MySQL crashes too! It doesn't exactly crash. The processes are running, but nobody can use it. I have to kill MySQL and start it back up again.
When I look in the mysql logs, it's always her editing or posting just before the trouble begins!
6593 pointsLike some sort of WPMU DEV GodExceptionally helpfulLifetime member
Keeper of the Dark Chocolate
—
18th February 2009 (3 years ago)
#
Five bucks says the content is a copy and paste out of Word and Word has added in hundreds of unnecessary lines that are nothing but opening and closing span font tags.
You can't provide a link to the post, can you? Gotta admit that I'm curious as well.
Is she writing a lot of pages or editing them a lot? We recently discovered an issue where as many as 11 rewrite rules are added to pages with attachments. This adds far to much overhead on some setups (or, well, at all) and can easily run up MySQL.
You may also want to tweak your revisions. If shes a heavy editor, that'll do it, or if she uses a lot of custom fields.
Yes, pasting from Word does all kinds of fun stuff, but it mostly messes up the layout - not drive the server nuts. I;ve got a setup where I have a lot of Word-pasters. :D
only partially related, but as you mentioned revisions I jsut wodnered if these codes inside wp-config.php can be applied to wpmu too? I know they work with wp.
Responses (6)
Erstwhile founder — 18th February 2009 (3 years ago) #
Hiya,
What sort of content is she using in her posts? That would be the first thing to check.
Thanks,
Andrew
Keeper of the Dark Chocolate — 18th February 2009 (3 years ago) #
Five bucks says the content is a copy and paste out of Word and Word has added in hundreds of unnecessary lines that are nothing but opening and closing span font tags.
You can't provide a link to the post, can you? Gotta admit that I'm curious as well.
— 18th February 2009 (3 years ago) #
Is she writing a lot of pages or editing them a lot? We recently discovered an issue where as many as 11 rewrite rules are added to pages with attachments. This adds far to much overhead on some setups (or, well, at all) and can easily run up MySQL.
You may also want to tweak your revisions. If shes a heavy editor, that'll do it, or if she uses a lot of custom fields.
Yes, pasting from Word does all kinds of fun stuff, but it mostly messes up the layout - not drive the server nuts. I;ve got a setup where I have a lot of Word-pasters. :D
Member — 18th February 2009 (3 years ago) #
Yes, as a matter of fact, her posts are all done in Word first. Then she copies and pastes. I've asked her not to do that from now on.
It's http://margaret.healthblogs.org/
I'm looking at the log from when it crashed again a few minutes ago, and there were other queries being run this time. Nothing to do with her blog
I wonder if MySQL just needs to be tuned (and I'm SO not someone who could do that)?
Here's some server info:
CPU0: Intel(R) Pentium(R) 4 CPU 2.40GHz stepping 09
CPU1: Intel(R) Pentium(R) 4 CPU 2.40GHz stepping 09
free
total used free shared buffers cached
Mem: 3895232 1756972 2138260 0 210284 1264116
-/+ buffers/cache: 282572 3612660
Swap: 524280 0 524280
15% of a 300 gig drive in use.
Member — 19th February 2009 (3 years ago) #
@andrea:
only partially related, but as you mentioned revisions I jsut wodnered if these codes inside wp-config.php can be applied to wpmu too? I know they work with wp.
— 19th February 2009 (3 years ago) #
Yes, they are essential on larger MU setups, IMNSHO.
See post here - http://wpmututorials.com/how-to/managing-autosavepost-revisions/
Become a member