Differences

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

--- unraid:dockers:mysql [2022/08/25 21:40] – [Load Football pool] 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 34: / Line 37: @@
 UPDATE games SET vscore = NULL where year = 2021;
 UPDATE games SET hscore = NULL where year = 2021;</code>
+===== Adjust Max Connections =====
+  * <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