源码编译MySQL 5.1生成InnoDB存储引擎
仅列出主要步骤:
[plain][/plain] view plaincopyprint?
- ./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][/plain] view plaincopyprint?
- 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][/plain] view plaincopyprint?
- [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