diff options
author | Joas Schilling <coding@schilljs.com> | 2020-12-11 11:14:43 +0300 |
---|---|---|
committer | backportbot[bot] <backportbot[bot]@users.noreply.github.com> | 2020-12-14 10:34:47 +0300 |
commit | 6814c0f7f37e5374d9e279827b5a77a36dfde269 (patch) | |
tree | 15b54819834069a229dbd959b60416e49d3a16a9 | |
parent | 2de129beef12833e7b64b0ae0e9bd911ff064e27 (diff) |
Fix MySQL database size calculation
Signed-off-by: Joas Schilling <coding@schilljs.com>
-rw-r--r-- | lib/DatabaseStatistics.php | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/lib/DatabaseStatistics.php b/lib/DatabaseStatistics.php index afdd039..a955f7f 100644 --- a/lib/DatabaseStatistics.php +++ b/lib/DatabaseStatistics.php @@ -95,12 +95,13 @@ class DatabaseStatistics { // This code is heavily influenced by a similar routine in phpMyAdmin 2.2.0 switch ($this->config->getSystemValue('dbtype')) { case 'mysql': + $mysqlEngine = ['MyISAM', 'InnoDB', 'Aria']; $db_name = $this->config->getSystemValue('dbname'); $sql = 'SHOW TABLE STATUS FROM `' . $db_name . '`'; $result = $this->connection->executeQuery($sql); $database_size = 0; while ($row = $result->fetch()) { - if ((isset($row['Type']) && $row['Type'] !== 'MRG_MyISAM') || (isset($row['Engine']) && ($row['Engine'] === 'MyISAM' || $row['Engine'] === 'InnoDB'))) { + if (isset($row['Engine']) && in_array($row['Engine'], $mysqlEngine)) { $database_size += $row['Data_length'] + $row['Index_length']; } } |