Differences

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

--- unraid:dockers:mysql [2022/10/23 19:20] – dirk
+++ unraid:dockers:mysql [2023/09/22 08:23] (current) – [Adjust Max Connections] dirk
@@ Line 21: / Line 21: @@
   * User standard SQL commands to import databases from back up, allow privileges, etc.
   * See [[unraid:virtual:ubuntu20.04#install_mysql_if_not_using_a_docker|Install MySql]] section of installing ubuntu pages for most commands.  write access is not needed as that feature was removed by changing the way the NCAA pool temp stores the data.
+===== Connect =====
+<code>docker exec -it mysql bash</code>
 ===== Load Football pool =====
@@ Line 38: / Line 41: @@
   * <code>show processlist;</code>
   * <code>show variables like '%timeout';</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 (put them just under the [mysqld] line... putting them under [client] is no bueno!<code>[mysqld]
+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