MySQL Forums
Forum List  »  Performance

Re: MySQL 5.7 performance issue with 300 GB Innodb
Posted by: Peter Brawley
Date: September 14, 2017 11:03AM

Select_scan and next-row-request rates are way too high, so I agree with Øystein, many queries are requiring table scans, you need to identify and optimise them.

It seems to be rotating the innodb log file every minute, that's probably slowing you down, optimum is usually about 30 mins, so consider increasing innodb_log_file_size, and see https://www.percona.com/blog/2012/10/08/measuring-the-amount-of-writes-in-innodb-redo-logs/

3k inserts/sec is busy, see https://dev.mysql.com/doc/refman/5.7/en/insert-optimization.html re optimising inserts.

Use free -h, or top, to see if the system is swapping. If it still is after fixing the inefficient queries, you'll need to identify the queries that induce swapping and fix them or adjust other params to get rid of swapping.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: MySQL 5.7 performance issue with 300 GB Innodb
703
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.