MySQL Forums
Forum List  »  Performance

Re: MyTOP - Key Efficiency 50.0% - How to improve it?
Posted by: Peter Brawley
Date: January 21, 2018 10:07PM

AFAIK one MySQL connection uses one CPU core, best config is innodb_thread_concurrency=0, which means no limit, then grow innodb_read_io_threads and innodb_write_io_threads to 64.

3P solution? https://www.percona.com/blog/2014/05/01/parallel-query-mysql-shard-query/ .

Options: ReplyQuote




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.