Not the answer you need?
Register and ask your own question!
Many Forum changes were implemented on Tue 22 Sep. Read about new Ranks, Scoring, and Reactions.
Email [email protected] for any comments or concerns.

InnoDB problem

DoktorPZDoktorPZ EntrantCurrent User Role Beginner
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.

Comments

  • scoundrelscoundrel Contributor Inactive User Role Beginner
    <table border="0" align="center" width="90%" cellpadding="3" cellspacing="1"><tr><td class="SmallText">DoktorPZ wrote on Sat, 15 December 2007 05:19</td></tr><tr><td class="quote">
    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.

    </td></tr></table>

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

    <table border="0" align="center" width="90%" cellpadding="3" cellspacing="1"><tr><td class="SmallText">DoktorPZ wrote on Sat, 15 December 2007 05:19</td></tr><tr><td class="quote">

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

    </td></tr></table>

    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.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.