After some digging of information, I switches from InnoDb to MyISAM because I need to Full-text queries highly then insert/update process.
My conclusion:
1. Used MyISAM when your system is highly utilize for viewing and querying.
2. Used InnoDb when your system highly processing insert/update such as logging data or inserting raw data like track-and-trace system.
3. Used MyISAM if your application has the capability to roll-back or hold the data.
4. Used MyISAM if your data will grow beyond 1TB as at this point of time, query will cause problem for InnoDB.
References:
- http://www.thegeekstuff.com/2014/02/myisam-innodb-memory/
- http://dev.mysql.com/doc/refman/5.0/en/myisam-storage-engine.html
- http://dev.mysql.com/doc/refman/5.0/en/innodb-storage-engine.html
- http://tag1consulting.com/MySQL_Engines_MyISAM_vs_InnoDB#comment-115
- https://www.percona.com/blog/2007/01/08/innodb-vs-myisam-vs-falcon-benchmarks-part-1/
- http://www.rackspace.com/knowledge_center/article/mysql-engines-myisam-vs-innodb
- http://dba.stackexchange.com/questions/1/what-are-the-main-differences-between-innodb-and-myisam
- http://dba.stackexchange.com/questions/1/what-are-the-main-differences-between-innodb-and-myisam
- https://www.quora.com/How-are-deadlocks-resolved-in-Innodb-vs-MyISAM
1 comments:
Nice Information thank you for Sharing useful information. Great job.
App developer Malaysia
Post a Comment