replication stopps

2003-07-28 Thread Moritz Steiner 
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 I/O thread exiting, read up to log 'log-bin.002',
position 283
 
Does anybody know how to prevent this accidentally stopping?
 
Moritz

AW: WG: wait_timeout in my.cnf

2003-07-18 Thread Moritz Steiner 
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 this:

 # The number of seconds the server waits for activity on a connection
 # before closing it
 wait_timeout=   300

Set interactive_timeout=300, too.


 -Urspr?ngliche Nachricht-
 Von: Egor Egorov [mailto:[EMAIL PROTECTED]
 Gesendet: Mittwoch, 16. Juli 2003 09:55
 An: [EMAIL PROTECTED]
 Betreff: Re: WG: wait_timeout in my.cnf

 Moritz Steiner [EMAIL PROTECTED] wrote:
  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.

 How did you set the wait_timeout variable?



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

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

2003-07-17 Thread Moritz Steiner 
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

2003-07-16 Thread Moritz Steiner 
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 while the server is running

[EMAIL PROTECTED] wrote:
Description:
 It would be nice if general query logging could be switched on and off
 while the MySQL server is running, and not only at startup time.
 While debugging an application that uses foreign database access
 libraries, this would be very helpful. One could switch on logging,
 perform an activity, switch off logging, and look what has happened.
 Otherwise, the server has to be restarted to change logging, which
 is a bit annoying...
How-To-Repeat:
 mysql show variables like 'log';
 +---+---+
 | Variable_name | Value |
 +---+---+
 | log   | ON|
 +---+---+
 1 row in set (0.00 sec)
 
 mysql set log off;
 ERROR 1193: Unknown system variable 'log'
 mysql set session log off;
 ERROR 1193: Unknown system variable 'log'
 mysql

This variable is called SQL_LOG_OFF. Please, read the manual:
http://www.mysql.com/doc/en/SET_OPTION.html


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.com





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

monitoring

2003-07-16 Thread Moritz Steiner 
 
How are you monitoring on your databases? Who has a good solution?
 
Moritz

replication

2003-07-15 Thread Moritz Steiner 

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 started in log 'FIRST' at position 4

030715 13:40:55  Slave I/O thread exiting, read up to log 'log-bin.003',

position 388

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

WG: wait_timeout in my.cnf

2003-07-15 Thread Moritz Steiner 

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 archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

genereal query log

2003-07-15 Thread Moritz Steiner 
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

2003-07-14 Thread Moritz Steiner 
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