I’ve got the great response to my two previous polls (1,2) so lets continue learning about how we all use MySQL. The question of this week is What is the maximum number of tables per MySQL instance do you use ?
What is the largest amount of tables do you have per MySQL Instance
- Less than 1000 (49%, 199 Votes)
- 1000 to 10000 (23%, 94 Votes)
- 10 thousands to 100 thousands (13%, 51 Votes)
- more than 1 million (8%, 32 Votes)
- 100 thousands to 1 million (7%, 30 Votes)
Total Voters: 406
Loading ...Thank you for participating!
About the Author
Peter ZaitsevPeter managed the High Performance Group within MySQL until 2006, when he founded Percona. Peter has a Master's Degree in Computer Science and is an expert in database kernels, computer hardware, and application scaling.
I can have one! Because if I have more I get confused! 🙂
Isn’t the file system the limitation here?
37k tables, 120k partitions. Wouldn’t # of partitions be a better question?
Rolf,
It would be better but more confusing question as not everyone uses partitions 🙂
Hi
i answered 1000-10000, this is just respective to Linux OS, as i know, the mysql tables can be made unlimited, it only depends on OS directory/files limit per folder.
~6,100 – MySQL server of a web development company / ~200 websites