Related

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
WordPress database error: [Expression #1 of ORDER BY clause is not in SELECT list... Question Question
Private connection to Managed DB not working from within same region droplet. Question Question

Question

What is the maximum number of tables, rows per table and column per table limit in MySQL

Posted October 21, 2021 75 views
DigitalOcean Managed MySQL Database

What is the maximum number of tables, rows per table and columns per table can be created in Managed MySQL database cluster?

Add a comment
priyankamalik
By:
priyankamalik

Related

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
WordPress database error: [Expression #1 of ORDER BY clause is not in SELECT list... Question Question
Private connection to Managed DB not working from within same region droplet. Question Question

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.

×
Submit an Answer
1 answer
priyankamalik October 21, 2021

Hello,

MySQL has no limit on the number of databases. The underlying file system may have a limit on the number of directories.

MySQL has no limit on the number of tables. The underlying file system may have a limit on the number of files that represent tables. Individual storage engines may impose engine-specific constraints. Our managed database cluster uses InnoDB. InnoDB permits up to 4 billion tables.

For reference:
https://dev.mysql.com/doc/refman/8.0/en/database-count-limit.html

Hope that this helps.
Regards,
Priyanka

Reply Report

Related

Looking for something else?

Ask a new question Search for more help