mysql 한계?
글쓴이: Anermy / 작성시간: 금, 2007/09/07 - 11:56오후
root 3381 3340 0 22:37 pts/0 00:00:00 grep mysqld [root@localhost /]# ps -ef | grep mysqld root 2612 1 0 22:36 ? 00:00:00 /bin/sh /usr/local/mysql_4.0.27/bin/mysqld_safe --datadir=/usr/local/mysql_4.0.27/data --pid-file=/usr/local/mysql_4.0.27/data/localhost.localdomain.pid mysql 2649 2612 0 22:36 ? 00:00:00 /usr/local/mysql_4.0.27/libexec/mysqld --basedir=/usr/local/mysql_4.0.27 --datadir=/usr/local/mysql_4.0.27/data --user=mysql --pid-file=/usr/local/mysql_4.0.27/data/localhost.localdomain.pid --skip-locking --port=3306 --socket=/tmp/mysql.sock mysql 3249 2649 0 22:36 ? 00:00:00 /usr/local/mysql_4.0.27/libexec/mysqld --basedir=/usr/local/mysql_4.0.27 --datadir=/usr/local/mysql_4.0.27/data --user=mysql --pid-file=/usr/local/mysql_4.0.27/data/localhost.localdomain.pid --skip-locking --port=3306 --socket=/tmp/mysql.sock mysql 3250 3249 0 22:36 ? 00:00:00 /usr/local/mysql_4.0.27/libexec/mysqld --basedir=/usr/local/mysql_4.0.27 --datadir=/usr/local/mysql_4.0.27/data --user=mysql --pid-file=/usr/local/mysql_4.0.27/data/localhost.localdomain.pid --skip-locking --port=3306 --socket=/tmp/mysql.sock mysql 3251 3249 0 22:36 ? 00:00:00 /usr/local/mysql_4.0.27/libexec/mysqld --basedir=/usr/local/mysql_4.0.27 --datadir=/usr/local/mysql_4.0.27/data --user=mysql --pid-file=/usr/local/mysql_4.0.27/data/localhost.localdomain.pid --skip-locking --port=3306 --socket=/tmp/mysql.sock mysql 3253 3249 0 22:36 ? 00:00:00 /usr/local/mysql_4.0.27/libexec/mysqld --basedir=/usr/local/mysql_4.0.27 --datadir=/usr/local/mysql_4.0.27/data --user=mysql --pid-file=/usr/local/mysql_4.0.27/data/localhost.localdomain.pid --skip-locking --port=3306 --socket=/tmp/mysql.sock mysql 3254 3249 0 22:36 ? 00:00:00 /usr/local/mysql_4.0.27/libexec/mysqld --basedir=/usr/local/mysql_4.0.27 --datadir=/usr/local/mysql_4.0.27/data --user=mysql --pid-file=/usr/local/mysql_4.0.27/data/localhost.localdomain.pid --skip-locking --port=3306 --socket=/tmp/mysql.sock mysql 3280 3249 0 22:36 ? 00:00:00 /usr/local/mysql_4.0.27/libexec/mysqld --basedir=/usr/local/mysql_4.0.27 --datadir=/usr/local/mysql_4.0.27/data --user=mysql --pid-file=/usr/local/mysql_4.0.27/data/localhost.localdomain.pid --skip-locking --port=3306 --socket=/tmp/mysql.sock mysql 3281 3249 0 22:36 ? 00:00:00 /usr/local/mysql_4.0.27/libexec/mysqld --basedir=/usr/local/mysql_4.0.27 --datadir=/usr/local/mysql_4.0.27/data --user=mysql --pid-file=/usr/local/mysql_4.0.27/data/localhost.localdomain.pid --skip-locking --port=3306 --socket=/tmp/mysql.sock mysql 3282 3249 0 22:36 ? 00:00:00 /usr/local/mysql_4.0.27/libexec/mysqld --basedir=/usr/local/mysql_4.0.27 --datadir=/usr/local/mysql_4.0.27/data --user=mysql --pid-file=/usr/local/mysql_4.0.27/data/localhost.localdomain.pid --skip-locking --port=3306 --socket=/tmp/mysql.sock mysql 3283 3249 0 22:36 ? 00:00:00 /usr/local/mysql_4.0.27/libexec/mysqld --basedir=/usr/local/mysql_4.0.27 --datadir=/usr/local/mysql_4.0.27/data --user=mysql --pid-file=/usr/local/mysql_4.0.27/data/localhost.localdomain.pid --skip-locking --port=3306 --socket=/tmp/mysql.sock
엄청나게 많은 접속자가 한순간 광고로 인해 접속하는데요...
정점에 이르면, 위와 같은 프로세스가 엄청나게 많습니다... 2000여개 정도...
물론, 웹에서 접속도 불가능하구요..
웹서버와 디비서버는 분리되어 있습니다. 2.0G CPU (듀얼아님) 1G RAM, 디비는 2G RAM 사용중입니다.
IDC 백본에 들어가 있구요..
MYSQL 튜닝은 아래와...
key_buffer = 20M max_allowed_packet = 1M table_cache = 64 sort_buffer_size = 512K net_buffer_length = 8K myisam_sort_buffer_size = 8M #Opened_tables = 2048 #thread_cache = 50 query_cache_size = 32M # Try number of CPU's*2 for thread_concurrency thread_concurrency = 4 max_connections = 2048 max_user_connections = 2048 wait_timeout=3600
다운이 너무 잘되서 갚을 이리저리 바꾸다 보니 이렇게 됐네요;;
프로세스가 엄청나게 뜨는게.. 저 max_user_connections때문일까여.
아무튼 서버를 늘리든 어케 해야 할듯한데...
무지해서 어쩌지 못하겠네요...
여러분의 작은 조언이 저에게는 큰 힘이 됩니다.
Forums: