cancel
Showing results for 
Search instead for 
Did you mean: 

MySQL shutdown issue on Magento

MySQL shutdown issue on Magento

We have magento website

Our website some times it showing below error like

There has been an error processing your request Exception printing is disabled by default for security reasons. Error log record number: 855613014442

Based on our logs, it is showing that Mysql is going down as shown below

2019-06-24T04:44:49.542168Z 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.7.26' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) 2019-06-24T04:44:50.594943Z 0 [Note] InnoDB: Buffer pool(s) load completed at 190624 4:44:50 2019-06-24T04:45:11.103402Z 0 [Note] Giving 0 client threads a chance to die gracefully 2019-06-24T04:45:11.103429Z 0 [Note] Shutting down slave threads 2019-06-24T04:45:11.103438Z 0 [Note] Forcefully disconnecting 0 remaining clients 2019-06-24T04:45:11.103444Z 0 [Note] Event Scheduler: Purging the queue. 0 events 2019-06-24T04:45:11.103484Z 0 [Note] Binlog end.

We have increased innodb_buffer_pool_size but still i am facing same issue.

Can anyone has idea how to resolve this issue.

Thanks

1 REPLY 1

Re: MySQL shutdown issue on Magento

Hello @kanchi_prasad 

 

Can you please check below link

https://www.digitalocean.com/community/questions/mysql-server-stops-very-frequently

 

Hope it will help you.


Problem solved? Click Kudos & Accept as Solution!
Sunil Patel
Magento 2 Certified Professional Developer & Frontend Developer