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