Re: Major issues with performance after mysql restore
Do most of the tables use the InnoDB storage engine? Please show us the result of ...
show variables like 'innodb%';
With 64GB of RAM, and more than that of data, innodb_buffer_pool_size should be 48-50G.
Edited 1 time(s). Last edit at 02/02/2022 09:22AM by Peter Brawley.
Subject
Written By
Posted
February 02, 2022 07:32AM
Re: Major issues with performance after mysql restore
February 02, 2022 09:22AM
February 02, 2022 11:58AM
February 02, 2022 12:18PM
February 02, 2022 12:45PM
February 02, 2022 03:57PM
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.