If your os permits, mysql can handle file sizes up to terabytes. You
don't need to spawn your tables. But you have to be careful when
creating your myisam tables. If you don't specify your table size limit
with the max_rows option when creating table mysql will create a table
with 4G file size
And the manual says : .
http://www.mysql.com/doc/en/Table_size.html
Jerry
- Original Message -
From: "Mark Vollmann" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 02, 2003 9:39 AM
Subject: Maximum table size
> Hello
>
> As i under
Hello
As i understand it mysql maintains a file for every table created. Does it
mean that the filesystem restricts the maximum size of a given table or do i
have the option to make table data spawn more than on file like in oracle?
Thanks in advance
Mark Vollmann
Mit freundlichen Grüßen,
Mar
Hi,
Would anyone be able to confirm that mysqld-max-nt.exe does not have a 4 GB
limitation. I'd like the DB to go up to 40GB and 330 million rows. I am
flexible, I'll use the biggest DB I can create.
ISAM seems to be the obvious choice but would INODB perform better on
inserts for a large DB, s