Linux下MySQL 5.5.x 编译安装详解

朱雀 2022-06-01 08:15 165阅读 0赞

下载地址：http://www.percona.com/redir/downloads/Percona-Server-5.5/Percona-Server-5.5.13-20.4/Linux/binary/Percona-Server-5.5.13-rel20.4-138.Linux.x86\_64.tar.gz  
  
   
  
1、上传二进制包文件到系统下，可以自己选择上传目录，我的在/opt/tools下  
  
2、解压文件到安装路径下  
  
 tar zvxf Percona-Server-5.5.13-rel20.4-138.Linux.x86\_64.tar.gz  
  
 mv Percona-Server-5.5.13-rel20.4-138.Linux.x86\_64 /app/mysql  
  
3、安装  
  
 groupadd mysql  
  
 useradd -r -g mysql mysql  
  
 cd /app/mysql/  
   
 mkdir tmp run log  
  
 chown -R mysql:mysql /app/mysql  
  
 scripts/mysql\_install\_db --user=mysql  
  
 cp support-files/mysql.server /etc/init.d/mysqld  
  
  
拷贝文件，允许在任何路径下使用mysql命令进入命令行  
  
 cp /app/mysql/bin/mysql  /usr/sbin/  
  
   
  
4、调整启动脚本 mysql.server 文件，将默认路径替换成 实际安装路径，否则会报错  
  
vi /etc/init.d/mysqld  
  
  basedir=/app/mysql  
  datadir=/app/mysql/data  
  
5.设置配置文件  注意： 根据不同的配置来配置不同的参数  
  
vi /etc/my.cnf  
  
输入：

\#The following options will be passed to all MySQL clients  
\[client\]  
\#password       = your\_password  
port            = 3306  
socket          = /app/mysql/run/mysql.sock  
  
\[mysqld\]  
\#\#\#\# Baes dir \#\#\#\#  
basedir = /app/mysql  
datadir = /app/mysql/data  
tmpdir = /app/mysql/tmp  
socket = /app/mysql/run/mysql.sock  
  
  
character\_set\_server = utf8  
init\_connect = 'SET NAMES utf8'  
  
  
\#\#\#\# Base configure info \#\#\#\#  
port = 3306  
old\_passwords = 0  
\#lower\_case\_table\_names = 1  
open\_files\_limit = 65535  
read\_rnd\_buffer\_size = 5M  
max\_allowed\_packet = 32M  
max\_connect\_errors = 50000  
max\_connections = 5000  
thread\_cache\_size=64  
thread\_stack=262144  
  
\#\#\#\# Log info \#\#\#\#  
log-error = /app/mysql/log/alert.log  
slow-query-log = /app/mysql/log/slow.log  
\#log-slow-admin-statements  
\#log-queries-not-using-indexes  
long\_query\_time = 1  
  
\#\#\#\# Binary log && Relay log \#\#\#\#  
log-bin = /app/mysql/log/mysql-bin  
log-slave-updates = 1  
relay-log = /app/mysql/log/mysqld-relay-bin  
relay-log-index = /app/mysql/log/mysqld-relay-bin.index  
master-info-file = /app/mysql/log/master.info  
relay-log-info-file = /app/mysql/log/relay-log.info  
max\_binlog\_size = 500M  
max\_binlog\_cache\_size = 1G  
  
  
  
\#\#\#\# query cache \#\#\#\#  
query\_cache\_size = 30M  
query\_cache\_limit = 1K  
query\_cache\_min\_res\_unit = 1K  
query\_cache\_type = 2  
  
  
\#myisam  
concurrent\_insert = 2  
key\_buffer = 100M  
sort\_buffer\_size = 100K  
join\_buffer\_size = 100K  
read\_buffer\_size = 1M  
myisam\_sort\_buffer\_size = 100M  
  
  
  
skip-external-locking  
key\_buffer\_size = 16M  
table\_open\_cache = 64  
sort\_buffer\_size = 512K  
net\_buffer\_length = 8K  
  
binlog\_format=mixed  
  
server-id       = 1  
auto-increment-increment = 1  
auto-increment-offset = 1  
  
  
  
\#innodb plugin  
\#ignore\_builtin\_innodb  
\#innodb\_file\_format=Antelope  
\#innodb\_strict\_mode=1  
  
\#innodb  
default-storage-engine = INNODB  
innodb\_file\_per\_table = 1  
innodb\_open\_files=50000  
innodb\_flush\_log\_at\_trx\_commit = 2  
innodb\_lock\_wait\_timeout = 100  
innodb\_additional\_mem\_pool\_size = 200  
innodb\_buffer\_pool\_size = 10G  
innodb\_log\_buffer\_size= 400M  
innodb\_log\_file\_size = 100M  
\#transaction-isolation = READ-COMMITTED  
innodb\_data\_file\_path = ibdata1:5G;ibdata2:5G:autoextend  
  
\[mysqldump\]  
quick  
max\_allowed\_packet = 16M  
  
\[mysql\]  
no-auto-rehash  
\# Remove the next comment character if you are not familiar with SQL  
\#safe-updates  
  
\[myisamchk\]  
key\_buffer\_size = 20M  
sort\_buffer\_size = 20M  
read\_buffer = 2M  
write\_buffer = 2M  
  
\[mysqlhotcopy\]  
interactive-timeout  
  
scripts/mysql\_install\_db --user=mysql

启动mysql

service mysqld start