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

InnoDB

In MySQL 8, InnoDB is the default storage engine broadly used out of all other available storage engines. InnoDB was released with MySQL 5.1 as a plugin in 2008 and this is considered as default storage engine from the version 5.5 and later. InnoDB has been taken over by Oracle Corporation in October 2005, from the Innobase Oy, which is a Finland-based company.

InnoDB tables support ACID-compliant commits, rollback, and crash recovery capabilities to protect user data. It also supports row-level locking, which helps with better concurrency and performance. InnoDB stores data in clustered indexes to reduce I/O operations for the all SQL select queries based on the primary key. InnoDB also supports FOREIGN KEY constraints that allows better data integrity for the database. The maximum size of an InnoDB table can scale up to 256 TB, which should be good enough to serve many big data use cases.

主站蜘蛛池模板: 景宁| 平罗县| 涟水县| 芒康县| 如皋市| 上虞市| 天长市| 德州市| 名山县| 商洛市| 溆浦县| 通许县| 普宁市| 惠州市| 信阳市| 旺苍县| 虎林市| 利川市| 山阴县| 梅州市| 通海县| 舞钢市| 景洪市| 台东县| 新绛县| 临沂市| 夹江县| 西华县| 友谊县| 密山市| 唐海县| 军事| 虎林市| 万全县| 伊春市| 乌恰县| 将乐县| 界首市| 静海县| 屯门区| 甘德县|