November 21, 2014

Question of the week: Maximum number of tables per MySQL instance.

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 ... Loading ...

Thank you for participating!

About Peter Zaitsev

Peter 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.


  1. I can have one! Because if I have more I get confused! :-)

    Isn’t the file system the limitation here?

  2. Rolf says:

    37k tables, 120k partitions. Wouldn’t # of partitions be a better question?

  3. Rolf,

    It would be better but more confusing question as not everyone uses partitions :)

  4. manish says:


    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.

  5. eRadical says:

    ~6,100 – MySQL server of a web development company / ~200 websites

Speak Your Mind