MySQL/MariaDB - InnoDB vs MyISAM

konfuzion · Post by **konfuzion** » Mon Nov 13, 2023 7:53 am

I noticed after executing the demo2024.sql, only 2 tables are myISAM. userlevelpermissions and userlevel
Is it ok to just leave it as myISAM or should convert to InnoDB? What is the reason for keeping it as myISAM?

cars - InnoDB
*othertables* - InnoDB
suppliers - InnoDB
tasks - InnoDB
trademarks - InnoDB
userlevelpermissions - myISAM
userlevel - myISAM

mobhar · Post by **mobhar** » Mon Nov 13, 2023 9:33 am

You may Google "mysql myisam vs innodb" for more info.

arbei · Post by **arbei** » Mon Nov 13, 2023 9:55 am

You better convert them to InnoDB also.

konfuzion · Post by **konfuzion** » Mon Nov 13, 2023 10:07 am

yes, will convert all to InnoDB and maybe time to update the demo2024 sql script and change it to InnoDB as well

konfuzion · Post by **konfuzion** » Tue Nov 14, 2023 12:35 pm

I created my tables in mariadb as InnoDB

With debug on and just entering a LIST page, why does it display: SHOW TABLE STATUS WHERE Engine = 'MyISAM' ?
Where can I make the change from MyISAM to InnoDB?

[DEBUG ON]
sql: SHOW TABLE STATUS WHERE Engine = 'MyISAM' AND Name = 'customers', executionMS: 0.0055088996887207

sql: SELECT COUNT(*) FROM customers, executionMS: 0.00053691864013672

sql: SELECT * FROM customers LIMIT 20, executionMS: 0.00035810470581055

I noticed if I click on ORDERS and then click back to CUSTOMERS then that MyISAM line disappears

[DEBUG ON]
sql: SELECT COUNT(*) FROM customers, executionMS: 0.00053691864013672

sql: SELECT * FROM customers LIMIT 20, executionMS: 0.00035810470581055

arbei · Post by **arbei** » Tue Nov 14, 2023 1:08 pm

PHPMaker will check if the table is InnoDB (i.e. Engine <> 'MyISAM') to determine if the table supports transaction, and each table will only be checked once per session. You do not need to change anything at all.