目录

MySQL

Installation

percona mysql server

https://www.percona.com/doc/percona-server/LATEST/installation.html#installing-from-binaries

Usage

允许远程访问

GRANT ALL PRIVILEGES ON db.* TO 'root'@'host' IDENTIFIED BY 'password';

修改密码

-- SET GLOBAL validate_password_policy=LOW;
SET PASSWORD = PASSWORD('your password');

Optimization

MySQL CPU 占用率高

使用以下命令查询当前的 SQL 查询:

SHOW FULL processlist;