MySQL Forums
Forum List  »  InnoDB

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

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

Written By
Best Configuration for large db
November 29, 2018 09:25PM
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.