At 04:30 AM 3/27/2002, you wrote:
>Hi
>
>I'm running mysql 3.23.36 on a Red Hat 7.1 with the standard kernel.
>
>I have a /var partition (ext2) with 6.5 gb total space.
>
>One of the tables are almost running out of space, it is almost 4 gb. is it
>the filsystem that prevents files larger than 4 gb, or is it mysql that
>should be tweaked ?
>
>If i could use the last 2 gb on the partition, my problems would be solved
>for the next 4 months, any sugestions ?
>
>Im also considering installing a rh7.2 with the sgi xfs, anyone having any
>experiance with XFS ?
>
>--
Svend,
You could switch to InnoDb table type. InnoDb allows you to
allocate multiple file spaces. So each file space is between 10M - 4g and
you can have several of these. All of the Innodb tables are stored in this
file space, the only separate files are *.frm files. InnoDb will load data
considerably slower than MyISAM tables, but it will stand up much better to
multi-user access. You may want to experiment with InnoDb to see if it
solves your problem. http://www.innodb.com/features.html
Brent
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
---------------------------------------------------------------------
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
