maria-discuss team mailing list archive

[Geunsik Lim <leemgs@xxxxxxxxx>]

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 <leemgs@xxxxxxxxx> 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
--