Page 1 of 1
InnoDb
Posted: Wed Apr 23, 2014 10:39 am
by drtech
I know there is a tool in database maint to convert to and from InnoDb. What is Open Dental's current position on the database type. Still don't want people to use InnoDb and use MyISAM or has that changed? And if not, what is the reasoning? I don't know if it actually makes a difference, but I read where InnoDb is better at utilizing multiple CPU cores is the main reason I am interested, as well as the supposed better failure recovery.
Re: InnoDb
Posted: Wed Apr 23, 2014 11:46 am
by jsalmon
Our current position is use MyISAM mainly because it's easy for us to grab a copy of your database. Otherwise the process is practically impossible.
You'll be interested in reading at least the first paragraph from:
http://opendental.com/manual/mysqlinnodb.html
Re: InnoDb
Posted: Mon Apr 28, 2014 1:57 pm
by drtech
isn't the last section of that page obsolete with the buttons now built into database maint that allow for conversion?
Re: InnoDb
Posted: Mon Apr 28, 2014 3:14 pm
by jsalmon
No. If the my.ini file isn't updated like it says then innodb will not be possible in the first place.
Re: InnoDb
Posted: Mon Apr 28, 2014 8:02 pm
by drtech
ah...for Windows users...my.ini...that's right, I do change the my.cnf file on linux..., or just select which database default type with webmin..