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

3k inserts/sec is busy, see 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

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