6

mysql my.cnf shows InnoDB as disabled "skip-innodb". Should I enable it for large Magento DB?

view full story
linux-howto

http://serverfault.com – The MySQL my.cnf file on our centOS server shows skip-innodb as present. We are looking to optimize my.cnf for a large Magento database. The server has 12GB of memory and 5 Xeon Processors. Would it be best to comment/remove the skip-innodb line? If would there be anything else that would need amending in the file? Current my.cnf file: [mysqld] skip-innodb ft_min_word_len=3 query_cache_limit = 4M query_cache_size = 16M ## 32MB for every 1GB of RAM query_cache_type = 1 max_user_connections = 50 max_connections = 50 interactive_timeout = 300 wait_timeout = 200 (HowTos)