MySQL Variables low_priority_updates 数据库 参数变量解释及正确配置使用
本站中文解释
low_priority_updates参数变量决定了在一个写入操作进行时,是否将其设定成低优先级操作,从而允许其他客户端正常读写数据。该参数变量默认为关闭,可以通过设置它的值为”ON“,或”OFF“来控制它。 如何设置: 如果要开启low_priority_updates参数,使用以下语句: set global low_priority_updates=1; 如果要关闭low_priority_updates参数,使用以下语句: set global low_priority_updates=0; 完成设置后,需要运行下面的语句,以使设置立即生效: flush privileges;
官方英文解释
low_priority_updates
Command-Line Format | --low-priority-updates[={OFF|ON}] |
---|---|
System Variable | low_priority_updates |
Scope | Global, Session |
Dynamic | Yes |
Type | Boolean |
Default Value | OFF |
If set to 1
, all
INSERT
,
UPDATE
,
DELETE
, and LOCK TABLE
statements wait until there is no pending
WRITE
SELECT
or LOCK TABLE
on the affected table. The same effect can be
READ
obtained using {INSERT | REPLACE | DELETE | UPDATE}
to lower the priority of only one
LOW_PRIORITY ...
query. This variable affects only storage engines that use
only table-level locking (such as MyISAM
,
MEMORY
, and MERGE
). See
Section 8.11.2, “Table Locking Issues”.