Take a look at
http://lists.mysql.com/mysql/158737
for an interesting 'trick' to optimze index creation.
Basically it amounts to:
* Create the data without indexes
* Move (rename) the table.MYD file to a backup
* Create an empy MYD file using TRUNCATE TABLE
* Add indexes
* Move the backed up
Hi folks,
I've got a problem creating an index on a MYISAM table with 302,000,000 lines,
roughly 58 GB on disk. Attached you will find the table definition, output
of mysqladmin variables, and mysql -e 'show status'.
After creating the above-mentioned table, I ran:
ALTER TABLE test_table ENABLE
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 302,000,000 lines,
JH roughly 58 GB on disk. Attached you will find the table definition, output
JH of mysqladmin variables, and mysql -e 'show status'.
JH and it's still
PM
Subject: Creating index on very large table
Hi folks,
I've got a problem creating an index on a MYISAM table with 302,000,000
lines,
roughly 58 GB on disk. Attached you will find the table definition, output
of mysqladmin variables, and mysql -e 'show status'.
After creating the above
http://www.geocrawler.com/archives/3/8/2002/11/50/10245455/
Kyle
- Original Message -
From: Jeffrey Horner [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, March 29, 2004 12:05 PM
Subject: Creating index on very large table
Hi folks,
I've got a problem creating an index