How to start the innodb engine of mysql
How to start mysql's innodb engine, I believe that many inexperienced people do not know what to do, so this paper summarizes the causes of the problem and solutions, through this article I hope you can solve this problem.
Turn on the innodb engine of mysql
Environment:
Mysql version 5.1.51
Os:rhel 5.4 32bit
The mysql installation directory is / mysql
Mysql data directory / mysql/data
Before installation
[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] #
Start the mysql server and install 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.52sec)
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 >
-- when executing the following command
INSTALL PLUGIN InnoDB SONAME 'ha_innodb.so'
Err log output
[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 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 logfile. / 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 logfile. / 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
=
Start and stop 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 log output
-- start
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 socket:' / tmp/mysql.sock' port: 3306 Source distribution
-- close
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
After reading the above, do you know how to start mysql's innodb engine? If you want to learn more skills or want to know more about it, you are welcome to follow the industry information channel, thank you for reading!
