From: Alan Knowles <alan@roojs.com>
Date: Mon, 31 Oct 2016 03:44:47 +0000 (+0800)
Subject: UpdateDatabase/MysqlEngineCharset.php
X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=4fe8b23a82e5d21f1f7ff9d8cfb1e4206e67d0bb

UpdateDatabase/MysqlEngineCharset.php
---

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');