MySQL Variables max_write_lock_count 数据库 参数变量解释及正确配置使用

本站中文解释

max_write_lock_count参数是MySQL中的写锁参数，用于控制MySQL在获取写锁时可以失败的次数。当写入操作多于max_write_lock_count时，MySQL会降低写锁的竞争，以提高写入性能。如果你的MySQL应用程序经常遇到长时间的写锁，你可以使用该参数来调整写锁的持续时间，以避免系统出现“死锁”情况。该参数的默认值为18，你可以通过设置“SET GLOBAL max_write_lock_count = n;”命令的方式来修改它的值，并将它的值设置为需要的值。

官方英文解释

max_write_lock_count

After this many write locks, permit some pending read lock
requests to be processed in between. Write lock requests have
higher priority than read lock requests. However, if
max_write_lock_count is set
to some low value (say, 10), read lock requests may be
preferred over pending write lock requests if the read lock
requests have already been passed over in favor of 10 write
lock requests. Normally this behavior does not occur because
max_write_lock_count by
default has a very large value.