ALTER TABLE improvements in MariaDB Server Optimized or instantaneous schema changes, including ADD/DROP COLUMN
5墨值下载
ALTER TABLE
IMPROVEMENTS IN
MARIADB SERVER
Marko Mäkelä
Lead Developer InnoDB
MariaDB Corporation
Generic ALTER TABLE in MySQL & MariaDB
CREATE…; INSERT…SELECT; RENAME…; DROP
● Starting with MySQL 5.6 & MariaDB 10.0, called ALGORITHM=COPY
● Until MySQL 8.0 & MariaDB 10.2, lots of unnecessary undo logging
○ To speed up crash recovery, there was a hack of “commit every 10,000 rows”.
● Copies data one index record at a time, unsorted
of 25
5墨值下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
评论