Usually people are talking about big databases but we have a very small database (~40MB, ~20 tables) where all tables are using MyISAM engine. My beginner question is: does it make sense to change to InnoDB engine? Current ratio between writes and reads from mysqlreport (last 80 days):
__ Questions _________________________________________________________Total 891.67M 128.0/s DMS 685.86M 98.4/s %Total: 76.92 Com 111.21M 16.0/s 12.47 COM_QUIT 97.60M 14.0/s 10.95 -Unknown 3.00M 0.4/s 0.34Slow 10 s 1 0.0/s 0.00 %DMS: 0.00 Log: OFFDMS 685.86M 98.4/s 76.92 SELECT 373.76M 53.6/s 41.92 54.50 REPLACE 202.12M 29.0/s 22.67 29.47 UPDATE 107.40M 15.4/s 12.04 15.66 DELETE 2.42M 0.3/s 0.27 0.35 INSERT 169.72k 0.0/s 0.02 0.02Com 111.21M 16.0/s 12.47 set_option 102.20M 14.7/s 11.46 stmt_prepar 2.99M 0.4/s 0.34 stmt_execut 2.99M 0.4/s 0.34
and table lock status:
__ Table Locks _________________________________________________________Waited 9.49M 1.4/s %Total: 0.79Immediate 1.19G 170.1/s
We are only interested about performance (speed) and reliability is not so important. Because there are lot of read and writes InnoDB should in theory be good if I understand correctly differences between MyISAM and InnoDB. But does the engine really matter in such a small database?