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) 1874 Lee Krawczyk 05/03/2006 02:08PM
Re: Innodb bogs down on complicated query(ies) 1433 Marko Mäkelä 05/04/2006 02:26AM
Re: Innodb bogs down on complicated query(ies) 1436 Lee Krawczyk 05/04/2006 12:53PM
Re: Innodb bogs down on complicated query(ies) 1436 Marko Mäkelä 05/05/2006 01:39AM
Re: Innodb bogs down on complicated query(ies) 1399 Lee Krawczyk 05/05/2006 11:12AM
Re: Innodb bogs down on complicated query(ies) 1505 Marko Mäkelä 05/08/2006 05:56AM
Re: Innodb bogs down on complicated query(ies) 1405 Lee Krawczyk 05/08/2006 02:05PM
Re: Innodb bogs down on complicated query(ies) 1355 Marko Mäkelä 05/10/2006 05:14AM
Re: Innodb bogs down on complicated query(ies) 1405 Steve Johnson 05/09/2006 08:28PM
Re: Innodb bogs down on complicated query(ies) 1333 Lee Krawczyk 05/10/2006 10:11AM
Re: Innodb bogs down on complicated query(ies) 2063 Heikki Tuuri 05/18/2006 07:41AM
Re: Innodb bogs down on complicated query(ies) 1392 Lee Krawczyk 05/30/2006 05:39PM
Re: Innodb bogs down on complicated query(ies) 1539 Marko Mäkelä 06/15/2006 02:13AM
Re: Innodb bogs down on complicated query(ies) 1375 Asif Lodhi 06/21/2006 12:23AM
Re: Innodb bogs down on complicated query(ies) 1445 Lee Krawczyk 08/10/2006 12:09PM
Re: Innodb bogs down on complicated query(ies) 2363 Marko Mäkelä 08/14/2006 06:08AM
Re: Innodb bogs down on complicated query(ies) 1328 Lee Krawczyk 08/14/2006 12:26PM
Re: Innodb bogs down on complicated query(ies) 1328 Lee Krawczyk 09/28/2006 01:07PM
Re: Innodb bogs down on complicated query(ies) 1354 Marko Mäkelä 10/04/2006 07:52AM
Re: Innodb bogs down on complicated query(ies) 1250 Lee Krawczyk 10/04/2006 12:12PM
Re: Innodb bogs down on complicated query(ies) 1309 Marko Mäkelä 10/06/2006 03:00AM
Re: Innodb bogs down on complicated query(ies) 1350 Lee Krawczyk 10/11/2006 11:36AM
Re: Innodb bogs down on complicated query(ies) 1463 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.