Search code examples
mysqlstoragequotamysql-json

How much can a MySQL 5.7 JSON datatype can hold

How much value / size can a MySQL 5.7 JSON datatype hold?

What are the limitations of the MySQL 5.7 JSON datatype?

Solution

  • The maximum size is 1GB per document, but the practical size should be about the same as (or within an order of magnitude of) what a typical row looks like.

    The JSON datatype still uses row level locking, and thus it is probably good to keep documents to around the 1-2MB size or less.