|List:||General Discussion||« Previous MessageNext Message »|
|From:||Ian Collins||Date:||July 7 2007 8:09pm|
|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.
|• LOW_PRIORITY_UPDATES||Ian Collins||7 Jul|
|• Re: LOW_PRIORITY_UPDATES||Paul DuBois||8 Jul|