Recently found strange behavior of InnoDB DB. When exlpain for heavy query show me different number of rows in table.
Sometimes difference more than 2-3 times.
Also sql optimzer don`t use some indexes, which can be used for this query.
Sometimes query hangup with “copying to tmp table” status.
How i can fix this?
OS Debian 4.0 i386.