MySQL Forums
Forum List  »  Newbie

Re: New install - slow performance
Posted by: Peter Brawley
Date: March 05, 2018 12:10PM

Some queries are requiring table cans, optimise those queries.

With 5G RAM, innodb_buffer_pool_size should be about 3.5GB.

MyISAM key_read_requests / key_reads and key_write_requests / key_writes are too high esp. for a tiny unbusy system, grow key_buffer_size.

Options: ReplyQuote


Subject
Written By
Posted
Re: New install - slow performance
March 05, 2018 12:10PM


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.