***BOGO*** delete takes 4 hours

["Mike Bolton" <palefacerocker@xxxxxxxxx>]

I've got two machines running mysql, a development box and a production box.
I have a database table with 795755 rows on both machines.  The schema is
the same.  When I execute a "delete from my_large_table" statement, it takes
9 minutes on the dev box and 4 hours on the production machine.  Needless to
say, this is not usable in a production environment, especially when I have
to delete and load the large table every single day (the table contains a
list of products as given by a distributor).  The configurations of the two
machines are as follows:

dev box:
FreeBSD dev 6.1-RC FreeBSD 6.1-RC #7
512 Megs RAM
Pentium 4
MySQL: 5.1.12-beta-log FreeBSD port: mysql-server-5.1.12


production box:
CentOS  2.6.9-55.0.12.EL
Intel 2.4 Ghz P4 Celeron
512 Megs RAM
MySQL: 5.1.22-rc-community


Can anyone tell me why this could possibly be taking so long?  Or where else
I should look to try to solve this issue?  Your help is greatly appreciated
since I'm at a complete loss here.  Thanks,

Mike