Hi all, I am in the process of upgrading one of my systems to use InnoDB tables, along with some other tweaks to my code. In any case, i just tried to delete around 7000 records from a table, where there are 9 other tables that will cascade delete when rows from the other table are deleted. Overall, id guess 140,000 rows are being deleted from all tables. This sat for at least 15 minutes, eventually i killed it and it took quite a while for that database to recover. (it was rolling back the tranaction i assume). In any case i didnt expect it to take that long to delete. Im now deleting in chunks of 100 rows in the main table, each chunk is taking 15-30 seconds.
This is on a 4 processor sun box running solaris, with 4GB of ram, and a lot of swap (8 GB i think). This is running MySQL 4.0.2 alpha, so that could be part of the issue. Any comments. Should it take this long? thanks sean peters [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
