为什么InnoDB和Myisam相差这么大? 请mysql高手指点!
而且用InnoDB CPU Wait%过多,Disk I/O Busy 达99%如下
│ Disk I/O ──/proc/diskstats────mostly in KB/s─────Warning:contains duplicates─│
DiskName BusyRead WriteKB|0
|25 |50
|75 100|│
│sda 99%0.0529.8|WWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWW>│
│sda1 0%0.00.0|>
test@phptest:/etc/mysql$ mysqlslap -a --concurrency=50,100 --number-of-queries 1000 --iterations=5 --engine=myisam,innodb --debug-info -uroot -ppassword
Benchmark
Running for engine myisam
Average number of seconds to run all queries: 0.107 seconds
Minimum number of seconds to run all queries: 0.098 seconds
Maximum number of seconds to run all queries: 0.112 seconds
Number of clients running queries: 50
Average number of queries per client: 20
Benchmark
Running for engine myisam
Average number of seconds to run all queries: 0.116 seconds
Minimum number of seconds to run all queries: 0.110 seconds
Maximum number of seconds to run all queries: 0.122 seconds
Number of clients running queries: 100
Average number of queries per client: 10
Benchmark
Running for engine innodb
Average number of seconds to run all queries: 5.171 seconds
Minimum number of seconds to run all queries: 4.977 seconds
Maximum number of seconds to run all queries: 5.328 seconds
Number of clients running queries: 50
Average number of queries per client: 20
Benchmark
Running for engine innodb
Average number of seconds to run all queries: 4.665 seconds
Minimum number of seconds to run all queries: 4.318 seconds
Maximum number of seconds to run all queries: 4.950 seconds
Number of clients running queries: 100
Average number of queries per client: 10
User time 1.06, System time 0.76
Maximum resident set size 6212, Integral resident set size 0
Non-physical pagefaults 20990, Physical pagefaults 0, Swaps 0
Blocks in 0 out 0, Messages in 0 out 0, Signals 0
Voluntary context switches 69300, Involuntary context switches 3978
|