MySQL Forums
Forum List  »  Optimizer & Parser

Re: Query optimization and indexing - Help needed
Posted by: Peter Brawley
Date: June 14, 2019 07:51AM

Innodb_buffer_pool_size is still at default value, 128MB. With 150 mn rows in this table, lots of "fat" columns", the query must have induced much swapping. That's a performance killer.

Assuming most of the 16GB RAM is available to MySQL, innodb_buffer_pool_size should be 70-75% of RAM, 11 to 12 GB.

That alone may make query performance acceptable. If not, you'll need to optimise the many subqueries & conditions.

Options: ReplyQuote

Written By
Re: Query optimization and indexing - Help needed
June 14, 2019 07:51AM

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.