Advice on MySQL Threads

C. Ed Felt edfelt at gmail.com
Thu Aug 4 15:30:33 MDT 2005


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

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


[ed at 200 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> 	root 
00: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> 	mysql 
00: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 ...


 




More information about the PLUG mailing list