- 论坛徽章:
- 0
|
开始速度还行,这几天又比较慢了,有时快有时慢,白天比晚上慢!
我是删除了RPM安装包,重装了mysql-max-4.1.20-pc-linux-gnu-i686-icc-glibc23.tar.gz
/etc/my.cnf 是默认设置!
# The MySQL server
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-locking
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
#skip-networking
# Replication Master Server (default)
# binary logging is required for replication
log-bin
# required unique id between 1 and 2^32 - 1
# defaults to 1 if master-host is not set
# but will not function as a master if omitted
server-id = 1
执行top ,发现有时CPU使用率很高,load average有时达到15以上,
16:12:30 up 8 days, 4:44, 1 user, load average: 7.26, 6.46, 5.51
42 processes: 41 sleeping, 1 running, 0 zombie, 0 stopped
CPU states: cpu user nice system irq softirq iowait idle
total 58.7% 0.0% 41.1% 0.0% 0.0% 0.0% 0.0%
cpu00 54.4% 0.0% 45.4% 0.0% 0.2% 0.0% 0.0%
cpu01 59.8% 0.0% 40.2% 0.0% 0.0% 0.0% 0.0%
cpu02 54.8% 0.0% 45.2% 0.0% 0.0% 0.0% 0.0%
cpu03 66.0% 0.0% 33.8% 0.0% 0.0% 0.0% 0.2%
Mem: 2061612k av, 1904056k used, 157556k free, 0k shrd, 177932k buff
1275156k actv, 78272k in_d, 30704k in_c
Swap: 2047976k av, 0k used, 2047976k free 1362140k cached
PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND
3428 mysql 21 0 38544 37M 4508 S 24.9 1.8 401:31 3 mysqld
执行ps -aux 也发现MYSQL占用CPU 很高;
root 3395 0.0 0.0 4248 1196 ? S 13:57 0:00 /bin/sh ./bin/mysqld_safe --datadir=/var/mysql/data --pid-fil
mysql 3428 99.9 1.9 130276 39204 ? S 13:57 408:34 /var/mysql/bin/mysqld --defaults-extra-file=/var/mysql/data/
另外这台机器有天夜里突然挂了,第二天检查是电源坏了,原来的系统盘也有问题,我是换了电源、换了个旧的SCSI硬盘重装了系统,但现在出现速度慢的现象!查不到是什么原因!
机器配置:intel se7501br2主板,双xeon2.4CPU,2G内存,希捷36G SCSI硬盘(是从其他坏的机器上拆下来的,没有问题)! |
|