Sunday, July 31, 2011

Compare MYSQL5.1 MYISAM and INNODB performance

Use the synbench to test mysql5.1 MYISAM and INNODB performance.get following result:

oltp-table-size=1000000
num-threads=16
max-requests=500

For insert:

MYISAM:

Creating table 'test_isam'...
Creating 1000000 records in table 'test_isam'...
real    0m12.516s
user    0m0.602s
sys     0m0.041s


INODB:

Creating table 'test_inno'...
Creating 1000000 records in table 'test_inno'...
real    0m16.746s
user    0m0.611s
sys     0m0.043s


For Query:













The innodb perfromance more better than myisam when we data query,but MYISAM will better than innodb  when we only insert the data.

No comments:

Post a Comment