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/conf.d/mysqldump.cnf mytizen$sudo vi /etc/mysql/mariadb.conf.d/50-server.cnf mytizen$sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf ----------- content ------------------------------------- # * Fine Tuning # max_allowed_packet: from 16M to 128M max_allowed_packet = 128M # timeout: from 28800 (8h) to 2592000 (30days) wait_timeout = 2592000 interactive_timeout = 2592000 ----------------------------------------------------------- The below is how we check the values if the modified valued is applied to Mariadb server. MariaDB [(none)]> MariaDB [(none)]> SELECT @@global.wait_timeout, @@global.interactive_timeout, @@session.wait_timeout, @@session.interactive_timeout; +-----------------------+------------------------------+------------------------+-------------------------------+ | @@global.wait_timeout | @@global.interactive_timeout | @@session.wait_timeout | @@session.interactive_timeout | +-----------------------+------------------------------+------------------------+-------------------------------+ | 2592000 | 2592000 | 2592000 | 2592000 | +-----------------------+------------------------------+------------------------+-------------------------------+ 1 row in set (0.00 sec) MariaDB [(none)]> MariaDB [(none)]> MariaDB [(none)]> show variables like 'max_allowed_packet'; +--------------------+-----------+ | Variable_name | Value | +--------------------+-----------+ | max_allowed_packet | 134217728 | +--------------------+-----------+ 1 row in set (0.00 sec) MariaDB [(none)]> On Tue, Apr 11, 2017 at 3:34 PM, Geunsik Lim <lee...@gmail.com> wrote: > 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 like the below > content? > > > u164.04$ mytop -u root -p*** [enter] > > MySQL on localhost (10.0.29) load 0.24 0.26 0.27 1/563 18515 > up 0+23:47:16 [15:22:38] > Queries: 5.2k qps: 0 Slow: 0.0 Se/In/Up/De(%): > 07/00/00/00 > Sorts: 0 qps now: 1 Slow qps: 0.0 Threads: 3 ( 1/ 1) > 00/00/00/00 > Key Efficiency: 100.0% Bps in/out: 1.7/233.2 Now in/out: 21.3/ 2.9k > > Id User Host/IP DB Time Cmd > State Query > -- ---- ------- -- ---- --- ----- > ---------- > 781 root localhost api_develo 28048 Sleep > > 751 tic localhost:56454 pdk 4406 Sleep > > 1084 root localhost 0 Query > init show full processlist > > BRs, > Geunsik Lim. > -- http://leemgs.fedorapeople.org Don't try to avoid pain if you fail. If you decided to face the challenges in life, you can gain a lot by giving your best. Cheolsang Jeong's Book & life --
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
