InnoDB problem

[DoktorPZ]

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.

[scoundrel]

[B]DoktorPZ wrote on Sat, 15 December 2007 05:19[/B]

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.

This is normal. Innodb has no precise information about your tables sizes.

[B]DoktorPZ wrote on Sat, 15 December 2007 05:19[/B]

Also sql optimzer don`t use some indexes, which can be used for this query. Sometimes query hangup with “copying to tmp table” status.

It is hard to say, what is wrong, but 99% that it is your query/indexes problem, not innodb problem So, show us your table, indexes, query, explain and we’ll try to help.