"Check that mysqld is running" message

[smirzaoe (Shabbir Ali)]

We upgraded OpenEMR from 4.2.0 to 5.0.0.6 on production. First we did this on test. Since the upgrade, EMR is working ok, however now and then it is giving this message “Check that mysqld is running” and when we refresh that tab within the EMR, it is back to normal. This is happening many times and this is happening when accessing demographics or fee sheet or any other place. Seems like this is happening more often where the internet connection could be little slow.

I was trying to find if there is any setting we have for SQL timeout or SQL wait time that could be causing this problem. Is it the logging?

Appreciate any help.

[stephenwaite]

hi @smirzaoe, one of the big changes from 4.x to 5.0 was switching to innodb storage engine for mysql.

InnoDB vs. MyISAM

sunsetsystems wrote on Tuesday, June 07, 2016: Brady, I expect your performance differences are related to available memory and MySQL server settings. This may be helpful: Oleg seems to have a fix for globals save performance, so if that tests well then I suggest committing that concurrently with the InnoDB support. Rod http://www.sunsetsystems.com/

[smirzaoe (Shabbir Ali)]

Hi @stephenwaite

Thanks! Your response was helpful. MySql had default number of connections 151 and I increased to 1000. Issue seems to be resolved. I still have to do other performance tuning though.

[PauloKanda (Paulo Afonso Medeiros Kanda)]

I took a recent backup and changed my.ini max connections to 1000

as in

How to set max connections in mysql permanently?

for me it worked removing the “check if mysql is running” problem.
best,