Date: Friday, January 25, 2008 08:07:32 AM -0500
From: Paul Berry [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Subject: mysql - debug connections dropping/not accepted
hey guys - overnight our sql server apparantly got hit hard, and
started dropping connections
it was restarted
hey guys - overnight our sql server apparantly got hit hard, and started
dropping connections
it was restarted and now this morning even though its showing 0 processes
running, seems
completely healthy on all tests, mysqld restarted with no sign of problems -
none of the
web servers can connect to
thanks - i think i'm ok because
i get these results
mysql show slave status;
Empty set (0.00 sec)
On 1/18/08, Saravanan [EMAIL PROTECTED] wrote:
Hi,
will removing the master.info help instead of executing change master?
or
stop slave;
reset master;
--- On Sat, 1/19/08, Paul Berry
check time in master and slave servers?
saravanan
--- On Sat, 1/19/08, Paul Berry [EMAIL PROTECTED] wrote:
From: Paul Berry [EMAIL PROTECTED]
Subject: another slave loading question
To: MySql mysql@lists.mysql.com
Date: Saturday, January 19, 2008, 7:56 AM
i have this State when I start
hi guys, quick question
how do i undo a CHANGE MASTER TO command and make it a master of itself
again?
thanks
i have this State when I start a slave: Has read all relay log; waiting for
the slave I/O thread to update it
mysql show processlist;
++-+---+---+-+--+---+--+
| Id | User
i ended up doing this - it seems to have worked fine
STOP SLAVE;
SHOW SLAVE STATUS;
CHANGE MASTER TO
MASTER_HOST='',
MASTER_PORT=0,
MASTER_USER='',
MASTER_PASSWORD='';
RESET MASTER;
On 1/18/08, Paul Berry [EMAIL PROTECTED] wrote:
hi guys, quick question
how do i undo a CHANGE
hey guys - is it possible to have a lightweight slave setup? so that you
only take X amount of tables from the DB
curious what good solutios are out there
hi there, sorry if this email doesn't follow policy correctly, its my first
post here.
we had a master/slave setup between 2 servers and 98% of the data seems to
have moved correctly, but there is a seemingly random 2% that didn't arrive
in the right way. for example records with a higher ID are