OTRS - Can we use innoDB instead of MyISAM

Moderator: crythias

Post Reply
sunny
Znuny newbie
Posts: 68
Joined: 30 Aug 2011, 13:14
Znuny Version: 5.0.22
Real Name: Sunny
Contact:

OTRS - Can we use innoDB instead of MyISAM

Post by 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
Znuny guru
Posts: 3224
Joined: 08 Jul 2010, 22:25
Znuny Version: x.x.x
Real Name: Florian

Re: OTRS - Can we use innoDB instead of MyISAM

Post by wurzel »

Hi,

InnoDB is the preferred setting and works fine.

Florian
OTRS 8 SILVER (Prod)
OTRS 8 auf Debian 11 (Test)
Znuny 7.x latest version testing auf Debian 11

-- Ich beantworte keine Forums-Fragen PN - No PN please

I won't answer to unfriendly users any more. A greeting and regards are just polite.
sunny
Znuny newbie
Posts: 68
Joined: 30 Aug 2011, 13:14
Znuny Version: 5.0.22
Real Name: Sunny
Contact:

Re: OTRS - Can we use innoDB instead of MyISAM

Post by sunny »

Hi Florian,

Thanks But how to convert all tables into innoDB
wurzel
Znuny guru
Posts: 3224
Joined: 08 Jul 2010, 22:25
Znuny Version: x.x.x
Real Name: Florian

Re: OTRS - Can we use innoDB instead of MyISAM

Post by 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
OTRS 8 SILVER (Prod)
OTRS 8 auf Debian 11 (Test)
Znuny 7.x latest version testing auf Debian 11

-- Ich beantworte keine Forums-Fragen PN - No PN please

I won't answer to unfriendly users any more. A greeting and regards are just polite.
sunny
Znuny newbie
Posts: 68
Joined: 30 Aug 2011, 13:14
Znuny Version: 5.0.22
Real Name: Sunny
Contact:

Re: OTRS - Can we use innoDB instead of MyISAM

Post by 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
Znuny newbie
Posts: 68
Joined: 30 Aug 2011, 13:14
Znuny Version: 5.0.22
Real Name: Sunny
Contact:

Re: OTRS - Can we use innoDB instead of MyISAM

Post by sunny »

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


Thanks
sunny
Znuny newbie
Posts: 68
Joined: 30 Aug 2011, 13:14
Znuny Version: 5.0.22
Real Name: Sunny
Contact:

Re: OTRS - Can we use innoDB instead of MyISAM

Post by 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
Znuny guru
Posts: 15019
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: OTRS - Can we use innoDB instead of MyISAM

Post by jojo »

set your database to use InnoDB per default (your DBA should be able to solve this issue)
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
sunny
Znuny newbie
Posts: 68
Joined: 30 Aug 2011, 13:14
Znuny Version: 5.0.22
Real Name: Sunny
Contact:

Re: OTRS - Can we use innoDB instead of MyISAM

Post by sunny »

Set and it is working fine now..Thanks
Post Reply