- 论坛徽章:
- 0
|
能不能说具体一点啊.这个线程是MYSQL自己启动的啊.数据库在UPDATE的时候速度很慢,还有另外一台服务器在远程调用这台数据库,速度也是很慢.一直查不出原因.我的my.cnf里面的配置是这样的
socket = /tmp/mysql.sock
skip-locking
#skip-innodb
skip-name-resolve
max_allowed_packet = 4M
table_cache = 512
sort_buffer_size = 32M
net_buffer_length = 8K
myisam_sort_buffer_size = 64M
max_connections=1024
wait_timeout=120
thread_concurrency = 4
thread_cache_size=100
tmp_table_size=80M
key_buffer_size = 400M
query_cache_size=128M
query_cache_limit=1M
query_cache_type=1
read_buffer_size=8M
read_rnd_buffer_size=768K
back_log=500
interactive_timeout=120
max_connect_error=30000
long_query_time=5
innodb_flush_log_at_trx_commit=0
两颗CPU,2G的内存.
执行show processlist;没有固定的进程在运行.多次执行显示的查询是不一样的啊.有SELECT,UPDATE的
下面是我的mysql_slow.log一部分日志.long_query_time=5
# Time: 060227 9:34:54
# User@Host: root[root] @ localhost []
# Query_time: 7 Lock_time: 1 Rows_sent: 0 Rows_examined: 0
update cdb_pay set pstate='2',outtime='2006-2-27',mempsw='******' where pcode='**********' and serv
erID='1001';
# Time: 060227 9:36:10
# User@Host: root[root] @ localhost []
# Query_time: 8 Lock_time: 1 Rows_sent: 0 Rows_examined: 0
update cdb_pay set pstate='2',outtime='2006-2-27',mempsw='******' where pcode=***********and serv
erID='1002';
# Time: 060227 9:37:05
# User@Host: root[root] @ localhost []
# Query_time: 8 Lock_time: 1 Rows_sent: 0 Rows_examined: 0
update cdb_pay set pstate='2',outtime='2006-2-27',mempsw='******' where pcode='***********' and serv
erID='1001';
# Time: 060227 9:38:58
# User@Host: root[root] @ localhost []
# Query_time: 7 Lock_time: 1 Rows_sent: 0 Rows_examined: 0
update cdb_pay set pdate='1141004330',mempsw='******',vartime='2006-2-27',unid='227',pstate='1' whe
re pcode='**********' and serverID='1001' limit 1;
# Time: 060227 9:39:12
# User@Host: root[root] @ localhost []
# Query_time: 7 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
update cdb_pay set pdate='1141004344',mempsw='******',vartime='2006-2-27',unid='227',pstate='1' whe
re pcode='***********' and serverID='1001' limit 1;
# Time: 060227 9:39:20
# User@Host: root[root] @ localhost []
# Query_time: 6 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
update cdb_pay set pstate='2',outtime='2006-2-27',mempsw='*****' where pcode='***********' and serv
erID='1001'; |
|