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] > ------------------------------------------------------------------ > ------------ > --------------------------------------------------------------------- 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