EmergencyEMERGENCY? Get 24/7 Help Now!

Correct Index Choices for Equality + LIKE Query Optimization

 | April 11, 2017 |  Posted In: Insight for DBAs, MySQL

Query Optimization

As part of our support services, we do a lot of query optimization. This is where most performance gains come from. Here’s an example of the work we do. Some days ago a customer arrived with the following table:

And a query that looked like this:

The table had an index t_msg that wasn’t […]

Read More

Thoughts on MySQL 8.0 Invisible Indexes

 | October 27, 2016 |  Posted In: MySQL

Invisible Indexes

MySQL 8.0 has a new feature called “invisible indexes,” which allow you to quickly enable/disable indexes from being used by the MySQL Optimizer. I wanted to share some of my first experiences and thoughts about this new feature. Why is it good for us? There are a couple of use cases. One of them is if you want to […]

Read More

Advanced JSON to MySQL indexing

 | March 10, 2015 |  Posted In: MySQL

This post will discuss some excellent methods of getting JSON to MySQL indexing to work smoothly. What is JSON JSON is an text based, human readable format for transmitting data between systems, for serializing objects and for storing document store data for documents that have different attributes/schema for each document. Popular document store databases use […]

Read More

The small improvements of MySQL 5.6: Duplicate Index Detection

 | May 31, 2013 |  Posted In: Insight for DBAs, MySQL, Percona Toolkit

Here at the MySQL Performance Blog, we’ve been discussing the several new features that MySQL 5.6 brought: GTID-based replication, InnoDB Fulltext, Memcached integration, a more complete performance schema, online DDL and several other InnoDB and query optimizer improvements. However, I plan to focus on a series of posts on the small but handy improvements – […]

Read More