- It uses the aggregate function LAST_VALUE to determine where to start a scan when a table is scanned using multiple (fast) queries rather than one slow query.
- It uses the aggregate functions UNORDERED_CHECKSUM and ORDERED_CHECKSUM to compute checksums.
ZFS would detect this error as it stores a page checksum separate from the disk page. RAID 10 might help. If writes for one of the copies was lost, then as long as your are lucky enough to read the page from the good side of the mirror, you will get the good data. But that might not be comforting. What else would help to detect and or correct this?

4 comments:
Mark,
Very interesting. What filesystem and RAID hardware versions are you using?
SW RAID 0. But if this is a misdirected write I will blame the disk.
On a sidenote, what does InnoDB do when you look up the row by the secondary index? Does it catch this at all, like chuck an error because it can't complete the PK lookup from the PK value in the secondary index?
Innodb does index only, so when we scanned only the secondary index we got the desired data. If a query then went back to the PK from there, I think we got a core file.
Post a Comment