mysql编译innodb_源码编译MySQL 5.1生成InnoDB存储引擎

这里就仅列出主要步骤：

./configure --prefix=/home/mysql51/mysql/ --enable-assembler --enable-local-infile --enable-thread-safe-client --with-big-tables --with-charset=utf8 --with-extra-charsets=gbk,gb2312,utf8,ascii --with-readline --with-ssl --with-embedded-server --with-pthread --with-mysqld-user=mysql51 --with-plugins=all > /home/mysql51/mysql_setuplogs_configure.log 2>&1

./scripts/mysql_install_db --basedir=/home/mysql51/mysql --datadir=/home/mysql51/mysql/data --user=mysql51 --defaults-file=/home/mysql51/mysql/my.cnf --force

mysqld_safe --defaults-file=/home/mysql51/mysql/my.cnf &

mysqladmin -u root -S /home/mysql51/mysql/mysql.sock password 'oracle'

验证效果：

mysql> select version();

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

| version() |

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

| 5.1.72-log |

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

mysql> show plugins;

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

| Name | Status | Type | Library | License |

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

| binlog | ACTIVE | STORAGE ENGINE | NULL | GPL |

| partition | ACTIVE | STORAGE ENGINE | NULL | GPL |

| ARCHIVE | ACTIVE | STORAGE ENGINE | NULL | GPL |

| BLACKHOLE | ACTIVE | STORAGE ENGINE | NULL | GPL |

| CSV | ACTIVE | STORAGE ENGINE | NULL | GPL |

| FEDERATED | DISABLED | STORAGE ENGINE | NULL | GPL |

| MEMORY | ACTIVE | STORAGE ENGINE | NULL | GPL |

| InnoDB | ACTIVE | STORAGE ENGINE | NULL | GPL |

| MyISAM | ACTIVE | STORAGE ENGINE | NULL | GPL |

| MRG_MYISAM | ACTIVE | STORAGE ENGINE | NULL | GPL |

| ndbcluster | DISABLED | STORAGE ENGINE | NULL | GPL |

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

11 rows in set (0.00 sec)

mysql> create table test.t_innodb(id int) engine=innodb;

Query OK, 0 rows affected (0.04 sec)

mysql> show create table test.t_innodb\G;

*************************** 1. row ***************************

Table: t_innodb

Create Table: CREATE TABLE `t_innodb` (

`id` int(11) DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8

1 row in set (0.00 sec)

ERROR:

No query specified

如果单台服务器上既跑MySQL 5.5又跑MySQL 5.1，那么：

① sock文件不能放在公用目录下，比如/tmp

② 启动mysql时也应该借助参数--defaults-file来指定配置文件my.cnf

[root@localhost ~]# netstat -lntp | grep :3306

tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 22171/mysqld

[root@localhost ~]# netstat -lntp | grep :3307

tcp 0 0 0.0.0.0:3307 0.0.0.0:* LISTEN 31183/mysqld

By DBA_WaterBin

2013-09-29

Good Luck