mysql5.7.21的配置文件my.cnf_my.cnf5.7模板-CSDN博客

本文链接：https://blog.csdn.net/qq_17040587/article/details/129175134

场景：好多次通过docker安装mysql，做了文件映射（通常数据文件映射日志文件映射配置文件映射）。当我们启动mysql的容器，发现起不来，所有映射目录竟然没有文件。这里提供一个mysql5.7.21的配置文件。仅供参考.具体的参数以自己实际场景为准。

配置文件常用解释参数：

# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html

[mysqld]
#
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
#
# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin
#
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
#accept A or a
lower_case_table_names=1
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
#skip-grant-tables

改进质量增加个tip

赋值运算

以下假设变量a为5，变量b为11：

运算符	描述	实例
=	简单的赋值运算符	c = a + b 将 a + b 的运算结果赋值为 c
+=	加法赋值运算符	c += a 等效于 c = c + a
-=	减法赋值运算符	c -= a 等效于 c = c - a
*=	乘法赋值运算符	c = a 等效于 c = c a
/=	除法赋值运算符	c /= a 等效于 c = c / a
%=	取模赋值运算符	c %= a 等效于 c = c % a
**=	幂赋值运算符	c = a 等效于 c = c a
//=	取整除赋值运算符	c //= a 等效于 c = c // a
:=	海象运算符，可在表达式内部为变量赋值。Python3.8 版本新增运算符。	避免重复

ast = "abc"
if (n := len(ast)) > 10:
    print(f"List is too long ({n} elements, expected <= 10)")
else :
    print(f"List is OK ({n} elements, expected <= 10)")

List is OK (3 elements, expected <= 10)

a = 11
b = 5
c = 0

c = a + b
print("1 - c 的值为：", c)
#16

c += a
print("2 - c 的值为：", c)
#27

c *= a
print("3 - c 的值为：", c)
#297

c /= a
print("4 - c 的值为：", c)
#27.0

c = 2
c %= a
print("5 - c 的值为：", c)
#2

a=5
c **= a
print("6 - c 的值为：", c)
# 32

c //= a
print("7 - c 的值为：", c)
#6

1 - c 的值为： 16
2 - c 的值为： 27
3 - c 的值为： 297
4 - c 的值为： 27.0
5 - c 的值为： 2
6 - c 的值为： 32
7 - c 的值为： 6