- 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.
- Google Flutter Mobile Development Quick Start Guide
- 零基礎(chǔ)搭建量化投資系統(tǒng):以Python為工具
- Apache Spark 2 for Beginners
- Python應(yīng)用輕松入門
- Yocto for Raspberry Pi
- Express Web Application Development
- Create React App 2 Quick Start Guide
- AIRIOT物聯(lián)網(wǎng)平臺開發(fā)框架應(yīng)用與實(shí)戰(zhàn)
- Natural Language Processing with Java and LingPipe Cookbook
- 超簡單:Photoshop+JavaScript+Python智能修圖與圖像自動化處理
- 金融商業(yè)數(shù)據(jù)分析:基于Python和SAS
- Splunk Essentials
- Backbone.js Patterns and Best Practices
- 程序員的算法趣題2
- Access 2010數(shù)據(jù)庫教程(微課版)