At 10:09 PM +0200 7/7/07, Ian Collins wrote:
Hi,
I am seeing a large lock contention on a production database (A large table_locks_waited against table_locks_immediate). I want to set low priority updates, but I don't want to shut the database down to do it.

Is,
set global LOW_PRIORITY_UPDATES=1;

the same as starting mysql with --low_priority_updates?
I think it is but want confirmation.

It's the same.

--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to