Call us Toll-Free:
Email us


MySQL 1 Million Rows Golden rule

Dawn Rossi, 10-10-2008
According to MySQL documentation there are no software limits on the number of records per table. Some users report using MySQL with 50 million records and more.

Here in SoftwareProjects we found it's okay to use MySQL "archive type" tables with tens of millions of records, but for all active tables where you're constantly inserting, updating, deleting and querying the table -

Do NOT load up more than 1 million rows into a MySQL table.

We measured a considerable performance degradation whenever there are more than 1 million rows in an active (busy) table.

If you need more than 1 million rows, look into: partitioning, sharding or a purge script that will move unused rows to an archive type table.
Enjoyed this post?

Subscribe Now to receive new posts via Email as soon as they come out.

Post your comments

Note: No link spamming! If your message contains link/s, it will NOT be published on the site before manually approved by one of our moderators.

About Us  |  Contact us  |  Privacy Policy  |  Terms & Conditions