Skip to content

Instantly share code, notes, and snippets.

@huang4207100
huang4207100 / readme.py
Created December 3, 2019 08:22
[python3 excel插入图片] excel中插入图片流 #python #excel
from io import BytesIO
# 从Python 2或3之一导入urlopen()
try:
from urllib.request import urlopen
except ImportError:
from urllib2 import urlopen
import xlsxwriter
@huang4207100
huang4207100 / readme.go
Created November 15, 2019 12:28
[go] empty structs #go #structs
package main
import(
"fmt"
"time"
)
func main(){
done := make(chan struct{})
go func(){
@huang4207100
huang4207100 / readme.py
Last active November 8, 2019 02:16
[python IP] pthon访问指定ip的域名 #ip #host #域名 #python
import requests
requests.get('https://192.168.100.4',headers={'Host':'test.com'},verify=False)
import urllib2
req=urllib2.Request('https://192.168.199.4',headers={'Host':'test.com'})
urllib2.urlopen(req)
#urllib2 https会自动忽略证书
curl --resolve test.test.com:80:127.0.0.1 "http://test.test.com/"
@huang4207100
huang4207100 / redis_1.md
Last active November 11, 2019 01:29
[redis经验] redis问题分析 #redis #延迟 #内存 #崩溃
@huang4207100
huang4207100 / readme.md
Created November 7, 2019 08:41
[内存] 内存名称解析 #memory #VSS #RSS #PSS #USS
名称 解析
VSS Virtual Set Size 虚拟耗用内存(包含共享库占用的内存)
RSS Resident Set Size 实际使用物理内存(包含共享库占用的内存)
PSS Proportional Set Size 实际使用的物理内存(比例分配共享库占用的内存)
USS Unique Set Size 进程独自占用的物理内存(不包含共享库占用的内存)

VSS = RSS + 虚拟耗用(分配但未使用的内存)

@huang4207100
huang4207100 / proc_dba_WhatSQLIsExecuting.sql
Created November 6, 2019 01:49
[sql server实用] sql server常用语法 #sql #sql server
/*
--
-- SQL Server 2014 SP2
--
-- 查看有哪些存储过程:
USE master;
SELECT * FROM sys.sysobjects WHERE xtype='P';
--
-- 查看存储过程或函数的基本信息
@huang4207100
huang4207100 / readme.md
Created November 5, 2019 01:55
[redis] 主从复制 #redis #同步

主从复制

触发条件: 从实例连接主实例

  • 完全重新同步, 第一次或主实例不支持部分, 后台进程转储rdb文件, 通过rdb复制
  • 部分重新同步, 之前有同步过且主实例同意, 主实例将backlog缓冲区的命令发送给从实例

redis随机数据生成器

  • npm i redis-random-data-generator
@huang4207100
huang4207100 / readme.md
Created November 4, 2019 02:19
[算法] big O #O #Algorithm

Big O Notation and Algorithm Complexity

Why is this important?

@huang4207100
huang4207100 / demo_psutil.py
Last active November 8, 2019 02:16
[python监控] python监控进程的CPU和内存 #python #psutil
import sys
import time
import psutil
# get pid from args
if len(sys.argv) < 2:
print ("missing pid arg")
sys.exit()
# get process
@huang4207100
huang4207100 / process_monitor.py
Created October 30, 2019 02:24
[监控脚本python] 监控单个进程的cpu和内存 #python #psutil
import sys
import time
import psutil
# get pid from args
if len(sys.argv) < 2:
print ("missing pid arg")
sys.exit()
# get process