Advice on MySQL Threads

C. Ed Felt Thu, 04 Aug 2005 14:30:45 -0700

Just need some advice. Any idea why there are so many threads of mysqlrunning on my server? We are trying to squeeze some performance out.

We are starting it the standard way "service mysql start" from the usualinit at startup.



[EMAIL PROTECTED] ed]$ mysql -V
mysql  Ver 11.18 Distrib 3.23.58, for pc-linux (i686)

Process ID     Owner     Started     Command

3233 root 00:01 /bin/sh /usr/bin/safe_mysqld--datadir=/var/lib/mysql --pid-file=/var/lib/mysql/ ...3261 mysql 00:01 /usr/sbin/mysqld --basedir=/--datadir=/var/lib/mysql --user=mysql --pid-file=/v ...3265 mysql 00:01 /usr/sbin/mysqld --basedir=/--datadir=/var/lib/mysql --user=mysql --pid-file=/v ...3266 mysql 00:01 /usr/sbin/mysqld --basedir=/--datadir=/var/lib/mysql --user=mysql --pid-file=/v ...3569 mysql 00:02 /usr/sbin/mysqld --basedir=/--datadir=/var/lib/mysql --user=mysql --pid-file=/v ...3570 mysql 00:02 /usr/sbin/mysqld --basedir=/--datadir=/var/lib/mysql --user=mysql --pid-file=/v ...3571 mysql 00:02 /usr/sbin/mysqld --basedir=/--datadir=/var/lib/mysql --user=mysql --pid-file=/v ...3572 mysql 00:02 /usr/sbin/mysqld --basedir=/--datadir=/var/lib/mysql --user=mysql --pid-file=/v ...3573 mysql 00:02 /usr/sbin/mysqld --basedir=/--datadir=/var/lib/mysql --user=mysql --pid-file=/v ...4415 mysql 13:44 /usr/sbin/mysqld --basedir=/--datadir=/var/lib/mysql --user=mysql --pid-file=/v ...7089 mysql 02:26 /usr/sbin/mysqld --basedir=/--datadir=/var/lib/mysql --user=mysql --pid-file=/v ...7979 mysql 02:40 /usr/sbin/mysqld --basedir=/--datadir=/var/lib/mysql --user=mysql --pid-file=/v ...7980 mysql 02:40 /usr/sbin/mysqld --basedir=/--datadir=/var/lib/mysql --user=mysql --pid-file=/v ...7982 mysql 02:40 /usr/sbin/mysqld --basedir=/--datadir=/var/lib/mysql --user=mysql --pid-file=/v ...7984 mysql 02:40 /usr/sbin/mysqld --basedir=/--datadir=/var/lib/mysql --user=mysql --pid-file=/v ...7985 mysql 02:40 /usr/sbin/mysqld --basedir=/--datadir=/var/lib/mysql --user=mysql --pid-file=/v ...7986 mysql 02:40 /usr/sbin/mysqld --basedir=/--datadir=/var/lib/mysql --user=mysql --pid-file=/v ...7989 mysql 02:40 /usr/sbin/mysqld --basedir=/--datadir=/var/lib/mysql --user=mysql --pid-file=/v ...7991 mysql 02:40 /usr/sbin/mysqld --basedir=/--datadir=/var/lib/mysql --user=mysql --pid-file=/v ...7992 mysql 02:40 /usr/sbin/mysqld --basedir=/--datadir=/var/lib/mysql --user=mysql --pid-file=/v ...7994 mysql 02:40 /usr/sbin/mysqld --basedir=/--datadir=/var/lib/mysql --user=mysql --pid-file=/v ...7995 mysql 02:40 /usr/sbin/mysqld --basedir=/--datadir=/var/lib/mysql --user=mysql --pid-file=/v ...7997 mysql 02:40 /usr/sbin/mysqld --basedir=/--datadir=/var/lib/mysql --user=mysql --pid-file=/v ...7998 mysql 02:40 /usr/sbin/mysqld --basedir=/--datadir=/var/lib/mysql --user=mysql --pid-file=/v ...8000 mysql 02:40 /usr/sbin/mysqld --basedir=/--datadir=/var/lib/mysql --user=mysql --pid-file=/v ...8001 mysql 02:40 /usr/sbin/mysqld --basedir=/--datadir=/var/lib/mysql --user=mysql --pid-file=/v ...8002 mysql 02:40 /usr/sbin/mysqld --basedir=/--datadir=/var/lib/mysql --user=mysql --pid-file=/v ...8003 mysql 02:40 /usr/sbin/mysqld --basedir=/--datadir=/var/lib/mysql --user=mysql --pid-file=/v ...8004 mysql 02:40 /usr/sbin/mysqld --basedir=/--datadir=/var/lib/mysql --user=mysql --pid-file=/v ...8006 mysql 02:40 /usr/sbin/mysqld --basedir=/--datadir=/var/lib/mysql --user=mysql --pid-file=/v ...8007 mysql 02:40 /usr/sbin/mysqld --basedir=/--datadir=/var/lib/mysql --user=mysql --pid-file=/v ...8009 mysql 02:40 /usr/sbin/mysqld --basedir=/--datadir=/var/lib/mysql --user=mysql --pid-file=/v ...8010 mysql 02:40 /usr/sbin/mysqld --basedir=/--datadir=/var/lib/mysql --user=mysql --pid-file=/v ...8012 mysql 02:40 /usr/sbin/mysqld --basedir=/--datadir=/var/lib/mysql --user=mysql --pid-file=/v ...8013 mysql 02:40 /usr/sbin/mysqld --basedir=/--datadir=/var/lib/mysql --user=mysql --pid-file=/v ...8017 mysql 02:40 /usr/sbin/mysqld --basedir=/--datadir=/var/lib/mysql --user=mysql --pid-file=/v ...


