Tag - json

used_columns: EXPLAIN FORMAT=JSON tells when you should use covered indexes

In the “MySQL Query tuning 101” video, Alexander Rubin provides an excellent example of when to use a covered index. On slide 25, he takes the query
select name from City where CountryCode = ’USA’ and District = ’Alaska’ and population > 10000 and adds the index
cov1(CountryCode, District, population, name) on table
City. With Alex’s query […]

Read more

Upcoming Webinar: MySQL 5.7 in a Nutshell

MySQL 5.7

Join Alexander Rubin, Principal Consultant, Percona as he provides an overview of MySQL 5.7 features. Wednesday, December 9, 2015 10:00AM PST (GMT -08:00).

MySQL® 5.7 is a great release that has a lot to offer, especially in the areas of development and replication. It provides many new optimizer features for developers, a much more powerful […]

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

Frohe Festtage Von Weinhem! (Or A Music-driven Holiday Light Display for MongoDB Hackers)

Want to tweet out a personalized holiday video to your friends?  Heckenlights is a Christmas lights installation playing Christmas songs that lets viewers customize and share it.
Heckenlights was created by software developer Mark Paluch (@mp911de) who thought it was time to introduce some American-style holiday bling to his hometown of Weinheim, Germany. A year ago, […]

Read more