Good day everyone, We are trying to install the 'ESET Enterprise Inspector' on a server, after installing mysql and changing parameters according to
these
requirements, when we try to start the mysql service, the progress bar goes to end (takes two minutes) and it says "the service did not respond to the start or control request in a timely fashion" and it is stuck in starting status.
The server has 32G of ram and we use
innodb_buffer_pool_size=26G
and
innodb_log_file_size=13G
as the parameters.
I've attached the my.ini file also. also the 'D11W19EEI01.err' file is empty.
Does anyone know why the service doesn't start? Thanks in advance.
my.ini.txt
Open the properties of your MySQL service and and copy the highlighted "Service Name:" at the top of the properties window. This will likely be
mysql57
or
mysql8
Open an administrative command prompt and issue the following command:
sc query
ServiceName
Replace
ServiceName
with the name you identified in step one. Like: sc query mysql57
You should see that the service is still starting. Its not uncommon that the MySQL service will take a long time to start. It is allocating memory and hard drive space.
If the service is never starting, check how much free space is on your hard drives. If none of the above works or helps, please ensure you gather the logs Marcos requested before replying.
I don't have access to the logs right now, but it shouldn't matter, should it? we had this problem even before installing
EDR
. one time we got lucky and the service was installed, so we immediately installed
EDR
. since then the mysql80 service stops from time to time. this time the service was stopped and it couldn't start again. and we have installed 2
EDR
servers and both times we had this problem with mysql.
Open the properties of your MySQL service and and copy the highlighted "Service Name:" at the top of the properties window. This will likely be
mysql57
or
mysql8
Open an administrative command prompt and issue the following command:
sc query
ServiceName
Replace
ServiceName
with the name you identified in step one. Like: sc query mysql57
You should see that the service is still starting. Its not uncommon that the MySQL service will take a long time to start. It is allocating memory and hard drive space.