» Boost MySQL Performance by 1200%

Sorry folks, this article was based on flawed benchmark results, I will soon post an update!

Please goto:

 

You probably shouldn't follow me


Like this Article?

I'd appreciate it if you leave a comment, spread the word, or consider a small donation


Related

Articles like this one

» Improve MySQL Insert Performance
» Convert all Tables to InnoDB
» Enhance PHP session management
» Survive heavy traffic with your webserver
» Create short IDs with PHP - Like Youtube or TinyURL

tags: mysql, performance, php, database, transactions, bulk, innodb, benchmark
category: Howto - MySQL
read: 6,436 times

Add comment

(required, shown)(required, not shown)for syntax highlighting

[CODE="Javascript"]
your_code_here();
[/CODE]

Replace "Javascript"
with "php", "text", etc.code (to make sure you are not a spammer)

 Track replies: rss feed comments feed

Comments

#4. Mohammad Shiblee on 29 January 2011

Gravatar.com: Mohammad ShibleeHi,
How can improve update performance in mysql.
Actually in my mysql-table there are approx 100000 records and i want to update all the records at once.

#3. Kevin on 03 April 2009

Twitter.com: kvz@ Thijs & feedreader: Lucky me. I was able to mess up my bench results only to find an even faster method :)
http://kevin.vanzonneveld.net/techblog/article/improve_mysql_insert_performance/

2100% instead of 1200% ;)

#2. Thijs on 31 March 2009

Gravatar.com: ThijsThanks alot! This was very helpfull and helped me to clean alot of my code!

#1. feedreader on 31 March 2009

Gravatar.com: feedreaderVery interesting. I wish I had read this 3 months ago :(