Question
What is the max table size (MB/GB) from a MySQL table hosted at DigitalOcean?
- Posted on September 25, 2021
- StorageMySQLDigitalOcean Managed MySQL Database
Asked by thibautdm9830
A lot of hosting providers use a maximum table size limit for security reasons. Does digitalocean also have a max table size or not?
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
Want to learn more? Join the DigitalOcean Community!
Join our DigitalOcean community of over a million developers for free! Get help and share knowledge in Q&A, subscribe to topics of interest, and get courses and tools that will help you grow as a developer and scale your project or business.
Hi @thibautdm9830,
Currently, Digitalocean does not have any limitations for table size placed on the Managed Databases platform. When you have more records it is highly recommended to ensure your node size can accommodate the number of resources needed to process a larger database.
Adding to this, max_heap_table_size and tmp_table_size are currently not configurable but these are something that could be implemented as user-configurable options.
https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_max_heap_table_size
You can read more about the product and limitations here: https://www.digitalocean.com/docs/databases/mysql/
Pricing: https://www.digitalocean.com/pricing#managed-databases
I hope this helps!
Regards, Rajkishore J