> > When I strace the mysqld process it doesn't do anything, it's waiting
>
> Do you use the official binaries? There're additional InnoDB monitors
> mentioned at:
> http://dev.mysql.com/doc/mysql/en/innodb-monitor.html
>
> which could provide more information.
My first try was with the included debian-mysql-amd64 package (against
64bit libs compiled). But it also happens with the official binaries
(for example with
mysql-standard-4.1.13-unknown-linux-gnu-x86_64-glibc23.tar.gz).
I already tried to activated the innodb monitor (create table ...).
But SHOW INNODB STATUS still show no problem (or active transactions),
while SHOW PROCESSLIST show me ongoing & locked queries...
>
> > When I strace the mysqld process it doesn't do anything, it's waiting
>
> MySQL trace files often help. See:
> http://dev.mysql.com/doc/mysql/en/making-trace-files.html
I get a big trace file... but for me it's not readable or providing any
help...
Possible that I hit the problem with mysql/libc2.3/amd64 ...
http://hashmysql.org/index.php?title=Opteron_HOWTO#pthread_rwlock_wrlock_hang_with_nptl
Cheers,
Andreas
