Re: On fighting with master-slave replication lag

2008-12-25 Thread Baron Schwartz
2008/12/24 xufeng : > > >> -Original Message- >> From: baron.schwa...@gmail.com [mailto:baron.schwa...@gmail.com] On Behalf >> Of Baron Schwartz >> Sent: 2008年12月24日 22:06 >> To: Jake Maul >> Cc: mysql@lists.mysql.com >> Subject: Re: On fighting with master-slave replication lag >> >> On We

Question on default database for stored functions

2008-12-25 Thread Vikram Vaswani
Hi According to the MySQL manual, "By default, a routine is associated with the default database.When the routine is invoked, an implicit USE db_name is performed (and undone when the routine terminates)" However, when I tried accessing a stored routine from another database, I received an e

Re: On fighting with master-slave replication lag

2008-12-25 Thread Andy Shellam
Xu, Slightly off-topic, but you might also want to look at your DNS set up as you're not capable of receiving e-mails: --- This message was created automatically by mail delivery software. A message that you sent could not be delivered to one or more of its recipients. This is a permanent error.

Re: On fighting with master-slave replication lag

2008-12-25 Thread Andy Shellam
Hi Xu, The check_mysql plugin is part of the standard plugins package (see the downloads page at http://www.nagios.org/download/download.php.) At a very minimum this plugin will check that the slave's SQL thread is running and compare the number of seconds it is behind the master, allowing you to