Recently, I have often been getting the "Error:MySQL server has gone away"
message
after I enabled the multiple-user access in front web service.
Here is logs.
. . . Upper Omission . . .
2017-04-10 21:15:22.881 [INFO][socketio.js] socket disconnect
2017-04-10 21:15:23.858 [INFO][socketio.js
For reference, We are running web-based front service
with nodejs package + pm2 (http://pm2.keymetrics.io/) on Ubuntu 16.04.1
server.
It seems that this issue results from the too big packet size and too long
waiting time
between mariadb server and our nodejs-based web-service.
Any hints (or Any
On 11/04/17 15:15, Geunsik Lim wrote:
> For reference, We are running web-based front service
> with nodejs package + pm2 (http://pm2.keymetrics.io/) on Ubuntu 16.04.1
> server.
>
> It seems that this issue results from the too big packet size and too
> long waiting time
> between mariadb serve
Thank you for telling me the webpage. I have got the more appropriate
method thanks to you. :)
On Tue, Apr 11, 2017 at 2:48 PM, Daniel Black
wrote:
>
>
> On 11/04/17 15:15, Geunsik Lim wrote:
> > For reference, We are running web-based front service
> > with nodejs package + pm2 (http://pm2.keym
I have summarized a solution after finding out some hints by running
"mytop" command and digging a related source code of mariadb server.
I have started running an existing our web service with the below two
solutions for aging test.
* EVALUATION ENVIRONMENT:
--
4 hours is passed. The web-based service is okay with "wait_timeout=8hours"
and "max_allowed_packet=100MB".
I am planning to execute aging test for 3 days at least.
BTW, Can we check inactivity time (e.g., wait_timeout) that MariaDB waits
before it will be close a connection with "mytop" command l
Finally, I am using the below setting file to avoid "Error: MySQL server
has gone away" message.
I have not been getting the message for 3 days (as an aging test).
Here is the related configuration files that have to be modified for Ubuntu
16.04.1 & Mariadb Server 10.0.
mytizen$sudo vi /etc/mysql/
7 matches
Mail list logo