Re: Locking issue in innodb select query
Posted by:
Rick James
Date: August 03, 2013 09:11AM
> every after 15 minutes and execute "analyze table ismpst;" command
> Any clue of this wrong index reading
That's the clue. ANALYZE may help; it may hurt. (5.6 may have a better solution.)
The solution may be:
INDEX(PSTISCOMBO, CREATEDATE)
(or it may not be useful until you get rid of the NULLs.)
Subject
Views
Written By
Posted
2238
July 11, 2013 06:30AM
992
July 12, 2013 09:42AM
1059
July 31, 2013 02:08AM
967
August 01, 2013 10:19PM
1339
August 02, 2013 04:04AM
Re: Locking issue in innodb select query
1035
August 03, 2013 09:11AM
982
August 12, 2013 12:45AM
882
August 13, 2013 11:27PM
959
August 14, 2013 01:14AM
852
August 31, 2013 05:39PM
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.