그누보드 사용자인데 이거 무슨 문제인지..ㅡㅡ;;

그누보드 사용자인데 이거 무슨 문제인지..ㅡㅡ;; 정보

그누보드 그누보드 사용자인데 이거 무슨 문제인지..ㅡㅡ;;

음냐리 자기소개 아이디로 검색 회원게시물 (218.♡.♡.230)
2004.11.10 23:21:04
조회 524
댓글 2

본문

서버호스팅을 하는데도 mysql 상태를 보니 select질의가 88.07 % 나 차지하고 있습니다.
물론 게시판 소스 건드린건 없고요..
CPU점유율도 90%이상이 나올 경우가 많고요..
특히 게시판 목록보기, 글보기 할때 많이 버벅거리거든요..

이유가 뭔지 좀 가르쳐 주십시요...;;;

전체 사용량	ø per hour	ø per minute	ø per second
3,193,393	97,450.32	1,624.17	27.07

질의 종류		ø per hour	%
admin commands	0	0.00	0.00 %
alter table	732	22.34	0.02 %
analyze	0	0.00	0.00 %
backup table	0	0.00	0.00 %
begin	0	0.00	0.00 %
change db	103,528	3,159.28	3.28 %
change master	0	0.00	0.00 %
check	0	0.00	0.00 %
commit	0	0.00	0.00 %
create db	0	0.00	0.00 %
create function	0	0.00	0.00 %
create index	0	0.00	0.00 %
create table	61	1.86	0.00 %
delete	41,239	1,258.46	1.31 %
drop db	0	0.00	0.00 %
drop function	0	0.00	0.00 %
drop index	0	0.00	0.00 %
drop table	0	0.00	0.00 %
flush	1	0.03	0.00 %
grant	0	0.00	0.00 %
insert	110,291	3,365.67	3.50 %
insert select	0	0.00	0.00 %
kill	88	2.69	0.00 %
load	0	0.00	0.00 %
load master table	0	0.00	0.00 %
lock tables	0	0.00	0.00 %
optimize	61	1.86	0.00 %
purge	0	0.00	0.00 %
rename table	0	0.00	0.00 %

질의 종류		ø per hour	%
repair	0	0.00	0.00 %
replace	0	0.00	0.00 %
replace select	0	0.00	0.00 %
reset	0	0.00	0.00 %
restore table	0	0.00	0.00 %
revoke	0	0.00	0.00 %
rollback	0	0.00	0.00 %
select	2,776,298	84,722.16	88.07 %
set option	0	0.00	0.00 %
show binlogs	0	0.00	0.00 %
show create	0	0.00	0.00 %
show databases	9	0.27	0.00 %
show fields	31,477	960.56	1.00 %
show grants	0	0.00	0.00 %
show keys	0	0.00	0.00 %
show logs	0	0.00	0.00 %
show master status	0	0.00	0.00 %
show open tables	0	0.00	0.00 %
show processlist	245	7.48	0.01 %
show slave status	0	0.00	0.00 %
show status	6	0.18	0.00 %
show innodb status	0	0.00	0.00 %
show tables	31,214	952.53	0.99 %
show variables	5	0.15	0.00 %
slave start	0	0.00	0.00 %
slave stop	0	0.00	0.00 %
truncate	0	0.00	0.00 %
unlock tables	0	0.00	0.00 %
update	57,008	1,739.67	1.81 %

댓글 전체

prosper 홈페이지 자기소개 아이디로 검색 회원게시물

홈페이지 자기소개 아이디로 검색 회원게시물

(211.♡.♡.186) 04.11.11 01:29:29

대략 회원수를 올려주시는게 좋을꺼 같습니다.

저의 경우 총회원이 7만을 넘어서면서 mysql 과부하가 생겼습니다.

아무래도 gnuboard의 쿼리가 최적화 되어있지 않은듯 싶네요.

저의 경우는 서버메모리를 256에서 512로 업그레이드 했으며,
my.cnf의 설정을 다시하였습니다.

아마도 회원 필드의 select가 많은거 같은데 이부분 최적화 신경을 쓰셔야 할껏 같네요..

