EmergencyEMERGENCY? Get 24/7 Help Now!

MySQL: what read_buffer_size value is optimal ?

 | September 17, 2007 |  Posted In: Benchmarks, Insight for DBAs

The more I work with MySQL Performance Optimization and Optimization for other applications the better I understand I have to less believe in common sense or common sense of documentation writers and do more benchmarks and performance research. I just recently wrote about rather surprising results with sort performance and today I’ve discovered even read_buffer_size […]

Read More

Going to MySQL Developers conference in Heidelberg

 | September 15, 2007 |  Posted In: Events and Announcements

I finally got my visa so I’m going to MySQL Developers meeting in Heidelberg, Germany next week. Hopefully it will be great source of “technical insight” information, either from organized sessions or from developers themselves. Plus I’m looking forward meeting a lot of friends our where both MySQL Developers and active community members.

Read More

InnoDB in self-compiled MySQL 5.1

 | September 13, 2007 |  Posted In: Insight for DBAs

If you like to compile MySQL from sources by yourself, for different needs, like debugging, testing etc, you probably can face this issue. What I usually do to fast compile and test is

and then, for example, load the dump of InnoDB from previous version:

I bet you will not notice all your […]

Read More

Query Profiling with MySQL: Bypassing caches

 | September 12, 2007 |  Posted In: Insight for Developers

Quite frequently I run into question like this “I’m using SQL_NO_CACHE but my query is still much faster second time I run it, why is that ? The answer to this question is simple – because SQL_NO_CACHE only bypasses query cache but it has no change on other caches, which are MySQL Caches – Innodb […]

Read More

Read Buffers, mmap, malloc and MySQL Performance

 | September 12, 2007 |  Posted In: Insight for DBAs

Monty Taylor posted interesting investigation of the fact read_buffer_size variable affects connection speed. This is not something you would expect right ? me too. Not only global user data is expected to be cached on startup but even if it is not why would you do full table scan to fetch single user information ? […]

Read More

VOIP Advice requested

 | September 10, 2007 |  Posted In: Events and Announcements

As one of my last posts about issues with hosting provider got great response and We got a lot of good advice and offers I decided to ask for advice another problem we have as we’re growing our company – organizing good phone communications. Our goals are rather simple though the fact we’re globally distributed […]

Read More

Speaking on HighLoad Conference, Moscow, Russia

 | September 3, 2007 |  Posted In: Events and Announcements

HighLoad.RU is the conference focused on Building High Performance Systems and has speakers from most of top Russian Internet companies. It is taking place in Moscow, Russia 24-25 of September and you should know a bit of Russian to attend 🙂 The conference has some international flavor though there are few people coming from other […]

Read More