16 reputation
1
bio website
location
age
visits member for 1 year, 11 months
seen Jun 4 '13 at 9:58

Oct
20
comment Select * from statement execute very slowly, innodb io read speed is low
I've resolve this question, it's because table fragments. after my optimizing the table, the table space shrinks from 18G to 12G and IO read rate is about 20~30M/s refer: mysqlperformanceblog.com/2008/05/01/…
Oct
12
comment Select * from statement execute very slowly, innodb io read speed is low
show full processlist: Id User Host db Command Time State Info 81 root localhost itms Query 101 Sending data select * from ap_statistic
Oct
12
awarded  Student
Oct
12
comment Select * from statement execute very slowly, innodb io read speed is low
server A storage is raid0 with 2 disks, server B storage is only 1 disk. I've done simple test on system IO, each one has at least 50M/s. and I alse restore server B's db to server A, the query is still very slow.
Oct
11
asked Select * from statement execute very slowly, innodb io read speed is low