Web Development

MySQL Internal Temporary Tables & Text, Blob, and JSON Field Types

A Quick Note:

Fields of type Text, Blob, and JSON prevent database engine from creating Internal Temporary Tables in memory ( a technique used to do lengthy operations on tables such as unions and views ). Instead, when these fields are used, the database engine creates Internal Temporary Tables on disk which is slower.

References:

  • 9.4.4 Internal Temporary Table Use in MySQL
  • Native JSON support in mysql 5.7 !!! what is the pros and cons of json data type in mysql?
  • Advertisements

    Leave a Reply

    Fill in your details below or click an icon to log in:

    WordPress.com Logo

    You are commenting using your WordPress.com account. Log Out / Change )

    Twitter picture

    You are commenting using your Twitter account. Log Out / Change )

    Facebook photo

    You are commenting using your Facebook account. Log Out / Change )

    Google+ photo

    You are commenting using your Google+ account. Log Out / Change )

    Connecting to %s