Does anyone know how to speed the performance of deletes on a large
table? I have a large table w/ approx. 180,000,000 rows, with the
following table structure:
mysql> desc TABLEA;
|+--------------+-------------------------------+------+-----+----------+-------+|
Field | Type | Null | Key | Default
| Extra
|+--------------+-------------------------------+------+-----+----------+-------+|
ID | int(10) unsigned | | | 0
| ||
CID | int(10) unsigned | | MUL | 0
| ||
GNUMBER | int(10) unsigned | | | 0
| ||
VAL | int(10) unsigned | | | 0
| ||
DENUM | enum('UP','DOWN') | | | UP
| || TIMESTAMP | int(10) | | MUL
| 0 | ||
|+--------------+-------------------------------+------+-----+----------+-------+|
It takes approximately 45 seconds to delete an hour's worth of data(
90323 rows) from the table, which tends to be a performance problem
since it's a table with a fair amount of contention.
Platform: x86
OS: RH Linux 2.4.6
MySQL V: 3.23.42-max
DB File Type: InnoDB
Memory: 1 GB
HD: 130GB SCSI
Thanks,
Chris
---------------------------------------------------------------------
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
