At 10:10 -0500 12/18/02, Michael T. Babcock wrote:
Qunfeng Dong wrote:
Another thing, with some linux system, there is a size
limit for file. MySQL seems to store each of its table
as single file. You need to choose a file system
without that limit.
Just use InnoDB tables for these files and you won't have a problem
AFAIK; you can have multiple 2G files that are used to create one
big table if you like (any InnoDB people want to comment on actual
limits?)
Check out:
http://www.innodb.com/ibman.html#InnoDB_restrictions
And take a look at the last few items in the list, pertaining to page
size, max number of pages, etc.
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
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