bitscn.com
源码编译mysql 5.1生成innodb存储引擎
这里就仅列出主要步骤：
[plain] ./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'
验证效果：
[plain] 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
[plain] [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
bitscn.com