How to increase wait_timeout and interactive_timeout on mysql_fdw?

[gferrette]

Hello!

Please, how do I increase wait_timeout and interactive_timeout in mysql_fdw?

Thanks in advance!

[surajkharage19]

Hi,

You need to set below GUC in postgresql.conf on PG/EPAS cluster:

mysql_fdw.wait_timeout=<timeout> mysql_fdw.interactive_timeout=<timeout>

OR set at session level in psql e.g: set mysql_fdw.wait_timeout=<timeout>; set mysql_fdw.interactive_timeout=<timeout>

Please let me know if that helps.

[gferrette]

Hello!

It works! Thank you very much!

[surajkharage19]

Glad to hear that your issue is resolved. Please let me know if you have further queries on this. If not, then can you please close this case?

[gferrette]

Sure!

Thanks!!