如何启动mysql的innodb引擎
发布时间：2021-12-18 14:03:25 所属栏目：MySql教程 来源：互联网
导读：如何开启mysql的innodb引擎，相信很多没有经验的人对此束手无策，为此本文总结了问题出现的原因和解决方法，通过这篇文章希望你能解决这个问题。 开启mysql的innodb引擎 环境： mysql版本 5.1.51 os：rhel 5.4 32bit mysql安装目录为/mysql mysql 的数据目录/
|
如何开启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引擎的方法了吗？如果还想学到更多技能或想了解更多相关内容，欢迎关注亿速云行业资讯频道，感谢各位的阅读！ （编辑：站长网） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |
