Re: InnoDB migration between servers

2005-07-31 Thread Gleb Paharenko
Hello. If you have a reproducible test case, you should report a bug. Andreas Unterkircher [EMAIL PROTECTED] wrote: I can now isolate the problems with the appearing lock of some queries. I updated MySQL from 4.1 to 5beta (mysql-standard-5.0.10-beta-linux-x86_64-glibc23) to

Re: InnoDB migration between servers

2005-07-30 Thread Andreas Unterkircher
I can now isolate the problems with the appearing lock of some queries. I updated MySQL from 4.1 to 5beta (mysql-standard-5.0.10-beta-linux-x86_64-glibc23) to test if the problem still appears in the newer version. I made a full sqldump on the old server and import it successfully on the new

Re: InnoDB migration between servers

2005-07-29 Thread Andreas Unterkircher
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

Re: InnoDB migration between servers

2005-07-28 Thread Gleb Paharenko
Hello. 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. When I strace the

InnoDB migration between servers

2005-07-26 Thread Andreas Unterkircher
Hello list, I'm having some mysterious problems when I try to migrate several databases from one server to another one. This databases contain some InnoDB tables - db size is around ~3GB. On both servers I'm using MySQL version 4.1.12, the same kernel version, same libc (2.3.2), but different