Announcement

Announcement Module
Collapse
No announcement yet.

InnoDB problem

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • InnoDB problem

    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.

  • #2
    DoktorPZ wrote on Sat, 15 December 2007 05:19

    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.

    DoktorPZ wrote on Sat, 15 December 2007 05:19


    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.

    Comment

    Working...
    X