EmergencyEMERGENCY? Get 24/7 Help Now!

Speedup your LAMP stack with LigHTTPD

 | May 21, 2006 |  Posted In: Insight for Developers

Apache Web server could frequently be bottleneck for your LAMP stack, or you might be wasting resources on your web servers. The problem with Apache server comes from “client per process” architecture which you have to stick to at least for dynamic content served by PHP or ModPerl. With “client per process” you end up […]

Read More

MySQL Server Memory Usage

 | May 17, 2006 |  Posted In: Insight for DBAs

Every so often people ask me the question how should they estimate memory consumption by MySQL Server in given configuration. What is the formula they could use. The reasons to worry about memory usage are quite understandable. If you configure MySQL Server so it uses too small amount of memory it will likey perform suboptimally. […]

Read More

To pack or not to pack – MyISAM Key compression

 | May 13, 2006 |  Posted In: Insight for DBAs

MyISAM storage engine has key compression which makes its indexes much smaller, allowing better fit in caches and so improving performance dramatically. Actually packed indexes not a bit longer rows is frequent reason of MyISAM performing better than Innodb. In this article I’ll get in a bit more details about packed keys and performance implications […]

Read More

Innodb Fuzzy checkpointing woes

 | May 10, 2006 |  Posted In: Insight for DBAs

As you might know Innodb storage engines uses Fuzzy Checkpointing technique as part of it recovery strategy.  It is very nice approach which means database never needs to “stall” to perform total modified pages flush but instead flushing of dirty pages happens gradually in small chunks so database load is very even. This works great […]

Read More

Descending indexing and loose index scan

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

Comments to my previous posts, especially this one by Gokhan inspired me to write a bit about descending indexes and about loose index scan, or what Gokhan calls “better range” support. None of these are actially related to Innodb tables in general – these are features MySQL should get for all storage engines at some […]

Read More

My Innodb Feature wishes

 | May 4, 2006 |  Posted In: Insight for Developers

At Users Conference Heikki did good presentation about Innodb planned features. I did not see some of big and tiny wishes listed so I was making notes. Here is what I’d like to see Packed indexes. In many cases then difference in Performace with MyISAM and Innodb is huge for read only workload it is […]

Read More

Group commit and real fsync

 | May 3, 2006 |  Posted In: Insight for DBAs

During the recent months I’ve seen few cases of customers upgrading to MySQL 5.0 and having serious performance slow downs, up to 10 times in certain cases. What was the most surprising for them is the problem was hardware and even OS specific – it could show up with one OS version but not in […]

Read More

Site goes lives

 | May 3, 2006 |  Posted In: Events and Announcements

Numerous talks at MySQL Users Conference and a lot of people asking me for my presentations motivated me to speed up launching of this site. I hope it will also motivate me to blog more frequently about performance as blog name implies. If you’re looking for presentations they are here. All of mine presentations which […]

Read More