NeDi Software Specific => Database => Topic started by: sjobergh on May 25, 2016, 01:02:26 AM
and it seems to work good, no table locks anymore and I think I gained about 30%-40% in speed/time when doing discovery
Only useful if you have parallel discovery sessions/tasks
Do you have a "manual" or any documentation on how you did the conversion?
Interesting indeed! I read about difference of the two, but never thought I'd affect it so much!
It was pretty easy, I just followed one of several instructions I found on the net
basically only one command per table
Before you alter the tables, stop all jobs that connected to database
ALTER TABLE tablename ENGINE=InnoDB;
When you are done with all tables you should edit "my.cnf" with InnoDB parameters that is adjusted for you hardware
You might have "fiddle" around with the different InnoDB parameters, some of them made my installation unusable but when taking them out it works again
I ended up with just these two rows
then you have to restart mysql engine,