Re: looking for ready made address management
Jerry Schwartz schrieb: I strongly advise you to use an off-the-shelf solution. In fact, if you can afford it you should go with a CRM vendor. They will have all kinds of features, such as address duplication detection, that you will need. you are of course perfectly right, however I need it as base of a bigger scenario (as part of a event/document managementsystem based on zope/plone). robert -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 of this
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
SELECT in NULL state for a long time
Hi, OS - Solaris 10, 32 Gb RAM, mysql 64-bit 4.1.22 Every day I see in processlist many SELECT queries that stay in NULL state for a long time. Something Like this | 368966 | radius | fire-u1:35671 | srg_conf | Query | 106 | NULL |SELECT id, deleted_id, status, name, LEFT( value, 1000 ) FROM s | 368967 | radius | fire-u1-1:35672 | srg_conf | Query | 105 | NULL |SELECT id, deleted_id, status, name, LEFT( value, 1000 ) FROM s | 368968 | radius | fire-u1-1:35673 | srg_conf | Query | 101 | NULL |SELECT id, deleted_id, status, name, LEFT( value, 1000 ) FROM s | 368969 | radius | fire-u1:35674 | srg_conf | Query | 101 | NULL |SELECT id, deleted_id, status, name, LEFT( value, 1000 ) FROM s | 368970 | radius | fire-u1:35675 | srg_conf | Query | 100 | NULL |SELECT id, deleted_id, status, name, LEFT( value, 1000 ) FROM s | 28 | mysql | fire-u1:58138 | hnt_cn | Query | 116 | NULL |SELECT id, deleted_id, status, name, LEFT( value, 1000 ) FROM h | 48 | radius | fire-u1:58166 | hnt_cn | Query | 114 | NULL |SELECT id, deleted_id, status, name, LEFT( value, 1000 ) FROM h | 49 | radius | fire-u1-1:58165 | srg_cn | Query | 127 | NULL |SELECT id, deleted_id, status, name, LEFT( value, 1000 ) FROM s | 50 | mysql | fire-u1-1:58163 | blr_cn | Query | 120 | NULL |SELECT id, deleted_id, status, name, LEFT( value, 1000 ) FROM b Connections grow up during this time and after a couple minutes this problem gonna away. Explain me please why it happens and how can I solve this problem Thanks -- Vlad A. Shalnev E-mail: [EMAIL PROTECTED] Gravity can't be blamed for someone falling in love ( Albert Einstein ) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: SELECT in NULL state for a long time
Record the query, execute and see the result. Make sure that you get the result. To me its seems that lots of request are comming and not full filled. Check the query for optimization. On Thu, Aug 14, 2008 at 5:17 PM, Vlad Shalnev [EMAIL PROTECTED] wrote: Hi, OS - Solaris 10, 32 Gb RAM, mysql 64-bit 4.1.22 Every day I see in processlist many SELECT queries that stay in NULL state for a long time. Something Like this | 368966 | radius | fire-u1:35671 | srg_conf | Query | 106 | NULL |SELECT id, deleted_id, status, name, LEFT( value, 1000 ) FROM s | 368967 | radius | fire-u1-1:35672 | srg_conf | Query | 105 | NULL |SELECT id, deleted_id, status, name, LEFT( value, 1000 ) FROM s | 368968 | radius | fire-u1-1:35673 | srg_conf | Query | 101 | NULL |SELECT id, deleted_id, status, name, LEFT( value, 1000 ) FROM s | 368969 | radius | fire-u1:35674 | srg_conf | Query | 101 | NULL |SELECT id, deleted_id, status, name, LEFT( value, 1000 ) FROM s | 368970 | radius | fire-u1:35675 | srg_conf | Query | 100 | NULL |SELECT id, deleted_id, status, name, LEFT( value, 1000 ) FROM s | 28 | mysql | fire-u1:58138 | hnt_cn | Query | 116 | NULL |SELECT id, deleted_id, status, name, LEFT( value, 1000 ) FROM h | 48 | radius | fire-u1:58166 | hnt_cn | Query | 114 | NULL |SELECT id, deleted_id, status, name, LEFT( value, 1000 ) FROM h | 49 | radius | fire-u1-1:58165 | srg_cn | Query | 127 | NULL |SELECT id, deleted_id, status, name, LEFT( value, 1000 ) FROM s | 50 | mysql | fire-u1-1:58163 | blr_cn | Query | 120 | NULL |SELECT id, deleted_id, status, name, LEFT( value, 1000 ) FROM b Connections grow up during this time and after a couple minutes this problem gonna away. Explain me please why it happens and how can I solve this problem Thanks -- Vlad A. Shalnev E-mail: [EMAIL PROTECTED] Gravity can't be blamed for someone falling in love ( Albert Einstein ) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Krishna Chandra Prajapati
RE: SELECT in NULL state for a long time
If you want MYSQL to process the SELECT, including information about how tables are joined and in which order usehttp://dev.mysql.com/doc/refman/5.0/en/using-explain.htmle.g. EXPLAIN [EXTENDED] SELECT select_optionsIf you want MySQL uses the stored key distribution to decide the order in which tables should be joined when you perform a join on something other than a constant. In addition, key distributions can be used when deciding which indexes to use for a specific table within a query. http://dev.mysql.com/doc/refman/5.0/en/analyze-table.htmlYou can also check your stored key distributionhttp://dev.mysql.com/doc/refman/5.0/en/show-index.htmlMartin __ Disclaimer and confidentiality note Everything in this e-mail and any attachments relates to the official business of Sender. This transmission is of a confidential nature and Sender does not endorse distribution to any party other than intended recipient. Sender does not necessarily endorse content contained within this transmission. Date: Thu, 14 Aug 2008 17:35:00 +0530 From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: SELECT in NULL state for a long time CC: mysql@lists.mysql.com Record the query, execute and see the result. Make sure that you get the result. To me its seems that lots of request are comming and not full filled. Check the query for optimization. On Thu, Aug 14, 2008 at 5:17 PM, Vlad Shalnev [EMAIL PROTECTED] wrote: Hi, OS - Solaris 10, 32 Gb RAM, mysql 64-bit 4.1.22 Every day I see in processlist many SELECT queries that stay in NULL state for a long time. Something Like this | 368966 | radius | fire-u1:35671 | srg_conf | Query | 106 | NULL |SELECT id, deleted_id, status, name, LEFT( value, 1000 ) FROM s | 368967 | radius | fire-u1-1:35672 | srg_conf | Query | 105 | NULL |SELECT id, deleted_id, status, name, LEFT( value, 1000 ) FROM s | 368968 | radius | fire-u1-1:35673 | srg_conf | Query | 101 | NULL |SELECT id, deleted_id, status, name, LEFT( value, 1000 ) FROM s | 368969 | radius | fire-u1:35674 | srg_conf | Query | 101 | NULL |SELECT id, deleted_id, status, name, LEFT( value, 1000 ) FROM s | 368970 | radius | fire-u1:35675 | srg_conf | Query | 100 | NULL |SELECT id, deleted_id, status, name, LEFT( value, 1000 ) FROM s | 28 | mysql | fire-u1:58138 | hnt_cn | Query | 116 | NULL |SELECT id, deleted_id, status, name, LEFT( value, 1000 ) FROM h | 48 | radius | fire-u1:58166 | hnt_cn | Query | 114 | NULL |SELECT id, deleted_id, status, name, LEFT( value, 1000 ) FROM h | 49 | radius | fire-u1-1:58165 | srg_cn | Query | 127 | NULL |SELECT id, deleted_id, status, name, LEFT( value, 1000 ) FROM s | 50 | mysql | fire-u1-1:58163 | blr_cn | Query | 120 | NULL |SELECT id, deleted_id, status, name, LEFT( value, 1000 ) FROM b Connections grow up during this time and after a couple minutes this problem gonna away. Explain me please why it happens and how can I solve this problem Thanks -- Vlad A. Shalnev E-mail: [EMAIL PROTECTED] Gravity can't be blamed for someone falling in love ( Albert Einstein ) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Krishna Chandra Prajapati _ Get more from your digital life. Find out how. http://www.windowslive.com/default.html?ocid=TXT_TAGLM_WL_Home2_082008
another INNODB vs MYISAM question
Hello mysql, As I have previously mentioned, I installed WAMPSERVER 2.0 on my Windows XP pro box recently. It installed INNODB as the Default Engine. All of my legacy Databases are MYISAM and after the installation, I copied them all into the DATA folder and everything worked, even adding new tables etc. but the new stuff was INNODB. So I ended up with some MYISAM databases that contained INNODB tables in them. After a few weeks I got to thinking that mixing INNODB and MYISAM might not be a good thing and switched the Default Engine to MYISAM in my.ini file. I didn't just switch the default, I commented out all the INNODB calls in the my.ini file as well. As I half expected, all the databases that I had added INNODB tables failed when I tried to fire up the applications that used them. Although I am not new to mysql, I have had a bit of MYISAM tunnel vision with it so my question is, if I had just switched the default engine and NOT disabled the INNODB calls in my.ini, would that have prevented the problem? I restored all the MYISAM files and got everything back working again. I don't want to go through the lengthy reproduction exercise of reinstalling everything to test the theory so if someone has had some experience with this, I would appreciate hearing from them. -- Best regards, mikesz mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Need help to query with timestamp in C++
Hi, I need to write a C++ program in a Linux environment to query with a timestamp. The user will only provide with an approximate time so I'd like to know how can I write a program or a query to return the closest data. The followings are the timestamp in the MySQL database: | 2008-08-05 03:56:09 | 1217933769 | | 2008-08-05 03:56:19 | 1217933779 | | 2008-08-05 03:56:29 | 1217933789 | | 2008-08-05 03:59:39 | 1217933979 | | 2008-08-05 03:59:49 | 1217933989 | | 2008-08-05 03:59:59 | 1217933999 | | 2008-08-05 04:02:39 | 1217934159 | | 2008-08-05 04:02:49 | 1217934169 | | 2008-08-05 04:02:59 | 1217934179 | For example, '2008-08-05 04:01:39' is the time provided by the user which does not exist in the database. So, how can I return the closest data? I know I can make use of 'LIKE' but this will return more than one data. What is the best method to get the closest one? And what is the good connector (C++ to MySQL) to use? Any suggestion? Thank you. Kandy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Need help to query with timestamp in C++
I have done queries to the database in PHP with variables like month but easily can select from a range of time and data to produce the same results, the output goes directly to the web so if that is what you are seeking for, I can help with PHP. Saul Kandy Wong wrote: Hi, I need to write a C++ program in a Linux environment to query with a timestamp. The user will only provide with an approximate time so I'd like to know how can I write a program or a query to return the closest data. The followings are the timestamp in the MySQL database: | 2008-08-05 03:56:09 | 1217933769 | | 2008-08-05 03:56:19 | 1217933779 | | 2008-08-05 03:56:29 | 1217933789 | | 2008-08-05 03:59:39 | 1217933979 | | 2008-08-05 03:59:49 | 1217933989 | | 2008-08-05 03:59:59 | 1217933999 | | 2008-08-05 04:02:39 | 1217934159 | | 2008-08-05 04:02:49 | 1217934169 | | 2008-08-05 04:02:59 | 1217934179 | For example, '2008-08-05 04:01:39' is the time provided by the user which does not exist in the database. So, how can I return the closest data? I know I can make use of 'LIKE' but this will return more than one data. What is the best method to get the closest one? And what is the good connector (C++ to MySQL) to use? Any suggestion? Thank you. Kandy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]