MySQL
- https://dev.mysql.com/doc/refman/5.6/ja/func-op-summary-ref.html
- https://dev.mysql.com/doc/refman/8.0/ja/mysqlpump.html
- https://downloads.mysql.com/docs/sakila-db.tar.gz
- https://planetscale.com/
- https://hub.docker.com/_/mysql
- https://www.percona.com/doc/percona-toolkit/LATEST/pt-query-digest.html
explain
import
general log
コンテナの general_log を tail -f する。
$ set u user
$ set p password
$ set n container_name
$ docker exec -it $n bash -c "mysql -u$u -p$p -e \"SET GLOBAL general_log = 'ON';\" 2>/dev/null && echo \"SELECT @@GLOBAL.general_log_file;\" | mysql -u$u -p$p -N 2>/dev/null"
/var/lib/mysql/xxxx.log
$ docker exec -it $n tail -f /var/lib/mysql/xxxx.log