MySQL Forums
Forum List  »  Performance

Re: MySQL 5.7 performance issue with 300 GB Innodb
Posted by: Øystein Grøvlen
Date: September 14, 2017 01:58AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: MySQL 5.7 performance issue with 300 GB Innodb
777
September 14, 2017 01:58AM


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.