MySQL Forums
Forum List  »  Performance

Re: Query Optimization Needed
Posted by: Rick James
Date: February 16, 2015 12:15AM

It takes time to shovel that many rows around. You should not expect any improvement. Anyway, how long will it take the client to munch on 167667 rows??

Watch "Rows_examined" in the slowlog -- it is a pretty good metric for comparing one index+query to another.

> so we can not allow a large buffer pool to InnoDB as recommandation (70% of available RAM).

The key word is _available_.

Options: ReplyQuote


Subject
Views
Written By
Posted
1666
February 11, 2015 01:31AM
751
February 11, 2015 12:42PM
854
February 12, 2015 03:51AM
783
February 12, 2015 01:24PM
749
February 13, 2015 06:53AM
682
February 13, 2015 07:36AM
702
February 14, 2015 01:04AM
780
February 15, 2015 11:07PM
Re: Query Optimization Needed
793
February 16, 2015 12:15AM
658
March 13, 2015 11:15AM


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.