MySQL can store data using a handful of different storage engines. Almost all installations of Open Dental use the MyISAM storage engine. For some large offices, MyISAM tables lock up for short periods of time when complex queries are being run (e.g. running the recall list). For example, you may notice that Open Dental is usually fast, but when you perform certain specific actions or run certain tools Open Dental locks up for a short period of time on all computers.
If you are experiencing such slowness:
- First make sure that you are on the latest version of Open Dental to ensure that the slowness is not due to any known bugs.
- Follow the steps on Troubleshooting Slowness.
- Bring the slowness issue to the attention of Open Dental support in case there is a slowness bug that needs to be fixed.
- As a last resort, consider switching the storage engine from MyISAM to InnoDb. The MyISAM storage engine locks at the table level and the InnoDb storage engine locks at the row level, so InnoDb does not run into locking slowness as often as MyISAM does.
Convert to InnoDb Storage Engine
These steps are for advanced technical users and will cause all databases within the database server to be converted to Innodb format. MySQL version 5.5 must already be installed. Make sure to review your Backup/restore strategy so that you know how to validate restored backups. It will probably involve a dump to text file instead of copying files. You will not be able to use Open Dental's built in Backup/Restore tool.
- Make certain that no users are currently using Open Dental.
- In the Main Menu, Tools, Database Maintenance. Click the Tools tab then run the Innodb tool to convert all tables in the database to InnoDb.
Your database tables will now all be in a single file rather than separate files inside a folder.