[MDEV-32490] performance differs a lot between INNODB and MYISAM Created: 2023-10-17 Updated: 2023-10-17 Resolved: 2023-10-17 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Storage Engine - InnoDB, Storage Engine - MyISAM |
| Affects Version/s: | 10.11.5 |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Major |
| Reporter: | csfuzz | Assignee: | Unassigned |
| Resolution: | Not a Bug | Votes: | 1 |
| Labels: | None | ||
| Attachments: |
WX20231017-170059@2x.png
WX20231017-170122@2x.png
create&insert.sql
select1.sql
select2.sql
|
| Description |
|
Using the same SQL statements to create tables, insert data and select data on INNODB and MYISAM respectively, the select performance differs by 100%. The create&insert&select SQLs and performance statistics are in the attachment. |
| Comments |
| Comment by Sergei Golubchik [ 2023-10-17 ] |
|
yes, such performance difference is possible and is not generally a bug |