Can i use some tables with InnoDB engine and some with MyIsam on my MySQL database? -

i read innodb better use on table lot's of insert records simultaneously. application gets 50 records per seconds. these tables should use innodb, right?

in other hand have tables used select, few updated or have few new insert. myisam faster select ? if it's case, better leave table myisam , innodb or should use tables same engine ?

my application searches lot on tables want pass in innodb. should ?

you can check these:

reasons use myisam:

• tables fast select-heavy loads
• table level locks limit scalability write intensive multi-user environments.
• smallest disk space consumption
• fulltext index
• merged , compressed tables.

reasons use innodb:

• acid transactions
• row level locking
• consistent reads – allows reach excellent read write concurrency.
• primary key clustering – gives excellent performance in cases.
• foreign key support.
• both index , data pages can cached.
• automatic crash recovery – in case mysql shutdown unclean innodb tables still
• recover consistent state- no check repair myisam may require. updates have pass through transactional engine in
  innodb, decreases - performance compared to
  non-transactional storage engines.

quoted here

and last part:

remember! it's ok mix table types in same database! in fact it's recommended , required. however, important note if having performance issues when joining 2 types, try converting 1 other , see if fixes it. issue not happen has been reported.

quoted here

i hope that's enough :d