Setting up MYSQL Server - Which DB Usage role? "Multifunctional" or "Transactional"??

When setting up MYSQL on a new server, which database role should be chosen? "Multifunctional Database", "Transactional Database" or "Non-Transactional Database"? I would like to know which one would be the optimal setup for on online shopping cart application such as OSCommerce and X-cart.

Thanks
-Tuan

Multifunctional Database: This option enables both the InnoDB and MyISAM storage engines and divides resources evenly between the two. This option is recommended for users who use both storage engines on a regular basis.

Transactional Database Only: This option enables both the InnoDB and MyISAM storage engines, but dedicates most server resources to the InnoDB storage engine. This option is recommended for users who use InnoDB almost exclusively and make only minimal use of MyISAM.

Non-Transactional Database Only: This option disables the InnoDB storage engine completely and dedicates all server resources to the MyISAM storage engine. This option is recommended for users who do not use InnoDB.

 

 

 

 

Top