From 4fe8b23a82e5d21f1f7ff9d8cfb1e4206e67d0bb Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Mon, 31 Oct 2016 11:44:47 +0800 Subject: [PATCH] UpdateDatabase/MysqlEngineCharset.php --- UpdateDatabase/MysqlEngineCharset.php | 11 +++++++++++ 1 file changed, 11 insertions(+) diff --git a/UpdateDatabase/MysqlEngineCharset.php b/UpdateDatabase/MysqlEngineCharset.php index d4d772b1..20a1dc73 100644 --- a/UpdateDatabase/MysqlEngineCharset.php +++ b/UpdateDatabase/MysqlEngineCharset.php @@ -96,7 +96,18 @@ class Pman_Core_UpdateDatabase_MysqlEngineCharset { } function updateEngine() { + $db = DB_DataObject::factory('core_enum'); + $db->query("show variables like 'innodb_file_per_table'"); + $db->fetch(); + if ($db->Value == 'OFF') { + die("Error: set innodb_file_per_table = 1 in my.cnf\n\n"); + } + // get a list of table views... + // innodb in single files is far more efficient that MYD or one big innodb file. + // first check if database is using this format. + + $db = DB_DataObject::factory('core_enum')->getDatabaseConnection(); $views = $db->getListOf( 'views'); -- 2.39.2