Magento

The following tables should be using the MyISAM engine, while the remaining tables should be using InnoDB:

catalogsearch_fulltext
log_customer     
log_quote
log_summary 
log_summary_type
log_url
log_url_info
log_visitor
log_visitor_info
oscommerce_orders
oscommerce_orders_products
oscommerce_orders_status_history
oscommerce_orders_total
paygate_authorizenet_debug
paypal_api_debug
product_alert_stock
sendfriend_log

Some of the above tables might not show up in your database depending on the version of Magento you’re running.

Also, if you have any extensions installed, please check with the developer to see what engine should be used for a particular table.