Mysql: how big you should keep your growing table?

My advice is if you have a growing fast/busy table, you should keep it below 4GB, if it’s over 4GB, you should find away to archive it. This will need some helps from the code as well. Why shouldn’t you let it growing more than 4GB? It’s because sometimes your server crash, mysql might need to recover/repair the table. If the table is too big, it will take a lot of time to repair. While the table is repairing, you will be unable to access that table, this will put everyone in a long queue. Just imagine that you have a busy and it takes 30 minutes to repair, that means your service is 30 minutes down.

Leave a Reply

Your email address will not be published. Required fields are marked *