Performance Comparison Between MySQL MyISAM and InnoDB for querying large data volumes

There is a MySQL database with more than 1.1 billion records because of its working relationship. I thought that the query performance of the MyISAM engine would exceed InnoDB. I tried it these two days,

There is a MySQL database with more than 1.1 billion records because of its working relationship. I thought that the query performance of the MyISAM engine would exceed InnoDB. I tried it these two days,

There is a MySQL database with more than 1.1 billion records because of its working relationship. I thought that the query performance of the MyISAM engine would exceed InnoDB. I tried it these two days, but because the data volume is too large, the conversion engine took several days.

Test environment:

DELL 860 server, CPU Xeon3210, memory 8 GB

MySQL 5.5.13 has two instances installed, with ports 3306 (InnoDB) and 3307 (MyISAM)

MySQL client tool HeidiSQL 6.0.0.3603, query statement:

Select count (1) from mytable where update_datetime> '2017-01-01'

Update_datetime fields are indexed.

The query time is as follows (1,132,191,947 records in total ):

InnoDB: 763.672 seconds

MyISAM: 4094.621 seconds

InnoDB is more than 4 times faster than MyISAM

In the future, we will have the opportunity to test the performance of ms SQL and Oracle.

,