I recently installed the embedded videos plugin and noticed upon inspecting my database that it had created a MyISAM table.

I had a look in the source and see the hard coded MyISAM engine selection:

    // create table
  $query = '
CREATE TABLE IF NOT EXISTS `' . $this->table . '` (
  `picture_id` mediumint(8) NOT NULL,
  `url` varchar(255) DEFAULT NULL,
  `type` varchar(64) NOT NULL,
  `video_id` varchar(128) NOT NULL,
  `width` smallint(9) DEFAULT NULL,
  `height` smallint(9) DEFAULT NULL,
  `autoplay` tinyint(1) DEFAULT NULL,
  `embed` text DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8
;';
    pwg_query($query);

Innodb has been the default storage engine for MySQL since 2010, perhaps you could consider removing the engine definition and allow the default storage engine to be used?

Fortunately I discovered this before I had started using the plugin. MyISAM is rather unreliable when using clustering software like Galera.

Last edited by philb (2014-07-22 18:57:00)