June 19, 2013

Post: A workaround for the performance problems of TEMPTABLE views

EXPLAIN EXTENDED to see that MySQL rewrites the view query to include the restriction: mysql> explain extended… | key_len | ref | rows | filtered | Extra | +—-+————-+——-+——+—————+——+———+——-+——+———-+————————–+ | 1 | SIMPLE | t2 | ref…

Post: Sphinx search performance optimization: attribute-based filters

… find our customers face is misuse of search filters. In this article I will cover how Sphinx … are always indexed and using the very powerful extended query syntax you can do search against certain …, it maybe a little confusing, but let me explain. Query returned 20 rows because unless you specify …

Post: ORDER BY ... LIMIT Performance Optimization

…few rows, even if some extra filtering takes place so you need … solution for this problem is ether extending your indexes so MySQL Optimizer … if it is quite fast: mysql> explain select * from test order by k limit 5; …