음냐리 자기소개 아이디로 검색 회원게시물

자기소개 아이디로 검색 회원게시물

(218.♡.♡.230) 04.11.10 23:27:15

23:38:54 up 1 day, 9:01, 1 user, load average: 0.61, 0.64, 0.70
60 processes: 58 sleeping, 2 running, 0 zombie, 0 stopped
CPU states: cpu user nice system irq softirq iowait idle
total 78.4% 0.0% 17.0% 0.0% 0.0% 0.0% 4.6%
Mem: 503864k av, 440812k used, 63052k free, 0k shrd, 46752k buff
325120k actv, 73572k in_d, 6764k in_c
Swap: 1052216k av, 34104k used, 1018112k free 267880k cached

PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND
550 mysql 15 0 22520 16M 1424 S 77.9 3.2 639:14 0 mysqld
552 root 15 0 2932 356 268 S 17.3 0.0 1:54 0 httpd
1 root 15 0 512 476 452 S 0.0 0.0 0:03 0 init
2 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 keventd
3 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 kapmd
4 root 34 19 0 0 0 SWN 0.0 0.0 0:00 0 ksoftirqd/0
7 root 25 0 0 0 0 SW 0.0 0.0 0:00 0 bdflush
5 root 15 0 0 0 0 SW 0.0 0.0 0:02 0 kswapd
6 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 kscand
8 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 kupdated
9 root 25 0 0 0 0 SW 0.0 0.0 0:00 0 mdrecoveryd
13 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 kjournald
116 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 kjournald
117 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 kjournald
118 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 kjournald
119 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 kjournald
120 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 kjournald
407 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 eth0
453 root 15 0 224 196 144 S 0.0 0.0 0:00 0 syslogd
457 root 22 0 96 36 32 S 0.0 0.0 0:00 0 klogd
485 root 16 0 540 396 292 S 0.0 0.0 0:00 0 sshd
496 root 22 0 244 128 124 S 0.0 0.0 0:00 0 xinetd
505 root 15 0 172 88 84 S 0.0 0.0 0:00 0 vsftpd
517 root 25 0 152 4 0 S 0.0 0.0 0:00 0 safe_mysqld
561 root 15 0 192 172 120 S 0.0 0.0 0:00 0 crond
570 root 25 0 152 52 48 S 0.0 0.0 0:00 0 saslauthd
586 root 15 0 12144 11M 1372 S 0.0 2.4 0:00 0 mdmpd
593 root 15 0 56 4 0 S 0.0 0.0 0:00 0 mingetty
594 root 15 0 56 4 0 S 0.0 0.0 0:00 0 mingetty
595 root 15 0 52 4 0 S 0.0 0.0 0:00 0 mingetty
596 root 15 0 52 4 0 S 0.0 0.0 0:00 0 mingetty
597 root 18 0 56 4 0 S 0.0 0.0 0:00 0 mingetty
598 root 18 0 56 4 0 S 0.0 0.0 0:00 0 mingetty
930 root 15 0 620 316 192 R 0.0 0.0 0:00 0 sshd
935 root 15 0 680 616 440 S 0.0 0.1 0:00 0 bash
14066 root 15 0 1216 1216 916 R 0.0 0.2 0:00 0 top

23:38:54&nbsp; up 1 day,&nbsp; 9:01,&nbsp; 1 user,&nbsp; load average: 0.61, 0.64, 0.70
60 processes: 58 sleeping, 2 running, 0 zombie, 0 stopped
CPU states:&nbsp; cpu&nbsp; &nbsp; user&nbsp; &nbsp; nice&nbsp; system&nbsp; &nbsp; irq&nbsp; softirq&nbsp; iowait&nbsp; &nbsp; idle
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;  total&nbsp;  78.4%&nbsp; &nbsp; 0.0%&nbsp;  17.0%&nbsp;  0.0%&nbsp; &nbsp;  0.0%&nbsp; &nbsp; 0.0%&nbsp; &nbsp; 4.6%
Mem:&nbsp;  503864k av,&nbsp; 440812k used,&nbsp;  63052k free,&nbsp; &nbsp; &nbsp;  0k shrd,&nbsp;  46752k buff
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 325120k actv,&nbsp;  73572k in_d,&nbsp; &nbsp; 6764k in_c
Swap: 1052216k av,&nbsp;  34104k used, 1018112k free&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 267880k cached