Thanks,

Ed Felt

----IGNORE AND DELETE HTML BELOW BEFORE REPLYING/FORWARDING----I JUST PUT IT HERE FOR THOSE WHO HAVE EMAIL CLIENTS THAT CAN READ IT


*Process ID*    *Owner*         *Started*       *Command*

3233 <http://200.68.87.115:10000/proc/edit_proc.cgi?3233> root00:01 /bin/sh /usr/bin/safe_mysqld --datadir=/var/lib/mysql--pid-file=/var/lib/mysql/ ...3261 <http://200.68.87.115:10000/proc/edit_proc.cgi?3261> mysql00:01 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql--user=mysql --pid-file=/v ...3265 <http://200.68.87.115:10000/proc/edit_proc.cgi?3265>mysql 00:01 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql--user=mysql --pid-file=/v ...3266 <http://200.68.87.115:10000/proc/edit_proc.cgi?3266>mysql 00:01 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql--user=mysql --pid-file=/v ...3569 <http://200.68.87.115:10000/proc/edit_proc.cgi?3569>mysql 00:02 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql--user=mysql --pid-file=/v ...3570 <http://200.68.87.115:10000/proc/edit_proc.cgi?3570>mysql 00:02 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql--user=mysql --pid-file=/v ...3571 <http://200.68.87.115:10000/proc/edit_proc.cgi?3571>mysql 00:02 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql--user=mysql --pid-file=/v ...3572 <http://200.68.87.115:10000/proc/edit_proc.cgi?3572>mysql 00:02 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql--user=mysql --pid-file=/v ...3573 <http://200.68.87.115:10000/proc/edit_proc.cgi?3573>mysql 00:02 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql--user=mysql --pid-file=/v ...4415 <http://200.68.87.115:10000/proc/edit_proc.cgi?4415>mysql 13:44 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql--user=mysql --pid-file=/v ...7089 <http://200.68.87.115:10000/proc/edit_proc.cgi?7089>mysql 02:26 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql--user=mysql --pid-file=/v ...7979 <http://200.68.87.115:10000/proc/edit_proc.cgi?7979>mysql 02:40 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql--user=mysql --pid-file=/v ...7980 <http://200.68.87.115:10000/proc/edit_proc.cgi?7980>mysql 02:40 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql--user=mysql --pid-file=/v ...7982 <http://200.68.87.115:10000/proc/edit_proc.cgi?7982>mysql 02:40 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql--user=mysql --pid-file=/v ...7984 <http://200.68.87.115:10000/proc/edit_proc.cgi?7984>mysql 02:40 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql--user=mysql --pid-file=/v ...7985 <http://200.68.87.115:10000/proc/edit_proc.cgi?7985>mysql 02:40 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql--user=mysql --pid-file=/v ...7986 <http://200.68.87.115:10000/proc/edit_proc.cgi?7986>mysql 02:40 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql--user=mysql --pid-file=/v ...7989 <http://200.68.87.115:10000/proc/edit_proc.cgi?7989>mysql 02:40 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql--user=mysql --pid-file=/v ...7991 <http://200.68.87.115:10000/proc/edit_proc.cgi?7991>mysql 02:40 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql--user=mysql --pid-file=/v ...7992 <http://200.68.87.115:10000/proc/edit_proc.cgi?7992>mysql 02:40 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql--user=mysql --pid-file=/v ...7994 <http://200.68.87.115:10000/proc/edit_proc.cgi?7994>mysql 02:40 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql--user=mysql --pid-file=/v ...7995 <http://200.68.87.115:10000/proc/edit_proc.cgi?7995>mysql 02:40 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql--user=mysql --pid-file=/v ...7997 <http://200.68.87.115:10000/proc/edit_proc.cgi?7997>mysql 02:40 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql--user=mysql --pid-file=/v ...7998 <http://200.68.87.115:10000/proc/edit_proc.cgi?7998>mysql 02:40 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql--user=mysql --pid-file=/v ...8000 <http://200.68.87.115:10000/proc/edit_proc.cgi?8000>mysql 02:40 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql--user=mysql --pid-file=/v ...8001 <http://200.68.87.115:10000/proc/edit_proc.cgi?8001>mysql 02:40 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql--user=mysql --pid-file=/v ...8002 <http://200.68.87.115:10000/proc/edit_proc.cgi?8002>mysql 02:40 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql--user=mysql --pid-file=/v ...8003 <http://200.68.87.115:10000/proc/edit_proc.cgi?8003>mysql 02:40 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql--user=mysql --pid-file=/v ...8004 <http://200.68.87.115:10000/proc/edit_proc.cgi?8004>mysql 02:40 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql--user=mysql --pid-file=/v ...8006 <http://200.68.87.115:10000/proc/edit_proc.cgi?8006>mysql 02:40 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql--user=mysql --pid-file=/v ...8007 <http://200.68.87.115:10000/proc/edit_proc.cgi?8007>mysql 02:40 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql--user=mysql --pid-file=/v ...8009 <http://200.68.87.115:10000/proc/edit_proc.cgi?8009>mysql 02:40 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql--user=mysql --pid-file=/v ...8010 <http://200.68.87.115:10000/proc/edit_proc.cgi?8010>mysql 02:40 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql--user=mysql --pid-file=/v ...8012 <http://200.68.87.115:10000/proc/edit_proc.cgi?8012>mysql 02:40 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql--user=mysql --pid-file=/v ...8013 <http://200.68.87.115:10000/proc/edit_proc.cgi?8013>mysql 02:40 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql--user=mysql --pid-file=/v ...8017 <http://200.68.87.115:10000/proc/edit_proc.cgi?8017>mysql 02:40 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql--user=mysql --pid-file=/v ...





.===================================.
| This has been a P.L.U.G. mailing. |
|      Don't Fear the Penguin.      |
|  IRC: #utah at irc.freenode.net   |
`==================================='

Advice on MySQL Threads

Reply via email to