扩展

mysql8源码安装

安装 MySQL8 编译依赖

dnf install -y \
gcc \
gcc-c++ \
cmake \
ncurses \
ncurses-devel \
openssl \
openssl-devel \
bison \
make \
perl \
wget \
rpcgen \
git \
libtirpc \
libtirpc-devel

命令作用：

执行结果：

关键参数：

注意事项：

关键参数：

注意事项：

--------------内容如下-------------------

--------------保存退出-------------------


**注意事项：**




--datadir=/usr/local/mysql/data

[client] socket=/usr/local/mysql/mysql.sock [mysqld] user=mysql basedir=/usr/local/mysql datadir=/usr/local/mysql/data socket=/usr/local/mysql/mysql.sock port=3306 character-set-server=utf8mb4 #default_authentication_plugin=mysql_native_password log-error=/usr/local/mysql/data/mysql.err pid-file=/usr/local/mysql/data/mysql.pid max_connections=200 innodb_buffer_pool_size=512M [mysql] default-character-set=utf8mb4


**注意事项：**



[Unit]
After=network.target

[Service]
Type=forking
User=mysql
Group=mysql
PIDFile=/usr/local/mysql/data/mysql.pid
TimeoutSec=600
#LimitNOFILE=65535
Restart=on-failure
RestartSec=5

[Install]
WantedBy=multi-user.target

注意事项：


**注意事项：**

注意事项：

解决：


**注意事项：**



#!/bin/bash


cpu_num=$(nproc)


sestatus=$(getenforce)






















[client]
user=root
password=Aa123456.

[mysql]
socket=/tmp/mysql.sock

[mysqld]
user=mysql
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
socket=/tmp/mysql.sock
character_set_server=utf8mb4

max_connections=300
thread_cache_size=4
wait_timeout=200
interactive_timeout=28800

#default_storage_engine=myisam
default_storage_engine=innodb

innodb_file_per_table=1
innodb_data_file_path=ibdata1:12M;ibdata2:100M:autoextend

#innodb_log_file_size=50M
#innodb_log_files_in_group=2
#innodb_log_group_home_dir=/usr/local/mysql/data

slow_query_log=1
long_query_time=0.1
slow_query_log_file=/usr/local/mysql/data/mysql-slow.log
#log_queries_not_using_indexes=1

#general_log=1
#general_log_file=/opt/3306/data/general.log

#binlog_format=statement

server-id=1


[Unit]
After=network.target

[Service]
Type=forking
User=mysql
Group=mysql


PIDFile=/usr/local/mysql/data/mysqld.pid

TimeoutSec=600

Restart=on-failure
RestartSec=5

StandardOutput=journal
StandardError=journal
SyslogIdentifier=mysqld

[Install]
WantedBy=multi-user.target

注意事项：

#!/bin/bash

cpu_num=$(nproc)

sestatus=$(getenforce)

[Unit] After=network.target After=syslog.target

[Service] Type=forking User=mysql Group=mysql PIDFile=/usr/local/mysql/data/mysqld.pid

TimeoutStartSec=300 Restart=on-failure RestartSec=10 LimitNOFILE=65535 PrivateTmp=true

WorkingDirectory=/usr/local/mysql

StandardOutput=journal StandardError=journal SyslogIdentifier=mysqld

[Install] WantedBy=multi-user.target

[mysqld] basedir=/usr/local/mysql datadir=/usr/local/mysql/data

socket=/tmp/mysql.sock

pid-file=/usr/local/mysql/mysqld.pid port=3306

#log-error=/usr/local/mysql/error.log

[client] socket=/tmp/mysql.sock user=root password=Aa123456.

[mysql] socket=/tmp/mysql.sock


**注意事项：**



#!/bin/bash


connName=${connName:-"ens160"}

注意事项：

[baseos] baseurl=https://mirrors.aliyun.com/centos-stream/\$stream/BaseOS/\$basearch/os/ gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-centosofficial gpgcheck=1 repo_gpgcheck=0 metadata_expire=6h countme=1 enabled=1

[baseos-debug] baseurl=https://mirrors.aliyun.com/centos-stream/\$stream/BaseOS/\$basearch/debug/tree/ gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-centosofficial gpgcheck=1 repo_gpgcheck=0 metadata_expire=6h enabled=0

[baseos-source] baseurl=https://mirrors.aliyun.com/centos-stream/\$stream/BaseOS/source/tree/ gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-centosofficial gpgcheck=1 repo_gpgcheck=0 metadata_expire=6h enabled=0

[appstream] baseurl=https://mirrors.aliyun.com/centos-stream/\$stream/AppStream/\$basearch/os/ gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-centosofficial gpgcheck=1 repo_gpgcheck=0 metadata_expire=6h countme=1 enabled=1

[appstream-debug] baseurl=https://mirrors.aliyun.com/centos-stream/\$stream/AppStream/\$basearch/debug/tree/ gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-centosofficial gpgcheck=1 repo_gpgcheck=0 metadata_expire=6h enabled=0

