, June 21, 2006 5:55 PM
Subject: Need to speed up deletes
I need to delete 200,000 rows from an 8 million row MyISAM table using an index. It's taking 20 minutes which is quite slow. Is
there any way to speed it up? TIA
Mike
MySQL 4.1.10
--
MySQL General Mailing List
For list archives: http
I need to delete 200,000 rows from an 8 million row MyISAM table using an
index. It's taking 20 minutes which is quite slow. Is there any way to
speed it up? TIA
Mike
MySQL 4.1.10
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Is the table heavily indexed? Indexes cause inserts and deletes (and updates
under certain conditions) to slow down.
Also, since you are deleting approx 2.5% of your rows, your delete-statement must have a where-clause. You might want to do an
explain-plan on it to make sure it's not an
Using an Apache/PHP/MySQL/Linux (Redhat 8.0) solution, PHPList, to create
an e-mailing list for our 5.6 million book club members. Unfortunately,
the import speed for importing records (at record number 150,000) is about
2,000 records per hour. We're running on the following:
P4 (1.5 Ghz),
* Creigh Shank
Using an Apache/PHP/MySQL/Linux (Redhat 8.0) solution, PHPList, to create
an e-mailing list for our 5.6 million book club members. Unfortunately,
the import speed for importing records (at record number 150,000)
is about
2,000 records per hour. We're running on the following:
At 01:02 PM 8/21/2003, you wrote:
Using an Apache/PHP/MySQL/Linux (Redhat 8.0) solution, PHPList, to create
an e-mailing list for our 5.6 million book club members. Unfortunately,
the import speed for importing records (at record number 150,000) is about
2,000 records per hour. We're running
Using an Apache/PHP/MySQL/Linux (Redhat 8.0) solution, PHPList, to create
an e-mailing list for our 5.6 million book club members. Unfortunately,
the import speed for importing records (at record number 150,000 the rate
is about 2,000 records per hour). We're running on the following:
P4
Creigh == Creigh Shank [EMAIL PROTECTED] writes:
Creigh Using an Apache/PHP/MySQL/Linux (Redhat 8.0) solution,
Creigh PHPList, to create an e-mailing list for our 5.6 million book
Creigh club members. Unfortunately, the import speed for importing
Creigh records (at record number 150,000 the
