Tag - MyISAM

InnoDB Full-text Search in MySQL 5.6 (part 1)

I’ve never been a very big fan of MyISAM; I would argue that in most situations, any possible advantages to using MyISAM are far outweighed by the potential disadvantages and the strengths of InnoDB. However, up until MySQL 5.6, MyISAM was the only storage engine with support for full-text search (FTS). And I’ve encountered […]

Read more

FictionPress Selects TokuDB for Consistent Performance and Fast Disaster Recovery

FictionPress
Issues addressed:

Support complex and efficient indexes at 100+ million rows.
Predicable and consistent performance regardless of data size growth.
Fast recovery.

Ensuring Predictable Performance at Scale
The Company:  FictionPress operates both FictionPress.com and FanFiction.net and is home to over 6 million works of fiction, with millions of writers/readers participating from around the world in over 30 languages
The Challenge: […]

Read more

First Sphinx Conference is Announced

The First ever Sphinx Users Conference is announced to take place in Moscow, Russia on October 24th,
which is the Sunday before Highload.ru conference, so if you’re attending that you may just drop by to this event too.
this is going to be free technically focused event, close in spirit to Percona Performance Conference, we organized […]

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