----- Original Message -----
Sent: September 25, 2003 12:30 PM
Subject: [wdvltalk] mysql: max number of tables
> Does anyone know if a mysql database has a maximum number of tables it
can
> handle? We are writing an application where the number of tables could
grow
> into several thousand.
>From the MySQL website:
Handles large databases. We use MySQL Server with databases that contain
50 million records. We also know of users that use MySQL Server with
60,000 tables and about 5,000,000,000 rows.
Up to 32 indexes per table are allowed. Each index may consist of 1 to
16 columns or parts of columns. The maximum index width is 500 bytes
(this may be changed when compiling MySQL Server). An index may use a
prefix of a CHAR or VARCHAR field.
Regards,
Mark Groen
MG Web Services
Web Site Hosting and Development
www.markgroen.com
[EMAIL PROTECTED]
604-780-6917
Bowen Island, Canada
____ � The WDVL Discussion List from WDVL.COM � ____
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED]
Send Your Posts To: [EMAIL PROTECTED]
To set a personal password send an email to [EMAIL PROTECTED] with the words: "set
WDVLTALK pw=yourpassword" in the body of the email.
To change subscription settings to the wdvltalk digest version:
http://wdvl.internet.com/WDVL/Forum/#sub
________________ http://www.wdvl.com _______________________
You are currently subscribed to wdvltalk as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
