Hi. I recently update my servers from 3.23.29 to 3.23.51 version.
Replication alwais works fine. Now, when I send show processlist command to slave, this is the response: +------+-------------+-----------+------+---------+------+-----------------------+------------------+ | Id | User | Host | db | Command | Time | State | |Info | +------+-------------+-----------+------+---------+------+-----------------------+------------------+ | 1 | system user | none | NULL | Connect | 664 | Reading master update | |NULL | | 4377 | root | localhost | biz | Query | 0 | NULL | |show processlist | +------+-------------+-----------+------+---------+------+-----------------------+------------------+ 2 rows in set (0.00 sec) The system user time used by replication always starts at 664 seconds (0 must be correct). The intervals are correct. Two seconds more without replication updates and Show processlist says: +------+-------------+-----------+------+---------+------+-----------------------+------------------+ | Id | User | Host | db | Command | Time | State | |Info | +------+-------------+-----------+------+---------+------+-----------------------+------------------+ | 1 | system user | none | NULL | Connect | 664 | Reading master update | |NULL | | 4377 | root | localhost | biz | Query | 0 | NULL | |show processlist | +------+-------------+-----------+------+---------+------+-----------------------+------------------+ 2 rows in set (0.00 sec) Correct! And in new update, Show processlist says: +------+-------------+-----------+------+---------+------+-----------------------+------------------+ | Id | User | Host | db | Command | Time | State | |Info | +------+-------------+-----------+------+---------+------+-----------------------+------------------+ | 1 | system user | none | NULL | Connect | 664 | Reading master update | |NULL | | 4377 | root | localhost | biz | Query | 0 | NULL | |show processlist | +------+-------------+-----------+------+---------+------+-----------------------+------------------+ 2 rows in set (0.00 sec) Incorrect again. All the servers are updated to 3.23.51 and replication works fine excepts this. Any sugestion?. Sorry for my limited English. Javier. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
