Re: How many databases does MySQL 5 support?

2006-10-18 Thread Philip Mather
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 su

Re: Re: How many databases does MySQL 5 support?

2006-10-18 Thread Dan Buettner
That does make sense, John. 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. The OS and the hardware will impose some (rather generous) restrictions

Re: How many databases does MySQL 5 support?

2006-10-18 Thread Rolando Edwards
AM GMT-0500 US/Eastern Subject: Re: How many databases does MySQL 5 support? John M.Brown schrieb: > Thanks for the info, but my question is how many databases, not so much how > many rows per table or how big the database can be... I mean, how many > "create database ABC" c

Re: How many databases does MySQL 5 support?

2006-10-18 Thread Dominik Klein
John M.Brown schrieb: Thanks for the info, but my question is how many databases, not so much how many rows per table or how big the database can be... I mean, how many "create database ABC" can I do before MySQL says "sorry, you can't have more than X databases". Say I create 1000 empty MySQL

Re: How many databases does MySQL 5 support?

2006-10-18 Thread John M . Brown
Thanks for the info, but my question is how many databases, not so much how many rows per table or how big the database can be... I mean, how many "create database ABC" can I do before MySQL says "sorry, you can't have more than X databases". Say I create 1000 empty MySQL databases (meaning no

Re: How many databases does MySQL 5 support?

2006-10-18 Thread Philip Mather
John, How many databases does a single instance of MySQL Server 5.x support? I suspect you'll get a bit of a , with a 64bit machine there's a limit of 4.2 billion rows per table and with an XFS file system 8EB per table, there's a join limit specified somewhere but I don't think there's an

How many databases does MySQL 5 support?

2006-10-18 Thread John M . Brown
I've looked as many places as I can think of and can't find a direct answer to my question: How many databases does a single instance of MySQL Server 5.x support? Is this because there is no logical limit? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsub