- 论坛徽章:
- 0
|
我有台服务器,1G Ram,双至强CPU,只运行了mysql,可当人访问多时,系统就运转不过来了,以下是一些信息,请各位高手指点一下,谢谢
(我用的是Redhat7.0,采用自带的mysql,其中有个表,约有300M,是不是这个表太大了?还是内存不够用了?我现在是用这各方法启动mysql的:
safe_mysqld safe_mysqld -O key_buffer=512k -O sort_buffer=100k -O record_buffer=100k )
[root@db /root]# pstree
init-+-a.out
|-crond
|-kflushd
|-klogd
|-kpiod
|-kswapd
|-kupdate
|-mdrecoveryd
|-6*[mingetty]
|-safe_mysqld---mysqld---mysqld---51*[mysqld]
|-syslogd
`-xinetd---in.telnetd---login---bash---su---bash---pstree
[root@db /root]# top
9:08am up 12 days, 21:25, 1 user, load average: 4.58, 3.01, 2.56
76 processes: 70 sleeping, 6 running, 0 zombie, 0 stopped
CPU0 states: 47.0% user, 52.0% system, 0.0% nice, 0.0% idle
CPU1 states: 41.0% user, 58.0% system, 0.0% nice, 0.0% idle
Mem: 906420K av, 810612K used, 95808K free, 8748K shrd, 449424K buff
Swap: 265032K av, 1188K used, 263844K free 319552K cached
PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND
15397 mysql 14 0 12004 11M 2028 R 49.4 1.3 0:06 mysqld
15475 mysql 7 0 12004 11M 2028 R 33.9 1.3 0:03 mysqld
15550 mysql 9 0 12004 11M 2028 R 31.0 1.3 0:01 mysqld
15429 mysql 5 0 12004 11M 2028 R 30.0 1.3 0:15 mysqld
15667 mysql 7 0 12004 11M 2028 S 26.1 1.3 0:01 mysqld
15552 mysql 6 0 12004 11M 2028 R 25.2 1.3 0:01 mysqld
15670 root 3 0 1044 1044 816 R 1.9 0.1 0:00 top
1 root 0 0 116 76 52 S 0.0 0.0 0:26 init
2 root 0 0 0 0 0 SW 0.0 0.0 0:08 kflushd
3 root 0 0 0 0 0 SW 0.0 0.0 2:27 kupdate
4 root 0 0 0 0 0 SW 0.0 0.0 0:00 kpiod
5 root 0 0 0 0 0 SW 0.0 0.0 0:04 kswapd
6 root -20 -20 0 0 0 SW< 0.0 0.0 0:00 mdrecoveryd
312 root 0 0 228 168 120 S 0.0 0.0 0:09 syslogd
322 root 0 0 388 0 0 SW 0.0 0.0 0:00 klogd
348 root 0 0 644 552 460 S 0.0 0.0 0:00 xinetd
383 root 0 0 180 120 76 S 0.0 0.0 0:02 crond
405 root 0 0 60 0 0 SW 0.0 0.0 0:00 a.out
412 root 0 0 68 0 0 SW 0.0 0.0 0:00 mingetty
413 root 0 0 68 0 0 SW 0.0 0.0 0:00 mingetty
414 root 0 0 68 0 0 SW 0.0 0.0 0:00 mingetty
415 root 0 0 68 0 0 SW 0.0 0.0 0:00 mingetty
416 root 0 0 68 0 0 SW 0.0 0.0 0:00 mingetty
487 root 0 0 68 0 0 SW 0.0 0.0 0:00 mingetty
15357 root 0 0 980 980 812 S 0.0 0.1 0:00 safe_mysqld
15370 mysql 0 0 12004 11M 2028 S 0.0 1.3 0:00 mysqld
15372 mysql 2 0 12004 11M 2028 S 0.0 1.3 0:00 mysqld
15373 mysql 0 0 12004 11M 2028 S 0.0 1.3 0:00 mysqld
15377 mysql 0 0 12004 11M 2028 S 0.0 1.3 0:01 mysqld
15380 mysql 0 0 12004 11M 2028 S 0.0 1.3 0:20 mysqld
15383 mysql 0 0 12004 11M 2028 S 0.0 1.3 0:05 mysqld
[root@db /root]# free
total used free shared buffers cached
Mem: 906420 809384 97036 8280 449424 319548
-/+ buffers/cache: 40412 866008
Swap: 265032 1188 263844 |
|