Problem with "opening tables"

2007-02-14 Thread mark_round
Hi all, I have a serious problem with MySQL 4.1.22 on Solaris 9, SPARC. I have a database server with around 10 or so databases, each with roughly 20-50 tables. At fairly consistent intervals, MySQL gets stuck with 100s of queries in the "Opening tables" state. I have checked the value of my Open_

RE: Problems with replication restarting

2004-12-20 Thread mark_round
So this would imply that you cannot simply stop/start a slave server - instead, I would need to write a wrapper script that stops the slave using "STOP SLAVE", and at next startup, read the master.info file to find out where it left off, and then issue a "CHANGE MASTER TO..." statement to continue

Problems with replication restarting

2004-12-20 Thread mark_round
Hi all, I originally posted this to the replication list, but as I haven't yet received a response, I thought I'd try my luck here... I'm having some troubles with replication, in particular restarting a slave. I'm using MySQL 4.0.22 for the slave, and 4.0.21 as the master. I've followed the inst