Skip navigation links

MySQL Forums :: InnoDB :: Innodb bogs down on complicated query(ies)


Advanced Search

Re: Innodb bogs down on complicated query(ies)
Posted by: Marko Mäkelä ()
Date: August 14, 2006 06:08AM

Lee,

Have you tried replacing the stored procedures with client-side code? As far as I have understood, the stored procedure implementation in MySQL tries to lock all tables for the duration of the execution of the procedure, in order to ensure that statement-based replication is deterministic. With row-based replication, the locking could be relaxed. Again, to my understanding, InnoDB downgrades the locks requested by MySQL in most cases.

There might also be some configuration option for controlling the locking. If you are not using statement-based replication, you could at least have a look at innodb_locks_unsafe_for_binlog.

Please let us know if this helps. If not, we will have a closer look, since performance and locking problems are important for us.

Best regards,

Marko Mäkelä
Senior Software Engineer
Innobase Oy

Options: ReplyQuote


Subject Views Written By Posted
Innodb bogs down on complicated query(ies) 2404 Lee Krawczyk 05/03/2006 02:08PM
Re: Innodb bogs down on complicated query(ies) 1611 Marko Mäkelä 05/04/2006 02:26AM
Re: Innodb bogs down on complicated query(ies) 1571 Lee Krawczyk 05/04/2006 12:53PM
Re: Innodb bogs down on complicated query(ies) 1611 Marko Mäkelä 05/05/2006 01:39AM
Re: Innodb bogs down on complicated query(ies) 1571 Lee Krawczyk 05/05/2006 11:12AM
Re: Innodb bogs down on complicated query(ies) 1704 Marko Mäkelä 05/08/2006 05:56AM
Re: Innodb bogs down on complicated query(ies) 1608 Lee Krawczyk 05/08/2006 02:05PM
Re: Innodb bogs down on complicated query(ies) 1558 Marko Mäkelä 05/10/2006 05:14AM
Re: Innodb bogs down on complicated query(ies) 1573 Steve Johnson 05/09/2006 08:28PM
Re: Innodb bogs down on complicated query(ies) 1534 Lee Krawczyk 05/10/2006 10:11AM
Re: Innodb bogs down on complicated query(ies) 2296 Heikki Tuuri 05/18/2006 07:41AM
Re: Innodb bogs down on complicated query(ies) 1577 Lee Krawczyk 05/30/2006 05:39PM
Re: Innodb bogs down on complicated query(ies) 1784 Marko Mäkelä 06/15/2006 02:13AM
Re: Innodb bogs down on complicated query(ies) 1567 Asif Lodhi 06/21/2006 12:23AM
Re: Innodb bogs down on complicated query(ies) 1603 Lee Krawczyk 08/10/2006 12:09PM
Re: Innodb bogs down on complicated query(ies) 2551 Marko Mäkelä 08/14/2006 06:08AM
Re: Innodb bogs down on complicated query(ies) 1516 Lee Krawczyk 08/14/2006 12:26PM
Re: Innodb bogs down on complicated query(ies) 1496 Lee Krawczyk 09/28/2006 01:07PM
Re: Innodb bogs down on complicated query(ies) 1527 Marko Mäkelä 10/04/2006 07:52AM
Re: Innodb bogs down on complicated query(ies) 1401 Lee Krawczyk 10/04/2006 12:12PM
Re: Innodb bogs down on complicated query(ies) 1482 Marko Mäkelä 10/06/2006 03:00AM
Re: Innodb bogs down on complicated query(ies) 1523 Lee Krawczyk 10/11/2006 11:36AM
Re: Innodb bogs down on complicated query(ies) 1639 Marko Mäkelä 10/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.