iostats per mysql process
Does anyone has any suggestions on how to get IO stats used by per process (mysqld) on Linux 2.6.18-53 kernel ... I just need to seeĀ how much reads and writes mysql is actually doing and what else is causing the IO load..
Re: iostats per mysql process
iopp but that need 2.6.20 kernel support On Wed, Jul 15, 2009 at 12:32 PM, dbrb2002-...@yahoo.com wrote: Does anyone has any suggestions on how to get IO stats used by per process (mysqld) on Linux 2.6.18-53 kernel ... I just need to seeĀ how much reads and writes mysql is actually doing and what else is causing the IO load.. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: MYSQL PROCESS
Can you give us the output of `uname -a` from your mysql hosts? There's a difference if you are running a 2.4 kernel vs. 2.6 kernel (Linux). In 2.4 kernel, try ps -ef, and in 2.6 kernel, ps -Lef. You may notice that PPID is the same for all PIDs except one, usually. -Paul On Thu, 2008-08-14 at 13:38 +0530, Krishna Chandra Prajapati wrote: But some of the mysql server(mysql server on debian) shows only one mysql process. On Thu, Aug 14, 2008 at 12:56 PM, Ellison, David [EMAIL PROTECTED] wrote: I may be talking rubbish here, but is it not threading? I have seen Linux processes before create more than one PID etc when it needs to handle multiple requests. This may be not true for MySQL. However when looking at my test server is shows more than one. If you use a command called htop, similar to top but a little more visually easier, it has an option called tree. Which shows how one process spawns many when/where needed. Dave -Original Message- From: Krishna Chandra Prajapati [mailto:[EMAIL PROTECTED] Sent: 14 August 2008 05:57 To: mysql Subject: MYSQL PROCESS Hi all, I am running mysql on debian. I didn't understand why there is a lots of mysql process running. There should be only one mysql process running. Please help me that what should i do. Although there is no problem with mysql server. debian:~# ps axu USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND root 1 0.0 0.0 1400 472 ?SJun03 0:03 init [2] root 2 0.0 0.0 00 ?SJun03 0:01 [keventd] root 3 0.0 0.0 00 ?SN Jun03 0:06 [ksoftirqd_CPU0] root 4 0.0 0.0 00 ?SJun03 2:25 [kswapd] root 5 0.0 0.0 00 ?SJun03 0:00 [bdflush] root 6 0.0 0.0 00 ?SJun03 1:15 [kupdated] root99 0.0 0.0 00 ?SJun03 6:52 [kjournald] root 250 0.0 0.0 00 ?SJun03 0:00 [kcopyd] root 252 0.0 0.0 00 ?SJun03 0:00 [kmirrord] root 265 0.0 0.0 00 ?SJun03 0:00 [kjournald] root 431 0.0 0.0 00 ?SJun03 0:00 [khubd] root 1247 0.0 0.0 1456 600 ?Ss Jun03 0:04 /sbin/syslogd root 1250 0.0 0.0 2084 444 ?Ss Jun03 0:00 /sbin/klogd root 1288 0.0 0.1 2432 1024 ?SJun03 0:00 /bin/sh /usr/bin/mysqld_safe mysql 1325 0.0 27.1 324124 262548 ? SJun03 0:31 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 1336 0.0 27.1 324124 262548 ? SJun03 0:03 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 1337 0.0 27.1 324124 262548 ? SJun03 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 1338 0.0 27.1 324124 262548 ? SJun03 0:01 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 1339 0.0 27.1 324124 262548 ? SJun03 16:49 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 1340 0.0 27.1 324124 262548 ? SJun03 0:30 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 1369 0.0 27.1 324124 262548 ? SJun03 6:10 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 1370 0.0 27.1 324124 262548 ? SJun03 3:32 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 1380 0.0 27.1 324124 262548 ? SJun03 1:16 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 1381 0.0 27.1 324124 262548 ? SJun03 0:08 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 1384 0.0 27.1 324124 262548 ? SJun03 5:33 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ root 1431 0.0 0.1 4736 1560 ?Ss Jun03 1:23 /usr/sbin/sshd . . . .. . mysql 3404 0.0 27.1 324124 262548 ? SJun04 3:22 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 3456 0.0 27.1 324124 262548 ? SJun04 3:06 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 3607 0.0 27.1 324124 262548 ? SJun04 3:24 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 3685 0.0 27.1 324124 262548 ? SJun04 2:25 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 5325 0.0 27.1 324124 262548 ? SJun05 3:14 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 5352 0.0 27.1 324124 262548 ? SJun05 3:21 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 5374 0.0 27.1 324124 262548 ? SJun05 3:16 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 5378 0.0 27.1 324124 262548 ? SJun05 3:06 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 5397 0.0 27.1 324124 262548 ? SJun05 2:49 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 5398 0.0
Re: MYSQL PROCESS
Is it possible to shutdown and restart mysql again, if its not in production. regards anandkl On 8/14/08, Krishna Chandra Prajapati [EMAIL PROTECTED] wrote: Hi all, I am running mysql on debian. I didn't understand why there is a lots of mysql process running. There should be only one mysql process running. Please help me that what should i do. Although there is no problem with mysql server. debian:~# ps axu USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND root 1 0.0 0.0 1400 472 ?SJun03 0:03 init [2] root 2 0.0 0.0 00 ?SJun03 0:01 [keventd] root 3 0.0 0.0 00 ?SN Jun03 0:06 [ksoftirqd_CPU0] root 4 0.0 0.0 00 ?SJun03 2:25 [kswapd] root 5 0.0 0.0 00 ?SJun03 0:00 [bdflush] root 6 0.0 0.0 00 ?SJun03 1:15 [kupdated] root99 0.0 0.0 00 ?SJun03 6:52 [kjournald] root 250 0.0 0.0 00 ?SJun03 0:00 [kcopyd] root 252 0.0 0.0 00 ?SJun03 0:00 [kmirrord] root 265 0.0 0.0 00 ?SJun03 0:00 [kjournald] root 431 0.0 0.0 00 ?SJun03 0:00 [khubd] root 1247 0.0 0.0 1456 600 ?Ss Jun03 0:04 /sbin/syslogd root 1250 0.0 0.0 2084 444 ?Ss Jun03 0:00 /sbin/klogd root 1288 0.0 0.1 2432 1024 ?SJun03 0:00 /bin/sh /usr/bin/mysqld_safe mysql 1325 0.0 27.1 324124 262548 ? SJun03 0:31 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 1336 0.0 27.1 324124 262548 ? SJun03 0:03 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 1337 0.0 27.1 324124 262548 ? SJun03 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 1338 0.0 27.1 324124 262548 ? SJun03 0:01 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 1339 0.0 27.1 324124 262548 ? SJun03 16:49 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 1340 0.0 27.1 324124 262548 ? SJun03 0:30 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 1369 0.0 27.1 324124 262548 ? SJun03 6:10 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 1370 0.0 27.1 324124 262548 ? SJun03 3:32 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 1380 0.0 27.1 324124 262548 ? SJun03 1:16 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 1381 0.0 27.1 324124 262548 ? SJun03 0:08 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 1384 0.0 27.1 324124 262548 ? SJun03 5:33 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ root 1431 0.0 0.1 4736 1560 ?Ss Jun03 1:23 /usr/sbin/sshd . . . .. . mysql 3404 0.0 27.1 324124 262548 ? SJun04 3:22 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 3456 0.0 27.1 324124 262548 ? SJun04 3:06 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 3607 0.0 27.1 324124 262548 ? SJun04 3:24 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 3685 0.0 27.1 324124 262548 ? SJun04 2:25 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 5325 0.0 27.1 324124 262548 ? SJun05 3:14 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 5352 0.0 27.1 324124 262548 ? SJun05 3:21 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 5374 0.0 27.1 324124 262548 ? SJun05 3:16 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 5378 0.0 27.1 324124 262548 ? SJun05 3:06 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 5397 0.0 27.1 324124 262548 ? SJun05 2:49 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 5398 0.0 27.1 324124 262548 ? SJun05 2:51 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 5400 0.0 27.1 324124 262548 ? SJun05 3:35 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ -- Krishna Chandra Prajapati MySQL DBA, Ed Ventures e-Learning Pvt.Ltd. 1-8-303/48/15, Sindhi Colony P.G.Road, Secunderabad. Pin Code: 53 Office Number: 040-66489771 Mob: 9912924044 URL: ed-ventures-online.com Email-id: [EMAIL PROTECTED]
RE: MYSQL PROCESS
I may be talking rubbish here, but is it not threading? I have seen Linux processes before create more than one PID etc when it needs to handle multiple requests. This may be not true for MySQL. However when looking at my test server is shows more than one. If you use a command called htop, similar to top but a little more visually easier, it has an option called tree. Which shows how one process spawns many when/where needed. Dave -Original Message- From: Krishna Chandra Prajapati [mailto:[EMAIL PROTECTED] Sent: 14 August 2008 05:57 To: mysql Subject: MYSQL PROCESS Hi all, I am running mysql on debian. I didn't understand why there is a lots of mysql process running. There should be only one mysql process running. Please help me that what should i do. Although there is no problem with mysql server. debian:~# ps axu USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND root 1 0.0 0.0 1400 472 ?SJun03 0:03 init [2] root 2 0.0 0.0 00 ?SJun03 0:01 [keventd] root 3 0.0 0.0 00 ?SN Jun03 0:06 [ksoftirqd_CPU0] root 4 0.0 0.0 00 ?SJun03 2:25 [kswapd] root 5 0.0 0.0 00 ?SJun03 0:00 [bdflush] root 6 0.0 0.0 00 ?SJun03 1:15 [kupdated] root99 0.0 0.0 00 ?SJun03 6:52 [kjournald] root 250 0.0 0.0 00 ?SJun03 0:00 [kcopyd] root 252 0.0 0.0 00 ?SJun03 0:00 [kmirrord] root 265 0.0 0.0 00 ?SJun03 0:00 [kjournald] root 431 0.0 0.0 00 ?SJun03 0:00 [khubd] root 1247 0.0 0.0 1456 600 ?Ss Jun03 0:04 /sbin/syslogd root 1250 0.0 0.0 2084 444 ?Ss Jun03 0:00 /sbin/klogd root 1288 0.0 0.1 2432 1024 ?SJun03 0:00 /bin/sh /usr/bin/mysqld_safe mysql 1325 0.0 27.1 324124 262548 ? SJun03 0:31 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 1336 0.0 27.1 324124 262548 ? SJun03 0:03 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 1337 0.0 27.1 324124 262548 ? SJun03 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 1338 0.0 27.1 324124 262548 ? SJun03 0:01 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 1339 0.0 27.1 324124 262548 ? SJun03 16:49 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 1340 0.0 27.1 324124 262548 ? SJun03 0:30 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 1369 0.0 27.1 324124 262548 ? SJun03 6:10 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 1370 0.0 27.1 324124 262548 ? SJun03 3:32 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 1380 0.0 27.1 324124 262548 ? SJun03 1:16 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 1381 0.0 27.1 324124 262548 ? SJun03 0:08 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 1384 0.0 27.1 324124 262548 ? SJun03 5:33 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ root 1431 0.0 0.1 4736 1560 ?Ss Jun03 1:23 /usr/sbin/sshd . . . .. . mysql 3404 0.0 27.1 324124 262548 ? SJun04 3:22 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 3456 0.0 27.1 324124 262548 ? SJun04 3:06 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 3607 0.0 27.1 324124 262548 ? SJun04 3:24 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 3685 0.0 27.1 324124 262548 ? SJun04 2:25 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 5325 0.0 27.1 324124 262548 ? SJun05 3:14 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 5352 0.0 27.1 324124 262548 ? SJun05 3:21 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 5374 0.0 27.1 324124 262548 ? SJun05 3:16 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 5378 0.0 27.1 324124 262548 ? SJun05 3:06 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 5397 0.0 27.1 324124 262548 ? SJun05 2:49 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 5398 0.0 27.1 324124 262548 ? SJun05 2:51 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 5400 0.0 27.1 324124 262548 ? SJun05 3:35 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ -- Krishna Chandra Prajapati MySQL DBA, Ed Ventures e-Learning Pvt.Ltd. 1-8-303/48/15, Sindhi Colony P.G.Road, Secunderabad. Pin Code: 53 Office Number: 040-66489771 Mob: 9912924044 URL: ed-ventures-online.com Email-id: [EMAIL PROTECTED] This message has been scanned for viruses by MailControl - (see http://bluepages.wsatkins.co.uk/?6875772) This email and any attached files are confidential and copyright protected. If you are not the addressee, any dissemination
Re: MYSQL PROCESS
On Thu, 14 Aug 2008 10:27:29 +0530, Krishna Chandra Prajapati wrote: Please help me that what should i do. Nothing. It's just multi-threaded. Everything's fine. -- Matthias Urlichs -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MYSQL PROCESS
But some of the mysql server(mysql server on debian) shows only one mysql process. On Thu, Aug 14, 2008 at 12:56 PM, Ellison, David [EMAIL PROTECTED] wrote: I may be talking rubbish here, but is it not threading? I have seen Linux processes before create more than one PID etc when it needs to handle multiple requests. This may be not true for MySQL. However when looking at my test server is shows more than one. If you use a command called htop, similar to top but a little more visually easier, it has an option called tree. Which shows how one process spawns many when/where needed. Dave -Original Message- From: Krishna Chandra Prajapati [mailto:[EMAIL PROTECTED] Sent: 14 August 2008 05:57 To: mysql Subject: MYSQL PROCESS Hi all, I am running mysql on debian. I didn't understand why there is a lots of mysql process running. There should be only one mysql process running. Please help me that what should i do. Although there is no problem with mysql server. debian:~# ps axu USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND root 1 0.0 0.0 1400 472 ?SJun03 0:03 init [2] root 2 0.0 0.0 00 ?SJun03 0:01 [keventd] root 3 0.0 0.0 00 ?SN Jun03 0:06 [ksoftirqd_CPU0] root 4 0.0 0.0 00 ?SJun03 2:25 [kswapd] root 5 0.0 0.0 00 ?SJun03 0:00 [bdflush] root 6 0.0 0.0 00 ?SJun03 1:15 [kupdated] root99 0.0 0.0 00 ?SJun03 6:52 [kjournald] root 250 0.0 0.0 00 ?SJun03 0:00 [kcopyd] root 252 0.0 0.0 00 ?SJun03 0:00 [kmirrord] root 265 0.0 0.0 00 ?SJun03 0:00 [kjournald] root 431 0.0 0.0 00 ?SJun03 0:00 [khubd] root 1247 0.0 0.0 1456 600 ?Ss Jun03 0:04 /sbin/syslogd root 1250 0.0 0.0 2084 444 ?Ss Jun03 0:00 /sbin/klogd root 1288 0.0 0.1 2432 1024 ?SJun03 0:00 /bin/sh /usr/bin/mysqld_safe mysql 1325 0.0 27.1 324124 262548 ? SJun03 0:31 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 1336 0.0 27.1 324124 262548 ? SJun03 0:03 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 1337 0.0 27.1 324124 262548 ? SJun03 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 1338 0.0 27.1 324124 262548 ? SJun03 0:01 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 1339 0.0 27.1 324124 262548 ? SJun03 16:49 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 1340 0.0 27.1 324124 262548 ? SJun03 0:30 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 1369 0.0 27.1 324124 262548 ? SJun03 6:10 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 1370 0.0 27.1 324124 262548 ? SJun03 3:32 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 1380 0.0 27.1 324124 262548 ? SJun03 1:16 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 1381 0.0 27.1 324124 262548 ? SJun03 0:08 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 1384 0.0 27.1 324124 262548 ? SJun03 5:33 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ root 1431 0.0 0.1 4736 1560 ?Ss Jun03 1:23 /usr/sbin/sshd . . . .. . mysql 3404 0.0 27.1 324124 262548 ? SJun04 3:22 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 3456 0.0 27.1 324124 262548 ? SJun04 3:06 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 3607 0.0 27.1 324124 262548 ? SJun04 3:24 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 3685 0.0 27.1 324124 262548 ? SJun04 2:25 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 5325 0.0 27.1 324124 262548 ? SJun05 3:14 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 5352 0.0 27.1 324124 262548 ? SJun05 3:21 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 5374 0.0 27.1 324124 262548 ? SJun05 3:16 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 5378 0.0 27.1 324124 262548 ? SJun05 3:06 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 5397 0.0 27.1 324124 262548 ? SJun05 2:49 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 5398 0.0 27.1 324124 262548 ? SJun05 2:51 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 5400 0.0 27.1 324124 262548 ? SJun05 3:35 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ -- Krishna Chandra Prajapati MySQL DBA, Ed Ventures e-Learning Pvt.Ltd. 1-8-303/48/15, Sindhi Colony P.G.Road, Secunderabad. Pin Code: 53 Office Number: 040-66489771 Mob: 9912924044 URL: ed-ventures-online.com Email-id: [EMAIL
Re: MYSQL PROCESS
r they all runing on the same port On 8/14/08, Krishna Chandra Prajapati [EMAIL PROTECTED] wrote: But some of the mysql server(mysql server on debian) shows only one mysql process. On Thu, Aug 14, 2008 at 12:56 PM, Ellison, David [EMAIL PROTECTED] wrote: I may be talking rubbish here, but is it not threading? I have seen Linux processes before create more than one PID etc when it needs to handle multiple requests. This may be not true for MySQL. However when looking at my test server is shows more than one. If you use a command called htop, similar to top but a little more visually easier, it has an option called tree. Which shows how one process spawns many when/where needed. Dave -Original Message- From: Krishna Chandra Prajapati [mailto:[EMAIL PROTECTED] Sent: 14 August 2008 05:57 To: mysql Subject: MYSQL PROCESS Hi all, I am running mysql on debian. I didn't understand why there is a lots of mysql process running. There should be only one mysql process running. Please help me that what should i do. Although there is no problem with mysql server. debian:~# ps axu USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND root 1 0.0 0.0 1400 472 ?SJun03 0:03 init [2] root 2 0.0 0.0 00 ?SJun03 0:01 [keventd] root 3 0.0 0.0 00 ?SN Jun03 0:06 [ksoftirqd_CPU0] root 4 0.0 0.0 00 ?SJun03 2:25 [kswapd] root 5 0.0 0.0 00 ?SJun03 0:00 [bdflush] root 6 0.0 0.0 00 ?SJun03 1:15 [kupdated] root99 0.0 0.0 00 ?SJun03 6:52 [kjournald] root 250 0.0 0.0 00 ?SJun03 0:00 [kcopyd] root 252 0.0 0.0 00 ?SJun03 0:00 [kmirrord] root 265 0.0 0.0 00 ?SJun03 0:00 [kjournald] root 431 0.0 0.0 00 ?SJun03 0:00 [khubd] root 1247 0.0 0.0 1456 600 ?Ss Jun03 0:04 /sbin/syslogd root 1250 0.0 0.0 2084 444 ?Ss Jun03 0:00 /sbin/klogd root 1288 0.0 0.1 2432 1024 ?SJun03 0:00 /bin/sh /usr/bin/mysqld_safe mysql 1325 0.0 27.1 324124 262548 ? SJun03 0:31 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 1336 0.0 27.1 324124 262548 ? SJun03 0:03 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 1337 0.0 27.1 324124 262548 ? SJun03 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 1338 0.0 27.1 324124 262548 ? SJun03 0:01 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 1339 0.0 27.1 324124 262548 ? SJun03 16:49 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 1340 0.0 27.1 324124 262548 ? SJun03 0:30 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 1369 0.0 27.1 324124 262548 ? SJun03 6:10 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 1370 0.0 27.1 324124 262548 ? SJun03 3:32 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 1380 0.0 27.1 324124 262548 ? SJun03 1:16 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 1381 0.0 27.1 324124 262548 ? SJun03 0:08 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 1384 0.0 27.1 324124 262548 ? SJun03 5:33 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ root 1431 0.0 0.1 4736 1560 ?Ss Jun03 1:23 /usr/sbin/sshd . . . .. . mysql 3404 0.0 27.1 324124 262548 ? SJun04 3:22 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 3456 0.0 27.1 324124 262548 ? SJun04 3:06 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 3607 0.0 27.1 324124 262548 ? SJun04 3:24 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 3685 0.0 27.1 324124 262548 ? SJun04 2:25 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 5325 0.0 27.1 324124 262548 ? SJun05 3:14 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 5352 0.0 27.1 324124 262548 ? SJun05 3:21 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 5374 0.0 27.1 324124 262548 ? SJun05 3:16 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 5378 0.0 27.1 324124 262548 ? SJun05 3:06 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 5397 0.0 27.1 324124 262548 ? SJun05 2:49 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 5398 0.0 27.1 324124 262548 ? SJun05 2:51 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 5400 0.0 27.1 324124 262548 ? SJun05 3:35 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ -- Krishna Chandra Prajapati
Re: MYSQL PROCESS
Yes, mysql12940 0.0 27.3 324124 264672 ? SAug06 0:12 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-external-locking --port=3306 --socket=/var/run/mysqld/mysqld.sock mysql12941 0.0 27.3 324124 264672 ? SAug06 0:19 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-external-locking --port=3306 --socket=/var/run/mysqld/mysqld.sock mysql12942 0.0 27.3 324124 264672 ? SAug06 1:01 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-external-locking --port=3306 --socket=/var/run/mysqld/mysqld.sock mysql13021 0.0 27.3 324124 264672 ? SAug06 0:09 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-external-locking --port=3306 --socket=/var/run/mysqld/mysqld.sock It's few of them. On Thu, Aug 14, 2008 at 2:38 PM, Ananda Kumar [EMAIL PROTECTED] wrote: r they all runing on the same port On 8/14/08, Krishna Chandra Prajapati [EMAIL PROTECTED] wrote: But some of the mysql server(mysql server on debian) shows only one mysql process. On Thu, Aug 14, 2008 at 12:56 PM, Ellison, David [EMAIL PROTECTED] wrote: I may be talking rubbish here, but is it not threading? I have seen Linux processes before create more than one PID etc when it needs to handle multiple requests. This may be not true for MySQL. However when looking at my test server is shows more than one. If you use a command called htop, similar to top but a little more visually easier, it has an option called tree. Which shows how one process spawns many when/where needed. Dave -Original Message- From: Krishna Chandra Prajapati [mailto:[EMAIL PROTECTED] Sent: 14 August 2008 05:57 To: mysql Subject: MYSQL PROCESS Hi all, I am running mysql on debian. I didn't understand why there is a lots of mysql process running. There should be only one mysql process running. Please help me that what should i do. Although there is no problem with mysql server. debian:~# ps axu USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND root 1 0.0 0.0 1400 472 ?SJun03 0:03 init [2] root 2 0.0 0.0 00 ?SJun03 0:01 [keventd] root 3 0.0 0.0 00 ?SN Jun03 0:06 [ksoftirqd_CPU0] root 4 0.0 0.0 00 ?SJun03 2:25 [kswapd] root 5 0.0 0.0 00 ?SJun03 0:00 [bdflush] root 6 0.0 0.0 00 ?SJun03 1:15 [kupdated] root99 0.0 0.0 00 ?SJun03 6:52 [kjournald] root 250 0.0 0.0 00 ?SJun03 0:00 [kcopyd] root 252 0.0 0.0 00 ?SJun03 0:00 [kmirrord] root 265 0.0 0.0 00 ?SJun03 0:00 [kjournald] root 431 0.0 0.0 00 ?SJun03 0:00 [khubd] root 1247 0.0 0.0 1456 600 ?Ss Jun03 0:04 /sbin/syslogd root 1250 0.0 0.0 2084 444 ?Ss Jun03 0:00 /sbin/klogd root 1288 0.0 0.1 2432 1024 ?SJun03 0:00 /bin/sh /usr/bin/mysqld_safe mysql 1325 0.0 27.1 324124 262548 ? SJun03 0:31 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 1336 0.0 27.1 324124 262548 ? SJun03 0:03 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 1337 0.0 27.1 324124 262548 ? SJun03 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 1338 0.0 27.1 324124 262548 ? SJun03 0:01 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 1339 0.0 27.1 324124 262548 ? SJun03 16:49 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 1340 0.0 27.1 324124 262548 ? SJun03 0:30 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 1369 0.0 27.1 324124 262548 ? SJun03 6:10 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 1370 0.0 27.1 324124 262548 ? SJun03 3:32 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 1380 0.0 27.1 324124 262548 ? SJun03 1:16 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 1381 0.0 27.1 324124 262548 ? SJun03 0:08 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 1384 0.0 27.1 324124 262548 ? SJun03 5:33 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ root 1431 0.0 0.1 4736 1560 ?Ss Jun03 1:23 /usr/sbin/sshd . . . .. . mysql 3404 0.0 27.1 324124 262548 ? SJun04 3:22 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 3456 0.0 27.1 324124 262548 ? SJun04 3:06 /usr/sbin/mysqld --basedir=/usr --datadir
MYSQL PROCESS
Hi all, I am running mysql on debian. I didn't understand why there is a lots of mysql process running. There should be only one mysql process running. Please help me that what should i do. Although there is no problem with mysql server. debian:~# ps axu USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND root 1 0.0 0.0 1400 472 ?SJun03 0:03 init [2] root 2 0.0 0.0 00 ?SJun03 0:01 [keventd] root 3 0.0 0.0 00 ?SN Jun03 0:06 [ksoftirqd_CPU0] root 4 0.0 0.0 00 ?SJun03 2:25 [kswapd] root 5 0.0 0.0 00 ?SJun03 0:00 [bdflush] root 6 0.0 0.0 00 ?SJun03 1:15 [kupdated] root99 0.0 0.0 00 ?SJun03 6:52 [kjournald] root 250 0.0 0.0 00 ?SJun03 0:00 [kcopyd] root 252 0.0 0.0 00 ?SJun03 0:00 [kmirrord] root 265 0.0 0.0 00 ?SJun03 0:00 [kjournald] root 431 0.0 0.0 00 ?SJun03 0:00 [khubd] root 1247 0.0 0.0 1456 600 ?Ss Jun03 0:04 /sbin/syslogd root 1250 0.0 0.0 2084 444 ?Ss Jun03 0:00 /sbin/klogd root 1288 0.0 0.1 2432 1024 ?SJun03 0:00 /bin/sh /usr/bin/mysqld_safe mysql 1325 0.0 27.1 324124 262548 ? SJun03 0:31 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 1336 0.0 27.1 324124 262548 ? SJun03 0:03 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 1337 0.0 27.1 324124 262548 ? SJun03 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 1338 0.0 27.1 324124 262548 ? SJun03 0:01 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 1339 0.0 27.1 324124 262548 ? SJun03 16:49 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 1340 0.0 27.1 324124 262548 ? SJun03 0:30 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 1369 0.0 27.1 324124 262548 ? SJun03 6:10 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 1370 0.0 27.1 324124 262548 ? SJun03 3:32 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 1380 0.0 27.1 324124 262548 ? SJun03 1:16 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 1381 0.0 27.1 324124 262548 ? SJun03 0:08 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 1384 0.0 27.1 324124 262548 ? SJun03 5:33 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ root 1431 0.0 0.1 4736 1560 ?Ss Jun03 1:23 /usr/sbin/sshd . . . .. . mysql 3404 0.0 27.1 324124 262548 ? SJun04 3:22 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 3456 0.0 27.1 324124 262548 ? SJun04 3:06 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 3607 0.0 27.1 324124 262548 ? SJun04 3:24 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 3685 0.0 27.1 324124 262548 ? SJun04 2:25 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 5325 0.0 27.1 324124 262548 ? SJun05 3:14 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 5352 0.0 27.1 324124 262548 ? SJun05 3:21 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 5374 0.0 27.1 324124 262548 ? SJun05 3:16 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 5378 0.0 27.1 324124 262548 ? SJun05 3:06 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 5397 0.0 27.1 324124 262548 ? SJun05 2:49 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 5398 0.0 27.1 324124 262548 ? SJun05 2:51 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ mysql 5400 0.0 27.1 324124 262548 ? SJun05 3:35 /usr/sbin/mysqld --basedir=/usr --datadir=/var/ -- Krishna Chandra Prajapati MySQL DBA, Ed Ventures e-Learning Pvt.Ltd. 1-8-303/48/15, Sindhi Colony P.G.Road, Secunderabad. Pin Code: 53 Office Number: 040-66489771 Mob: 9912924044 URL: ed-ventures-online.com Email-id: [EMAIL PROTECTED]
mysql process 99.9 percent
hi do you have any idea why the mysql process is 99.9 percent? when i click one hyperlink it takes more than 1 minute to load the page. thank you very much. -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.344 / Virus Database: 267.11.6/111 - Release Date: 9/23/2005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql process 99.9 percent
Joeffrey Betita wrote: do you have any idea why the mysql process is 99.9 percent? No. when i click one hyperlink it takes more than 1 minute to load the page. thank you very much. Maybe if you provided some details then someone would be able to help you. We're not psychic. What programming language/API? What MySQL version? What OS/platform? How much load is on your database from other users, if any? What is the query being executed when the process is at 99.9%? -- Jasper Bryant-Greene Freelance web developer http://jasper.bryant-greene.name/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql process 99.9 percent
Hi Most readers in this list expect OS and MySQL server information etc before responding. In our experience this is usually caused by poor SQL query construction e.g. large result set e.g. x million rows and/or index choice, database table design and/or MySQL server setup. Turn-on logging, rerun selected queries with and without the explain syntax, look at the MySQL administrator process list to see which query is the problem whilst the CPU is 99.9 %. Good news is : 'it is solvable'. Mark Joeffrey Betita wrote: hi do you have any idea why the mysql process is 99.9 percent? when i click one hyperlink it takes more than 1 minute to load the page. thank you very much. -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.344 / Virus Database: 267.11.6/111 - Release Date: 9/23/2005 -- Mark Carson Managing Integrated Product Intelligence/IPI CC CK 95/35630/23 Members : MH Carson and AG Carson EMail : [EMAIL PROTECTED]/[EMAIL PROTECTED] snailmail : P.O. Box 36095 Menlo Park 0102, South Africa Cell : +27 83 260 8515 Tel : +27 12 349 2786 Fax : +27 12 349 2787 This e-mail may contain PRIVILEGED AND/OR CONFIDENTIAL INFORMATION intended only for use of the addressee. If you are not the addressee, or the person responsible for delivering it to the person addressed, you may not copy or deliver this to anyone else. If you received this e-mail by mistake, please do not make use of it, nor disclose it's contents to anyone. Thank you for notifying us immediately by return e-mail or telephone. INFORMATION PROVIDED IN THIS ELECTRONIC MAIL IS PROVIDED AS IS WITHOUT WARRANTY REPRESENTATION OR CONDITION OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO CONDITIONS OR OTHER TERMS OF MERCHANTABILITY AND/OR FITNESS FOR A PARTICULAR PURPOSE. THE USER ASSUMES THE ENTIRE RISK AS TO THE ACCURACY AND THE USE OF THIS DOCUMENT. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql process 99.9 percent
Joeffrey Betita wrote: hi Jasper the linux distribution is redhat 9, mysql-4.0.15a-log, apache-2.0.47, php-4.3.3 etc. just clicking one hyperlink and searching for any item. OK, would you mind providing the SQL query that's being executed when you click that hyperlink? You see, MySQL doesn't have anything to do with hyperlinks and searching (well, not searching at the user-level, anyway). It only knows about SQL queries. So if something's making it go slow, the culprit is an SQL query, not a hyperlink. Please always reply to the list, not just to me. -- Jasper Bryant-Greene Freelance web developer http://jasper.bryant-greene.name/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql process 99.9 percent
On Monday, 26 September 2005 at 9:29:32 +0200, mark carson wrote: Joeffrey Betita wrote: hi do you have any idea why the mysql process is 99.9 percent? when i click one hyperlink it takes more than 1 minute to load the page. thank you very much. Most readers in this list expect OS and MySQL server information etc before responding. In our experience this is usually caused by poor SQL query construction e.g. large result set e.g. x million rows and/or index choice, database table design and/or MySQL server setup. Turn-on logging, rerun selected queries with and without the explain syntax, look at the MySQL administrator process list to see which query is the problem whilst the CPU is 99.9 %. FWIW, we have at least one case where the server gets itself into a loop for no obvious reason. See http://bugs.mysql.com/bug.php?id=414 and http://bugs.mysql.com/bug.php?id=12061 for more details. If the problem at hand is related to this bug, I'd be very interested in hearing from you, especially if you can reproduce the problem easily. Note that the submitter of the second-mentioned bug report has done a very good job of describing his problem. Only reports of similar quality would be of much help. If this isn't your (Joeffrey's) problem, it might give you an idea of the kind of information we're looking for. Greg -- Greg Lehey, Senior Software Engineer MySQL AB, http://www.mysql.com/ Echunga, South Australia See complete headers for address and phone numbers. Are you MySQL certified? http://www.mysql.com/certification/ pgpc37noUE7K3.pgp Description: PGP signature
MySQL Process
Hi, I run Debian 3.1 with kernel 2.6.8-1-686-smp, I wonder why why I do ps -aux, I only can see 1 MySQL process. mysql 4227 0.0 64.6 1849456 1341912 pts/1 S Sep16 4:57 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql/ --user=mysql --pid-file=/var/lib/mysql//natuna.pid --skip-locking --port=3306 --socket=/var/lib/mysql/mysql.sock On my other machine, there are many processes. mysql13648 0.1 57.7 1858672 1195352 ? S20:44 0:03 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/tidore.pid --skip-locking --port=3306 --socket=/var/lib/mysql/mysql.sock mysql13649 0.1 57.7 1858672 1195352 ? S20:44 0:03 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/tidore.pid --skip-locking --port=3306 --socket=/var/lib/mysql/mysql.sock mysql13650 0.1 57.7 1858672 1195352 ? S20:44 0:03 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/tidore.pid --skip-locking --port=3306 --socket=/var/lib/mysql/mysql.sock ... I use the same my.cnf, and show processlist show me more than 1 process on both machines. Both of these machines are slave DBs. The one that only has 1 process tends to lag behind a lot. I am not sure that they are somewhat connected. Any idea? Thank you very much. --bk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL process increasing problem..
Thank you Matt, Jeremy and Gerald for helping me. It seems that the code is opening many connections. I have decreased wait_timeout and it should be better for the time being. Thanks and Regards, Shailesh Agrawal -- For sale, parachute, used once, never opened, small stain. -Original Message- From: Matt W [mailto:[EMAIL PROTECTED] Sent: Thursday, November 06, 2003 7:22 AM To: Jobs PHP Workshop; [EMAIL PROTECTED] Subject: Re: MySQL process increasing problem.. Hi, Yes, in top, those are threads not processes, as Gerald already said. Not that it really matters. :-) Your connections in PROCESSLIST are sleeping (e.g. idle). What are the clients? It looks like you may be using persistent connections with a Web app. If you want to get rid of the sleeping threads (which shouldn't be much harm, except for a bit of memory usage), don't use persistent connections, or lower the wait_timeout and/or interactive_timeout server variables to have MySQL disconnect idle clients sooner. Hope that helps. Matt - Original Message - From: Jobs PHP Workshop To: [EMAIL PROTECTED] Sent: Wednesday, November 05, 2003 11:08 AM Subject: MySQL process increasing problem.. Hi, Problem is, Mysql server in our production machine keeps spawning child processes and it reaches to a level where mysql hangs and the only solution is to restart our mysql server. I have checked all the databases using mysqlcheck command and every table is OK now. Recently, MySQL server suffered from low disk space and hence some of the tables got corrupted. We have repaired them using mysqlcheck -r option. Can this be a Reason of the mysqld process spawning problem ??. Some help will really save me as this is a production machine. We have MySQL 3.23.x running and Following is more technical details that you may need to think upon: (1) HERE IS THE PARTIAL OUTPUT OF 'TOP' COMMAND: 2:52pm up 1 day, 22:34, 2 users, load average: 0.30, 0.09, 0.03 134 processes: 133 sleeping, 1 running, 0 zombie, 0 stopped CPU states: 0.9% user, 2.7% system, 0.0% nice, 96.3% idle Mem: 1028316K av, 1015484K used, 12832K free, 0K shrd, 180292K buff Swap: 522072K av,4096K used, 517976K free 470328K cached PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND 6097 mysql 9 0 23004 22M 1528 S 0.0 2.2 0:00 mysqld 6099 mysql 8 0 23004 22M 1528 S 0.0 2.2 0:00 mysqld 6100 mysql 9 0 23004 22M 1528 S 0.0 2.2 0:00 mysqld 6105 mysql 9 0 23004 22M 1528 S 0.0 2.2 0:03 mysqld 6108 mysql 9 0 23004 22M 1528 S 0.0 2.2 0:00 mysqld 6109 mysql 9 0 23004 22M 1528 S 0.0 2.2 0:00 mysqld (2) HERE IS THE PARTIAL LIST OF PROCESSES OUT OF TOTAL 94 AS A RESULT OF 'SHOW PROCESSLIST' COMMAND.REST OTHER PROCESSES ARE ALSO SIMILAR: id User Host DatabaseCommand Time Status SQL-query -- -- --- 131 u125 localhost db125 Sleep 6243 --- --- 139 csha localhost db_cshaw_com Sleep 2494 --- --- 140 tanb localhost db_tban_com Sleep 1985 --- --- 141 tanb localhost db_tban_com Sleep 2006 --- --- 142 tanb localhost db_tban_com Sleep 1977 --- --- 143 tanb localhost db_tban_com Sleep 1948 --- --- 144 tanb localhost db_tban_com Sleep 1939 --- --- 145 tanb localhost db_tban_com Sleep 1410 --- --- 146 tanb localhost db_tban_com Sleep 1394 --- --- 147 dbpr localhost dbpropertydb Sleep 1092 --- --- 154 root localhost mysql Query 0 --- SHOW PROCESSLIST (3) HERE IS THE 'extended-status' of MySQL: +--+--+ | Variable_name| Value| +--+--+ | Aborted_clients | 1| | Aborted_connects | 0| | Bytes_received | 6271826 | | Bytes_sent | 18499758 | | Connections | 158 | | Created_tmp_disk_tables | 105 | | Created_tmp_tables | 1174 | | Created_tmp_files| 0| | Delayed_insert_threads | 0| | Delayed_writes | 0| | Delayed_errors | 0| | Flush_commands | 1| | Handler_delete | 283 | | Handler_read_first | 618 | | Handler_read_key | 598750 | | Handler_read_next| 600043 | | Handler_read_prev| 0| | Handler_read_rnd | 20400| | Handler_read_rnd_next| 21962199 | | Handler_update | 1035 | | Handler_write| 22201| | Key_blocks_used | 15582| | Key_read_requests| 1403805 | | Key_reads| 85703| | Key_write_requests | 5742 | | Key_writes | 4974
MySQL process increasing problem..
Hi, Problem is, Mysql server in our production machine keeps spawning child processes and it reaches to a level where mysql hangs and the only solution is to restart our mysql server. I have checked all the databases using mysqlcheck command and every table is OK now. Recently, MySQL server suffered from low disk space and hence some of the tables got corrupted. We have repaired them using mysqlcheck -r option. Can this be a Reason of the mysqld process spawning problem ??. Some help will really save me as this is a production machine. We have MySQL 3.23.x running and Following is more technical details that you may need to think upon: (1) HERE IS THE PARTIAL OUTPUT OF 'TOP' COMMAND: 2:52pm up 1 day, 22:34, 2 users, load average: 0.30, 0.09, 0.03 134 processes: 133 sleeping, 1 running, 0 zombie, 0 stopped CPU states: 0.9% user, 2.7% system, 0.0% nice, 96.3% idle Mem: 1028316K av, 1015484K used, 12832K free, 0K shrd, 180292K buff Swap: 522072K av,4096K used, 517976K free 470328K cached PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND 6097 mysql 9 0 23004 22M 1528 S 0.0 2.2 0:00 mysqld 6099 mysql 8 0 23004 22M 1528 S 0.0 2.2 0:00 mysqld 6100 mysql 9 0 23004 22M 1528 S 0.0 2.2 0:00 mysqld 6105 mysql 9 0 23004 22M 1528 S 0.0 2.2 0:03 mysqld 6108 mysql 9 0 23004 22M 1528 S 0.0 2.2 0:00 mysqld 6109 mysql 9 0 23004 22M 1528 S 0.0 2.2 0:00 mysqld (2) HERE IS THE PARTIAL LIST OF PROCESSES OUT OF TOTAL 94 AS A RESULT OF 'SHOW PROCESSLIST' COMMAND.REST OTHER PROCESSES ARE ALSO SIMILAR: idUser HostDatabase Command Time Status SQL-query --- 131 u125 localhost db125 Sleep 6243 --- --- 139 csha localhost db_cshaw_com Sleep 2494 --- --- 140 tanb localhost db_tban_com Sleep 1985 --- --- 141 tanb localhost db_tban_com Sleep 2006 --- --- 142 tanb localhost db_tban_com Sleep 1977 --- --- 143 tanb localhost db_tban_com Sleep 1948 --- --- 144 tanb localhost db_tban_com Sleep 1939 --- --- 145 tanb localhost db_tban_com Sleep 1410 --- --- 146 tanb localhost db_tban_com Sleep 1394 --- --- 147 dbpr localhost dbpropertydb Sleep 1092 --- --- 154 root localhost mysql Query 0 --- SHOW PROCESSLIST (3) HERE IS THE 'extended-status' of MySQL: +--+--+ | Variable_name| Value| +--+--+ | Aborted_clients | 1| | Aborted_connects | 0| | Bytes_received | 6271826 | | Bytes_sent | 18499758 | | Connections | 158 | | Created_tmp_disk_tables | 105 | | Created_tmp_tables | 1174 | | Created_tmp_files| 0| | Delayed_insert_threads | 0| | Delayed_writes | 0| | Delayed_errors | 0| | Flush_commands | 1| | Handler_delete | 283 | | Handler_read_first | 618 | | Handler_read_key | 598750 | | Handler_read_next| 600043 | | Handler_read_prev| 0| | Handler_read_rnd | 20400| | Handler_read_rnd_next| 21962199 | | Handler_update | 1035 | | Handler_write| 22201| | Key_blocks_used | 15582| | Key_read_requests| 1403805 | | Key_reads| 85703| | Key_write_requests | 5742 | | Key_writes | 4974 | | Max_used_connections | 88 | | Not_flushed_key_blocks | 0| | Not_flushed_delayed_rows | 0| | Open_tables | 64 | | Open_files | 131 | | Open_streams | 0| | Opened_tables| 20961| | Questions| 63778| | Select_full_join | 1288 | | Select_full_range_join | 0| | Select_range | 0| | Select_range_check | 0| | Select_scan | 7348 | | Slave_running| OFF | | Slave_open_temp_tables | 0| | Slow_launch_threads | 0| | Slow_queries | 0| | Sort_merge_passes| 0| | Sort_range | 0| | Sort_rows| 20400| | Sort_scan| 1405 | | Table_locks_immediate| 49707| | Table_locks_waited | 1| | Threads_cached | 0| | Threads_created | 157 | | Threads_connected| 88 | | Threads_running | 1| | Uptime | 18794| +--+--+ Thanks..,
Re: MySQL process increasing problem..
Those are threads, not processes. Each connection gets a thread. Many connections waiting for disk space will give you this problem. Jobs PHP Workshop wrote: Hi, Problem is, Mysql server in our production machine keeps spawning child processes and it reaches to a level where mysql hangs and the only solution is to restart our mysql server. I have checked all the databases using mysqlcheck command and every table is OK now. Recently, MySQL server suffered from low disk space and hence some of the tables got corrupted. We have repaired them using mysqlcheck -r option. Can this be a Reason of the mysqld process spawning problem ??. Some help will really save me as this is a production machine. We have MySQL 3.23.x running and Following is more technical details that you may need to think upon: (1) HERE IS THE PARTIAL OUTPUT OF 'TOP' COMMAND: 2:52pm up 1 day, 22:34, 2 users, load average: 0.30, 0.09, 0.03 134 processes: 133 sleeping, 1 running, 0 zombie, 0 stopped CPU states: 0.9% user, 2.7% system, 0.0% nice, 96.3% idle Mem: 1028316K av, 1015484K used, 12832K free, 0K shrd, 180292K buff Swap: 522072K av,4096K used, 517976K free 470328K cached PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND 6097 mysql 9 0 23004 22M 1528 S 0.0 2.2 0:00 mysqld 6099 mysql 8 0 23004 22M 1528 S 0.0 2.2 0:00 mysqld 6100 mysql 9 0 23004 22M 1528 S 0.0 2.2 0:00 mysqld 6105 mysql 9 0 23004 22M 1528 S 0.0 2.2 0:03 mysqld 6108 mysql 9 0 23004 22M 1528 S 0.0 2.2 0:00 mysqld 6109 mysql 9 0 23004 22M 1528 S 0.0 2.2 0:00 mysqld (2) HERE IS THE PARTIAL LIST OF PROCESSES OUT OF TOTAL 94 AS A RESULT OF 'SHOW PROCESSLIST' COMMAND.REST OTHER PROCESSES ARE ALSO SIMILAR: id User Host Database Command Time Status SQL-query --- 131 u125 localhost db125 Sleep 6243 --- --- 139 csha localhost db_cshaw_com Sleep 2494 --- --- 140 tanb localhost db_tban_com Sleep 1985 --- --- 141 tanb localhost db_tban_com Sleep 2006 --- --- 142 tanb localhost db_tban_com Sleep 1977 --- --- 143 tanb localhost db_tban_com Sleep 1948 --- --- 144 tanb localhost db_tban_com Sleep 1939 --- --- 145 tanb localhost db_tban_com Sleep 1410 --- --- 146 tanb localhost db_tban_com Sleep 1394 --- --- 147 dbpr localhost dbpropertydb Sleep 1092 --- --- 154 root localhost mysql Query 0 --- SHOW PROCESSLIST (3) HERE IS THE 'extended-status' of MySQL: +--+--+ | Variable_name| Value| +--+--+ | Aborted_clients | 1| | Aborted_connects | 0| | Bytes_received | 6271826 | | Bytes_sent | 18499758 | | Connections | 158 | | Created_tmp_disk_tables | 105 | | Created_tmp_tables | 1174 | | Created_tmp_files| 0| | Delayed_insert_threads | 0| | Delayed_writes | 0| | Delayed_errors | 0| | Flush_commands | 1| | Handler_delete | 283 | | Handler_read_first | 618 | | Handler_read_key | 598750 | | Handler_read_next| 600043 | | Handler_read_prev| 0| | Handler_read_rnd | 20400| | Handler_read_rnd_next| 21962199 | | Handler_update | 1035 | | Handler_write| 22201| | Key_blocks_used | 15582| | Key_read_requests| 1403805 | | Key_reads| 85703| | Key_write_requests | 5742 | | Key_writes | 4974 | | Max_used_connections | 88 | | Not_flushed_key_blocks | 0| | Not_flushed_delayed_rows | 0| | Open_tables | 64 | | Open_files | 131 | | Open_streams | 0| | Opened_tables| 20961| | Questions| 63778| | Select_full_join | 1288 | | Select_full_range_join | 0| | Select_range | 0| | Select_range_check | 0| | Select_scan | 7348 | | Slave_running| OFF | | Slave_open_temp_tables | 0| | Slow_launch_threads | 0| | Slow_queries | 0| | Sort_merge_passes| 0| | Sort_range | 0| | Sort_rows| 20400| | Sort_scan| 1405 | | Table_locks_immediate| 49707| | Table_locks_waited | 1| | Threads_cached | 0| | Threads_created | 157 | | Threads_connected| 88 | | Threads_running |
Re: MySQL process increasing problem..
Hi, Yes, in top, those are threads not processes, as Gerald already said. Not that it really matters. :-) Your connections in PROCESSLIST are sleeping (e.g. idle). What are the clients? It looks like you may be using persistent connections with a Web app. If you want to get rid of the sleeping threads (which shouldn't be much harm, except for a bit of memory usage), don't use persistent connections, or lower the wait_timeout and/or interactive_timeout server variables to have MySQL disconnect idle clients sooner. Hope that helps. Matt - Original Message - From: Jobs PHP Workshop To: [EMAIL PROTECTED] Sent: Wednesday, November 05, 2003 11:08 AM Subject: MySQL process increasing problem.. Hi, Problem is, Mysql server in our production machine keeps spawning child processes and it reaches to a level where mysql hangs and the only solution is to restart our mysql server. I have checked all the databases using mysqlcheck command and every table is OK now. Recently, MySQL server suffered from low disk space and hence some of the tables got corrupted. We have repaired them using mysqlcheck -r option. Can this be a Reason of the mysqld process spawning problem ??. Some help will really save me as this is a production machine. We have MySQL 3.23.x running and Following is more technical details that you may need to think upon: (1) HERE IS THE PARTIAL OUTPUT OF 'TOP' COMMAND: 2:52pm up 1 day, 22:34, 2 users, load average: 0.30, 0.09, 0.03 134 processes: 133 sleeping, 1 running, 0 zombie, 0 stopped CPU states: 0.9% user, 2.7% system, 0.0% nice, 96.3% idle Mem: 1028316K av, 1015484K used, 12832K free, 0K shrd, 180292K buff Swap: 522072K av,4096K used, 517976K free 470328K cached PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND 6097 mysql 9 0 23004 22M 1528 S 0.0 2.2 0:00 mysqld 6099 mysql 8 0 23004 22M 1528 S 0.0 2.2 0:00 mysqld 6100 mysql 9 0 23004 22M 1528 S 0.0 2.2 0:00 mysqld 6105 mysql 9 0 23004 22M 1528 S 0.0 2.2 0:03 mysqld 6108 mysql 9 0 23004 22M 1528 S 0.0 2.2 0:00 mysqld 6109 mysql 9 0 23004 22M 1528 S 0.0 2.2 0:00 mysqld (2) HERE IS THE PARTIAL LIST OF PROCESSES OUT OF TOTAL 94 AS A RESULT OF 'SHOW PROCESSLIST' COMMAND.REST OTHER PROCESSES ARE ALSO SIMILAR: id User Host DatabaseCommand Time Status SQL-query -- -- --- 131 u125 localhost db125 Sleep 6243 --- --- 139 csha localhost db_cshaw_com Sleep 2494 --- --- 140 tanb localhost db_tban_com Sleep 1985 --- --- 141 tanb localhost db_tban_com Sleep 2006 --- --- 142 tanb localhost db_tban_com Sleep 1977 --- --- 143 tanb localhost db_tban_com Sleep 1948 --- --- 144 tanb localhost db_tban_com Sleep 1939 --- --- 145 tanb localhost db_tban_com Sleep 1410 --- --- 146 tanb localhost db_tban_com Sleep 1394 --- --- 147 dbpr localhost dbpropertydb Sleep 1092 --- --- 154 root localhost mysql Query 0 --- SHOW PROCESSLIST (3) HERE IS THE 'extended-status' of MySQL: +--+--+ | Variable_name| Value| +--+--+ | Aborted_clients | 1| | Aborted_connects | 0| | Bytes_received | 6271826 | | Bytes_sent | 18499758 | | Connections | 158 | | Created_tmp_disk_tables | 105 | | Created_tmp_tables | 1174 | | Created_tmp_files| 0| | Delayed_insert_threads | 0| | Delayed_writes | 0| | Delayed_errors | 0| | Flush_commands | 1| | Handler_delete | 283 | | Handler_read_first | 618 | | Handler_read_key | 598750 | | Handler_read_next| 600043 | | Handler_read_prev| 0| | Handler_read_rnd | 20400| | Handler_read_rnd_next| 21962199 | | Handler_update | 1035 | | Handler_write| 22201| | Key_blocks_used | 15582| | Key_read_requests| 1403805 | | Key_reads| 85703| | Key_write_requests | 5742 | | Key_writes | 4974 | | Max_used_connections | 88 | | Not_flushed_key_blocks | 0| | Not_flushed_delayed_rows | 0| | Open_tables | 64 | | Open_files | 131 | | Open_streams | 0| | Opened_tables| 20961| | Questions| 63778| | Select_full_join | 1288 | | Select_full_range_join | 0| | Select_range | 0| | Select_range_check | 0
How do I tell which mysql process has a lock?
Greetings. How do I tell which mysql process has a lock on what tables? I'm using mysql 3.23.54-Max with MyISAM tables on Linux 2.4.9-34 (RedHat 7.2). We've got about 20 users and a myriad of automated scripts (Perl DBI, Java JDBC) connecting to the database on a regular basis. Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql process keeps references to files after conn.close()
Hi. I am doing a simple programmatic task. I am opening a connection to a database using connn = DriverManager.getConnection(jdbc:mysql://localhost/dbname) I then do some stuff, and execute a conn.close(). I then try and delete the database files, and I get an error that they are in use by another process - you guessed it, mysql. My question is why?!!! thanks, David PS And can I get mysql to drop it's connection without a net stop/start? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql process keeps references to files after conn.close()
- Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, November 15, 2002 4:51 PM Subject: mysql process keeps references to files after conn.close() Hi. I am doing a simple programmatic task. I am opening a connection to a database using connn = DriverManager.getConnection(jdbc:mysql://localhost/dbname) I then do some stuff, and execute a conn.close(). I then try and delete the database files, and I get an error that they are in use by another process - you guessed it, mysql. My question is why?!!! Because the MySQL database server process has nothing to do with the connections that are made to it. You are also probably running on Windows which does have 'interesting' file handling semantics, to say the least. You will need to stop the MySQL server before trying to delete the files. On the other hand, you would be better off to use the normal 'drop table' and 'drop database' commands from within MySQL, really. -Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL Process ID Unix PID
Hi, Is there a way to compare between a mysql process ID showed in top or ps with a process ID from mysqladmin processlist ? I'm asking this because we operate a mysql machine used for webhosting and it has many users and many databases. If users do crazy stuff that result in high usage of resources, we need to determine who is the user, which database is it accessing and finally what script causes the problem. Any ideas or utils/scripts for digging this info apreciated. Tnx. Justin Grindea System Administrator SweetHome.co.il - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Show Tables Freezing a MySQL process
Hi Everyone. Here's a VERY unusualy problem. We are running a mod_perl application with MySQL. One of the functions in the program performs a SHOW TABLE command. This is performed with apparently great regularity within the program. It has begun locking a process up, at 100% CPU (All held by system). When this occurs the process will respond to nothing. I try kill -9, I try the kill command via mysqladmin or mtop. Nothing works. We are forced to reboot. This is on a 4 processor Xeon Dell server, and when it reaches three locked up processes (Currently taking less than 4 hours!!!) We have to reboot. Does anyone have any suggestions for repair or workaround (Killing off these processes somehow?) LMK -- Lloyd Duhon Founder Open Space Initiative http://openspaceinitiative.org/ The Exploration of the Universe is our responsibility! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Fw: Stalled MySQL process causing high CPU load
Sorry to repost this, but I have no idea what to do about this problem, which is making our systems almost unworkable. Does anyone have any suggestions about what to do about this, or at least tests I could try to narrow down the possible causes. Would it help to upgrade MySQL to a later version of 3 or to version 4? Or should I scrap MySQL and try PostgreSQL? - Original Message - From: Bruno Prior [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, November 21, 2001 10:05 PM Subject: Stalled MySQL process causing high CPU load I am a MySQL novice, so there may be a simple explanation for this. But I have been unable to find one in the list archives, although several people seem to have had similar problems. I am running MySQL 3.23.36 from the package that comes with Mandrake linux 8.0. I am using linux software-RAID mirroring, which required upgrading the kernel to 2.4.6-ac2. The hardware is relatively limited (Duron 800, 128Mb RAM), but so are our MySQL requirements. I currently run 2 databases from it. One is a home-grown contacts and document management database with around 20 tables, none with more than 1,000 records, which I migrated off MS Access 2000. The other is the tables (around 30 or so) required for phpgrouware, which I am testing, and consequently have very few records in any of the tables. phpgroupware was the first to be set up, and shortly after I started trialling it, I started having a problem with random MySQL processes suddenly going into a spin and consuming all the CPU time (around 95% according to top), consequently slowing the machine dramatically. According to ps, the stalled process is a sibling of the process whose pid is stored in the pid file, but the process does not respond in any way to mysqladmin. the process cannot be killed with mysqladmin or kill, and attempts to shutdown the database with mysqladmin or safe-mysql (called from the init script) go into a permanent loop. The only way I can get out of it is to reboot the server. What makes this particularly hard to track down is that it often occurs when no one is even using the database. It occurs with both databases, so I don't think it is caused by PHP or MyODBC, which are used to connect to the two databases. Nor is the load real - these lockups usually occur when there is little happening on the server, and nothing happening with MySQL. Nor do I think it is a lock problem - it has occurred frequently when I have been the only person accessing the server. To avoid posting all my vital statistics to the mailing list, I have put the output of various mysqladmin commands on our server, in the hope that someone might like to take a look to see if I have an obvious problem with my configuration. The output of mysqladmin version, extended-status, variables and processlist are on http://www.summerleaze.co.uk respectively at /mysql-vers.txt, /mysql-status.txt, /mysql-vars.txt and /mysql-process. I hope I have provided sufficient information. Does anyone have any idea what might be causing this? Cheers, Bruno Prior [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Stalled MySQL process causing high CPU load
I am a MySQL novice, so there may be a simple explanation for this. But I have been unable to find one in the list archives, although several people seem to have had similar problems. I am running MySQL 3.23.36 from the package that comes with Mandrake linux 8.0. I am using linux software-RAID mirroring, which required upgrading the kernel to 2.4.6-ac2. The hardware is relatively limited (Duron 800, 128Mb RAM), but so are our MySQL requirements. I currently run 2 databases from it. One is a home-grown contacts and document management database with around 20 tables, none with more than 1,000 records, which I migrated off MS Access 2000. The other is the tables (around 30 or so) required for phpgrouware, which I am testing, and consequently have very few records in any of the tables. phpgroupware was the first to be set up, and shortly after I started trialling it, I started having a problem with random MySQL processes suddenly going into a spin and consuming all the CPU time (around 95% according to top), consequently slowing the machine dramatically. According to ps, the stalled process is a sibling of the process whose pid is stored in the pid file, but the process does not respond in any way to mysqladmin. the process cannot be killed with mysqladmin or kill, and attempts to shutdown the database with mysqladmin or safe-mysql (called from the init script) go into a permanent loop. The only way I can get out of it is to reboot the server. What makes this particularly hard to track down is that it often occurs when no one is even using the database. It occurs with both databases, so I don't think it is caused by PHP or MyODBC, which are used to connect to the two databases. Nor is the load real - these lockups usually occur when there is little happening on the server, and nothing happening with MySQL. Nor do I think it is a lock problem - it has occurred frequently when I have been the only person accessing the server. To avoid posting all my vital statistics to the mailing list, I have put the output of various mysqladmin commands on our server, in the hope that someone might like to take a look to see if I have an obvious problem with my configuration. The output of mysqladmin version, extended-status, variables and processlist are on http://www.summerleaze.co.uk respectively at /mysql-vers.txt, /mysql-status.txt, /mysql-vars.txt and /mysql-process. I hope I have provided sufficient information. Does anyone have any idea what might be causing this? Cheers, Bruno Prior [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql process running
Hi Everybody, I am a web developer (Apache ,Perl Mysql) , I am facing a problem , i have a program that runs a query on a text field and displays results , but since the database is huge sometimes apache sends a timeout to the client(browser) but my problem is that when i check the process list the mysqld is still running that query , how do i stop mysql from running the query once the perl program is stopped .Are there any server parameters that i have to tune i am using Mysql version 3.22.32 Thanks in Advance Kiran __ 123India.com - India's Premier Portal Get your Free Email Account at http://www.123india.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mysql process running
Hi there Kiran We had the same problme and we found that updating ModAuthMySQL solved the problem.. Hope this helps... Simon -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 26 February 2001 13:27 To: [EMAIL PROTECTED] Subject: mysql process running Hi Everybody, I am a web developer (Apache ,Perl Mysql) , I am facing a problem , i have a program that runs a query on a text field and displays results , but since the database is huge sometimes apache sends a timeout to the client(browser) but my problem is that when i check the process list the mysqld is still running that query , how do i stop mysql from running the query once the perl program is stopped .Are there any server parameters that i have to tune i am using Mysql version 3.22.32 Thanks in Advance Kiran __ 123India.com - India's Premier Portal Get your Free Email Account at http://www.123india.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql process running
As far as I know, this is on the wishlist, but has not been implemented - ie, a thread should die if the client disconnects. You'll probably need to run mysqladmin kill xxx, where is the offending thread id. regards, P On 26 Feb 2001 [EMAIL PROTECTED] wrote: Hi Everybody, I am a web developer (Apache ,Perl Mysql) , I am facing a problem , i have a program that runs a query on a text field and displays results , but since the database is huge sometimes apache sends a timeout to the client(browser) but my problem is that when i check the process list the mysqld is still running that query , how do i stop mysql from running the query once the perl program is stopped .Are there any server parameters that i have to tune i am using Mysql version 3.22.32 Thanks in Advance Kiran __ 123India.com - India's Premier Portal Get your Free Email Account at http://www.123india.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mysql process running
Oh... Isn't ModAuthMySQL used for HTTP authentication against a mysql database ? I can't see how that could influence queries running from within a mod_perl/CGI script... P On Mon, 26 Feb 2001, Simon Green wrote: Hi there Kiran We had the same problme and we found that updating ModAuthMySQL solved the problem.. Hope this helps... Simon -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 26 February 2001 13:27 To: [EMAIL PROTECTED] Subject: mysql process running Hi Everybody, I am a web developer (Apache ,Perl Mysql) , I am facing a problem , i have a program that runs a query on a text field and displays results , but since the database is huge sometimes apache sends a timeout to the client(browser) but my problem is that when i check the process list the mysqld is still running that query , how do i stop mysql from running the query once the perl program is stopped .Are there any server parameters that i have to tune i am using Mysql version 3.22.32 Thanks in Advance Kiran __ 123India.com - India's Premier Portal Get your Free Email Account at http://www.123india.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
starting second mysql process gives process already exists error
Hi, I need to start 2 mysql server processes on the same box (Redhat Linux release 6.2), using the following 2 commands: bin/safe_mysqld -u root --socket=/tmp/test1.sock --port=9000 and bin/safe_mysqld -u root --socket=/tmp/test2.sock --port=9020 Previously I was using mysql 3.23.27 beta and it works fine. Now I'm switching over to the newer version 3.23.32, and I am not able to start the second process any more. The second command keeps giving me "A mysqld process already exists" message. I look into the .err file and the first command gives: 010215 17:52:50 mysqld started /usr/local/mysql-3.23.32-pc-linux-gnu-i686/bin/mysqld: ready for connections while the second gives: A mysqld process already exists at Thu Feb 15 17:53:20 SGT 2001 Is there any special setting that I need to make to solve the problem?. Any help very much appreciated. Thanks. Lois - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: starting second mysql process gives process already exists error
On Wed, Feb 14, 2001 at 07:15:16PM +0800, Neo Sok Lay wrote: Hi, I need to start 2 mysql server processes on the same box (Redhat Linux release 6.2), using the following 2 commands: bin/safe_mysqld -u root --socket=/tmp/test1.sock --port=9000 and bin/safe_mysqld -u root --socket=/tmp/test2.sock --port=9020 Previously I was using mysql 3.23.27 beta and it works fine. Now I'm switching over to the newer version 3.23.32, and I am not able to start the second process any more. The second command keeps giving me "A mysqld process already exists" message. Is there any special setting that I need to make to solve the problem?. Usually you would start the second mysqld using another data directory. safe_mysqld places a .pid file in its data (.../var) directory which it checks for when starting again. If you have separate data directories, each will contain one .pid file and it works fine. Fred. -- Fred van Engen XO Communications B.V. email: [EMAIL PROTECTED] Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php