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

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.

主站蜘蛛池模板: 阿鲁科尔沁旗| 泰兴市| 博乐市| 福海县| 普陀区| 舟曲县| 河津市| 攀枝花市| 六盘水市| 桃源县| 甘洛县| 郸城县| 黑河市| 东山县| 那坡县| 德兴市| 东阳市| 兴山县| 当雄县| 汉中市| 铁岭县| 丽水市| 垫江县| 永顺县| 民乐县| 台湾省| 南康市| 遂溪县| 喜德县| 洪江市| 溆浦县| 英山县| 高要市| 建瓯市| 策勒县| 班戈县| 云南省| 淅川县| 霍邱县| 枣强县| 永靖县|