突然发现mysql占用很大内存,不知道是怎么回事?应该怎么解决呢?各位高手请帮帮忙啊,我安装的lamp PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
7931 nobody 18 0 148m 47m 5412 S 99.9 3.7 108:10.33 mysqld
6416 squid 15 0 189m 184m 2292 S 0.3 14.6 10:13.56 squid
7953 root 16 0 2408 1024 804 S 0.3 0.1 0:38.33 top
1 root 15 0 2156 644 552 S 0.0 0.0 0:05.55 init
7931 nobody 18 0 148m 47m 5412 S 99.9 3.7 108:10.33 mysqld
6416 squid 15 0 189m 184m 2292 S 0.3 14.6 10:13.56 squid
7953 root 16 0 2408 1024 804 S 0.3 0.1 0:38.33 top
1 root 15 0 2156 644 552 S 0.0 0.0 0:05.55 init
不好意思,笔误,是cpu,不是内存
*************************** 1. row ***************************
Id: 1499
User: sunqing
Host: 192.168.15.74:57101
db: smmdb_test
Command: Sleep
Time: 445
State:
Info: NULL
*************************** 2. row ***************************
Id: 1500
User: sunqing
Host: 192.168.15.74:57102
db: NULL
Command: Sleep
Time: 1454
State:
Info: NULL
*************************** 3. row ***************************
Id: 1519
User: zhaojuan
Host: localhost
db: NULL
Command: Query
Time: 0
State: NULL
Info: show processlist
*************************** 4. row ***************************
Id: 1523
User: luochao
Host: 192.168.15.7:55385
db: smmdb_test
Command: Query
Time: 81
State: Copying to tmp table发现有两条是sleep的
把这个停掉后看看CPU使用率。