So I've been a senior dev for lots of years, clustered environments, XXXgb databases etc etc
somebody said to me last ngiht that mysql has a limit on the number of tables you can use per database, and that is was 256! I've dismissed this as "erm no" but can't find any info anywhere about it.. which leads me to confirm that nope there is no limit. I also can't see how there can be a limit to tabels in db, based on the fact each table is a file..
anybody shed any long forgotten insight into this? something runs in my mind about there being a limit way back in the 3.X days but??
mysql table limit??
Moderator: General Moderators
Doesn't mean that there is a much lower limit per database, but...http://dev.mysql.com/doc/refman/5.0/en/features.html wrote: Scalability and Limits:
* Handles large databases. We use MySQL Server with databases that contain 50 million records. We also know of users who use MySQL Server with 60,000 tables and about 5,000,000,000 rows.
-
Charles256
- DevNet Resident
- Posts: 1375
- Joined: Fri Sep 16, 2005 9:06 pm
yeah a junior came to me some weeks ago, claiming to be a senior and said that "mysql can only handle 256 tables" - when somebody says soemthing like that, however rediculous you have to double check just to be on the safe side, theoretically I can't see any table limit, and I've certainly never came accross one. There does come a time when you have to think, why do I have this many tables.. perhaps I need a bit of normalisation here..
In short, to the best of my knowledge, there are limits placed on number of rows, number of index's, number of cols that can be indexed or in an index, limit's to filesizes depending on OS config's, but short of running a stored proc to make millions of tables and actually get a point where we get an error, I can't see any way of getting a firm answer.
recomemnd the debate closes, unless somebody has a solid fixed figure on a per version/OS basis as to the number of tables limit.
In short, to the best of my knowledge, there are limits placed on number of rows, number of index's, number of cols that can be indexed or in an index, limit's to filesizes depending on OS config's, but short of running a stored proc to make millions of tables and actually get a point where we get an error, I can't see any way of getting a firm answer.
recomemnd the debate closes, unless somebody has a solid fixed figure on a per version/OS basis as to the number of tables limit.
The maximum number of tables in a Cluster database in MySQL 5.0 is limited to 1792.