Thanks. A cron job that runs mysqladmin that flushes the tables every 15 mins or so is now in place. A flush-only user has been created to do this.
I wonder if any negative impact for other databases could be expected at any point. -- Mark P. Hennessy [EMAIL PROTECTED] On Sat, 7 Sep 2002, Jeremy Zawodny wrote: > Date: Sat, 7 Sep 2002 11:20:27 -0700 > From: Jeremy Zawodny <[EMAIL PROTECTED]> > Reply-To: [EMAIL PROTECTED] > To: Mark Hennessy <[EMAIL PROTECTED]> > Cc: Jeremy Tinley <[EMAIL PROTECTED]>, [EMAIL PROTECTED] > Subject: Re: Master MySQL server rdist db to public MySQL servers > > On Fri, Sep 06, 2002 at 04:25:42PM -0400, Mark Hennessy wrote: > > > > Is there any way to just force the MySQL server to reload from the > > table data on disk? The recipient servers are read-only, and the > > sending server has a relatively infrequent rate of change, but just > > enough that it's important to make sure that things are flushed on > > the recipient servers every time there's an update. > > "FLUSH TABLES WITH READ LOCK" may do what you need. > > Jeremy > -- > Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! > <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ > > MySQL 3.23.51: up 32 days, processed 657,485,780 queries (234/sec. avg) > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
