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

首頁 >

MariaDB Cookbook

Switching between InnoDB and XtraDB

By default, MariaDB uses the XtraDB storage engine in place of InnoDB because it contains improvements to InnoDB that are useful for all users. If we want to use the InnoDB storage engine for some reason, it is easy to do so.

How to do it...

Let's get started by following the ensuing steps:

  1. Stop MariaDB by following the directions in the recipe we followed when installing MariaDB.
  2. Open our my.cnf or my.ini file in a text editor such as Vim, Emacs, TextWrangler, or Notepad. On Windows, there is a helpful link under the MariaDB group that will automatically open the my.ini file in Notepad. On Linux, the my.cnf file is located at either /etc/mysql/my.cnf or /etc/my.cnf depending on the Linux distribution we are using.
  3. Add the following lines of code to the [mysqld] section of the system's my.cnf or my.ini file. If the section does not exist, add it. 
    ignore_builtin_innodb
plugin_load=innodb=ha_innodb.so
  4. Save the file and then start MariaDB by following the instructions in the recipe we followed when installing MariaDB.

How it works...

To check if we are using InnoDB or XtraDB, we use the SHOW ENGINES command. If we are using XtraDB, the InnoDB line of the output will begin as shown in the following command line:

| InnoDB | DEFAULT | Percona-XtraDB,Supports...

And, if we are using the InnoDB plugin, the InnoDB line will begin as shown in the following command line:

| InnoDB | DEFAULT | Supports...

Only one of the storage engines can be loaded at one time. It is not possible to have both the InnoDB and XtraDB plugins loaded at the same time.

See also

  • Refer to another InnoDB- and XtraDB-specific recipe, Using extended keys with InnoDB and XtraDB, in Chapter 3, Optimizing and Tuning MariaDB
  • The InnoDB and XtraDB section of the MariaDB Knowledgebase has lots of great information on these storage engines, which is available at https://mariadb.com/kb/en/xtradb-and-innodb/
主站蜘蛛池模板： 龙口市| 新蔡县| 札达县| 郑州市| 镇江市| 青浦区| 城市| 芒康县| 雷州市| 通渭县| 崇左市| 平度市| 基隆市| 贵州省| 唐河县| 临猗县| 正安县| 高青县| 阿克苏市| 通渭县| 凉城县| 大荔县| 新疆| 兴安盟| 阿鲁科尔沁旗| 中宁县| 佳木斯市| 阳山县| 凭祥市| 九龙坡区| 临沧市| 兰州市| 曲水县| 玛沁县| 仲巴县| 苗栗市| 丹寨县| 重庆市| 泸西县| 新巴尔虎左旗| 慈溪市|