S. Fischer [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 20, 2003 1:43 PM
To: 'Jack Coxen'; 'MySQL List (E-mail)'
Subject: RE: Delete questions and speed/safety issues
It's quite possible you're using the wrong tool for the job. Since this
is a write-intensive environment, you may get better
: Wednesday, August 20, 2003 6:07 AM
To: MySQL List (E-mail)
Subject: Delete questions and speed/safety issues
I'm in the process of writing a Perl script to delete records
out of a database when the records are more than 90 days old.
I'm running MySQL version 4.0.12-standard. The db consists
Jack Coxen wrote:
I had originally planned to use syntax similar to:
DELETE * FROM table_name WHERE `dtime` [90 days ago]
delete * from table_name where to_days(now())-to_days(dtime) 90
After the DELETE runs, I plan on running MYISAMCHK on the affected table.
Then I'll repeat both steps for
I'm in the process of writing a Perl script to delete records out of a
database when the records are more than 90 days old. I'm running MySQL
version 4.0.12-standard. The db consists of around 620 MyISAM tables with
the following structure:
CREATE TABLE `ifInErrors_2` (
`id` int(11) NOT NULL
Coxen; 'MySQL List (E-mail)'
Subject: RE: Delete questions and speed/safety issues
Switching to another database isn't really an option. I didn't write
the package and I'm not good enough to port it to another database or to
rewrite it for a multiple machine architecture.
Probably the only non