Shulou(Shulou.com)05/31 Report--

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!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.