MySQLのログ

mysql_tips.md

General LOG

my.cnf

[mysqld]
general_log_file = /var/log/mysql/general.log
general_log=1

log-slow-queries = /var/log/mysql/slow_query.log
long_query_time = 0.5

mysqlコマンド

> SET GLOBAL general_log='on';
> SHOW VARIABLES LIKE 'general_log%';

> show variables like 'slow%';
> show variables like 'long%';
> SET GLOBAL long_query_time=1;
> SET @@GLOBAL.long_query_time = 1;
> SET GLOBAL slow_query_log=ON;
> SET @@GLOBAL.slow_launch_time = 1;
> SET GLOBAL slow_launch_time=1;

注意 以下の三つは別の値を参照する

> SHOW SESSION VARIABLES LIKE "long_query_time";
> SHOW GLOBAL VARIABLES LIKE "long_query_time";
> SHOW VARIABLES LIKE "long_query_time";
> 

参考

MariaDB on macOS

logは /usr/local/var/mysql

DB creation

CREATE DATABASE dabase_name CHARACTER SET utf8mb4;

User creation

<MySQL 5.*, MariaDB

CREATE USER 'user1'@'%' IDENTIFIED BY 'password1';

GRANT ALL PRIVILEGES ON database1.* TO 'user1'@'%' IDENTIFIED BY 'password1';
GRANT ALL PRIVILEGES ON database1.* TO 'user1'@localhost IDENTIFIED BY 'password1';


FLUSH PRIVILEGES;

MySQL 8.*<

CREATE USER 'user1'@'%' IDENTIFIED BY 'password1';

GRANT ALL PRIVILEGES ON `database1`.* TO 'user1'@'%';
GRANT ALL PRIVILEGES ON `database1`.* TO 'user1'@localhost;

5.6では違う模様