replication stopps

Hi, I set up a two-way replication server, it works very well, but after some hours (24-48) the replication stopps, the log-error only says: 030725 14:03:53 Slave I/O thread: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'FIRST' at position 4 030726 9:36:40 Slave

AW: WG: wait_timeout in my.cnf

Thanks a lot, that solved my problem! Moritz -Ursprüngliche Nachricht- Von: Egor Egorov [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 18. Juli 2003 10:16 An: [EMAIL PROTECTED] Betreff: Re: WG: wait_timeout in my.cnf On Wednesday 16 July 2003 16:10, Moritz Steiner wrote: Like

server doesn't take all options out of my.cnf

My problem is, that all variables except wait_timeout are initialized from the my.cnf file, only wait_timeout is always set to the standard value... Has anyone the same problem? Does somebody know how to resolve it? Moritz

AW: switch query logging while the server is running

Ok, but this only works for the current session, if I close and restart the client the settings are reset... -Ursprüngliche Nachricht- Von: Victoria Reznichenko [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 16. Juli 2003 11:19 An: [EMAIL PROTECTED] Betreff: Re: switch query logging

monitoring

How are you monitoring on your databases? Who has a good solution? Moritz

replication

I set up a replication with MySQL 4.0.13, it works very fine, but unfortunately only for several hours (between 10 and 30 hours) Has someone an idea why the replication stopps? Thanks, Moritz 030714 18:02:07 Slave I/O thread: connected to master '[EMAIL PROTECTED]:3306', replication

WG: wait_timeout in my.cnf

I set a lot of variables in the my.cnf file, all variables are set (I checked it with show variables) except of wait_timeout. If I set the option in MySQL with option wait_status=xxx it works. Does anybody know why this could happen? Thanks, Moritz -- MySQL General Mailing List For list

genereal query log

I want to turn on and off the general query log from time to time. Is there a possibility to do this without changing the my.cnf file and restarting the server. I thought for example set option log=ON Thanks, Moritz

mysqlhotcopy on innoDB

Does mysqlhotcopy work with innoDB? I only get it to work with MyISAM tables... For innoDB only the structure is saved but not the data Thanks for some answers, Moritz