Dan,
Cheers for doing the translating, I'm one of those beardy types they
keep locked in a dark room writing search engines so my English isn't
spectacular ;^)
As Rolando points out your file system may place a limit on the
number of files or directories, but to my knowledge XFS has no such
limit so your still left with 8 Exabytes (approximately one quintillion
bytes) to store your data.
By the way if you used Solaris 10 (he says looking under his desk)
you could use ZFS which would give you 16 exabytes (and a 2^48 file
limit), which is er, many.
Back to the question at hand tho', the schema_information table is
required to store information about each column (which looks like the
most populous table in there), assuming a vaguely realistic 3 tables
with 5 columns per database that would give you 160 million databases
before you reached the 2.4 billion row limit of that table?
Interestingly I can't file a file limit mentioned for XFS, if it's
2^24 that's only 16.7 million. How about we leave it at "lots".
What Philip is saying is that you might run into problems with one of
the tables used to keep track of tables and databases, before you run
into problems with any hard coded limit of MySQL itself.
Regards,
Philip (I better get back to real work) Mather ;)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
