0 like 0 dislike
231 views
Hi,

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

Can anyone help me?
asked Oct 25, 2017 in Education & Reference by Neha (690 points) | 231 views
    

2 Answers

0 like 0 dislike

[otrs@localhost bin]$ ./otrs.Console.pl Maint::Database::MySQL::InnoDBMigration
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.

[otrs@localhost bin]$ ./otrs.Console.pl Maint::Database::MySQL::InnoDBMigration --force

OUTPUT
Converting all database tables to InnoDB...
95 tables need to be converted.
Changing table acl to engine InnoDB...
Changing table aclsync to engine InnoDB...
Changing table article to engine InnoDB...
Changing table article
attachment to engine InnoDB...

AND to VERIFY

mysql> SELECT TABLE_NAME,  ENGINE FROM   information_schema.TABLES WHERE  TABLE_SCHEMA = 'otrs';

OUTPUT
+------------------------------+--------+
| TABLENAME | ENGINE |
+------------------------------+--------+
| acl | InnoDB |
| acl
sync | InnoDB |
| article | InnoDB |
| article_attachment | InnoDB |

answered Oct 25, 2017 by Krish (890 points)
0 like 0 dislike

Dont forget to modify my.cnf file

add line
default-storage-engine=InnoDB

answered Oct 25, 2017 by Sam (1,380 points)

Related questions

2 like 0 dislike
1 answer
asked Dec 5, 2017 in Computers & Internet by Simmi (510 points) | 91 views
0 like 0 dislike
1 answer
0 like 0 dislike
1 answer
2 like 0 dislike
1 answer
0 like 0 dislike
1 answer
0 like 0 dislike
2 answers
asked Oct 25, 2017 in Education & Reference by Krish (890 points) | 2,040 views
0 like 0 dislike
1 answer
1 like 0 dislike
1 answer
0 like 0 dislike
1 answer

Where your donation goes
Technology: We will utilize your donation for development, server maintenance and bandwidth management, etc for our site.

Employee and Projects: We have only 15 employees. They are involved in a wide sort of project works. Your valuable donation will definitely boost their work efficiency.

How can I earn points?
Awarded a Best Answer 10 points
Answer questions 10 points
Asking Question -20 points

Mathe Forum Schule und Studenten
1,164 questions
1,304 answers
275 comments
1,589 users