Re: On fighting with master-slave replication lag

2008-12-24 Thread Baron Schwartz
On Wed, Dec 24, 2008 at 2:31 AM, Jake Maul wrote: > Slightly more complicated (and also probably more accurate- the time > reported by show slave status is known to be unreliable in some cases) > would be a script that inserts a row into a table, then check the > slave over and over till it arrive

Question on returning multiple rows from a stored procedure into a session variable

2008-12-24 Thread Vikram Vaswani
Hi Is there a way to write a stored procedure that returns a result set containing multiple rows? More specifically, I'm trying to return the multi-row result set as an OUT parameter, which I can then access via a session variable. If this is possible, could someone direct me to the appropria

RE: On fighting with master-slave replication lag

2008-12-24 Thread 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 Wed, Dec 24, 2008 at 2:31 AM, Ja

RE: On fighting with master-slave replication lag

2008-12-24 Thread xufeng
Hi All On http://www.nagiosexchange.org/cgi-bin/search.cgi?d=1&query=check_mysql&Go=Go I found some useful scripts to do the work and there are some scripts that do the work as you have described. The most important lesson I have learned is to know how theses various tools achieve the goals (not on