network profile
| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 7 months |
| seen | yesterday | |
| stats | profile views | 5 |
|
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 |
