On 01/12/17 00:22, Josip Deanovic wrote: > On Wednesday 2017-01-11 17:43:42 Phil Stracchino wrote: > [...] >> The truth is, MyISAM pretty much sucks and you shouldn't be using it in >> production any more. Remember that MyISAM is a 20-year-old storage >> engine, one of whose primary design criteria was that it needed to work >> *acceptably well* on a small shared server, at a time when a "large" >> server might have a whole 32MB of RAM. The default sizes of some >> individual MySQL *BUFFERS* are larger than that. > > There are applications that require MyISAM and the Innodb is not an > option at all because critical parts of the application just doesn't > work with innodb and if the application is proprietary software you > can't do much about it but continue to use MyISAM. > > People usually ignore such cases and insist that there is absolutely > no reason to use MyISAM.
Most applications that "require" MyISAM "require" it for no good reason, or depend on features that have historically been supported only by MyISAM but are now supported in InnoDB in current MySQL releases. It bears case-by-case examination. One of the most common reasons to "require" MyISAM is fulltext search, but the honest truth is that if you're making heavy use of fulltext search in MySQL you should probably be using an external fulltext engine such as Sphinx, SOLR, or Lucene for it anyway. You might be shocked to find how many proprietary application that "require" MyISAM do so simply because "but we've always done it that way". The fact remains, the MyISAM storage engine is well on its way to being removed from MySQL, and some awareness on the matter is in order. MySQL 5.7 already allows it to be completely disabled. -- Phil Stracchino Babylon Communications ph...@caerllewys.net p...@co.ordinate.org Landline: 603.293.8485 ------------------------------------------------------------------------------ Developer Access Program for Intel Xeon Phi Processors Access to Intel Xeon Phi processor-based developer platforms. With one year of Intel Parallel Studio XE. Training and support from Colfax. Order your platform today. http://sdm.link/xeonphi _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
