I'm most curious as to what your simultaneous connections are doing; Can you run the following query in MySQL Workbench when it's grinding to a halt and provide us the results?
Also, maybe you simply just have that many workstations needing to connect and need to increase the amount of connections that MySQL will allow by adding the following line to your my.ini.
Note: this will instantly (well, after you restart the MySQL service) eat up more RAM (for MySQL v5.6+) so if your server doesn't have enough memory you might consider a smaller value.
drawab wrote:The reason why MySQL server is 5.6 is because somewhere in a year or so back i downloaded and installed using TrialDownload 15.1.26 which had MySQL 5.6 and it unknowing to me i upgraded the entire setup to MySQL 5.6 - I think im now stuck with this or should I roll back using the later 17.2.43 that is available on your site today
We rolled out v5.6 because it is much more efficient than v5.5 and we still plan on doing so. However, they changed how they store some data types and it was causing problems with our conversion department and with users trying to connect to old databases that were in the v5.5 format (not possible BTW). You might need to run the "mysql_upgrade.exe" within a command prompt which can be found in bin folder of the MySQL Server 5.6 folder if you haven't already.
Note: this will upgrade all databases on your server, not just the Open Dental database.