Hi Chris,
I have run into this myself before as well, where the partition housing
the bin log filled up. In our case, there weren't failed queries on the
master; the integrity of data on the master was fine, and the slave was
simply out of date, but not error-full. However, even in that case (
I have a similar problem to this..
What happens is somehow something is causing mysql to hang which forces
it to reach max connections.. if i shutdown and restart mysql using
safe_mysqld --skip=networking it starts fine.. will do selects fine but
not inserts because the tables that were being in
Shut down the server before repairing tables.
Robert Clugston wrote:
> List,
> I'm having some serious problems with MySQL. I have some PHP and perl
> scripts that do INSERTs into MySQL. Multiple times during the day various
> tables become corrupted.
> Repairing the table using myisamch
List,
I'm having some serious problems with MySQL. I have some PHP and perl
scripts that do INSERTs into MySQL. Multiple times during the day various
tables become corrupted.
Repairing the table using myisamchk with "-r" usually fixes the problem,
but sometimes I have to restart mysqld to
