EmergencyEMERGENCY? Get 24/7 Help Now!

MySQL Performance Forums

 | August 10, 2006 |  Posted In: Events and Announcements

I’m happy to announce availability of MySQL Performance Forums on MySQL Performance Blog. This forum is created as free alternative to MySQL Consulting Services which we provide. If you would like to get some free help to your performance issues please use forums so everyone else could benefit from our replies. You also should get […]

Read More

Cache Performance Comparison

 | August 9, 2006 |  Posted In: Insight for Developers

Jay Pipes continues cache experiements and has compared performance of MySQL Query Cache and File Cache. Jay uses Apache Benchmark to compare full full stack, cached or not which is realistic but could draw missleading picture as contribution of different components may be different depending on your unique applications. For example for application containing a […]

Read More

Caching techinques

 | August 8, 2006 |  Posted In: Insight for Developers

Recently Jay Pipes published great article about lazy connecting and caching which reminded me my post on this matter is well overdue. Let me start with couple of comments about Jays article. First – caching in files should be used with caution. It may be very efficient especially if number of cached objects is small […]

Read More

Innodb Double Write

 | August 4, 2006 |  Posted In: Insight for DBAs

One of very interesting techniques Innodb uses is technique called “doublewrite” It means Innodb will write data twice when it performs table space writes – writes to log files are done only once. So why doublewrite is needed ? It is needed to archive data safety in case of partial page writes. Innodb does not […]

Read More

MySQL Prepared Statements

 | August 2, 2006 |  Posted In: Benchmarks, Insight for Developers

If you care about archiving best performance in your application using MySQL you should learn about prepared statements. These do not neccesary provide performance beneft but they may, they also have other benefits. As a quick introduction – before MySQL 4.1 there were only textual statements and textual protocol for data transfer – query was […]

Read More