← Back to team overview

percona-discussion team mailing list archive

[Bug 378100] Re: Innodb locks up under large INSERT load

 

Just a thought here - perhaps we're not actually deadlocked, just
running really slowly due to the one-second wakeups issued by the
sync_arr_wake_threads_if_sema_free() thread. If the wakeups aren't
occurring properly due to the weak memory ordering model on Power6, it
may be possible that lock acquires are taking up to a second to
complete.

I'd suggest testing this by putting a breakpoint on line 908 of
sync0arr.c and seeing how often it's hit.

-- 
Innodb locks up under large INSERT load
https://bugs.launchpad.net/bugs/378100
You received this bug notification because you are a member of Percona
developers, which is the registrant for Percona-XtraDB.

Status in Percona XtraDB Storage Engine for MySQL: New

Bug description:
While trying to load a new db on the 5.1.34-xtradb build, the Innodb engine locks up after a few minutes with multiple table loads running.

I can still log into the server, but I don't get any data back from the SHOW ENGINE INNODB STATUS command. I also can't kill any of the existing INSERT commands. I can reproduce the problem with as few as 3 simulateous loads (INSERT) occurring.

I am running this on SuSE version 10 with 8 processors and 126GB of RAM. 

Can I get some help in troubleshooting this? There are no messages being written to the error log.



Follow ups

References