Bug #22037 limits number of tables per database
Submitted: 6 Sep 2006 0:51 Modified: 6 Sep 2006 1:05
Reporter: pavel stano Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: General Severity:S4 (Feature request)
Version: OS:Any
Assigned to: CPU Architecture:Any

[6 Sep 2006 0:51] pavel stano
some mysql "experts" dont know for what is relational database and create thousands tables, so it will be nice to have limits for max number of tables per database to stop making this stupidity

How to repeat:
find stupid customer who create thousands tables "table$i" when he needs just one table

Suggested fix:
limits number of tables per database
[6 Sep 2006 1:05] MySQL Verification Team
Thank you for the bug feature request.
[21 Feb 2007 16:44] Andrew Lam
Don't, you can't always protect everyone from their own stupidity.

People that use dynamic tables in their db design would probably just use dynamic databases if this feature was implemented. So what is next? Limit the number of databases per mysql instance?