View Single Post
  #4  
Old 20th December 2011, 13:28
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,784
Thanks: 840
Thanked 5,610 Times in 4,421 Posts
Default

Innodb is indeed faster when it comes to complex queries that use a lot of joins, but on the other side innodb uses a lot more ram. As ISPconfig dont use complex queries and does not require any of the innodb features, so it does not benefit from innodb and we decided to keep the RAM for the applications instead of wasting it for the controlpanel.

Quote:
I also thought that scripts were agnostic as far as the table engine being used? I've not come across any script which cared whether it was myISAM or InnoDB before, only an old one which used MyISAM indexes.
Thats almost always the case, but in some scenarios the engins seem to differ when it comes to inserting data into the table. I experienced that a operation might succeeed with myisam while it failed with innodb, maybe myisam is a bit more fault tolerant.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote