From 16ea7e0fe44a8f3ee25e0ca84f4aa15ed62a5d72 Mon Sep 17 00:00:00 2001
From: "terry%mozilla.org" <>
Date: Tue, 21 Mar 2000 03:25:56 +0000
Subject: Make the syncing process low priority, so that we won't hang up
 shadowdb operations.

---
 syncshadowdb | 8 ++++++++
 1 file changed, 8 insertions(+)

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");
-- 
cgit v1.2.3-24-g4f1b