MySQL Forums
Forum List  »  Performance

Re: Foreman query optimization
Posted by: Peter Brawley
Date: November 05, 2015 11:19PM

Indexing won't help the sources side of The Left Join, but an index on source_id might help the logs side.

And, how much RAM, what is innodb_buffer_pool_size?

Options: ReplyQuote


Subject
Views
Written By
Posted
1768
November 05, 2015 04:15PM
719
November 05, 2015 05:42PM
769
November 05, 2015 06:54PM
Re: Foreman query optimization
694
November 05, 2015 11:19PM
786
November 06, 2015 11:58AM
709
November 06, 2015 12:35PM
683
November 06, 2015 06:44PM
780
November 26, 2015 08:56PM


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.