Re: runaway process eating all cpu-time?
I converted the only innodb-table to myisam so the innodb-engine is no longer used. The problem has vanished since then. Pity that there seems to be no simple way to diagnose the problem in innodb. check table has showed no problems. Seems like I have to stay away from innodb for the time being :(. thomas Victor Pendleton wrote: Do you have anything in the show processlist? Are you using innodb table types and a rollback is occurring? -Original Message- From: Thomas - Lists To: [EMAIL PROTECTED] Sent: 8/24/04 6:49 AM Subject: runaway process eating all cpu-time? Hi there, after a system-crash I got the following problem. Some seconds after starting mysql (v4.0.20) a process will stay there taking all cpu-time it can get (99.9% ;)) ... and it can't be terminated, just killed completely. mysqlcheck ran through without any problems, the logs tell nothing. I just did a strace on the last process doing that: --- time(NULL) = 1093348119 time(NULL) = 1093348119 time(NULL) = 1093348119 time(NULL) = 1093348119 time(NULL) = 1093348119 time(NULL) = 1093348119 time(NULL) = 1093348119 time(NULL) = 1093348119 time(NULL) = 1093348119 time(NULL) = 1093348119 time(NULL) = 1093348119 time(NULL) = 1093348119 time(NULL) = 1093348120 time(NULL) = 1093348120 time(NULL) = 1093348120 time(NULL) = 1093348120 time(NULL) = 1093348120 time(NULL) = 1093348120 time(NULL) = 1093348120 time(NULL) = 1093348120 time(NULL) = 1093348120 time(NULL) = 1093348120 time(NULL) = 1093348120 time(NULL) = 1093348120 time(NULL) = 1093348120 sched_yield() = 0 time(NULL) = 1093348120 rt_sigprocmask(SIG_SETMASK, NULL, [HUP INT QUIT PIPE TERM TSTP 32], 8) = 0 rt_sigsuspend([HUP INT QUIT PIPE TERM TSTP] --- SIGRT_0 (Real-time signal 0) --- --- Any idea where to look at that problem further? The system is a linux - redhat-7.2 with dual athlon-mp, 2 GB ram, running kernel-2.4.26. Using the official mysql.com-binaries (rpm-install). TIA, Thomas -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: runaway process eating all cpu-time?
Hi Victor, thanks for your reply. Victor Pendleton wrote: Do you have anything in the show processlist? Are you using innodb table types and a rollback is occurring? mysql> show processlist; +---+-+---+---++--++--+ | Id| User| Host | db| Command| Time | State | Info | +---+-+---+---++--++--+ | 810 | DELAYED | | phpadsnew | Delayed_insert | 3| Waiting for INSERT | | | 10125 | root| localhost | NULL | Sleep | 70 || NULL | | 12020 | root| localhost | NULL | Query | 0| NULL | show processlist | +---+-+---+---++--++--+ Could it be the delayed_insert thread? I checked its tables extended already. Any way to see a connection-id <-> process-id relation? I'm using innodb just for one table at the moment. but its idle too. Any ideas? Thanks, Thomas -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: runaway process eating all cpu-time?
Do you have anything in the show processlist? Are you using innodb table types and a rollback is occurring? -Original Message- From: Thomas - Lists To: [EMAIL PROTECTED] Sent: 8/24/04 6:49 AM Subject: runaway process eating all cpu-time? Hi there, after a system-crash I got the following problem. Some seconds after starting mysql (v4.0.20) a process will stay there taking all cpu-time it can get (99.9% ;)) ... and it can't be terminated, just killed completely. mysqlcheck ran through without any problems, the logs tell nothing. I just did a strace on the last process doing that: --- time(NULL) = 1093348119 time(NULL) = 1093348119 time(NULL) = 1093348119 time(NULL) = 1093348119 time(NULL) = 1093348119 time(NULL) = 1093348119 time(NULL) = 1093348119 time(NULL) = 1093348119 time(NULL) = 1093348119 time(NULL) = 1093348119 time(NULL) = 1093348119 time(NULL) = 1093348119 time(NULL) = 1093348120 time(NULL) = 1093348120 time(NULL) = 1093348120 time(NULL) = 1093348120 time(NULL) = 1093348120 time(NULL) = 1093348120 time(NULL) = 1093348120 time(NULL) = 1093348120 time(NULL) = 1093348120 time(NULL) = 1093348120 time(NULL) = 1093348120 time(NULL) = 1093348120 time(NULL) = 1093348120 sched_yield() = 0 time(NULL) = 1093348120 rt_sigprocmask(SIG_SETMASK, NULL, [HUP INT QUIT PIPE TERM TSTP 32], 8) = 0 rt_sigsuspend([HUP INT QUIT PIPE TERM TSTP] --- SIGRT_0 (Real-time signal 0) --- --- Any idea where to look at that problem further? The system is a linux - redhat-7.2 with dual athlon-mp, 2 GB ram, running kernel-2.4.26. Using the official mysql.com-binaries (rpm-install). TIA, Thomas -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]