MySQL Performance Forum: Hot Topics

As I already announced last week I started MySQL Performance Forums project focusing on MySQL Performance discussions as it names says.
I spend planty of time replying questions and thought it would be good idea to provide weekly overviews of most interesting topic discussed. Here is the list for last week:

Ways to perform […]

Read more

SysBench – benchmark tool

Sysbench is benchmark developed by Alexey Kopytov (software engineer @ MySQL AB)
– http://sysbench.sourceforge.net/ and I want to write a short intro about this tool as sysbench is one of software for my everyday use. For example, SUN published their Solaris vs RedHat stuff based on sysbench’s results (Peter and me provided performance consutling for […]

Read more

MySQL: Followup on UNION for query optimization, Query profiling

Few days ago I wrote an article about using UNION to implement loose index scan.
First I should mention double IN also works same way so you do not have to use the union. So changing query to:

Shell

mysql> SELECT sql_no_cache name FROM people WHERE age in(18,19,20) AND zip IN (12345,12346, 12347);
+———————————-+
| […]

Read more