Hi, I run something similar, apx 11 Gb MyIsam + 9 Gb index per month and I use a merge table on top of sevral 9-11 Gb tables. I dont think you need to have a merge table if doesnt bring you any other advantages, eg. cycling of tables.
RH 7.2 + 2.4.18 kernel, ReiserFs Compaq 4 way XENON, fiberchannel and SAN w 1 TB raid 5. /Jörgen Nigel Edwards wrote: >I need to use some large tables using MySQL under Linux and would welcome >suggestions from anyone with any experience. Currently one months data >creates a table of 3M records about 750Mb in size. I should like to >consolidate 12 Months data (which is expected to grow to say 50M records per >month) so I could be looking at 15Gb table plus indexes. This is for >'warehousing' so transactional security and frequent updates are of little >concern. > >The options I can see include: >Merge Tables/INNODB or MyIsam using large file capable file-system (XFS?) > >Please offer ideas and experience. I don't want to reinvent the wheel. > >Thanks > >Nigel > > > >--------------------------------------------------------------------- >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 > > > > > --------------------------------------------------------------------- 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
