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) 2100 Lee Krawczyk 05/03/2006 02:08PM
Re: Innodb bogs down on complicated query(ies) 1465 Marko Mäkelä 05/04/2006 02:26AM
Re: Innodb bogs down on complicated query(ies) 1462 Lee Krawczyk 05/04/2006 12:53PM
Re: Innodb bogs down on complicated query(ies) 1481 Marko Mäkelä 05/05/2006 01:39AM
Re: Innodb bogs down on complicated query(ies) 1448 Lee Krawczyk 05/05/2006 11:12AM
Re: Innodb bogs down on complicated query(ies) 1540 Marko Mäkelä 05/08/2006 05:56AM
Re: Innodb bogs down on complicated query(ies) 1462 Lee Krawczyk 05/08/2006 02:05PM
Re: Innodb bogs down on complicated query(ies) 1395 Marko Mäkelä 05/10/2006 05:14AM
Re: Innodb bogs down on complicated query(ies) 1442 Steve Johnson 05/09/2006 08:28PM
Re: Innodb bogs down on complicated query(ies) 1385 Lee Krawczyk 05/10/2006 10:11AM
Re: Innodb bogs down on complicated query(ies) 2121 Heikki Tuuri 05/18/2006 07:41AM
Re: Innodb bogs down on complicated query(ies) 1418 Lee Krawczyk 05/30/2006 05:39PM
Re: Innodb bogs down on complicated query(ies) 1597 Marko Mäkelä 06/15/2006 02:13AM
Re: Innodb bogs down on complicated query(ies) 1417 Asif Lodhi 06/21/2006 12:23AM
Re: Innodb bogs down on complicated query(ies) 1485 Lee Krawczyk 08/10/2006 12:09PM
Re: Innodb bogs down on complicated query(ies) 2404 Marko Mäkelä 08/14/2006 06:08AM
Re: Innodb bogs down on complicated query(ies) 1365 Lee Krawczyk 08/14/2006 12:26PM
Re: Innodb bogs down on complicated query(ies) 1380 Lee Krawczyk 09/28/2006 01:07PM
Re: Innodb bogs down on complicated query(ies) 1388 Marko Mäkelä 10/04/2006 07:52AM
Re: Innodb bogs down on complicated query(ies) 1277 Lee Krawczyk 10/04/2006 12:12PM
Re: Innodb bogs down on complicated query(ies) 1355 Marko Mäkelä 10/06/2006 03:00AM
Re: Innodb bogs down on complicated query(ies) 1377 Lee Krawczyk 10/11/2006 11:36AM
Re: Innodb bogs down on complicated query(ies) 1506 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.