OTRS - Can we use innoDB instead of MyISAM
Moderator: crythias
-
- 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
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
I am using otrs5 and would like to use InnoDB instead of MyISAM because of table locking issue.
Can anyone help me?
Thanks,
Sunny
Re: OTRS - Can we use innoDB instead of MyISAM
Hi,
InnoDB is the preferred setting and works fine.
Florian
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.
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.
-
- 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
Hi Florian,
Thanks But how to convert all tables into innoDB
Thanks But how to convert all tables into innoDB
Re: OTRS - Can we use innoDB instead of MyISAM
Hi,
check documentation or your
command
Florian
check documentation or your
Code: Select all
/opt/otrs/bin/otrs.Console.pl
Code: Select all
Maint::Database::MySQL::InnoDBMigration - Convert all MySQL database tables to InnoDB.
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.
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.
-
- 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
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
> 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
-
- 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
Oh sorry I did a mistake ..It is done by doing --force..
Thanks
Thanks
-
- 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
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:
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:
Re: OTRS - Can we use innoDB instead of MyISAM
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
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
-
- 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
Set and it is working fine now..Thanks