Insight for DBAs

MySQL: What read_buffer_size Value is Optimal?

MySQL

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 more

InnoDB in self-compiled MySQL 5.1

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

Shell

./configure –prefix=/dir/to/mysql
make
make install

123

./configure –prefix=/dir/to/mysqlmakemake install

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

Shell

mysql testdatabase < dump.sql

1

mysql testdatabase < dump.sql

I […]

Read more

Guess what?! Microsecond slow query timing finally available in MySQL!

Vadim asked me yesterday to update Microslow patch for 5.1.21, because the previous one I wrote for 5.1.20 failed to apply correctly on the new MySQL release. Imagine the expression on my face after I unpacked the sources and found out that MySQL incorporated the patch to their release. So it’s a built-in feature […]

Read more