0 like 0 dislike
397 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 (570 points) | 397 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 (800 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,290 points)

Related questions

0 like 0 dislike
1 answer
asked Jan 18 in Education & Reference by Marc (2,430 points) | 36 views
2 like 0 dislike
1 answer
asked Dec 5, 2017 in Computers & Internet by Simmi (510 points) | 161 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 (800 points) | 3,415 views
0 like 0 dislike
1 answer
1 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,186 questions
1,324 answers
277 comments
1,638 users