MySQL is generally limited by the OS you are running it on. If you
start having thousands of table, the OS is probably going to get
bogged down in trying to keep track of all the file handles needed
for all those tables and indexes. The practical limit to the number
of tables is far lower than the theoretical maximum. So I wouldn't
design your database with unlimited tables in mind.
A database can hold multiple terabytes of data, but again you would
run into limits of the OS, like maximum file size. Using InnoDB you
would be able to split the tables into multiple files to work around
OS limits on the maximum file size. But again, there are only so many
files an OS can keep open and manage before you run into performance
problems. Keep in mind that you don't have to keep everything on one
machine.
Yes, you can store binary data in MySQL.
On Sep 20, 2005, at 9:23 AM, [EMAIL PROTECTED] wrote:
Hi, all
I have 2 questions:
1) Is there any limit on the number of tables I can create in MySQL
and
how large I can hold in a database?
2) Does MYSQL support to save binary data file in the table. I
can't just
save paths to the files. They files reside in another machine.
Thanks for reply.
X.Chen
--
Brent Baisley
Systems Architect
Landover Associates, Inc.
Search & Advisory Services for Advanced Technology Environments
p: 212.759.6400/800.759.0577
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]