Re: Why so many mysqld lines in process list on Linux box
In the last episode (Feb 03), Rochester, Dean said: > We had an issue the other day where we could not access the myslq > database we have on our redhat linux 7.2 box. > > when I did a > > ps -ef |grep mysql > > I got the following. > > root 645 1 0 2002 ?00:00:00 [safe_mysqld] > root 688 645 0 2002 ?00:01:31 > /usr/local/mysql/bin/mysqld --ba > root 699 688 0 2002 ?00:00:33 > /usr/local/mysql/bin/mysqld --ba Arg. Please don't wrap things like logfiles or process lists. Linux creates a separate process for each thread, and it creates 3 helper processes, so all this means is you have 16 connections open to the server. -- Dan Nelson [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
Why so many mysqld lines in process list on Linux box
We had an issue the other day where we could not access the myslq database we have on our redhat linux 7.2 box. when I did a ps -ef |grep mysql I got the following. root 645 1 0 2002 ?00:00:00 [safe_mysqld] root 688 645 0 2002 ?00:01:31 /usr/local/mysql/bin/mysqld --ba root 699 688 0 2002 ?00:00:33 /usr/local/mysql/bin/mysqld --ba root 700 699 0 2002 ?00:00:43 /usr/local/mysql/bin/mysqld --ba root 13208 699 99 Jan31 ?18:36:55 /usr/local/mysql/bin/mysqld --ba root 13308 699 0 Jan31 ?00:00:00 /usr/local/mysql/bin/mysqld --ba root 13317 699 0 00:18 ?00:00:00 /usr/local/mysql/bin/mysqld --ba root 13322 699 0 00:33 ?00:00:00 /usr/local/mysql/bin/mysqld --ba root 13657 699 0 10:04 ?00:00:00 /usr/local/mysql/bin/mysqld --ba root 13658 699 0 10:05 ?00:00:00 /usr/local/mysql/bin/mysqld --ba root 13659 699 0 10:06 ?00:00:00 /usr/local/mysql/bin/mysqld --ba root 13660 699 0 10:07 ?00:00:00 /usr/local/mysql/bin/mysqld --ba root 13680 699 0 11:25 ?00:00:00 /usr/local/mysql/bin/mysqld --ba root 13681 699 0 11:27 ?00:00:00 /usr/local/mysql/bin/mysqld --ba root 13684 699 0 11:30 ?00:00:00 /usr/local/mysql/bin/mysqld --ba root 13730 699 0 11:39 ?00:00:00 /usr/local/mysql/bin/mysqld --ba root 13732 699 0 11:39 ?00:00:00 /usr/local/mysql/bin/mysqld --ba root 13737 699 0 11:41 ?00:00:00 /usr/local/mysql/bin/mysqld --ba root 13751 699 0 11:47 ?00:00:00 /usr/local/mysql/bin/mysqld --ba root 13756 699 0 11:49 ?00:00:00 /usr/local/mysql/bin/mysqld --ba root 13764 699 0 11:54 ?00:00:00 /usr/local/mysql/bin/mysqld --ba root 13832 13813 0 12:05 pts/000:00:00 grep mysql Why so many? Is this a problem? Thanks in advance Dean-O - 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
