如何开启mysql的innodb引擎

如何开启mysql的innodb引擎，相信很多没有经验的人对此束手无策，为此本文总结了问题出现的原因和解决方法，通过这篇文章希望你能解决这个问题。

开启mysql的innodb引擎

环境：

mysql版本 5.1.51

os：rhel 5.4 32bit

mysql安装目录为/mysql

mysql 的数据目录/mysql/data

安装之前

[root@odb1 plugin]# pwd

/mysql/lib/mysql/plugin

[root@odb1 plugin]# 

[root@odb1 plugin]# ls -l ha_innodb*

-rw-r--r-- 1 root root 6207320 Mar 26 01:04 ha_innodb.a

-rwxr-xr-x 1 root root    1005 Mar 26 01:04 ha_innodb.la

-rw-r--r-- 1 root root 7064416 Mar 26 01:04 ha_innodb_plugin.a

-rwxr-xr-x 1 root root    1054 Mar 26 01:04 ha_innodb_plugin.la

lrwxrwxrwx 1 root root      25 Mar 26 01:04 ha_innodb_plugin.so -> ha_innodb_plugin.so.0.0.0

lrwxrwxrwx 1 root root      25 Mar 26 01:04 ha_innodb_plugin.so.0 -> ha_innodb_plugin.so.0.0.0

-rwxr-xr-x 1 root root 5032879 Mar 26 01:04 ha_innodb_plugin.so.0.0.0

lrwxrwxrwx 1 root root      18 Mar 26 01:04 ha_innodb.so -> ha_innodb.so.0.0.0

lrwxrwxrwx 1 root root      18 Mar 26 01:04 ha_innodb.so.0 -> ha_innodb.so.0.0.0

-rwxr-xr-x 1 root root 4560527 Mar 26 01:04 ha_innodb.so.0.0.0

[root@odb1 plugin]#

[root@odb1 plugin]# ls -l ha_innodb*.so

lrwxrwxrwx 1 root root 25 Mar 26 01:04 ha_innodb_plugin.so -> ha_innodb_plugin.so.0.0.0

lrwxrwxrwx 1 root root 18 Mar 26 01:04 ha_innodb.so -> ha_innodb.so.0.0.0

[root@odb1 plugin]# 

启动mysql服务器，然后安装innodb

mysql> show variables like %plugin_dir%;

+---------------+---------------------------------+

| Variable_name | Value                           |

+---------------+---------------------------------+

| plugin_dir    | /mysql/lib/mysql/plugin |

+---------------+---------------------------------+

1 row in set (0.00 sec)

mysql> 

mysql> INSTALL PLUGIN InnoDB SONAME ha_innodb.so;

Query OK, 0 rows affected (0.52 sec)

mysql> 

mysql> show engines;

+------------+---------+------------------------------------------------------------+--------------+------+------------+

| Engine     | Support | Comment                                                    | Transactions | XA   | Savepoints |

+------------+---------+------------------------------------------------------------+--------------+------+------------+

| CSV        | YES     | CSV storage engine                                         | NO           | NO   | NO         |

| InnoDB     | YES     | Supports transactions, row-level locking, and foreign keys | YES          | YES  | YES        |

| MEMORY     | YES     | Hash based, stored in memory, useful for temporary tables  | NO           | NO   | NO         |

| MyISAM     | DEFAULT | Default engine as of MySQL 3.23 with great performance     | NO           | NO   | NO         |

| MRG_MYISAM | YES     | Collection of identical MyISAM tables                      | NO           | NO   | NO         |

+------------+---------+------------------------------------------------------------+--------------+------+------------+

5 rows in set (0.00 sec)

mysql> 

--执行如下命令时

INSTALL PLUGIN InnoDB SONAME ha_innodb.so;

err日志输出

[root@odb1 data]# pwd

/mysql/data

[root@odb1 data]# 

[root@odb1 data]# ls -l

total 20556

-rw-rw---- 1 mysql mysql 10485760 Apr  2 21:18 ibdata1

