Chang Huang vebodev

删除某个时间点前的indics

# 列出当前所有indics
curl -k  "https://localhost:9200/_cat/indices"

curl -k -X POST "http://localhost:9200/graylog_148/_delete_by_query?pretty" -H 'Content-Type: application/json' -d'
{

Install Warp Terminal on Arch Linux

sudo sh -c "echo -e '\n[warpdotdev]\nServer = https://releases.warp.dev/linux/pacman/\$repo/\$arch' >> /etc/pacman.conf"
sudo pacman-key -r "[email protected]"
sudo pacman-key --lsign-key "[email protected]"

	[test]
	Driver = mysql
	Description = Connector/ODBC 8.0 UNICODE Driver DSN
	SERVER = tidb-dev
	PORT = 4000
	USER =
	Password =
	Database = patrolman
	OPTION = 3
	SOCKET =

	# This is the UnixODBC driver config
	[mysql]
	Driver = /usr/local/lib/libmyodbc8a.so
	UsageCount = 1

	#[derive(Debug, StructOpt)]
	#[structopt(name = "wechat-user-refresh", about = "批量刷新微信用户 unionid")]
	struct Opt {
	#[structopt(short="t", long="token", help="微会员企业Token, 不是微信token")]
	token: String,
	#[structopt(short="c", long="concurrency", default_value="16", help="并发数")]
	concurrency: usize,
	#[structopt(name="FILE", parse(from_os_str), help="包含 card_num,openid 格式的 csv文件")]
	file: PathBuf,
	}

	# match text in all tables' comments
	SELECT TABLE_NAME, COLUMN_NAME, COLUMN_COMMENT
	FROM INFORMATION_SCHEMA.COLUMNS
	WHERE TABLE_SCHEMA = 'iCRM2_CustomerDB_Saas_xzdyf'
	AND COLUMN_COMMENT LIKE '%复购%';

	# list all running tasks from tidb
	select * from information_schema.cluster_processlist where INFO is not null order by Time DESC

	/* 查询 TiKV 节点状态 */
	select * from INFORMATION_SCHEMA.TIKV_STORE_STATUS;