Author - Istvan Podor

Keep your MySQL backend online no matter what + TGIF Contest!

On Oct. 25th I will be presenting my conference session “Keep your MySQL backend online no matter what” at the Percona Live London Conference. Considering their is a variety of highly knowledgeable MySQL experts speaking at this event I wanted to give my talk a special plug so you won’t miss THIS knowledgeable MySQL […]

Read more

When the subselect runs faster

A few weeks ago, we had a query optimization request from one of our customer.
The query was very simple like:

Shell

SELECT * FROM `table` WHERE (col1=’A’||col1=’B’) ORDER BY id DESC LIMIT 20 OFFSET 0

1

SELECT * FROM `table` WHERE (col1=’A’||col1=’B’) ORDER BY id DESC LIMIT 20 OFFSET 0

This column in the table is looks like this:

Shell

`col1` […]

Read more