Re: How to see why client got blocked

2006-05-08 Thread Dominik Klein
sheeri kritzer schrieb: If your server has log-warnings set to ON, you can check the error logs, and use a script to count how many times for each host, in a row, this happens. +---+---+ | Variable_name | Value | +---+---+ | log_warnings | 1 | I did not tur

Re: How to see why client got blocked

2006-05-05 Thread sheeri kritzer
If your server has log-warnings set to ON, you can check the error logs, and use a script to count how many times for each host, in a row, this happens. -Sheeri On 5/5/06, Kishore Jalleda <[EMAIL PROTECTED]> wrote: On 5/5/06, Dominik Klein <[EMAIL PROTECTED]> wrote: > I experience that my slave

Re: How to see why client got blocked

2006-05-05 Thread Kishore Jalleda
On 5/5/06, Dominik Klein <[EMAIL PROTECTED]> wrote: I experience that my slave gets blocked after a while (a couple of slave stop and slave start happen in the meantime). In errorlog I see Slave I/O thread: error reconnecting to master '[EMAIL PROTECTED]:3306': Error: 'Host 'myhost.mydomain.de'

Re: How to see why client got blocked

2006-05-05 Thread Dominik Klein
another question on this error message: is it possible to see the count of errors for each host from some table or file? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]