MySQL Query Anti-Patterns that can be moved to Sphinx
There are some types of queries can become a bottleneck in your MySQL instance as your dataset and traffic increases. Not only full text and wildcard search, but also full table and large dataset scans and sorts. In this talk I will share hands-on experience with identifying these and moving them to an appropriate tier in the stack such as Sphinx. Advanced techniques such as sharded indexes for parallelism, and in memory scans will be discussed in detail.