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

by

The physical database size doesn’t matter. The number of records don’t matter.

In my experience the biggest problem that you are going to run in to is not size, but the number of queries you can handle at a time. Most likely you are going to have to move to a master/slave configuration so that the read queries can run against the slaves and the write queries run against the master. However if you are not ready for this yet, you can always tweak your indexes for the queries you are running to speed up the response times. Also there is a lot of tweaking you can do to the network stack and kernel in Linux that will help.

I have had mine get up to 10GB, with only a moderate number of connections and it handled the requests just fine.

I would focus first on your indexes, then have a server admin look at your OS, and if all that doesn’t help it might be time to implement a master/slave configuration.

More Related Contents:

  1. How do I store large no.of small entries in Mysql?
  2. ‘IF’ in ‘SELECT’ statement – choose output value based on column values
  3. 1052: Column ‘id’ in field list is ambiguous
  4. How to do a batch insert in MySQL
  5. Count the occurrences of DISTINCT values
  6. Codeigniter – multiple database connections
  7. Location of my.cnf file on macOS
  8. Maximum number of records in a MySQL database table
  9. Swapping column values in MySQL
  10. JOIN queries vs multiple queries
  11. Is the primary key automatically indexed in MySQL?
  12. Storing Data in MySQL as JSON
  13. MySql: MyISAM vs. Inno DB! [closed]
  14. MySQL: Cloning a MySQL database on the same MySql instance
  15. DOs and DONTs for Indexes [closed]
  16. How to change the default port of mysql from 3306 to 3360
  17. How to set a MySQL row to READ-ONLY?
  18. How to insert images from database?
  19. Is there an SQLite equivalent to MySQL’s DESCRIBE [table]?
  20. mySQL – Create a New Table Using Data and Columns from Three Tables
  21. Calculating a Moving Average MySQL?
  22. How to get size of mysql database?
  23. Case Sensitive collation in MySQL
  24. Can’t import database through phpmyadmin file size too large
  25. How do you write a case insensitive query for both MySQL and Postgres?
  26. What is the best way to do incremental backups in MySQL?
  27. #1130 – Host ‘localhost’ is not allowed to connect to this MySQL server
  28. How to Get True Size of MySQL Database?
  29. MySQL: Computed Column
  30. How to recover just deleted rows in mysql?

Leave a Comment