MySQL Forums
Forum List  »  InnoDB

Re: Innodb bogs down on complicated query(ies)
Posted by: Lee Krawczyk
Date: August 14, 2006 12:26PM

Marko,

We'll try the innodb_locks_unsafe_for_binlog=1 since we've created our own methods for replication.

I don't want to rewrite the client side if I don't have to. That would be a major undertaking. I waited for stored functions from mysql for many years so I could move away from Oracle and SQL Server.

I know that Heikki worked on a bug in stored functions regarding downgrading locking, and the fix was released in 5.0.20. I'm just not convinced that all the issues of the locking mechanism were addressed.

All in all I am extremely pleased with the way MySql is performing 95% of the time. It's just certain times I am having this problem. Somewhat frustrating.

Thanks for the help and I'll let you know.

Lee

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Innodb bogs down on complicated query(ies)
1799
August 14, 2006 12:26PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.