On Mon, Nov 03, 2003 at 11:18:55AM -0600, William Baker wrote: > I am using a pentium4-2GHz machine with Linux-RH9 installed and 1GB > RAM. The database is on a dedicated SCSI drive with an Adaptec > UltraScsi3 controller which shows 40MHz bus connecting the 10K-RPM > disks. (Fairly new, fairly capable, low-end server grade.) > > I have a 2GB datafile with 10 indexes. Each of those indexes takes > about 1.5 hrs to build (total of 15 hours). Any suggestions for > reducing build time ... preferrably to around 10 minutes or less? I > could even live with 20 minutes for each. (Our current system uses ISAM > style indexed data files.
Without understanding the bottleneck, that's a difficult question to answer. Is it CPU bound? Disk I/O bound? Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 50 days, processed 1,886,376,428 queries (430/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
