Topic: mysql procesu ribojimas - kaip taupyti serverio resursus ?
Serveryje sukasi virualus mailai ir kelios www related duombazes..
Kaip uzribot mysql procesu kieki nes:
wm@ds:~$ ps aux | grep mysqld
root 8249 0.0 0.1 2708 1464 ? S 2007 0:00 /bin/sh ./mysqld_safe --user=mysql
mysql 8276 0.0 2.3 60660 23848 ? S 2007 0:11 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --pid-file=/usr/local/mysql/var/stud.pid --skip-external-locking --port=3306 --socket=/tmp/mysql.sock
mysql 8277 0.0 2.3 60660 23848 ? S 2007 0:06 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --pid-file=/usr/local/mysql/var/stud.pid --skip-external-locking --port=3306 --socket=/tmp/mysql.sock
mysql 8278 0.0 2.3 60660 23848 ? S 2007 0:00 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --pid-file=/usr/local/mysql/var/stud.pid --skip-external-locking --port=3306 --socket=/tmp/mysql.sock
mysql 8279 0.0 2.3 60660 23848 ? S 2007 0:00 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --pid-file=/usr/local/mysql/var/stud.pid --skip-external-locking --port=3306 --socket=/tmp/mysql.sock
mysql 8280 0.0 2.3 60660 23848 ? S 2007 0:00 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --pid-file=/usr/local/mysql/var/stud.pid --skip-external-locking --port=3306 --socket=/tmp/mysql.sock
mysql 8281 0.0 2.3 60660 23848 ? S 2007 0:00 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --pid-file=/usr/local/mysql/var/stud.pid --skip-external-locking --port=3306 --socket=/tmp/mysql.sock
mysql 8282 0.0 2.3 60660 23848 ? S 2007 0:00 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --pid-file=/usr/local/mysql/var/stud.pid --skip-external-locking --port=3306 --socket=/tmp/mysql.sock
mysql 8283 0.0 2.3 60660 23848 ? S 2007 0:00 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --pid-file=/usr/local/mysql/var/stud.pid --skip-external-locking --port=3306 --socket=/tmp/mysql.sock
mysql 8284 0.0 2.3 60660 23848 ? S 2007 0:00 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --pid-file=/usr/local/mysql/var/stud.pid --skip-external-locking --port=3306 --socket=/tmp/mysql.sock
mysql 8285 0.0 2.3 60660 23848 ? S 2007 0:01 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --pid-file=/usr/local/mysql/var/stud.pid --skip-external-locking --port=3306 --socket=/tmp/mysql.sock
mysql 23829 0.0 2.3 60660 23848 ? S 23:37 0:00 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --pid-file=/usr/local/mysql/var/stud.pid --skip-external-locking --port=3306 --socket=/tmp/mysql.sock
mysql 23876 0.0 2.3 60660 23848 ? S 23:39 0:00 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --pid-file=/usr/local/mysql/var/stud.pid --skip-external-locking --port=3306 --socket=/tmp/mysql.sock
mysql 23954 0.0 2.3 60660 23848 ? S 23:40 0:00 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --pid-file=/usr/local/mysql/var/stud.pid --skip-external-locking --port=3306 --socket=/tmp/mysql.sock
mysql 24062 0.0 2.3 60660 23848 ? S 23:41 0:00 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --pid-file=/usr/local/mysql/var/stud.pid --skip-external-locking --port=3306 --socket=/tmp/mysql.sock
mysql 24063 0.0 2.3 60660 23848 ? S 23:41 0:00 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --pid-file=/usr/local/mysql/var/stud.pid --skip-external-locking --port=3306 --socket=/tmp/mysql.sock
mysql 24082 0.0 2.3 60660 23848 ? S 23:41 0:00 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --pid-file=/usr/local/mysql/var/stud.pid --skip-external-locking --port=3306 --socket=/tmp/mysql.sock
wm 24120 0.0 0.0 1792 604 pts/1 R+ 23:42 0:00 grep mysqld
wm@ds:~$