Monthly Archives - August 2006

MySQL wins C’T Database Contest

Today MySQL published the press release with results of Database Contest (results on German available here http://www.mysql.de/ct-dbcontest).
Peter and me spent quite some time working on this project while being employed by MySQL and it is great to see results finally publicly available.
The story began about year ago when C’T magazine had called for Database […]

Read more

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