-
Bug
-
Resolution: Done
-
Medium
-
None
-
None
-
None
timeouts were added per POLICY-24 that seem to be unnecessary (and probably not recommended) under the belief that the underlying pap libraries need it. These seems to be not the case, based on monitoring idle DB connections. I don't see persistent connections being idled for a long time that may require the reset of the timeout. If any, it is recommended to shorten the defaults. interactive_timeout is not necessary as I only think they apply to interactive sessions as the name indicates.
MariaDB [ecomp_sdk]> show full processlist;
------------------------------------------------------------------------------------------------
Id | User | Host | db | Command | Time | State | Info | Progress |
------------------------------------------------------------------------------------------------
44 | policy_user | pap.policy_default:50134 | ecomp_sdk | Sleep | 4 | NULL | 0.000 | |
46 | policy_user | brmsgw.policy_default:48765 | ecomp_sdk | Sleep | 0 | NULL | 0.000 | |
48 | policy_user | brmsgw.policy_default:48767 | ecomp_sdk | Sleep | 8 | NULL | 0.000 | |
52 | policy_user | pdp.policy_default:37703 | ecomp_sdk | Sleep | 4 | NULL | 0.000 | |
54 | policy_user | pap.policy_default:50160 | ecomp_sdk | Sleep | 3 | NULL | 0.000 | |
71 | policy_user | pdp.policy_default:37830 | ecomp_sdk | Sleep | 0 | NULL | 0.000 | |
72 | policy_user | pap.policy_default:50425 | ecomp_sdk | Sleep | 537 | NULL | 0.000 | |
73 | policy_user | pap.policy_default:50426 | ecomp_sdk | Sleep | 537 | NULL | 0.000 | |
74 | policy_user | pap.policy_default:50427 | ecomp_sdk | Sleep | 537 | NULL | 0.000 | |
75 | policy_user | pap.policy_default:50428 | ecomp_sdk | Sleep | 537 | NULL | 0.000 | |
76 | policy_user | pap.policy_default:50429 | ecomp_sdk | Sleep | 537 | NULL | 0.000 | |
78 | policy_user | localhost | ecomp_sdk | Query | 0 | init | show full processlist | 0.000 |
------------------------------------------------------------------------------------------------
12 rows in set (0.00 sec)
MariaDB [ecomp_sdk]>
MariaDB [ecomp_sdk]>
MariaDB [ecomp_sdk]> show full processlist;
------------------------------------------------------------------------------------------------
Id | User | Host | db | Command | Time | State | Info | Progress |
------------------------------------------------------------------------------------------------
44 | policy_user | pap.policy_default:50134 | ecomp_sdk | Sleep | 2 | NULL | 0.000 | |
46 | policy_user | brmsgw.policy_default:48765 | ecomp_sdk | Sleep | 3 | NULL | 0.000 | |
48 | policy_user | brmsgw.policy_default:48767 | ecomp_sdk | Sleep | 26 | NULL | 0.000 | |
52 | policy_user | pdp.policy_default:37703 | ecomp_sdk | Sleep | 2 | NULL | 0.000 | |
54 | policy_user | pap.policy_default:50160 | ecomp_sdk | Sleep | 1 | NULL | 0.000 | |
71 | policy_user | pdp.policy_default:37830 | ecomp_sdk | Sleep | 1 | NULL | 0.000 | |
72 | policy_user | pap.policy_default:50425 | ecomp_sdk | Sleep | 555 | NULL | 0.000 | |
73 | policy_user | pap.policy_default:50426 | ecomp_sdk | Sleep | 555 | NULL | 0.000 | |
74 | policy_user | pap.policy_default:50427 | ecomp_sdk | Sleep | 555 | NULL | 0.000 | |
75 | policy_user | pap.policy_default:50428 | ecomp_sdk | Sleep | 555 | NULL | 0.000 | |
76 | policy_user | pap.policy_default:50429 | ecomp_sdk | Sleep | 555 | NULL | 0.000 | |
78 | policy_user | localhost | ecomp_sdk | Query | 0 | init | show full processlist | 0.000 |
------------------------------------------------------------------------------------------------
12 rows in set (0.00 sec)
MariaDB [ecomp_sdk]>
MariaDB [ecomp_sdk]>
MariaDB [ecomp_sdk]> show full processlist;
------------------------------------------------------------------------------------------------
Id | User | Host | db | Command | Time | State | Info | Progress |
------------------------------------------------------------------------------------------------
44 | policy_user | pap.policy_default:50134 | ecomp_sdk | Sleep | 2 | NULL | 0.000 | |
46 | policy_user | brmsgw.policy_default:48765 | ecomp_sdk | Sleep | 3 | NULL | 0.000 | |
48 | policy_user | brmsgw.policy_default:48767 | ecomp_sdk | Sleep | 26 | NULL | 0.000 | |
52 | policy_user | pdp.policy_default:37703 | ecomp_sdk | Sleep | 2 | NULL | 0.000 | |
54 | policy_user | pap.policy_default:50160 | ecomp_sdk | Sleep | 0 | NULL | 0.000 | |
71 | policy_user | pdp.policy_default:37830 | ecomp_sdk | Sleep | 1 | NULL | 0.000 | |
72 | policy_user | pap.policy_default:50425 | ecomp_sdk | Sleep | 585 | NULL | 0.000 | |
73 | policy_user | pap.policy_default:50426 | ecomp_sdk | Sleep | 585 | NULL | 0.000 | |
74 | policy_user | pap.policy_default:50427 | ecomp_sdk | Sleep | 585 | NULL | 0.000 | |
75 | policy_user | pap.policy_default:50428 | ecomp_sdk | Sleep | 585 | NULL | 0.000 | |
76 | policy_user | pap.policy_default:50429 | ecomp_sdk | Sleep | 585 | NULL | 0.000 | |
78 | policy_user | localhost | ecomp_sdk | Query | 0 | init | show full processlist | 0.000 |
------------------------------------------------------------------------------------------------
12 rows in set (0.00 sec)
MariaDB [ecomp_sdk]> show full processlist;
------------------------------------------------------------------------------------------------
Id | User | Host | db | Command | Time | State | Info | Progress |
------------------------------------------------------------------------------------------------
44 | policy_user | pap.policy_default:50134 | ecomp_sdk | Sleep | 2 | NULL | 0.000 | |
46 | policy_user | brmsgw.policy_default:48765 | ecomp_sdk | Sleep | 3 | NULL | 0.000 | |
48 | policy_user | brmsgw.policy_default:48767 | ecomp_sdk | Sleep | 11 | NULL | 0.000 | |
52 | policy_user | pdp.policy_default:37703 | ecomp_sdk | Sleep | 2 | NULL | 0.000 | |
54 | policy_user | pap.policy_default:50160 | ecomp_sdk | Sleep | 0 | NULL | 0.000 | |
71 | policy_user | pdp.policy_default:37830 | ecomp_sdk | Sleep | 3 | NULL | 0.000 | |
78 | policy_user | localhost | ecomp_sdk | Query | 0 | init | show full processlist | 0.000 |
------------------------------------------------------------------------------------------------