[prev in list] [next in list] [prev in thread] [next in thread]
List: fedora-list
Subject: how to limit number of mysqld processes?
From: Phil <plabonte () gmail ! com>
Date: 2006-08-31 15:54:19
Message-ID: 4527aede0608310854t2df56da7iee31ecd7b5ec01ba () mail ! gmail ! com
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
on Fedora Core 3
I have about 15 mysqld processes running. They all appear to be child
processes of one. Can I limit the number of child processes of MySQL?
Here is the list of processes running:
root 9505 1 0 10:19 ? 00:00:00 /bin/sh /usr/bin/mysqld_safe
--datadir=/var/lib/mysql --pid-file=/var/lib/mysql/vottrt1.vistar.ca.pid
mysql 9698 9505 0 11:42 ? 00:00:00 /usr/sbin/mysqld --basedir=/
--datadir=/var/lib/mysql --user=mysql
--pid-file=/var/lib/mysql/vottrt1.vistar.ca.pid --skip-locking
--socket=/var/lib/mysql/mysql.sock
mysql 9699 9698 0 11:42 ? 00:00:00 /usr/sbin/mysqld --basedir=/
--datadir=/var/lib/mysql --user=mysql
--pid-file=/var/lib/mysql/vottrt1.vistar.ca.pid --skip-locking
--socket=/var/lib/mysql/mysql.sock
mysql 9700 9699 0 11:42 ? 00:00:00 /usr/sbin/mysqld --basedir=/
--datadir=/var/lib/mysql --user=mysql
--pid-file=/var/lib/mysql/vottrt1.vistar.ca.pid --skip-locking
--socket=/var/lib/mysql/mysql.sock
mysql 9701 9699 0 11:42 ? 00:00:00 /usr/sbin/mysqld --basedir=/
--datadir=/var/lib/mysql --user=mysql
--pid-file=/var/lib/mysql/vottrt1.vistar.ca.pid --skip-locking
--socket=/var/lib/mysql/mysql.sock
mysql 9702 9699 0 11:42 ? 00:00:00 /usr/sbin/mysqld --basedir=/
--datadir=/var/lib/mysql --user=mysql
--pid-file=/var/lib/mysql/vottrt1.vistar.ca.pid --skip-locking
--socket=/var/lib/mysql/mysql.sock
mysql 9703 9699 0 11:42 ? 00:00:00 /usr/sbin/mysqld --basedir=/
--datadir=/var/lib/mysql --user=mysql
--pid-file=/var/lib/mysql/vottrt1.vistar.ca.pid --skip-locking
--socket=/var/lib/mysql/mysql.sock
mysql 9704 9699 0 11:42 ? 00:00:00 /usr/sbin/mysqld --basedir=/
--datadir=/var/lib/mysql --user=mysql
--pid-file=/var/lib/mysql/vottrt1.vistar.ca.pid --skip-locking
--socket=/var/lib/mysql/mysql.sock
mysql 9705 9699 0 11:42 ? 00:00:00 /usr/sbin/mysqld --basedir=/
--datadir=/var/lib/mysql --user=mysql
--pid-file=/var/lib/mysql/vottrt1.vistar.ca.pid --skip-locking
--socket=/var/lib/mysql/mysql.sock
mysql 9706 9699 0 11:42 ? 00:00:00 /usr/sbin/mysqld --basedir=/
--datadir=/var/lib/mysql --user=mysql
--pid-file=/var/lib/mysql/vottrt1.vistar.ca.pid --skip-locking
--socket=/var/lib/mysql/mysql.sock
mysql 9707 9699 0 11:42 ? 00:00:00 /usr/sbin/mysqld --basedir=/
--datadir=/var/lib/mysql --user=mysql
--pid-file=/var/lib/mysql/vottrt1.vistar.ca.pid --skip-locking
--socket=/var/lib/mysql/mysql.sock
mysql 9709 9699 0 11:42 ? 00:00:01 /usr/sbin/mysqld --basedir=/
--datadir=/var/lib/mysql --user=mysql
--pid-file=/var/lib/mysql/vottrt1.vistar.ca.pid --skip-locking
--socket=/var/lib/mysql/mysql.sock
mysql 9710 9699 0 11:42 ? 00:00:01 /usr/sbin/mysqld --basedir=/
--datadir=/var/lib/mysql --user=mysql
--pid-file=/var/lib/mysql/vottrt1.vistar.ca.pid --skip-locking
--socket=/var/lib/mysql/mysql.sock
root 9804 9763 0 11:53 pts/1 00:00:00 grep mysql
[Attachment #5 (text/html)]
on Fedora Core 3<br><br>I have about 15 mysqld processes running. They all appear to \
be child processes of one. Can I limit the number of child processes of \
MySQL?<br><br>Here is the list of processes \
running:<br>root 9505 1 0 \
10:19 ? 00:00:00 /bin/sh \
/usr/bin/mysqld_safe --datadir=/var/lib/mysql \
--pid-file=/var/lib/mysql/vottrt1.vistar.ca.pid <br>mysql \
9698 9505 0 11:42 ? 00:00:00 \
/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql \
--pid-file=/var/lib/mysql/vottrt1.vistar.ca.pid --skip-locking \
--socket=/var/lib/mysql/mysql.sock<br>mysql 9699 \
9698 0 11:42 ? 00:00:00 \
/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql \
--pid-file=/var/lib/mysql/vottrt1.vistar.ca.pid --skip-locking \
--socket=/var/lib/mysql/mysql.sock <br>mysql 9700 \
9699 0 11:42 ? 00:00:00 \
/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql \
--pid-file=/var/lib/mysql/vottrt1.vistar.ca.pid --skip-locking \
--socket=/var/lib/mysql/mysql.sock<br>mysql 9701 \
9699 0 11:42 ? 00:00:00 \
/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql \
--pid-file=/var/lib/mysql/vottrt1.vistar.ca.pid --skip-locking \
--socket=/var/lib/mysql/mysql.sock <br>mysql 9702 \
9699 0 11:42 ? 00:00:00 \
/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql \
--pid-file=/var/lib/mysql/vottrt1.vistar.ca.pid --skip-locking \
--socket=/var/lib/mysql/mysql.sock<br>mysql 9703 \
9699 0 11:42 ? 00:00:00 \
/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql \
--pid-file=/var/lib/mysql/vottrt1.vistar.ca.pid --skip-locking \
--socket=/var/lib/mysql/mysql.sock <br>mysql 9704 \
9699 0 11:42 ? 00:00:00 \
/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql \
--pid-file=/var/lib/mysql/vottrt1.vistar.ca.pid --skip-locking \
--socket=/var/lib/mysql/mysql.sock<br>mysql 9705 \
9699 0 11:42 ? 00:00:00 \
/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql \
--pid-file=/var/lib/mysql/vottrt1.vistar.ca.pid --skip-locking \
--socket=/var/lib/mysql/mysql.sock <br>mysql 9706 \
9699 0 11:42 ? 00:00:00 \
/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql \
--pid-file=/var/lib/mysql/vottrt1.vistar.ca.pid --skip-locking \
--socket=/var/lib/mysql/mysql.sock<br>mysql 9707 \
9699 0 11:42 ? 00:00:00 \
/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql \
--pid-file=/var/lib/mysql/vottrt1.vistar.ca.pid --skip-locking \
--socket=/var/lib/mysql/mysql.sock <br>mysql 9709 \
9699 0 11:42 ? 00:00:01 \
/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql \
--pid-file=/var/lib/mysql/vottrt1.vistar.ca.pid --skip-locking \
--socket=/var/lib/mysql/mysql.sock<br>mysql 9710 \
9699 0 11:42 ? 00:00:01 \
/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql \
--pid-file=/var/lib/mysql/vottrt1.vistar.ca.pid --skip-locking \
--socket=/var/lib/mysql/mysql.sock <br>root 9804 \
9763 0 11:53 pts/1 00:00:00 grep mysql<br>
--
fedora-list mailing list
fedora-list@redhat.com
To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic