MySQL Forums
Forum List  »  Performance

Re: Index performance
Posted by: Alex Vilner
Date: June 21, 2010 06:55PM

Rick, thanks again for the ideas!

In case of the summary tables, queries can actually be any combination of customer, product, provider, and a few other factors, like min/max volumes, min/max session duration, etc. So, if anything, the summary table will end up looking like the transactional one :)

On the index front, I think I have the solution - for the time being:
1. Created 2 named key caches
2. Assigned 2 large indexes we use to these
3. Preloaded indexes into cache.

Now, the queries that took minutes to run are behaving more like they should...

Still does not really explain why selecting 25k rows from a 250 million row table on a numeric index would be taking minutes, but for the time being, I think I am ok...

Thank you for all your help!

--Alex

Options: ReplyQuote


Subject
Views
Written By
Posted
4372
June 15, 2010 08:30AM
1250
June 16, 2010 09:54AM
1360
June 16, 2010 12:03PM
1496
June 16, 2010 08:47PM
1397
June 20, 2010 02:30PM
1229
June 20, 2010 11:05PM
1534
June 21, 2010 07:35AM
1194
June 21, 2010 09:21AM
1203
June 21, 2010 10:31AM
1324
June 21, 2010 06:43PM
Re: Index performance
1513
June 21, 2010 06:55PM


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.