MySQL Forums
Forum List  »  Performance

Re: Slow query
Posted by: Rick James
Date: April 24, 2015 05:22PM

Interesting. I do see a difference in the last line in the EXPLAINs. If imsi_ne is a big table, that would explain a big time difference.

However, that does not say why.

Please provide `SHOW CREATE TABLE dn_insi`.

Let me ask about that '\0\0\0\0hI'. Is this supposed to be some binary code? And you are stuffing it into a CHAR(9)? WHY??? BINARY(9) is designed for such.

I suspect the problem has to do with '\0\0\0\0hI' being only 8 characters. That leads to the question of what kind of padding will happen. I _think_ CHAR will be padded with spaces on either system, and work just fine. Note that BINARY will pad with \0, which is distinctly smaller than space.

If you can isolate a reasonably small test case that shows the different EXPLAINs, please post a bug report at http://bugs.mysql.com . They love to see cases where the new version degrades in performance.

Options: ReplyQuote


Subject
Views
Written By
Posted
2029
April 21, 2015 11:15AM
848
April 22, 2015 07:17AM
785
April 22, 2015 07:05PM
992
April 23, 2015 11:42PM
789
April 23, 2015 11:55PM
Re: Slow query
766
April 24, 2015 05:22PM
768
April 25, 2015 02:31AM
855
April 25, 2015 02:41AM
1477
April 25, 2015 05:22AM
823
April 25, 2015 10:42PM
797
May 13, 2015 03:30AM
877
April 28, 2015 03:40AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.