mysql5.5.28 通用二进制安装

8767654r

编译安装MySQL-5.5.28通用二进制
[iyunv@localhost local]# groupadd -r -g 306 mysql  为mysql创建一个系统用户
[iyunv@localhost local]# useradd -r -g 306 -u 306 mysql
[iyunv@localhost local]# tar -xf mysql-5.5.28-linux2.6-x86_64.tar.gz
[iyunv@localhost local]# ln -sv  mysql-5.5.28-linux2.6-x86_64 mysql  
[iyunv@localhost local]# chown -R mysql.mysql mysql/*
[iyunv@localhost local]# chmod -R 750 mysql/*
[iyunv@localhost mysql]# less INSTALL-BINARY  查看安装说明
[iyunv@localhost mysql]# ls scripts/
mysql_install_db  初始化系统的脚本
[iyunv@localhost mysql]# scripts/mysql_install_db  --help 查看说明
  --datadir=path 改变data目录的位置，建议放到一个逻辑卷上
  --user=user_name  以哪个用户进行初始化

创建一个逻辑卷
fdisk /dev/sda
n
4
n
e

+20G
t
5
8e
p
w
partprobe /dev/sda
pvcreate /dev/sda5 创建物理卷
vgcreate myvg /dev/sda5 把sda5创建成卷组叫myvg
lvcreate -n mydata -L 5G myvg 指定逻辑卷大小和逻辑卷名
lvs 查看逻辑卷
mke2fs -j /dev/myvg/mydata 格式化
[iyunv@localhost mysql]# mkdir -p /mydata/data
[iyunv@localhost mysql]# vim /etc/fstab 开机自动挂载
/dev/myvg/mydata        /mydata                 ext3    defaults        0 0
[iyunv@localhost mysql]# chown -R mysql.mysql /mydata/data
[iyunv@localhost mysql]# chmod o-rx /mydata/data
[iyunv@localhost mysql]# scripts/mysql_install_db   --user=mysql   --datadir=/mydata/data/
[iyunv@mylinux mysql]# chown -R root /usr/local/mysql/*
/mydata/data   必须是mysql:mysql
[iyunv@mylinux mysql]# cp support-files/mysql.server  /etc/init.d/mysqld  把mysql脚本放到init.d下
[iyunv@mylinux mysql]# ls -l /etc/init.d/mysqld 查看是否有执行权限
[iyunv@mylinux mysql]# chkconfig  --add  mysqld
[iyunv@mylinux mysql]# chkconfig  --list mysqld
此时还不能启动，没有配置文件
/etc/my.cnf  -->  /etc/mysql/my.cnf  -->  $BASEDIR/my.cnf  -->$DATADIR/my.cnf  --> ~/.my.cnf
以最后一个为准
[iyunv@mylinux support-files]# head my-huge.cnf
# This is for a large system with memory of 1G-2G where the system runs mainly
根据内存大小选择合适的配置文件
[iyunv@mylinux support-files]# cp my-large.cnf  /etc/my.cnf
thread_concurrency = 2    此项填写CPU个数*2
[iyunv@mylinux support-files]# cat /proc/cpuinfo 查看cpu个数
加一项 datadir=/mydata/data
service mysqld start
netstat -tnlp
[iyunv@mylinux support-files]# vim /etc/profile.d/mysql.sh
export PATH=$PATH:/usr/local/mysql/bin

MySQL服务器维护了两类变量：
服务器变量：
    定义MySQL服务器运行特性
    show global variables [like 'STRING’]；
状态变量：
    show global status [like 'STRING’]；
MySQL 通配符
_任意单个字符
%任意长度的任意字符
[iyunv@localhost ~]# vim /etc/man.config
MANPATH /usr/man
MANPATH /usr/share/man
MANPATH /usr/local/man
MANPATH /usr/local/share/man
MANPATH /usr/X11R6/man
MANPATH /usr/local/mysql/man 新增一条
[iyunv@localhost ~]# vim /etc/ld.so.conf.d/mysql.conf
/usr/local/mysql/lib
[iyunv@localhost ~]# ldconfig -v 让系统重新读取
[iyunv@localhost ~]# ls -l /etc/ld.so.cache 缓存到这个文件
-rw-r--r--. 1 root root 41662 Jul 27 17:15 /etc/ld.so.cache
[iyunv@localhost mysql]# ln -sv /usr/local/mysql/include  /usr/include/mysql