Re: Innodb bogs down on complicated query(ies)
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
Subject
Views
Written By
Posted
3176
May 03, 2006 02:08PM
1894
May 04, 2006 02:26AM
1884
May 04, 2006 12:53PM
2009
May 05, 2006 01:39AM
1891
May 05, 2006 11:12AM
2032
May 08, 2006 05:56AM
1904
May 08, 2006 02:05PM
1896
May 10, 2006 05:14AM
2001
May 09, 2006 08:28PM
1850
May 10, 2006 10:11AM
2766
May 18, 2006 07:41AM
1891
May 30, 2006 05:39PM
2186
June 15, 2006 02:13AM
1939
June 21, 2006 12:23AM
1952
August 10, 2006 12:09PM
3132
August 14, 2006 06:08AM
Re: Innodb bogs down on complicated query(ies)
1835
August 14, 2006 12:26PM
1868
September 28, 2006 01:07PM
1861
October 04, 2006 07:52AM
1753
October 04, 2006 12:12PM
1781
October 06, 2006 03:00AM
1832
October 11, 2006 11:36AM
1898
October 16, 2006 06:49AM
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.