MySQL 数据库

MySQL 是最流行的开源关系型数据库之一。本文记录 MySQL 的运维与调优经验。

安装与配置

# CentOS/RHEL
yum install mysql-server

# Ubuntu/Debian
apt install mysql-server

mysql_secure_installation

[mysqld]
innodb_buffer_pool_size = 2G
innodb_log_file_size = 256M
max_connections = 500
query_cache_size = 0

SHOW GLOBAL STATUS LIKE 'Threads%';
SHOW GLOBAL STATUS LIKE 'Innodb%';

SHOW PROCESSLIST;
SHOW STATUS LIKE 'Threads_connected';

SET GLOBAL slow_query_log = 'ON';
SET GLOBAL long_query_time = 1;