Tag - index

Webinar Wednesday July 12, 2017: MongoDB Index Types – How, When and Where Should They Be Used?

MongoDB Index Types

Join Percona’s Senior Technical Services Engineer, Adamo Tonete as he presents MongoDB Index Types: How, When and Where Should They Be Used? on Wednesday, July 12, 2017 at 11:00 am PDT / 2:00 pm EDT (UTC-7).
Register Now

MongoDB has 12 index types. Do you know how each works, or when you should use each of […]

Read more

Correct Index Choices for Equality + LIKE Query Optimization

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:

Shell

CREATE TABLE `infamous_table` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`member_id` int(11) NOT NULL DEFAULT ‘0’,
[…]

Read more

Thoughts on MySQL 8.0 Invisible Indexes

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 drop an […]

Read more

Advanced JSON to MySQL indexing

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 JSON […]

Read more

‘Indexing’ JSON documents for efficient MySQL queries over JSON data

MySQL meets NoSQL with JSON UDF
I recently got back from FOSDEM, in Brussels, Belgium. While I was there I got to see a great talk by Sveta Smirnova, about her MySQL 5.7 Labs release JSON UDF functions. It is important to note that while the UDF come in a 5.7 release it is absolutely […]

Read more