Source code compilation MySQL5.1 generate InnoDB storage engine _ MySQL

Source code compilation MySQL5.1 generate InnoDB storage engine bitsCN.com

Compile MySQL 5.1 with source code to generate the InnoDB storage engine

Here we will only list the main steps:

[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'  

Verification results:

[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  

If a single server runs MySQL 5.5 and MySQL 5.1, then:

① The sock file cannot be placed in a public directory, such as/tmp

② When starting mysql, you should also use the -- defaults-file parameter to specify the configuration 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