Re: MySQL 5.7 performance issue with 300 GB Innodb
Hi,
It seems you are doing a lot of table scans and joins without indexes. Hence, I recommend to investigate whether the queries that spend the most time in your system could be improved. A good place to start is to run "SELECT * FROM sys.statement_analysis LIMIT 10". It will show the top 10 queries wrt total execution time.
Given that you have allocated most of the memory on your system for the InnoDB buffer pool, and have significantly increased the size of many memory buffers, you should also make sure that the there is no memory swapping on your system.
I also recommend setting "innodb_flush_method=O_DIRECT" to avoid using extra memory for the file system cache.
Øystein Grøvlen,
Senior Principal Software Engineer,
MySQL Group, Oracle,
Trondheim, Norway
Subject
Views
Written By
Posted
3303
September 13, 2017 03:52AM
879
September 13, 2017 11:25AM
776
September 13, 2017 10:35PM
1098
September 13, 2017 10:53PM
784
September 13, 2017 11:02PM
Re: MySQL 5.7 performance issue with 300 GB Innodb
777
September 14, 2017 01:58AM
770
September 14, 2017 11:03AM
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.