sean c peters <[EMAIL PROTECTED]> wrote: > 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?
First you definitely need to upgrade to a recent MySQL version. 4.0.20. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]