EmergencyEMERGENCY? Get 24/7 Help Now!

Intel Woodcrest vs AMD Opteron for MySQL

 | June 8, 2006 |  Posted In: Benchmarks

AnandTech published Intel Woodcrest preview benchmarks which have some numbers for MySQL as well. From these numbers performance looks great and it looks like finally Intel has something to respond to AMD Opterons on Server market. Now competition heats up and we’ll see what AMD will have to respond. As Opteron did not have serious […]

Read More

MySQL INSERT ON DUPLICATE KEY UPDATE and counters

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

MySQL INSERT ON DUPLICATE KEY UPDATE is very powerful but often forgotten MySQL feature. It was introduced in MySQL 4.1 but I still constantly see people unaware of it. Myself I like this feature big deal because it is designed in truly MySQL style – very efficient solution for frequent task while keeping it beautiful […]

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