- MariaDB Cookbook
- Daniel Bartholomew
- 352字
- 2021-07-16 12:19:25
Migrating a table from MyISAM to Aria
MariaDB ships with the MyISAM and Aria storage engines, among many others. The main difference between these two is that Aria is crash safe, whereas MyISAM is not. Being crash safe means that an Aria table can recover from catastrophic power loss or other unexpected failures in a much better way than a MyISAM table can. If we use MyISAM tables, an easy upgrade is to convert them to Aria tables.
Getting ready
Import the ISFDB database as described in the Importing the data exported by mysqldump recipe in this chapter.
How to do it...
- Open the
mysqlcommand-line client and connect to theisfdbdatabase. - Run the following command line:
ALTER TABLE authors ENGINE=Aria; - The
ALTERcommand will then change the table so that it uses the Aria storage engine. - After it has finished, a message similar to the following will be displayed:
Query OK, 110829 rows affected (3.14 sec) Records: 110829 Duplicates: 0 Warnings: 0
- If our system is older or is under heavy load and it takes longer than 5 seconds for
ALTER TABLEto complete, we'll see a progress message letting us know how much of the task has been completed, updated every 5 seconds, until the task is finished.
How it works...
The ALTER TABLE command changes a table in two stages. First, it creates a new table identical in every way to the old table, except that the new table has the changes specified by the command. In our case, the only change is to use the Aria storage engine instead of the MyISAM storage engine. Then, the command copies all of the data to the new table.
In the second stage, ALTER TABLE removes the old table and renames the new table with the name of the old table.
On a table like authors that only has around a hundred thousand rows, the conversion is quick and easy; however, on a table with several billion rows, the conversion process will take significantly longer.
See also
- The full documentation of the
ALTER TABLEcommand can be found at https://kb.askmonty.org/en/alter-table/
- 基于粒計算模型的圖像處理
- 體驗設計原理：行為、情感和細節
- OpenCV 3和Qt5計算機視覺應用開發
- Building a Recommendation Engine with Scala
- Visual C
- Hands-On RESTful Web Services with Go
- 軟件工程
- Swift語言實戰精講
- 小程序，巧應用：微信小程序開發實戰（第2版）
- Python機器學習算法與應用
- 零基礎學Python編程（少兒趣味版）
- Learning Nessus for Penetration Testing
- jQuery for Designers Beginner's Guide Second Edition
- Android Studio開發實戰：從零基礎到App上線 （移動開發叢書）
- C#程序設計基礎入門教程