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 ?
[poll id=”4″]
Thank you for participating!
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