my.cnf

[mysqld]
user=mysql
skip-host-cache
skip-name-resolve
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
secure-file-priv=/var/lib/mysql-files
pid-file=/var/run/mysqld/mysqld.pid
bind_address=0.0.0.0
max_connections=144
max_user_connections=144
default-authentication-plugin=mysql_native_password
character-set-server=utf8mb4
collation-server=utf8mb4_unicode_ci
sql_mode= STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
symbolic-links=0
max_allowed_packet=128M
key_buffer_size=64M
old_passwords=0
general_log=1
general_log_file=/var/log/mysql_all.log
long_query_time=1

innodb_buffer_pool_size=2048M
innodb_log_file_size=1024M
innodb_log_buffer_size=1024M
innodb_file_per_table=ON
innodb_flush_method=O_DIRECT
innodb_flush_log_at_trx_commit=1
innodb_force_recovery=1
query_cache_size=0
thread_cache_size=128

[mysqldump]
quick
quote-names
max_allowed_packet=16M

mysql.dockerfile

FROM mysql:5.7.32

COPY conf /etc/mysql/conf.d

RUN chmod 0444 /etc/mysql/conf.d/*.cnf

RUN touch /var/log/mysql/mysql_slow_query.log