|
|
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: 412 Location: A'dam/Diemen, The Netherlands
|
Posted: Tue Oct 27, 2009 8:13 am Post subject: [wordpress] How to break WP ( and how I did it ) |
|
|
Ow yes ! It can be done
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 |
|
 |
Google adsense Advertisement
|
Posted: 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
|
Posted: Tue Oct 27, 2009 8:13 am Post subject: [wordpress] How to break WP ( and how I did it ) |
|
|
Advertisement
 |
|
Back to top |
|
 |
|
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
|
|
|
|