os: centos7.4
db: mysql 5.7.21
安装一些依赖包
# yum install make cmake *gcc* libaio libaio-devel automake autoconf bz bison libtool ncurses wget perl-DBI perl-DBD-MySQL perl-JSON perl-Time-HiRes perl-devel numactl* bzip2 git openssl openssl-devel
修改 NOZEROCONF
# vi /etc/sysconfig/network
NOZEROCONF=YES修改IO调度器设置
elevator=deadline
关闭 NUMA 特性
numa=off
禁用透明大页
transparent_hugepage=never
# vi /etc/default/grub
# grub2-mkconfig -o /boot/grub2/grub.cfg 修改内核参数
# vi /etc/sysctl.conf
vm.swappiness = 1 调整资源限制
# vi /etc/security/limits.conf
* soft nofile 65535
* hard nofile 65535
* soft nproc 65535
* hard nproc 65535禁止selinux
vi /etc/sysconfig/selinux
SELINUX=DISABLED
或者
vi /etc/selinux/config
SELINUX=disabledsshd中关闭UseDNS：
vi /etc/ssh/sshd_config
UseDNS no
systemctl restart sshd确认安装sysstat
rpm -qa | grep sysstatcentos 7 安装mysql时，默认的是mariadb
# yum install mysql
---> Package mariadb-libs.x86_64 1:5.5.44-2.el7.centos will be updated
---> Package mariadb-libs.x86_64 1:5.5.56-2.el7 will be an update所以需要安装mysql的yum源
https://dev.mysql.com/downloads/repo/yum/
下载 mysql57-community-release-el7-11.noarch.rpm
# rpm -ivh /tmp/mysql57-community-release-el7-11.noarch.rpm
# cd /etc/yum.repos.d
# ls -l |grep -i mysql
-rw-r--r-- 1 root root 1838 Apr 27 2017 mysql-community.repo
-rw-r--r-- 1 root root 1885 Apr 27 2017 mysql-community-source.repo安装mysql 5.7
# yum install mysql
Dependencies Resolved
=======================================================================================================================================================================================
Package Arch Version Repository Size
=======================================================================================================================================================================================
Installing:
mysql-community-client x86_64 5.7.21-1.el7 mysql57-community 24 M
mysql-community-libs x86_64 5.7.21-1.el7 mysql57-community 2.1 M
replacing mariadb-libs.x86_64 1:5.5.44-2.el7.centos
mysql-community-libs-compat x86_64 5.7.21-1.el7 mysql57-community 2.0 M
replacing mariadb-libs.x86_64 1:5.5.44-2.el7.centos
Installing for dependencies:
mysql-community-common x86_64 5.7.21-1.el7 mysql57-community 272 k
Transaction Summary
=======================================================================================================================================================================================
Install 3 Packages (+1 Dependent package)
Total download size: 28 M
Is this ok [y/d/N]: y
Downloading packages:
warning: /var/cache/yum/x86_64/7/mysql57-community/packages/mysql-community-common-5.7.21-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY| 85 kB --:--:-- ETA
Public key for mysql-community-common-5.7.21-1.el7.x86_64.rpm is not installed
(1/4): mysql-community-common-5.7.21-1.el7.x86_64.rpm | 272 kB 00:00:00
(2/4): mysql-community-libs-5.7.21-1.el7.x86_64.rpm | 2.1 MB 00:00:01
(3/4): mysql-community-libs-compat-5.7.21-1.el7.x86_64.rpm | 2.0 MB 00:00:01
(4/4): mysql-community-client-5.7.21-1.el7.x86_64.rpm | 24 MB 00:01:24
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total 342 kB/s | 28 MB 00:01:24
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
Importing GPG key 0x5072E1F5:
Userid : "MySQL Release Engineering <mysql-build@oss.oracle.com>"
Fingerprint: a4a9 4068 76fc bd3c 4567 70c8 8c71 8d3b 5072 e1f5
Package : mysql57-community-release-el7-11.noarch (@/mysql57-community-release-el7-11.noarch)
From : /etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
Is this ok [y/N]: y
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : mysql-community-common-5.7.21-1.el7.x86_64 1/5
Installing : mysql-community-libs-5.7.21-1.el7.x86_64 2/5
Installing : mysql-community-client-5.7.21-1.el7.x86_64 3/5
Installing : mysql-community-libs-compat-5.7.21-1.el7.x86_64 4/5
Erasing : 1:mariadb-libs-5.5.44-2.el7.centos.x86_64 5/5
Verifying : mysql-community-common-5.7.21-1.el7.x86_64 1/5
Verifying : mysql-community-libs-5.7.21-1.el7.x86_64 2/5
Verifying : mysql-community-client-5.7.21-1.el7.x86_64 3/5
Verifying : mysql-community-libs-compat-5.7.21-1.el7.x86_64 4/5
Verifying : 1:mariadb-libs-5.5.44-2.el7.centos.x86_64 5/5
Installed:
mysql-community-client.x86_64 0:5.7.21-1.el7 mysql-community-libs.x86_64 0:5.7.21-1.el7 mysql-community-libs-compat.x86_64 0:5.7.21-1.el7
Dependency Installed:
mysql-community-common.x86_64 0:5.7.21-1.el7
Replaced:
mariadb-libs.x86_64 1:5.5.44-2.el7.centos
Complete!# yum install mysql-server
Dependencies Resolved
=======================================================================================================================================================================================
Package Arch Version Repository Size
=======================================================================================================================================================================================
Installing:
mysql-community-server x86_64 5.7.21-1.el7 mysql57-community 164 M
Transaction Summary
=======================================================================================================================================================================================
Install 1 Package
Total download size: 164 M
Installed size: 740 M
Is this ok [y/d/N]: y
Downloading packages:
mysql-community-server-5.7.21-1.el7.x86_64.rpm | 164 MB 00:01:01
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : mysql-community-server-5.7.21-1.el7.x86_64 1/1
Verifying : mysql-community-server-5.7.21-1.el7.x86_64 1/1
Installed:
mysql-community-server.x86_64 0:5.7.21-1.el7
Complete!所有安装的mysql rpm文件
mysql57-community-release-el7-11.noarch.rpm
mysql-community-client-5.7.21-1.el7.x86_64
mysql-community-common-5.7.21-1.el7.x86_64 1/5
mysql-community-libs-5.7.21-1.el7.x86_64 2/5 3/5
mysql-community-libs-compat-5.7.21-1.el7.x86_64
mysql-community-server-5.7.21-1.el7.x86_64查看依赖的lib库是否安装全了
# ldd /sbin/mysqld
linux-vdso.so.1 => (0x00007ffc102f5000)
libpthread.so.0 => /lib64/libpthread.so.0 (0x00007fea7784b000)
libaio.so.1 => /lib64/libaio.so.1 (0x00007fea77649000)
libnuma.so.1 => /lib64/libnuma.so.1 (0x00007fea7743c000)
libcrypt.so.1 => /lib64/libcrypt.so.1 (0x00007fea77205000)
libdl.so.2 => /lib64/libdl.so.2 (0x00007fea77001000)
librt.so.1 => /lib64/librt.so.1 (0x00007fea76df8000)
libstdc++.so.6 => /lib64/libstdc++.so.6 (0x00007fea76af0000)
libm.so.6 => /lib64/libm.so.6 (0x00007fea767ee000)
libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00007fea765d7000)
libc.so.6 => /lib64/libc.so.6 (0x00007fea76214000)
/lib64/ld-linux-x86-64.so.2 (0x00007fea77a6f000)
libfreebl3.so => /lib64/libfreebl3.so (0x00007fea76011000)初始化并启动mysql
# systemctl status mysqld.service
● mysqld.service - MySQL Server
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
Active: inactive (dead)
Docs: man:mysqld(8)
http://dev.mysql.com/doc/refman/en/using-systemd.html# cat /usr/lib/systemd/system/mysqld.service
# Copyright (c) 2015, 2016, Oracle and/or its affiliates. All rights reserved.
#
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation; version 2 of the License.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with this program; if not, write to the Free Software
# Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA
#
# systemd service file for MySQL forking server
#
[Unit]
Description=MySQL Server
Documentation=man:mysqld(8)
Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html
After=network.target
After=syslog.target
[Install]
WantedBy=multi-user.target
[Service]
User=mysql
Group=mysql
Type=forking
PIDFile=/var/run/mysqld/mysqld.pid
# Disable service start and stop timeout logic of systemd for mysqld service.
TimeoutSec=0
# Execute pre and post scripts as root
PermissionsStartOnly=true
# Needed to create system tables
ExecStartPre=/usr/bin/mysqld_pre_systemd
# Start main service
ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid $MYSQLD_OPTS
# Use this to switch malloc implementation
EnvironmentFile=-/etc/sysconfig/mysql
# Sets open_files_limit
LimitNOFILE = 5000
Restart=on-failure
RestartPreventExitStatus=1
PrivateTmp=false# systemctl start mysqld.service
Mar 26 11:28:37 mysql-18-235 mysqld_pre_systemd: 2018-03-26T03:28:37.692515Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).–explicit_defaults_for_timestamp
在MySQL 5.6.6及以后的版本和MySQL 5.7之前的版本中，如果在配置文件中没有指定explicit_defaults_for_timestamp参数，启动时error日志中会报如下警告：
[Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use –explicit_defaults_for_timestamp server option (see documentation for more details).
注意观察日志
/var/log/messages
/var/log/mysqld.log
# vi /etc/my.cnf
explicit_defaults_for_timestamp=1修改密码策略，测试环境，不需要那么严格
# vi /etc/my.cnf
validate_password_length=4
validate_password_mixed_case_count=0
validate_password_number_count=0
validate_password_policy=0
validate_password_special_char_count=0修改密码
set password for 'root'@'localhost'= password('TE3edc4rfv@');创建用户
create user 'usr_abc'@'%.%.%.%' identified by 'usr_abc';select host,user,authentication_string
from mysql.user
where 1=1
order by user,host
;查看错误信息
# perror 24
OS error code 24: Too many open files