maria-discuss team mailing list archive

[Geunsik Lim <leemgs@xxxxxxxxx>]

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.