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) 2250 Lee Krawczyk 05/03/2006 02:08PM
Re: Innodb bogs down on complicated query(ies) 1499 Marko Mäkelä 05/04/2006 02:26AM
Re: Innodb bogs down on complicated query(ies) 1491 Lee Krawczyk 05/04/2006 12:53PM
Re: Innodb bogs down on complicated query(ies) 1500 Marko Mäkelä 05/05/2006 01:39AM
Re: Innodb bogs down on complicated query(ies) 1469 Lee Krawczyk 05/05/2006 11:12AM
Re: Innodb bogs down on complicated query(ies) 1577 Marko Mäkelä 05/08/2006 05:56AM
Re: Innodb bogs down on complicated query(ies) 1486 Lee Krawczyk 05/08/2006 02:05PM
Re: Innodb bogs down on complicated query(ies) 1433 Marko Mäkelä 05/10/2006 05:14AM
Re: Innodb bogs down on complicated query(ies) 1478 Steve Johnson 05/09/2006 08:28PM
Re: Innodb bogs down on complicated query(ies) 1418 Lee Krawczyk 05/10/2006 10:11AM
Re: Innodb bogs down on complicated query(ies) 2176 Heikki Tuuri 05/18/2006 07:41AM
Re: Innodb bogs down on complicated query(ies) 1459 Lee Krawczyk 05/30/2006 05:39PM
Re: Innodb bogs down on complicated query(ies) 1646 Marko Mäkelä 06/15/2006 02:13AM
Re: Innodb bogs down on complicated query(ies) 1462 Asif Lodhi 06/21/2006 12:23AM
Re: Innodb bogs down on complicated query(ies) 1504 Lee Krawczyk 08/10/2006 12:09PM
Re: Innodb bogs down on complicated query(ies) 2439 Marko Mäkelä 08/14/2006 06:08AM
Re: Innodb bogs down on complicated query(ies) 1394 Lee Krawczyk 08/14/2006 12:26PM
Re: Innodb bogs down on complicated query(ies) 1403 Lee Krawczyk 09/28/2006 01:07PM
Re: Innodb bogs down on complicated query(ies) 1426 Marko Mäkelä 10/04/2006 07:52AM
Re: Innodb bogs down on complicated query(ies) 1307 Lee Krawczyk 10/04/2006 12:12PM
Re: Innodb bogs down on complicated query(ies) 1390 Marko Mäkelä 10/06/2006 03:00AM
Re: Innodb bogs down on complicated query(ies) 1414 Lee Krawczyk 10/11/2006 11:36AM
Re: Innodb bogs down on complicated query(ies) 1545 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.