kuailewangzi1212

摘要： --1、查进程select request_session_id spid,OBJECT_NAME(resource_associated_entity_id) tableNamefrom sys.dm_tran_locks where resource_type='OBJECT'order by 阅读全文

摘要： --导入大文件50G文件到mysql1、修改配置innodb_flush_log_at_trx_commit=0 2、导入时的注意事项set autocommit=1;show variables like 'autocommit';set names utf8;source f://file.sq 阅读全文

摘要： --初次迁出svn checkout https://101.67.160.144:83/svn/DywxApp --username XXX --password xxx DywxApp --更新全部 cd dywxappsvn update --提交 svn add test.js svn co 阅读全文

摘要： mac上docker常见问题 1、the Docker daemon at tcp://192.168.0.107:2375. Is the docker daemon running unset DOCKER_HOST unset DOCKER_TLS_VERIFY unset DOCKER_TL 阅读全文

摘要： docker run -p 3306:3306 --name mysql -v $PWD/conf:/etc/mysql/conf.d -v $PWD/logs:/logs -v $PWD/data:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=soft -d mysq 阅读全文

摘要： 1、制作docker-compose.yml 2、安装 阅读全文

摘要： apt install docker.io 配置加速器、私有仓库地址 mkdir -p /etc/dockertee /etc/docker/daemon.json <<-'EOF'{ "registry-mirrors": ["https://plapxez2.mirror.aliyuncs.co 阅读全文

摘要： git常用git clone https://github.com/kuailewangzi1212/WeApp-Demo.git 查看令牌docker swarm join-token manager节点升级managerdocker node promote docker-118节点降级为wor 阅读全文

摘要： --创建用户CREATE USER 'test'@'%' IDENTIFIED BY 'test'; --授权GRANT ALL ON *.* TO 'test'@'%'; --修改密码SET PASSWORD FOR 'test'@'%' = PASSWORD('test'); 阅读全文

摘要： SELECT t.NAME AS TableName, s.Name AS SchemaName, p.rows AS RowCounts, SUM(a.total_pages) * 8 AS TotalSpaceKB, CAST(ROUND(((SUM(a.total_pages) * 8) / 阅读全文