How to Use JSON in MySQL Wrong

Tuesday 1:20PM-2:10PM

@ Room E


50 minutes conference


Business / Case Studies, Operations

The JSON data type and functions that support it comprise one of the most interesting features introduced in MySQL 5.7 for application developers. But no feature is a "Golden Hammer." We need to apply a little expertise to get the best result, and avoid misusing it. I'll show practical examples that work well with JSON, and other scenarios where conventional columns perform better.

Questions addressed in this presentation:
- How much space does JSON data use, compared to conventional data?
- What is the performance of querying JSON vs. conventional data?
- How do I create indexes for JSON data?
- What kind of data is best to store in JSON?
- How do I get the best of both worlds?


Bill Karwin

Bill Karwin (Square)

Database Developer


Bill Karwin has many years of experience as a database developer, consultant, and trainer. He published the popular book "SQL Antipatterns: Avoiding the Pitfalls of Database Programming." Throughout his career, Bill has shared his knowledge to help other programmers achieve success and productivity. Bill has answered thousands of questions, giving him a unique perspective on SQL mistakes that most commonly cause problems.


  Download Slides  

Connect with Percona

Stay Connected on:

Percona Live Conferences

The Percona Live Open Source Database Conferences are the premier event for the diverse and active open source database community, as well as businesses that develop and use open source database software.

Contact Us

For general information about the event/expo/conference, including registration, please contact us at:

  • info(@)
  • +1-888-401-3401
  • +1-919-948-2863