List:General Discussion« Previous MessageNext Message »
From:Ian Collins Date:July 7 2007 8:09pm
Subject:LOW_PRIORITY_UPDATES
View as plain text  
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.

Cheers,
Ian.



Thread
LOW_PRIORITY_UPDATESIan Collins7 Jul
  • Re: LOW_PRIORITY_UPDATESPaul DuBois8 Jul