OTRS - Can we use innoDB instead of MyISAM

[sunny]

Hi,

I am using otrs5 and would like to use InnoDB instead of MyISAM because of table locking issue.

Can anyone help me?


Thanks,
Sunny

[wurzel]

Hi,

InnoDB is the preferred setting and works fine.

Florian

[sunny]

Hi Florian,

Thanks But how to convert all tables into innoDB

[wurzel]

Hi,

check documentation or your

Code: Select all

/opt/otrs/bin/otrs.Console.pl 

command

Code: Select all

 Maint::Database::MySQL::InnoDBMigration  - Convert all MySQL database tables to InnoDB.

Florian

[sunny]

I have done but it is still showing MyISAM

> Checking for tables that need to be converted to InnoDB...
95 tables need to be converted.
You can re-run this script with --force to start the migration.
This operation can take a long time.


mysql> SELECT TABLE_NAME,
-> ENGINE
-> FROM information_schema.TABLES
-> WHERE TABLE_SCHEMA = 'otrs';
+------------------------------+--------+
| TABLE_NAME | ENGINE |
+------------------------------+--------+
| acl | MyISAM |
| acl_sync | MyISAM |
| article | MyISAM |

Please suggest

[sunny]

Oh sorry I did a mistake ..It is done by doing --force..


Thanks

[sunny]

Now i got into another problem

I was checking the DB connection and it is showing the below error

Trying to connect to database 'DBI:mysql:database=otrs;host=127.0.0.1' with user 'otrs'...
Connection successful.
Error: Your storage engine is MyISAM.
These tables use a different storage engine:

[jojo]

set your database to use InnoDB per default (your DBA should be able to solve this issue)

[sunny]

Set and it is working fine now..Thanks