percona-discussion team mailing list archive
-
percona-discussion team
-
Mailing list archive
-
Message #00639
[Bug 378100] Re: Innodb locks up under large INSERT load
As Mark has said, compiling UNIV_SYNC_DEBUG may be a good idea; in this
case we'll be able to see where the buf_pool_mutex was acquired.
However, this may perturb the timing enough to make things work again.
If this is the case, let me know and I'll try to get a repro case on a
machine with more CPU threads.
--
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.
References