摘要: pip install virtualenv virtualenv --version virtualenv my_name virtualenv -p /usr/bin/python3 virtualenv_name source virtualenv_name/bin/activate pip 阅读全文
posted @ 2022-05-26 11:08 sam_wang10 阅读(18) 评论(0) 推荐(0) 编辑
摘要: CREATE RESOURCE UNIT unit1 MAX_CPU 1, MAX_MEMORY '1G', MAX_IOPS 128,MAX_DISK_SIZE '10G', MAX_SESSION_NUM 64, MIN_CPU=1, MIN_MEMORY='1G', MIN_IOPS=128; 阅读全文
posted @ 2022-01-26 16:05 sam_wang10 阅读(31) 评论(0) 推荐(0) 编辑
摘要: sudo rpm -ivh obproxy-3.2.0-1.el7.x86_64.rpm sudo rpm -ivh libobclient-2.0.0-2.el7.x86_64.rpmsudo rpm -ivh obclient-2.0.0-2.el7.x86_64.rpm cd /home/ad 阅读全文
posted @ 2022-01-25 15:22 sam_wang10 阅读(241) 评论(0) 推荐(0) 编辑
摘要: checkpoint [seconds] DBCC DROPCLEANBUFFERS #TABLES WITHOUT PRIMARY KEY USE incrLifeproNew; SELECT SCHEMA_NAME(schema_id) AS [Schema], name AS [Table] 阅读全文
posted @ 2021-12-22 15:02 sam_wang10 阅读(43) 评论(0) 推荐(0) 编辑
摘要: events select date_format(from_unixtime(clock),'%Y-%m-%d')time,name,count(*) from events where name like '%frequent%' and value=0 group by date_format 阅读全文
posted @ 2021-11-23 09:26 sam_wang10 阅读(36) 评论(0) 推荐(0) 编辑
摘要: vim /etc/odbcinst.ini 创建监控账号 use master EXEC sp_addlogin 'zbx_monitor', 'Pas5W@0rd', 'master' USE [master] GO GRANT VIEW ANY DATABASE TO [zbx_monitor] 阅读全文
posted @ 2021-11-18 15:12 sam_wang10 阅读(22) 评论(0) 推荐(0) 编辑
摘要: Top 50 CPU Consuming Queries in SQL Server Select st.[text] AS [Query Text], wt.last_execution_time AS [Last Execution Time], wt.execution_count AS [E 阅读全文
posted @ 2021-11-05 10:57 sam_wang10 阅读(38) 评论(0) 推荐(0) 编辑
摘要: https://www.zabbix.com/integrations/nginx#3rd_party https://nginx.org/en/docs/http/ngx_http_stub_status_module.html 阅读全文
posted @ 2021-10-14 15:46 sam_wang10 阅读(17) 评论(0) 推荐(0) 编辑
摘要: https://www.windows-commandline.com/windows-for-loop-examples/ https://www.windows-commandline.com/cmd-commands/ https://ss64.com/nt/for.html for /F % 阅读全文
posted @ 2021-08-25 10:37 sam_wang10 阅读(32) 评论(0) 推荐(0) 编辑
摘要: Recover a lost SA password https://www.sqlshack.com/recover-lost-sa-password/ Use [dbname]gosp_change_users_login 'update_one', 'username', 'username' 阅读全文
posted @ 2021-07-21 09:11 sam_wang10 阅读(38) 评论(0) 推荐(0) 编辑