[appstream-source] baseurl=https://mirrors.aliyun.com/centos-stream/\$stream/AppStream/\$basearch/debug/tree/ gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-centosofficial gpgcheck=1 repo_gpgcheck=0 metadata_expire=6h enabled=0

[crb] baseurl=https://mirrors.aliyun.com/centos-stream/\$stream/CRB/\$basearch/os/ gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-centosofficial gpgcheck=1 repo_gpgcheck=0 metadata_expire=6h countme=1 enabled=0

[crb-debug] baseurl=https://mirrors.aliyun.com/centos-stream/\$stream/CRB/\$basearch/debug/tree/ gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-centosofficial gpgcheck=1 repo_gpgcheck=0 metadata_expire=6h enabled=0

[crb-source] baseurl=https://mirrors.aliyun.com/centos-stream/\$stream/CRB/source/tree/ gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-centosofficial gpgcheck=1 repo_gpgcheck=0 metadata_expire=6h enabled=0

[highavailability] baseurl=http://mirrors.aliyun.com/centos-stream/\$stream/HighAvailability/\$basearch/os/ gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-centosofficial gpgcheck=1 repo_gpgcheck=0 metadata_expire=6h countme=1 enabled=0

[highavailability-debug] baseurl=http://mirrors.aliyun.com/centos-stream/\$stream/HighAvailability/\$basearch/debug/tree/ gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-centosofficial gpgcheck=1 repo_gpgcheck=0 metadata_expire=6h enabled=0

[highavailability-source] baseurl=http://mirrors.aliyun.com/centos-stream/\$stream/HighAvailability/source/tree/ gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-centosofficial gpgcheck=1 repo_gpgcheck=0 metadata_expire=6h enabled=0

[nfv] baseurl=http://mirrors.aliyun.com/centos-stream/\$stream/NFV/\$basearch/os/ gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-centosofficial gpgcheck=1 repo_gpgcheck=0 metadata_expire=6h countme=1 enabled=0

[nfv-debug] baseurl=http://mirrors.aliyun.com/centos-stream/\$stream/NFV/\$basearch/debug/tree/ gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-centosofficial gpgcheck=1 repo_gpgcheck=0 metadata_expire=6h enabled=0

[nfv-source] baseurl=http://mirrors.aliyun.com/centos-stream/\$stream/NFV/source/tree/ gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-centosofficial gpgcheck=1 repo_gpgcheck=0 metadata_expire=6h enabled=0

[rt] baseurl=http://mirrors.aliyun.com/centos-stream/\$stream/RT/\$basearch/os/ gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-centosofficial gpgcheck=1 repo_gpgcheck=0 metadata_expire=6h countme=1 enabled=0

[rt-debug] baseurl=http://mirrors.aliyun.com/centos-stream/\$stream/RT/\$basearch/debug/tree/ gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-centosofficial gpgcheck=1 repo_gpgcheck=0 metadata_expire=6h enabled=0

[rt-source] baseurl=http://mirrors.aliyun.com/centos-stream/\$stream/RT/source/tree/ gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-centosofficial gpgcheck=1 repo_gpgcheck=0 metadata_expire=6h enabled=0

[resilientstorage] baseurl=http://mirrors.aliyun.com/centos-stream/\$stream/ResilientStorage/\$basearch/os/ gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-centosofficial gpgcheck=1 repo_gpgcheck=0 metadata_expire=6h countme=1 enabled=0

[resilientstorage-debug] baseurl=http://mirrors.aliyun.com/centos-stream/\$stream/ResilientStorage/\$basearch/debug/tree/ gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-centosofficial gpgcheck=1 repo_gpgcheck=0 metadata_expire=6h enabled=0

[resilientstorage-source] baseurl=http://mirrors.aliyun.com/centos-stream/\$stream/ResilientStorage/source/tree/ gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-centosofficial gpgcheck=1 repo_gpgcheck=0 metadata_expire=6h enabled=0

[extras-common] baseurl=http://mirrors.aliyun.com/centos-stream/SIGs/\$stream/extras/\$basearch/extras-common/ gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-SIG-Extras-SHA512 gpgcheck=1 repo_gpgcheck=0 metadata_expire=6h countme=1 enabled=1

[extras-common-source] baseurl=http://mirrors.aliyun.com/centos-stream/SIGs/\$stream/extras/source/extras-common/ gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-SIG-Extras-SHA512 gpgcheck=1 repo_gpgcheck=0 metadata_expire=6h enabled=0


**注意事项：**

注意事项：


**注意事项：**

注意事项：


**命令拆解：**

| 命令部分 | 重要程度 | 详细解释 |
|---|---|---|
| `/etc/security/limits.conf` | 【普通】 | 配置文件路径，命令会读取这个文件里的配置。 |

**注意事项：**