i have a table this is 50 Million, has 10 indexs, some are on varchar's disk space is 34 GB for the MYD, and 6.5 GB for the MYI. Granted I have a pretty old box, 2x660 Mhz P3's, and a RAID array good for about 25-30 MBs, it took me when the DB as at 42 million records about 28 hours to reindex
-pete -----Original Message----- From: Richard Davey [mailto:[EMAIL PROTECTED] Sent: Monday, March 29, 2004 10:12 AM To: [EMAIL PROTECTED] Subject: Re: Creating index on very large table Hello Jeffrey, Monday, March 29, 2004, 7:05:27 PM, you wrote: JH> I've got a problem creating an index on a MYISAM table with JH> 302,000,000 lines, roughly 58 GB on disk. Attached you will find the JH> table definition, output of "mysqladmin variables", and "mysql -e 'show status'". JH> and it's still running! That's roughly 11 days and it's not complete yet! JH> Here's the current file sizes under the mysql root directory... Index creation CAN take a long time, but I've never known it last 11 days :) but then I've never tried it on a table with 302 million records (although I'm sure others here have). My suggestion would have been - why not take say 10,000 records and just test the index creation on that small sub-set of the data? If it works without error then you know it will (should?) eventually finish on the final massive set. -- Best regards, Richard Davey http://www.phpcommunity.org/wiki/296.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
