docker run -itd --name mysql8 -p 3307:3306 -e MYSQL_ROOT_PASSWORD=r6kEwqWU9!v3 -v D:/MySQL/docker_mysql:/var/lib/mysql mysql:8.0.28-oracle docker run -itd --name mysql82 -p 3312:3306 -e MYSQL_ROOT_PASSWORD=r6kEwqWU9!v3 mysql:8.0.28-oracle mysqldump -uroot -pr6kEwqWU9!v3 -P3307 --databases qmt_stocks_whole >d:/qmt_stocks_whole.sql # version order 1 docker run -itd --name mysql8 -p 3307:3306 -e MYSQL_ROOT_PASSWORD=r6kEwqWU9!v3 -v C:/docker_mysql/stock_data:/var/lib/mysql -v C:/docker_mysql/config/mysql.cnf:/etc/my.cnf daocloud.io/library/mysql:8.0.21 docker run -itd --name mysql8033 -p 3308:3306 -e MYSQL_ROOT_PASSWORD=r6kEwqWU9!v3 -v C:/docker_mysql/0833:/var/lib/mysql -v C:/docker_mysql/conf:/etc/mysql mysql:8.0.33 docker run -itd --name mysql8033 -p 3308:3306 -e MYSQL_ROOT_PASSWORD=r6kEwqWU9!v3 -v C:/docker_mysql/mysql.cnf:/etc/my.cnf mysql:8.0.33-debian docker run -itd -p 3307:3306 --name mysql8033 -e character-set-server=utf8mb4 --privileged=true --restart unless-stopped -v C:/docker_mysql/stock_data:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=r6kEwqWU9!v3 -d mysql:8.0.33 --skip-log-bin --disable-log-bin --lower_case_table_names=1 docker run -itd -p 3307:3306 --name mysql8033 -e character-set-server=utf8mb4 --privileged=true --restart unless-stopped -v C:/docker_mysql/stock_data:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=r6kEwqWU9!v3 -d mysql:8.0.33 --lower_case_table_names=1 --skip-log-bin --disable-log-bin docker run --restart=always --log-opt max-size=40960m --log-opt max-file=2 -p 6379:6379 --name redis -v C:/docker_redis:/data --network stk-net -d redislabs/redisearch:2.8.3 redis-server --appendonly yes 20230515 docker run -itd -p 3307:3306 --name mysql8033 --privileged=true --restart unless-stopped -v C:/docker_mysql/stock_data:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=r6kEwqWU9!v3 -d mysql:8.0.33 docker run -itd -p 3309:3306 --name mysqltest -e character-set-server=utf8mb4 --privileged=true --restart unless-stopped -e MYSQL_ROOT_PASSWORD=r6kEwqWU9!v3 -d mysql:8.0.33 --skip-log-bin --disable-log-bin --log-error=/var/lib/mysql/err.log 20230626 OMMAND docker pull nvcr.io/nvidia/rapidsai/rapidsai-core:23.06-cuda11.8-runtime-ubuntu22.04-py3.10 docker run -d --name cudf --gpus all -it --shm-size=1g --ulimit memlock=-1 --ulimit stack=67108864 --restart unless-stopped --network stk-net -p 8888:8888 -p 8787:8787 -p 8786:8786 -p 8722:22 nvcr.io/nvidia/rapidsai/rapidsai-core:23.06-cuda11.8-runtime-ubuntu22.04-py3.10 20230706 docker run --name tidb -d -v C:/docker_tidb:/tmp/tidb --privileged=true --restart unless-stopped -p 3308:4000 -p 10080:10080 --network stk-net pingcap/tidb:latest docker run --name pgsql -d -v C:/docker_pgsql:/var/lib/postgresql --privileged=true --restart unless-stopped -p 3309:5432 -e POSTGRES_PASSWORD='r6kEwqWU9!v3' --network stk-net postgres:13 docker run --name tidb -d -v C:/docker_tidb:/tmp/tidb --privileged=true --restart unless-stopped -p 3308:4000 -p 10080:10080 --network stk-net pingcap/tidb:latest # For advice on how to change settings please see # http://dev.mysql.com/doc/refman/8.0/en/server-configuration-defaults.html [mysqld] # # Remove leading # and set to the amount of RAM for the most important data # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%. # innodb_buffer_pool_size = 128M # # Remove leading # to turn on a very important data integrity option: logging # changes to the binary log between backups. # log_bin # # Remove leading # to set options mainly useful for reporting servers. # The server defaults are faster for transactions and fast SELECTs. # Adjust sizes as needed, experiment to find the optimal values. # join_buffer_size = 128M # sort_buffer_size = 2M # read_rnd_buffer_size = 2M # Remove leading # to revert to previous value for default_authentication_plugin, # this will increase compatibility with older clients. For background, see: # https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_default_authentication_plugin # default-authentication-plugin=mysql_native_password skip-log-bin disable-log-bin skip-host-cache skip-name-resolve datadir=/var/lib/mysql socket=/var/run/mysqld/mysqld.sock secure-file-priv=/var/lib/mysql-files user=mysql max_connections=10000 max_user_connections=5000 character-set-server=utf8mb4 thread_stack=4096k innodb_log_file_size=200M pid-file=/var/run/mysqld/mysqld.pid [client] socket=/var/run/mysqld/mysqld.sock character-set-server=utf8mb4 !includedir /etc/mysql/conf.d/ # For advice on how to change settings please see # http://dev.mysql.com/doc/refman/8.0/en/server-configuration-defaults.html [mysqld] # # Remove leading # and set to the amount of RAM for the most important data # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%. # innodb_buffer_pool_size = 128M # # Remove leading # to turn on a very important data integrity option: logging # changes to the binary log between backups. # log_bin # # Remove leading # to set options mainly useful for reporting servers. # The server defaults are faster for transactions and fast SELECTs. # Adjust sizes as needed, experiment to find the optimal values. # join_buffer_size = 128M # sort_buffer_size = 2M # read_rnd_buffer_size = 2M # Remove leading # to revert to previous value for default_authentication_plugin, # this will increase compatibility with older clients. For background, see: # https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_default_authentication_plugin # default-authentication-plugin=mysql_native_password skip-host-cache skip-name-resolve datadir=/var/lib/mysql socket=/var/run/mysqld/mysqld.sock secure-file-priv=/var/lib/mysql-files log_error=/var/lib/mysql/error.log user=mysql max_connections=2000 max_user_connections=1000 max_connect_errors=1000000 thread_cache_size=300 server-id = 1 character-set-server = utf8mb4 pid-file=/var/run/mysqld/mysqld.pid [client] socket=/var/run/mysqld/mysqld.sock !includedir /etc/mysql/conf.d/