Top Poster
#1 ramon fincken 400
#2 Site admin 3
#3 Ber|Art 2
#4 braddmark 1
#5 accentmedia 1
#6 Xarzu 1
#7 pEcosespedex 1
#8 khadish 1
#9 moxxx 1
#10 nistelrock 1
[wordpress] How to break WP ( and how I did it )



Rating : 4 / 5

 
Post new topic   Reply to topic    Ramonfincken.com Forum Index -> CMS-ses (Joomla, WordPress, etc..)
Beta
Want to be notified by email when this topic gets a reply?  
View previous topic :: View next topic  
Author Message
ramon fincken
Site's programmer

Get a free globally recognized avatar
It's free!


Joined: 03 Aug 2007
Posts: 400
Location: A'dam/Diemen, The Netherlands

PostPosted: Tue Oct 27, 2009 8:13 am    Post subject: [wordpress] How to break WP ( and how I did it ) Reply with quote

Ow yes ! It can be done Smile

I recently found out that there is a serious performance and Mysql limit to WordPress. Ok I admit, the chances were there yet I did not expect it to happen that fast!

The setup:
I wrote a plugin for www.basketleagues.com which reads XML info of basket matches, teams etcetera. Every team should have it's own wordpress page.
So the plugin created this new page if that page did not exist yet.

My fault: The mechanism to check if a page existed had a bug, and pages with special chars were created over and over again.


You should know that this was an optimised server for Wordpress/mysql etc..

This is what happened:
* WordPress contained at one point in time about 2500 pages.
* Frontpage loads were extreme: from +- 180 to 2500 pages in about a second to over 1minute 40
* Adding a new page triggered a mysql error, we had reached the mysql max packet size
HUH? > Well apparently when adding a new page there is 1 option value in the options table which is updated. I am not sure what is does, but it adds all pages with link to (I guess) rss/feed purposes.
The single mysql query filled my screen so much my scrollbar was about 5 millimeters in height ...


Explanation and how to prevent this:
http://ottopress.com/2010/category-in-p...d-harmful/
http://www.wptavern.com/forum/troublesh...#post14268


So ... read on!
How to break wordpress by Lorelle Vanfossen
How to code (API) a new post or page.
Back to top
View user's profile Send private message Visit poster's website
Google adsense
Advertisement





PostPosted: Tue Oct 27, 2009 8:13 am    Post subject: [wordpress] How to break WP ( and how I did it )

Advertisement
Back to top
GravityForms
Advertisement





PostPosted: Tue Oct 27, 2009 8:13 am    Post subject: [wordpress] How to break WP ( and how I did it )

Advertisement
Gravity Forms Plugin for WordPress
Back to top
Post new topic   Reply to topic    Ramonfincken.com Forum Index -> CMS-ses (Joomla, WordPress, etc..) All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
General forums
The world of freelance
Programming
Other projects
Poll
I love gifts

Yes goodies and presents! [3]
No but I love polls ! [1]

Related google ads