Compile and install lamp (ii)--Compile and install MySQL-5.5.28

1. Prepare the file system for data storage
Create a new logical volume and mount it to a specific directory. The process is no longer given here.

This assumes that the mounted directory of its logical volume is/mydata, and then needs to create the/mydata/data directory as the storage directory for MySQL data.

2. The new user runs the process in a secure manner:

# groupadd-r mysql# useradd-g mysql-r-s/sbin/nologin mysql# chown-r mysql:mysql/mydata/data

3. Install and initialize the mysql-5.5.28
First download the platform corresponding to the MySQL version to the local, here is the 32-bit platform, therefore, the choice is mysql-5.5.28-linux2.6-i686.tar.gz.

# tar XF mysql-5.5.28-linux2.6-i686.tar.gz-c/usr/local# cd/usr/local/# ln-sv mysql-5.5.28-linux2.6-i686 mysql# CD Mys QL # chown-r Mysql:mysql. # scripts/mysql_install_db--user=mysql--datadir=/mydata/data# chown-r root.

4. Provide the main configuration file for MySQL:

# cd/usr/local/mysql# CP support-files/my-large.cnf/etc/my.cnf

and modify the value of thread_concurrency in this file to multiply your number of CPUs by 2, for example using the following line:
thread_concurrency = 2 (thread concurrency)
Also add the following line to specify where the MySQL data file will be stored:
DataDir =/mydata/data


5. Provide SYSV service script for MySQL:

# cd/usr/local/mysql# CP support-files/mysql.server/etc/rc.d/init.d/mysqld# chmod +x/etc/rc.d/init.d/mysqld

Add to Service list:

# chkconfig--add mysqld# chkconfig mysqld on

You can then start the service test using.

In order to use the MySQL installation to conform to the system usage specification and export its development components to the system, the following steps are required:
6, output the MySQL man manual to the man command to find the path:
To edit the/etc/man.config, add the following line:
Manpath/usr/local/mysql/man

7, output MySQL header file to the System header file path/usr/include:
This can be achieved by simply creating a link:

# Ln-sv/usr/local/mysql/include/usr/include/mysql

8. Output MySQL library file to the system library to find the path:

# echo '/usr/local/mysql/lib ' >/etc/ld.so.conf.d/mysql.conf

The system is then re-loaded into the system library:

# Ldconfig

9, modify the PATH environment variable, so that the system can directly use MySQL related commands.

# echo ' Export path= $PATH:/usr/local/mysql/bin ' >/etc/profile.d/mysql.sh

Compile and install lamp (ii)--Compile and install MySQL-5.5.28