&nbsp; PID USER&nbsp; &nbsp;  PRI&nbsp; NI&nbsp; SIZE&nbsp; RSS SHARE STAT %CPU %MEM&nbsp;  TIME CPU COMMAND
&nbsp; 550 mysql&nbsp; &nbsp;  15&nbsp;  0 22520&nbsp; 16M&nbsp; 1424 S&nbsp; &nbsp; 77.9&nbsp; 3.2 639:14&nbsp;  0 mysqld
&nbsp; 552 root&nbsp; &nbsp; &nbsp; 15&nbsp;  0&nbsp; 2932&nbsp; 356&nbsp;  268 S&nbsp; &nbsp; 17.3&nbsp; 0.0&nbsp;  1:54&nbsp;  0 httpd
&nbsp; &nbsp; 1 root&nbsp; &nbsp; &nbsp; 15&nbsp;  0&nbsp;  512&nbsp; 476&nbsp;  452 S&nbsp; &nbsp;  0.0&nbsp; 0.0&nbsp;  0:03&nbsp;  0 init
&nbsp; &nbsp; 2 root&nbsp; &nbsp; &nbsp; 15&nbsp;  0&nbsp; &nbsp;  0&nbsp; &nbsp; 0&nbsp; &nbsp;  0 SW&nbsp; &nbsp; 0.0&nbsp; 0.0&nbsp;  0:00&nbsp;  0 keventd
&nbsp; &nbsp; 3 root&nbsp; &nbsp; &nbsp; 15&nbsp;  0&nbsp; &nbsp;  0&nbsp; &nbsp; 0&nbsp; &nbsp;  0 SW&nbsp; &nbsp; 0.0&nbsp; 0.0&nbsp;  0:00&nbsp;  0 kapmd
&nbsp; &nbsp; 4 root&nbsp; &nbsp; &nbsp; 34&nbsp; 19&nbsp; &nbsp;  0&nbsp; &nbsp; 0&nbsp; &nbsp;  0 SWN&nbsp;  0.0&nbsp; 0.0&nbsp;  0:00&nbsp;  0 ksoftirqd/0
&nbsp; &nbsp; 7 root&nbsp; &nbsp; &nbsp; 25&nbsp;  0&nbsp; &nbsp;  0&nbsp; &nbsp; 0&nbsp; &nbsp;  0 SW&nbsp; &nbsp; 0.0&nbsp; 0.0&nbsp;  0:00&nbsp;  0 bdflush
&nbsp; &nbsp; 5 root&nbsp; &nbsp; &nbsp; 15&nbsp;  0&nbsp; &nbsp;  0&nbsp; &nbsp; 0&nbsp; &nbsp;  0 SW&nbsp; &nbsp; 0.0&nbsp; 0.0&nbsp;  0:02&nbsp;  0 kswapd
&nbsp; &nbsp; 6 root&nbsp; &nbsp; &nbsp; 15&nbsp;  0&nbsp; &nbsp;  0&nbsp; &nbsp; 0&nbsp; &nbsp;  0 SW&nbsp; &nbsp; 0.0&nbsp; 0.0&nbsp;  0:00&nbsp;  0 kscand
&nbsp; &nbsp; 8 root&nbsp; &nbsp; &nbsp; 15&nbsp;  0&nbsp; &nbsp;  0&nbsp; &nbsp; 0&nbsp; &nbsp;  0 SW&nbsp; &nbsp; 0.0&nbsp; 0.0&nbsp;  0:00&nbsp;  0 kupdated
&nbsp; &nbsp; 9 root&nbsp; &nbsp; &nbsp; 25&nbsp;  0&nbsp; &nbsp;  0&nbsp; &nbsp; 0&nbsp; &nbsp;  0 SW&nbsp; &nbsp; 0.0&nbsp; 0.0&nbsp;  0:00&nbsp;  0 mdrecoveryd
&nbsp;  13 root&nbsp; &nbsp; &nbsp; 15&nbsp;  0&nbsp; &nbsp;  0&nbsp; &nbsp; 0&nbsp; &nbsp;  0 SW&nbsp; &nbsp; 0.0&nbsp; 0.0&nbsp;  0:00&nbsp;  0 kjournald
&nbsp; 116 root&nbsp; &nbsp; &nbsp; 15&nbsp;  0&nbsp; &nbsp;  0&nbsp; &nbsp; 0&nbsp; &nbsp;  0 SW&nbsp; &nbsp; 0.0&nbsp; 0.0&nbsp;  0:00&nbsp;  0 kjournald
&nbsp; 117 root&nbsp; &nbsp; &nbsp; 15&nbsp;  0&nbsp; &nbsp;  0&nbsp; &nbsp; 0&nbsp; &nbsp;  0 SW&nbsp; &nbsp; 0.0&nbsp; 0.0&nbsp;  0:00&nbsp;  0 kjournald
&nbsp; 118 root&nbsp; &nbsp; &nbsp; 15&nbsp;  0&nbsp; &nbsp;  0&nbsp; &nbsp; 0&nbsp; &nbsp;  0 SW&nbsp; &nbsp; 0.0&nbsp; 0.0&nbsp;  0:00&nbsp;  0 kjournald
&nbsp; 119 root&nbsp; &nbsp; &nbsp; 15&nbsp;  0&nbsp; &nbsp;  0&nbsp; &nbsp; 0&nbsp; &nbsp;  0 SW&nbsp; &nbsp; 0.0&nbsp; 0.0&nbsp;  0:00&nbsp;  0 kjournald
&nbsp; 120 root&nbsp; &nbsp; &nbsp; 15&nbsp;  0&nbsp; &nbsp;  0&nbsp; &nbsp; 0&nbsp; &nbsp;  0 SW&nbsp; &nbsp; 0.0&nbsp; 0.0&nbsp;  0:00&nbsp;  0 kjournald
&nbsp; 407 root&nbsp; &nbsp; &nbsp; 15&nbsp;  0&nbsp; &nbsp;  0&nbsp; &nbsp; 0&nbsp; &nbsp;  0 SW&nbsp; &nbsp; 0.0&nbsp; 0.0&nbsp;  0:00&nbsp;  0 eth0
&nbsp; 453 root&nbsp; &nbsp; &nbsp; 15&nbsp;  0&nbsp;  224&nbsp; 196&nbsp;  144 S&nbsp; &nbsp;  0.0&nbsp; 0.0&nbsp;  0:00&nbsp;  0 syslogd
&nbsp; 457 root&nbsp; &nbsp; &nbsp; 22&nbsp;  0&nbsp; &nbsp; 96&nbsp;  36&nbsp; &nbsp; 32 S&nbsp; &nbsp;  0.0&nbsp; 0.0&nbsp;  0:00&nbsp;  0 klogd
&nbsp; 485 root&nbsp; &nbsp; &nbsp; 16&nbsp;  0&nbsp;  540&nbsp; 396&nbsp;  292 S&nbsp; &nbsp;  0.0&nbsp; 0.0&nbsp;  0:00&nbsp;  0 sshd
&nbsp; 496 root&nbsp; &nbsp; &nbsp; 22&nbsp;  0&nbsp;  244&nbsp; 128&nbsp;  124 S&nbsp; &nbsp;  0.0&nbsp; 0.0&nbsp;  0:00&nbsp;  0 xinetd
&nbsp; 505 root&nbsp; &nbsp; &nbsp; 15&nbsp;  0&nbsp;  172&nbsp;  88&nbsp; &nbsp; 84 S&nbsp; &nbsp;  0.0&nbsp; 0.0&nbsp;  0:00&nbsp;  0 vsftpd
&nbsp; 517 root&nbsp; &nbsp; &nbsp; 25&nbsp;  0&nbsp;  152&nbsp; &nbsp; 4&nbsp; &nbsp;  0 S&nbsp; &nbsp;  0.0&nbsp; 0.0&nbsp;  0:00&nbsp;  0 safe_mysqld
&nbsp; 561 root&nbsp; &nbsp; &nbsp; 15&nbsp;  0&nbsp;  192&nbsp; 172&nbsp;  120 S&nbsp; &nbsp;  0.0&nbsp; 0.0&nbsp;  0:00&nbsp;  0 crond
&nbsp; 570 root&nbsp; &nbsp; &nbsp; 25&nbsp;  0&nbsp;  152&nbsp;  52&nbsp; &nbsp; 48 S&nbsp; &nbsp;  0.0&nbsp; 0.0&nbsp;  0:00&nbsp;  0 saslauthd
&nbsp; 586 root&nbsp; &nbsp; &nbsp; 15&nbsp;  0 12144&nbsp; 11M&nbsp; 1372 S&nbsp; &nbsp;  0.0&nbsp; 2.4&nbsp;  0:00&nbsp;  0 mdmpd
&nbsp; 593 root&nbsp; &nbsp; &nbsp; 15&nbsp;  0&nbsp; &nbsp; 56&nbsp; &nbsp; 4&nbsp; &nbsp;  0 S&nbsp; &nbsp;  0.0&nbsp; 0.0&nbsp;  0:00&nbsp;  0 mingetty
&nbsp; 594 root&nbsp; &nbsp; &nbsp; 15&nbsp;  0&nbsp; &nbsp; 56&nbsp; &nbsp; 4&nbsp; &nbsp;  0 S&nbsp; &nbsp;  0.0&nbsp; 0.0&nbsp;  0:00&nbsp;  0 mingetty
&nbsp; 595 root&nbsp; &nbsp; &nbsp; 15&nbsp;  0&nbsp; &nbsp; 52&nbsp; &nbsp; 4&nbsp; &nbsp;  0 S&nbsp; &nbsp;  0.0&nbsp; 0.0&nbsp;  0:00&nbsp;  0 mingetty
&nbsp; 596 root&nbsp; &nbsp; &nbsp; 15&nbsp;  0&nbsp; &nbsp; 52&nbsp; &nbsp; 4&nbsp; &nbsp;  0 S&nbsp; &nbsp;  0.0&nbsp; 0.0&nbsp;  0:00&nbsp;  0 mingetty
&nbsp; 597 root&nbsp; &nbsp; &nbsp; 18&nbsp;  0&nbsp; &nbsp; 56&nbsp; &nbsp; 4&nbsp; &nbsp;  0 S&nbsp; &nbsp;  0.0&nbsp; 0.0&nbsp;  0:00&nbsp;  0 mingetty
&nbsp; 598 root&nbsp; &nbsp; &nbsp; 18&nbsp;  0&nbsp; &nbsp; 56&nbsp; &nbsp; 4&nbsp; &nbsp;  0 S&nbsp; &nbsp;  0.0&nbsp; 0.0&nbsp;  0:00&nbsp;  0 mingetty
&nbsp; 930 root&nbsp; &nbsp; &nbsp; 15&nbsp;  0&nbsp;  620&nbsp; 316&nbsp;  192 R&nbsp; &nbsp;  0.0&nbsp; 0.0&nbsp;  0:00&nbsp;  0 sshd
&nbsp; 935 root&nbsp; &nbsp; &nbsp; 15&nbsp;  0&nbsp;  680&nbsp; 616&nbsp;  440 S&nbsp; &nbsp;  0.0&nbsp; 0.1&nbsp;  0:00&nbsp;  0 bash
14066 root&nbsp; &nbsp; &nbsp; 15&nbsp;  0&nbsp; 1216 1216&nbsp;  916 R&nbsp; &nbsp;  0.0&nbsp; 0.2&nbsp;  0:00&nbsp;  0 top

그누보드 사용자인데 이거 무슨 문제인지..ㅡㅡ;; > 그누3질답

그누3질답

그누보드 사용자인데 이거 무슨 문제인지..ㅡㅡ;; 정보

본문

댓글 전체

회원로그인