MySQL Forums :: Performance :: Single Database Vs Multiple Databases


Advanced Search

Single Database Vs Multiple Databases
Posted by: Atul Dixit ()
Date: February 23, 2017 12:44PM

Hi,

On Single Physical Server, with Single MySQL Instance:
We have 90 million records in each of 20 tables. We are thinking about splitting data into 25-25-25-15 millions into 4 databases on Single MySQL Instance, assuming it will give better performance.

Will Multiple Databases really perform better than Single Database, where hardware is same for both scenarios?
Could someone shed some light on this and help me.

Regards,
Srinivas

Options: ReplyQuote


Subject Views Written By Posted
Single Database Vs Multiple Databases 153 Atul Dixit 02/23/2017 12:44PM
Re: Single Database Vs Multiple Databases 92 Øystein Grøvlen 03/01/2017 07:22AM


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.