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) 2529 Lee Krawczyk 05/03/2006 02:08PM
Re: Innodb bogs down on complicated query(ies) 1664 Marko Mäkelä 05/04/2006 02:26AM
Re: Innodb bogs down on complicated query(ies) 1648 Lee Krawczyk 05/04/2006 12:53PM
Re: Innodb bogs down on complicated query(ies) 1689 Marko Mäkelä 05/05/2006 01:39AM
Re: Innodb bogs down on complicated query(ies) 1611 Lee Krawczyk 05/05/2006 11:12AM
Re: Innodb bogs down on complicated query(ies) 1757 Marko Mäkelä 05/08/2006 05:56AM
Re: Innodb bogs down on complicated query(ies) 1656 Lee Krawczyk 05/08/2006 02:05PM
Re: Innodb bogs down on complicated query(ies) 1611 Marko Mäkelä 05/10/2006 05:14AM
Re: Innodb bogs down on complicated query(ies) 1618 Steve Johnson 05/09/2006 08:28PM
Re: Innodb bogs down on complicated query(ies) 1590 Lee Krawczyk 05/10/2006 10:11AM
Re: Innodb bogs down on complicated query(ies) 2345 Heikki Tuuri 05/18/2006 07:41AM
Re: Innodb bogs down on complicated query(ies) 1609 Lee Krawczyk 05/30/2006 05:39PM
Re: Innodb bogs down on complicated query(ies) 1844 Marko Mäkelä 06/15/2006 02:13AM
Re: Innodb bogs down on complicated query(ies) 1631 Asif Lodhi 06/21/2006 12:23AM
Re: Innodb bogs down on complicated query(ies) 1667 Lee Krawczyk 08/10/2006 12:09PM
Re: Innodb bogs down on complicated query(ies) 2612 Marko Mäkelä 08/14/2006 06:08AM
Re: Innodb bogs down on complicated query(ies) 1565 Lee Krawczyk 08/14/2006 12:26PM
Re: Innodb bogs down on complicated query(ies) 1543 Lee Krawczyk 09/28/2006 01:07PM
Re: Innodb bogs down on complicated query(ies) 1565 Marko Mäkelä 10/04/2006 07:52AM
Re: Innodb bogs down on complicated query(ies) 1447 Lee Krawczyk 10/04/2006 12:12PM
Re: Innodb bogs down on complicated query(ies) 1532 Marko Mäkelä 10/06/2006 03:00AM
Re: Innodb bogs down on complicated query(ies) 1563 Lee Krawczyk 10/11/2006 11:36AM
Re: Innodb bogs down on complicated query(ies) 1677 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.