안녕하세요? 하이랜더 입니다.
CentOS 5.5 Linux 이며 MySQL 의 show status; 명령어로 본 결과 중 이상하다고 생각되는 부분만 추려서 올려 봅니다.
고수분들께서 보시기에 어떠신지요?
지금 요 근래에 이 서버가 많이 느려졌거든요?
시스템 전체를 리부팅 해야 하는지, MySQL 만 재기동 하면 될런지 고민중입니다.
Aborted_connects 46990
Connections 16992633
Created_tmp_files 65995
Key_read_requests 2053960964442
Key_reads 945264
Key_write_requests 330572991
Key_writes 215017086
Open_files 1480
Open_table_definitions 256
Open_tables 512
Opened_files 42009734
Queries 757849787
Questions 16
Slow_launch_threads 41
Table_locks_immediate 1390562813
Table_locks_waited 584641
Threads_created 16992632
Uptime 100458855
Uptime_since_flush_status 100458855
참고로 다음은 top 명령어 결과 입니다.
Tasks: 162 total, 2 running, 160 sleeping, 0 stopped, 0 zombie
Cpu0 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu1 : 3.3%us, 0.3%sy, 0.0%ni, 96.3%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu2 : 3.3%us, 3.3%sy, 0.0%ni, 93.0%id, 0.3%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu3 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu4 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu5 : 72.8%us, 27.2%sy, 0.0%ni, 0.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu6 : 0.0%us, 0.0%sy, 0.0%ni, 99.7%id, 0.3%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu7 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 3106912k total, 1322392k used, 1784520k free, 28852k buffers
Swap: 5144872k total, 1145760k used, 3999112k free, 764772k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
3222 avahi 25 0 2804 504 456 R 99.9 0.0 30374:56 avahi-daemon
15741 nobody 17 0 52184 16m 2972 S 6.3 0.5 0:01.08 httpd
3124 mysql 15 0 1177m 278m 3168 S 3.7 9.2 662044:04 mysqld
1 root 15 0 2160 392 368 S 0.0 0.0 0:02.42 init
2 root RT -5 0 0 0 S 0.0 0.0 0:09.76 migration/0
답변 주시면 감사하겠습니다.
|