Differences

This shows you the differences between two versions of the page.

--- unraid:dockers:mysql [2022/12/10 17:12] – [Adjust Max Connections] dirk
+++ unraid:dockers:mysql [2023/09/22 08:23] (current) – [Adjust Max Connections] dirk
@@ Line 41: / Line 41: @@
   * <code>show processlist;</code>
   * <code>show variables like '%timeout';</code>
-  * copy my.cnf from /etc folder in the docker to the server for editing <code>docker cp mysql:/etc/my.cnf .</code>
+  * Either use vs-code setup to edit my.cnf from /etc folder OR copy my.cnf from /etc folder in the docker to the server for editing <code>docker cp mysql:/etc/my.cnf .</code>
-  * add following lines to my.cnf <code> wait_timeout = 300
+  * add following lines to my.cnf (put them just under the [mysqld] line... putting them under [client] is no bueno!<code>[mysqld]
- interactive_timeout = 300</code>
+wait_timeout = 600
+interactive_timeout = 600
+max_connections = 500</code>
   * copy my.cnf back to docker <code>cp my.cnf mysql:/etc/my.cnf</code>
   * restart docker

brimble.com