Hi, Since we upgraded from MySql 3.20 to 4.1 innodb seems to have become slower.
I'd like to understand the innodb status a bit better. Here is a the slow innodb transaction ---TRANSACTION 0 2599083795, ACTIVE 72659 sec, process no 12324, OS thread id 1138606116 estimating records in index range mysql tables in use 1, locked 1 1527743 lock struct(s), heap size 127790400, undo log entries 127362260 MySQL thread id 8885936, query id 78269607 10.168.80.166 web init delete from negotiated_classes_cache where id=110495925522553001 Trx read view will not see trx with id >= 0 2599083796, sees < 0 2599083791 What exactly does this mean ? And why would this query take so long ? In this table Id is the primary key. The machine that this is running on is a Dell quad Xeon and the data is stored on a SAN. The machine is not showing high load at all. I'd be grateful for your advice. Please let me know if I should provide any more information. Regards, Marvin Wright Flights Developer Lastminute.com [EMAIL PROTECTED] +44 (0) 207 802 4543 ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com **********************************************************************
