第3章　MySQL体系结构 - xiaoboluo768/qianjinliangfang GitHub Wiki

3.1　快速安装MySQL

[root@localhost ~]# wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.20-linux-glibc2.12-x86_64.tar.gz

[root@localhost ~]# mkdir -p /home/mysql/program
[root@localhost ~]# tar xf /soft_resource/mysql-percona-mariadb/\
mysql-5.7.20-linux- glibc2.12-x86_64.tar.gz -C /home/mysql/program/
[root@localhost ~]# ll /home/mysql/program/mysql-5.7.20-linux-glibc2.12-x86_64/
......

# 创建mysql用户
[root@localhost ~]# useradd mysql -s /sbin/nologin

# 创建磁盘目录
[root@localhost ~]# mkdir -p /home/mysql/data/mysqldata1/{binlog,innodb_log,innodb_ts,\
log,mydata,relaylog,slowlog,sock,tmpdir,undo}
[root@localhost ~]# chown mysql.mysql /home/mysql/data -R

[root@localhost ~]# ln -s /home/mysql/program/mysql-5.7.20-linux-glibc2.12-x86_64/\
/usr/local/mysql
[root@localhost ~]# export PATH=$PATH:/usr/local/mysql/bin/
[root@localhost ~]# echo 'export PATH=$PATH:/usr/local/mysql/bin/' >> /etc/profile

[root@localhost ~]# mysqld --defaults-file=/etc/my.cnf --initialize-insecure

[root@localhost ~]# cp -ar /usr/local/mysql/support-files/mysql.server/etc/init.d/ mysqld
[root@localhost ~]# chmod +x /etc/init.d/mysqld
[root@localhost ~]# chkconfig mysqld on
[root@localhost ~]# chkconfig --list mysqld
mysqld       0:关闭   1:关闭   2:启用   3:启用   4:启用   5:启用   6:关闭

# 启动
[root@localhost ~]# service mysqld start
Starting MySQL..                                          [确定]

# 登录（由于初始化数据库时使用了--initialize-insecure选项，所以初始化完成之后没有密码，直接登录）
[root@localhost ~]# mysql
......

3.2　数据目录结构

# 使用如下两个命令搜索datadir下的所有文件
[root@localhost ~]# tree /home/mysql/data/mysqldata1/* | grep -Ei '.frm|.myi|.myd|.ibd'\
|awk -F '.' '{print $2}' |sort |uniq -c
    236 frm
    36 ibd
    11 MYD
    11 MYI

[root@localhost ~]# tree /home/mysql/data/mysqldata1/* | grep -Eiv '.frm|.myi|.myd|.ibd'
......

• 3.6　InnoDB存储引擎后台线程

mysql> select name,type,thread_id, processlist_id from performance_schema.threads;
......
40 rows in set (0.00 sec)

• 3.7　MySQL前台线程

mysql> select name,type,thread_id, processlist_id from performance_schema.threads where type='FOREGROUND';
......
9 rows in set (0.00 sec)

---

上一篇：第2章　MySQL常用的两种升级方法 | 下一篇：第4章　performance_schema初相识