0 like 0 dislike
275 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 (670 points) | 275 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 (880 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,370 points)

Related questions

2 like 0 dislike
1 answer
asked Dec 5, 2017 in Computers & Internet by Simmi (510 points) | 113 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 (880 points) | 2,484 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,169 questions
1,309 answers
276 comments
1,601 users