-rw-rw---- 1 mysql mysql  5242880 Apr  2 21:18 ib_logfile0

-rw-rw---- 1 mysql mysql  5242880 Apr  2 21:18 ib_logfile1

drwx------ 2 mysql root      4096 Mar 26 01:17 mysql

-rw-rw---- 1 mysql mysql      409 Mar 27 20:53 odb1.log

-rw-rw---- 1 mysql root     15246 Apr  2 21:18 odb1.test.com.err

-rw-rw---- 1 mysql mysql        6 Apr  2 21:01 odb1.test.com.pid

drwx------ 2 mysql root      4096 Apr  2 19:04 test

drwx------ 2 mysql mysql     4096 Apr  2 19:10 test2

[root@odb1 data]# 

more odb1.test.com.err

160402 21:01:25 mysqld_safe Starting mysqld daemon with databases from /mysql/data

160402 21:01:25 [Warning] --skip-locking is deprecated and will be removed in a future release. Please use --skip-external-locking instead.

160402 21:01:25 [Warning] --log_slow_queries is deprecated and will be removed in a future release. Please use --slow_query_log/--slow_query_log_file instead.

160402 21:01:25 [Note] Event Scheduler: Loaded 0 events

160402 21:01:25 [Note] /mysql/libexec/mysqld: ready for connections.

Version: 5.1.51-log  socket: /tmp/mysql.sock  port: 3306  Source distribution

InnoDB: The first specified data file ./ibdata1 did not exist:

InnoDB: a new database to be created!

160402 21:18:49  InnoDB: Setting file ./ibdata1 size to 10 MB

InnoDB: Database physically writes the file full: wait...

160402 21:18:49  InnoDB: Log file ./ib_logfile0 did not exist: new to be created

InnoDB: Setting log file ./ib_logfile0 size to 5 MB

InnoDB: Database physically writes the file full: wait...

160402 21:18:49  InnoDB: Log file ./ib_logfile1 did not exist: new to be created

InnoDB: Setting log file ./ib_logfile1 size to 5 MB

InnoDB: Database physically writes the file full: wait...

InnoDB: Doublewrite buffer not found: creating new

InnoDB: Doublewrite buffer created

InnoDB: Creating foreign key constraint system tables

InnoDB: Foreign key constraint system tables created

160402 21:18:49  InnoDB: Started; log sequence number 0 0

==================================================================================

启停mysql

[root@odb1 data]# service mysql start

Starting MySQL.[  OK  ]

[root@odb1 data]# 

[root@odb1 data]# 

[root@odb1 data]# service mysql stop

Shutting down MySQL....[  OK  ]

err日志输出

--启动

160402 21:27:20 mysqld_safe Starting mysqld daemon with databases from /mysql/data

160402 21:27:20 [Warning] --skip-locking is deprecated and will be removed in a future release. Please use --skip-external-locking instead.

160402 21:27:20 [Warning] --log_slow_queries is deprecated and will be removed in a future release. Please use --slow_query_log/--slow_query_log_file instead.

160402 21:27:20  InnoDB: Started; log sequence number 0 44233

160402 21:27:20 [Note] Event Scheduler: Loaded 0 events

160402 21:27:20 [Note] /mysql/libexec/mysqld: ready for connections.

Version: 5.1.51-log  socket: /tmp/mysql.sock  port: 3306  Source distribution

--关闭

160402 21:28:27 [Note] /mysql/libexec/mysqld: Normal shutdown

160402 21:28:27 [Note] Event Scheduler: Purging the queue. 0 events

160402 21:28:27  InnoDB: Starting shutdown...

160402 21:28:30  InnoDB: Shutdown completed; log sequence number 0 44233

160402 21:28:30 [Note] /mysql/libexec/mysqld: Shutdown complete

160402 21:28:30 mysqld_safe mysqld from pid file /mysql/data/odb1.test.com.pid ended

看完上述内容，你们掌握如何开启mysql的innodb引擎的方法了吗？如果还想学到更多技能或想了解更多相关内容，欢迎关注行业资讯频道，感谢各位的阅读！