found in the slave. Therefore, I
> > would like to monitor and send out an email or alert whenever it is
> > down.
> >
> >
> >
> > Every so often, I would logon to MySQl and issue this command: "SHOW
> > SLAVE STATUS". I would like to autom
; method for monitoring replication in MySQL. Recently, my replication
> stopped as a result of duplicate row found in the slave. Therefore, I
> would like to monitor and send out an email or alert whenever it is
> down.
>
>
>
> Every so often, I would logon to MySQl and issue this
often, I would logon to MySQl and issue this command: "SHOW
SLAVE STATUS". I would like to automate this process. I would like to
parse the output of this command and look pertinent info such as
"seconds_behind_master" < 10. If it greater than 10, then I'll send out
an em
Hm. Running on 4.1.21 seems to have a 'feature' where SHOW SLAVE
STATUS blocks when the disk is full. Thoughts?
Kevin
--
Founder/CEO Tailrank.com
Location: San Francisco, CA
AIM/YIM: sfburtonator
Skype: burtonator
Blog: feedblog.org
Cell: 415-637-8078
--
MySQL General Mailin
at this script from my website, and it should help you to get started right
away .
http://kjalleda.googlepages.com/checkingmysqlslavestatus
Kishore Jalleda
On 6/14/06, Jacek Becla <[EMAIL PROTECTED]> wrote:
Hi,
I'm trying to find how to split the output from SHOW SLAVE
Hi,
I'm trying to find how to split the output from SHOW SLAVE STATUS
into individual fields. Specifically, I would like to be able to
do in a stored function:
1) determine what the status of slave is, and if it is
"Waiting for master to send event", do some action,
like s
string values by #0 terminator."
It's seems , are least that is what MYDAC support told me, that
"MySQL API function mysql_fetch_field_direct returns Field.Length = 14 for
Slave_IO_state field."
while the field should be bigger.
So, the field Slave_IO_State, returned by 'sh
"AESYS S.p.A. [Enzo Arlati]" <[EMAIL PROTECTED]> wrote on 01/11/2006
03:00:37 AM:
>
> I found out that when I run a query like 'show slave status' mysql I get
> wrong size of the data field.
>
> The component I using to read the field are using the
I found out that when I run a query like 'show slave status' mysql I get
wrong size of the data field.
The component I using to read the field are using the field length by the db
to allocate the space for data, so the mismatch cause the read of truncated
data.
Is this bug already kno
answer to Mr Ikar, hoping to have more detail on
this topic.
-Messaggio originale-
Da: Gleb Paharenko [mailto:[EMAIL PROTECTED]
Inviato: martedì 27 dicembre 2005 17.13
A: mysql@lists.mysql.com
Oggetto: Re: field truncate trying to using 'show slave status'
Hello. > Is this a l
Hello.
> The info returned by 'show slave status' are available in some table,
>when I can retrieve data using normal select statement ?
As far as I know - not.
AESYS S.p.A. [Enzo Arlati] wrote:
> Normal query , the one started with the select statement
Normal query , the one started with the select statement works well, so I'm
thinking about a workaround if possible.
The info returned by 'show slave status' are available in some table, when I
can retrieve data using normal select statement ?
regards, Enzo
-Messaggio or
ponent, which seems to work well
> enough.
> I got a problem when I tried to load the resultset returned by a query like
> 'show slave status'.
> In this case some of the fields are truncated.
> As example the first field named 'Slave_IO_State' should have
I'm using mysql 5.0.15 on windows 2000.
I connect to database using MYDAC component, which seems to work well
enough.
I got a problem when I tried to load the resultset returned by a query like
'show slave status'.
In this case some of the fields are truncated.
As example the fi
t;[EMAIL PROTECTED]> wrote:
> Hi! I never saw a follow-up to the post about SHOW SLAVE STATUS
> hanging while LOAD DATA FROM MASTER is running as of about 4.0.20 on.
> (<http://lists.mysql.com/mysql/167238>)
>
> Is this a known bug? Or a feature?
>
> thanks!
Hi! I never saw a follow-up to the post about SHOW SLAVE STATUS
hanging while LOAD DATA FROM MASTER is running as of about 4.0.20 on.
(<http://lists.mysql.com/mysql/167238>)
Is this a known bug? Or a feature?
thanks!
chris
--
MySQL General Mailing List
For list archives
While doing a "Load table from master", "show slave status"
will hang (like it is locked, but processlist will not show
it as locked) on MySQL 4.0.20... is this a bug or a feature?
I don't remember earlier versions doing this.
Also: I still experience mysql crashes
Solved issue.
Sorry. Connection was connecting to Master not slave...
Hence... Master possessed no Slave Status information.
_A
"Deduction, dear Watson..."
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTE
>From a Java connection object, Show Slave Status returns no rows
Running mysql on linux.
Also testing the SQL through mysql control center 0.8.9
Thanks,
Andy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EM
>Description:
Access denied errores, for the replication user, are not reported in:
SHOW SLAVE STATUS;
They show all relevant information, and queries like:
CHANGE MASTER TO
report no error.
Subsequent LOAD TABLE % FROM MASTER queries, hang indefinet
What permissions do you need to have to issue a show slave status
command?
Thanks,
database,sql,query,table
--
Michael Eklund
System Administrator
Netmechanic, Inc.
[EMAIL PROTECTED]
http://www.netmechanic.com
-
Before
What permissions do you need to have to issue a show slave status
command?
Thanks,
database,sql,query,table
--
Michael Eklund
System Administrator
Netmechanic, Inc.
[EMAIL PROTECTED]
http://www.netmechanic.com
22 matches
Mail list logo
