Hi
I have a simple replication service, “show slave status” shows that the
Exec_Master_Log_Pos is smaller than it’s correct value occasionally, why?
Mysql version: 5.1.53
Regards,
Zhigang
Same as this bug report:
http://bugs.mysql.com/bug.php?id=25713
Please tell me why?
Regards
Zhigang
_
From: Zhigang Zhang [mailto:zzgang2...@gmail.com]
Sent: Tuesday, March 18, 2014 4:04 PM
To: 'mysql@lists.mysql.com'
Subject: Exec_Master_Log_Pos is smaller than it's cor
Hi list,
I'd like to get your advice about precedence in where clauses in MySQL
(5.0.51, and 5.1.66 in this case / from lenny and squeeze Debian
packages ).
Considering the following simple query :
SELECT * FROM Status WHERE DWProcessed = 0 AND PreviousStatus NOT IN
('PENDING', 'ACCEPTED') AND S
My advice to you is to make use of the EXPLAIN facility which
porovides the most accurate information about how MySQL is going to
treat your query.
Also, as you currently have it, the expression DATE_SUB(NOW(),
INTERVAL 24 is going to be executed once for every single candidate
row. I would sugge