Re: Query optimization and indexing - Help needed
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.
Subject
Views
Written By
Posted
1059
June 13, 2019 06:41AM
493
June 13, 2019 12:55PM
489
June 14, 2019 12:01AM
Re: Query optimization and indexing - Help needed
543
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.