Click here to Skip to main content
15,880,469 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi,

I have a virtual machine which is having Windows (Windows Server 2012 R2 Datacenter) with (2 vcpus, 4 GiB memory) in azure cloud installed with MYSQL Server free edition.

i am experiencing an issue where MYSQL Service is getting stopped frequently, please help in this regard.

i saw .err log file in MYSQL and it is having message as below:

2020-12-30T05:34:53.027640Z 0 [System] [MY-013105] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: Normal shutdown.

sometimes it would have restarted and sometime it is not restarted but endup with stop state.

settings in .ini file:
innodb_log_buffer_size=1M
innodb_buffer_pool_size=1G
group_concat_max_len = 4294967295
innodb_buffer_pool_instances=8

What I have tried:

I have tried restarting the service option in services.msc on mysqlservice if it stops as a plan B, but not able to find out why the service is getting stopped and what needs to be done.
Posted
Updated 5-Jan-21 6:16am
v2
Comments
CHill60 6-Jan-21 5:37am    
If you are running this in the free Azure tier it will disconnect regularly, by design. If you are paying for this service then contact Azure.
Make sure you manage your connections and if using a connection pool, return connections as soon as you've finished with them.
You also haven't defined "frequently" which might help

1 solution

I don't use MySQL so I couldn't tell you what's wrong.

But, the first place I'd look for any other information is the Application Event Log. Launch Eventvwr to get to it.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900