MySQL Forums
Forum List  »  InnoDB

Best Configuration for large db
Posted by: saravanan pichaipillai
Date: November 29, 2018 09:25PM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Best Configuration for large db
42
November 29, 2018 09:25PM
18
November 30, 2018 01:00AM


Sorry, only registered users may post in this forum.

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.