Best Configuration for large db
HI,
we have multiple database on MySQL
but one database is large which has 60 Millions of data in single table
details : community edition
version : 5.6
Engine : InnoDB
server RAM 16 GB
CPU : 4 Core
what is the best configuration we need to follow for INSERT/UPDATE / DELETE as currently its slow
does improving RAM to 60 G, 4 core to 8 can help to speed up the query processing
?
Appreciate your help
Subject
Views
Written By
Posted
Best Configuration for large db
1054
November 29, 2018 09:25PM
577
November 30, 2018 01:00AM
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.