InnoDb
InnoDb
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
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
You'll be interested in reading at least the first paragraph from:
http://opendental.com/manual/mysqlinnodb.html
The best thing about a boolean is even if you are wrong, you are only off by a bit.
Jason Salmon
Open Dental Software
http://www.opendental.com
Jason Salmon
Open Dental Software
http://www.opendental.com
Re: InnoDb
isn't the last section of that page obsolete with the buttons now built into database maint that allow for conversion?
Re: InnoDb
No. If the my.ini file isn't updated like it says then innodb will not be possible in the first place.
The best thing about a boolean is even if you are wrong, you are only off by a bit.
Jason Salmon
Open Dental Software
http://www.opendental.com
Jason Salmon
Open Dental Software
http://www.opendental.com
Re: InnoDb
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..