*very* long timeout for 'slave stop io_thread'

2005-12-22 Thread Irek Słonina
thing to cure this situation. Best Regards, Irek Slonina -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: no 3306 but mysqld running

2005-06-07 Thread Irek Słonina
you have the same option in your mysql config. regards, Irek Słonina -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: replication errors

2005-03-10 Thread Irek Słonina
ting the same queries that slave does - if an error exists on slave then it first comes up on the master and master is not executing it either. You prove that I was wrong... now I must check the integrity of the data on my slaves, which all are running with slave skip errors turned on :/. -- Irek Slo

Re: replication errors

2005-03-10 Thread Irek S?onina
fer to the manual for an extensive description. -- Irek Slonina -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Replication from multiple masters to one slave

2005-03-04 Thread Irek Słonina
very grateful for a help. -- Irek Słonina -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

minimal privileges for a replication slave

2004-12-27 Thread Irek Slonina
REPLICATION SLAVE can be set only globally, to all databases... I would be very thankful for a help Regards, Irek Slonina -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Force slave to connect from specified IP

2004-09-15 Thread Irek Slonina
I need similiar behaviour like: ping -I 10.10.10.1 192.168.168.168 I have tried to bind mysqld only to 10.10.10.1:3336 by bind-address option but that does not make the thing. I would be very thankful for any hints, for now I will try to redirect this with firewall. Regards, Irek Slonina -- MySQL G

slave death during transfer

2004-06-17 Thread Irek Slonina
"slave start" and so on for all off the slaves and the loop is starting again with remembered values of binlogname and binlogpos after each "slave stop". -- Irek Slonina -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

grepping data from show processlist in more elegant way

2004-06-17 Thread Irek Slonina
processes() output for a string "Has read all relay log; waiting for the I/O slave thread to update it" but it is not too elegant, is there a way to do it in more elegant way? Or maybe mysql do not permit to do "slave stop" before the end of transmission? -- Irek Slonina -- MyS

UNION + SQL_CACHE: How to do that ?

2003-02-20 Thread Irek
Hello, I have two questions: 1) How to write my query with SQL_CACHE and UNION ? UNION work with SQL_CACHE ? A) SELECT SQL_CACHE UNION SELECT SQL_CACHE or B) SELECT SQL_CACHE UNION SELECT 2) How to write my

Red Hat 6.2 and kernel 2.2.14 and mysql 3.23.42

2001-10-04 Thread irek
Hi everybody ! I have Red Hat 6.2 and kernel 2.2.14. I installed mysql server 3.23.42 from rpms. Shall i recompile my kernel to the newest version ?? I heard, that kernel 2.2.14 have serious problem on hevy loaded system = using mysql 3.23.42 . Please, answer this questions. regards I. Piasec