diff options
-rwxr-xr-x | syncshadowdb | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/syncshadowdb b/syncshadowdb index b4ba58bd2..e19e30cfc 100755 --- a/syncshadowdb +++ b/syncshadowdb @@ -32,6 +32,7 @@ require "defparams.pl"; sub sillyness { my $zz; + $zz = $::db; $zz = $::dbwritesallowed; } @@ -188,6 +189,13 @@ if ($syncall) { Verbose("Looking for commands to execute."); $::dbwritesallowed = 1; + +# Make us low priority, to not block anyone who is trying to actually use +# the shadowdb. Note that this is carefully coded to ignore errors; we want +# to keep going even on older mysqld's that don't have the +# SQL_LOW_PRIORITY_UPDATES option. +$::db->query("SET OPTION SQL_LOW_PRIORITY_UPDATES = 1"); + while (1) { SendSQL("SELECT id, command FROM $shadowtable WHERE reflected = 0 " . "ORDER BY id LIMIT 1"); |