Jose, ----- Original Message ----- From: ""JSL"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Monday, September 02, 2002 11:49 PM Subject: Maximum number of tables
> > ----- Original Message ----- > From: "JSL" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Monday, September 02, 2002 5:05 PM > Subject: Maximum number of tables > > > > > > Subject: Maximum number of tables > > > > > Does anyone know what the maximum number of tables a > > > INNODB can store is? one table occupies at least n pages where 1) n = 1 + the number of indexes, if you have not defined a primary key for the table; 2) n = the number of indexes, if you have defined a primary key. Since there are max 4 billion pages in the tablespace, you can calculate the max number of tables from this formula. We can say InnoDB supports up to 4 billion tables. > > > Thanks, > > > > > > José Lourenço> Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, hot backup, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com sql query --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php