Oh, I don't know how well that would work. But I do know you will still run into limitations of 2 GB, so if you had 2 drives raided then you now have a 4 GB limit which doesn't help to much. I would think the best solution would be to re-compile your kernel to include large file support and tweak you MySQL for limit-less records. That's what I do when I run into older distro's.
Benjamin Arai [EMAIL PROTECTED] On Mon, 14 Jan 2002, Geoffrey Soh wrote: > Hi, > > Sorry for being unclear :) I was talking about the --with-raid compilation > option in MySQL that lets you create tables with the RAID_TYPE RAID_CHUNKS > RAID_CHUNKSIZE options, allowing tables to span across multiple data files, > each file having a size below the OS limit. Thanks for the response. > > Cheers, > Geoffrey > __________________________________________________ > > Geoffrey Soh, Software Architect > Ufinity - http://www.ufinity.com > Leading Enterprise Access Management Software! > 9 Scotts Road, Pacific Plaza, #06-01, Singapore 228210 > Tel : +65 830-0341 > Fax : +65 737-0213 > __________________________________________________ > > > > > -----Original Message----- > > From: Benjamin Arai [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, January 15, 2002 1:52 AM > > To: Geoffrey Soh > > Cc: [EMAIL PROTECTED] > > Subject: RE: Redhat 7.2 Linux Maximum Database/Table Size > > > > > > You don't understand. You need to use a operating system which has a > > filesystem which lifts the 2 GB limit. By default from every Linux > > distrobtion I have used, if the OS has lifted the limit then they usually > > fix all the programs to uses the new file size capabilities. > > > > Raid doesn't help at all for the limit because the physical limit by the > > OS is a file size limit and not a partition or drive limit. > > > > Increase the max rows as you see appropriate but that is almost never the > > problem in terms of file size issues like you are having. > > > > Raids don't really help Table performance because in almost all cases the > > bottlneck is caused by the drives access time. raiding drives doesn't > > increase the access time therefore, you are most likely not going to see > > and poerformance increases using a raid system unless you are change to > > drives to ones with lower access times. > > > > Benjamin Arai > > [EMAIL PROTECTED] > > > > On Mon, 14 Jan 2002, Geoffrey Soh wrote: > > > > > > On Fri, Jan 11, 2002 at 08:51:33AM +0100, Dr. Frank Ullrich wrote: > > > > > Benjamin, > > > > > can you also grow MyISAM tables to such sizes? > > > > > > > > You can. > > > > > > I understand that the RAID option can help break the 2GB/4GB > > barrier, esp. > > > on Linux machines. > > > > > > But how do you surpass the Max_data_length restriction of > > 4294967295 bytes > > > on a "RAIDED" table? do you increase max_rows on such a table? if so, > > > would this affect the performance of a large table e.g. above 50GB? > > > > > > Without changing max_rows it seems that MySQL will still > > restrict the table > > > size to 4GB, even with raid_chunks and raid_chunksize set to e.g. 50 and > > > 256? > > > > > > Anyone out there tweaked these settings before and what was the outcome? > > > Thanks. > > > > > > Cheers, > > > Geoffrey > > > __________________________________________________ > > > > > > Geoffrey Soh, Software Architect > > > Ufinity - http://www.ufinity.com > > > Leading Enterprise Access Management Software! > > > 9 Scotts Road, Pacific Plaza, #06-01, Singapore 228210 > > > Tel : +65 830-0341 > > > Fax : +65 737-0213 > > > __________________________________________________ > > > > > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > > 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 > > > > > > > -- > > ------------------------------------------------------------------ > > ------------ > > Benjamin Arai > > [EMAIL PROTECTED] > > ------------------------------------------------------------------ > > ------------ > > > -- ------------------------------------------------------------------------------ Benjamin Arai [EMAIL PROTECTED] ------------------------------------------------------------------------------ --------------------------------------------------------------------- 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
