View Issue Details

This bug affects 1 person(s).
 4
IDProjectCategoryView StatusLast Update
12252Feature requestsInstallationpublic2021-11-26 07:41
Reporterarborepom Assigned Toc_schmitz  
PrioritynoneSeverityfeature 
Status closedResolutionfixed 
Summary12252: problem with InnoDB
Description

To be able to choose -for the installation- the engine for Mysql (MyISAM, InnoDB) : it would be very appreciable ...

TagsNo tags attached.
Bug heat4
Story point estimate
Users affected %

Users monitoring this issue

There are no users monitoring this issue.

Activities

borisbaesler

borisbaesler

2017-10-18 15:56

reporter   ~44722

I'm with aborepom. We're using MariaDB in a Cloud Foundry environment. The Database is no longer supporting MyISAM. Therefore, I needed to "hack" /application/core/db/MysqlSchema.php.

I replaced

public function createTable($table, $columns, $options = null) {
if(empty($options))
{
$options='ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci';
}
$result = parent::createTable($table, $columns, $options);
return $result;
}

with

public function createTable($table, $columns, $options = null) {
if(empty($options))
{
$options='ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci';
}
$result = parent::createTable($table, $columns, $options);
return $result;
}

A configurable solution would be preferable to that (on so many levels). Maybe, we can add an element to the db-array (in application/config/config.php?

'components' => array(
    'db' => array(
        'connectionString' => 'mysql:host=localhost;port=3306;dbname=baeslerc_lime298;',
        'emulatePrepare' => true,
        'username' => 'baeslerc_lime298',
        'password' => '@]qF7!pS9o.dl-Fl!9',
        'charset' => 'utf8mb4',
        'tablePrefix' => 'lsfr_',
                    'defaultEngine' => 'InnoDB'
    ),

If empty -> use MyISAM, if set, use the defined engine (in my case InnoDB).

c_schmitz

c_schmitz

2021-11-26 07:41

administrator   ~67579

Since version 4 you can select the default table format during installation.

Issue History

Date Modified Username Field Change
2017-04-03 16:45 arborepom New Issue
2017-10-18 15:56 borisbaesler Note Added: 44722
2021-11-26 07:41 c_schmitz Assigned To => c_schmitz
2021-11-26 07:41 c_schmitz Status new => closed
2021-11-26 07:41 c_schmitz Resolution open => fixed
2021-11-26 07:41 c_schmitz Note Added: 67579
2021-11-26 07:41 c_schmitz Bug heat 2 => 4