官术网_书友最值得收藏!

  • MySQL 8 for Big Data
  • Shabbir Challawala Jaydip Lakhatariya Chintan Mehta Kandarp Patel
  • 165字
  • 2021-08-20 10:06:04

Transactional data dictionary

Up until the previous version, the MySQL data dictionary was stored in different metadata files and non-transactional tables, but from this version, it will have a transactional data dictionary to store the information about the database. No more .frm, .trg, or .par files. All information will be stored in the database, which removes the cost of performing heavy file operations. There were numerous issues with filesystem metadata storage like the vulnerability of the filesystem, exorbitant file operations, difficult to handle crash recovery failures, or replication; it was also difficult to add new feature-related metadata. Now this upgrade has made it simple by storing information in a centralized manner, and will have improved performance as this data dictionary object can be cached in memory, similar to other database objects.

This data dictionary will have data that is needed for SQL query execution such as catalog information, character sets, collations, column types, indexes, database information, tables, store procedures, functions and triggers, and so on.

主站蜘蛛池模板: 郧西县| 泌阳县| 光山县| 宝鸡市| 禹城市| 延吉市| 抚远县| 正阳县| 汶川县| 浠水县| 辽阳市| 东丰县| 梅州市| 洛南县| 西充县| 和平区| 比如县| 平潭县| 林州市| 张家港市| 淮阳县| 胶州市| 视频| 汉川市| 景洪市| 锦屏县| 台南县| 额尔古纳市| 富平县| 稻城县| 乾安县| 轮台县| 罗定市| 额尔古纳市| 大名县| 开阳县| 洮南市| 巩义市| 冀州市| 广州市| 南昌县|