InnoDb

For complex topics that regular users would not be interested in. For power users and database administrators.
Post Reply
User avatar
drtech
Posts: 1647
Joined: Wed Jun 20, 2007 8:44 am
Location: Springfield, MO
Contact:

InnoDb

Post by drtech » Wed Apr 23, 2014 10:39 am

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.
David Fuchs
Dentist - Springfield, MO
Smile Dental http://www.887-smile.com

User avatar
jsalmon
Posts: 1551
Joined: Tue Nov 30, 2010 12:33 pm
Contact:

Re: InnoDb

Post by jsalmon » Wed Apr 23, 2014 11:46 am

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
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

User avatar
drtech
Posts: 1647
Joined: Wed Jun 20, 2007 8:44 am
Location: Springfield, MO
Contact:

Re: InnoDb

Post by drtech » Mon Apr 28, 2014 1:57 pm

isn't the last section of that page obsolete with the buttons now built into database maint that allow for conversion?
David Fuchs
Dentist - Springfield, MO
Smile Dental http://www.887-smile.com

User avatar
jsalmon
Posts: 1551
Joined: Tue Nov 30, 2010 12:33 pm
Contact:

Re: InnoDb

Post by jsalmon » Mon Apr 28, 2014 3:14 pm

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

User avatar
drtech
Posts: 1647
Joined: Wed Jun 20, 2007 8:44 am
Location: Springfield, MO
Contact:

Re: InnoDb

Post by drtech » Mon Apr 28, 2014 8:02 pm

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..
David Fuchs
Dentist - Springfield, MO
Smile Dental http://www.887-smile.com

Post Reply