====== MySQL ======

===== Installation =====

==== percona mysql server ====

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

===== Usage =====

**允许远程访问**

<code sql>
GRANT ALL PRIVILEGES ON db.* TO 'root'@'host' IDENTIFIED BY 'password';
</code>

**修改密码**

<code sql>
-- SET GLOBAL validate_password_policy=LOW;
SET PASSWORD = PASSWORD('your password');
</code>

===== Optimization =====

==== MySQL CPU 占用率高 ====

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

<code sql>
show full processlist;
</code>