Alex Rivera | Logout

How big can a MySQL database get before performance starts to degrade

Asked 2008-08-04T14:31:11.410
345

At what point does a MySQL database start to lose performance?

  • Does physical database size matter?
  • Do number of records matter?
  • Is any performance degradation linear or exponential?

I have what I believe to be a large database, with roughly 15M records which take up almost 2GB. Based on these numbers, is there any incentive for me to clean the data out, or am I safe to allow it to continue scaling for a few more years?

Edit
Report

1 Answer

27

2GB and about 15M records is a very small database - I've run much bigger ones on a pentium III(!) and everything has still run pretty fast.. If yours is slow it is a database/application design problem, not a mysql one.

answered 2010-08-05T09:03:48.627

Your Answer