- 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.
- UI設計基礎培訓教程
- 從零開始構建企業級RAG系統
- Java編程技術與項目實戰(第2版)
- AppInventor實踐教程:Android智能應用開發前傳
- ASP.NET Core 2 Fundamentals
- Procedural Content Generation for C++ Game Development
- SciPy Recipes
- Node.js從入門到精通
- 物聯網系統架構設計與邊緣計算(原書第2版)
- 軟件測試分析與實踐
- 讓Python遇上Office:從編程入門到自動化辦公實踐
- Learning Zimbra Server Essentials
- 深度學習的數學:使用Python語言
- jQuery權威指南
- 微信小程序開發圖解案例教程:附精講視頻(第3版)