mzhang77’s gists

mzhang77 / or_index.md

Created January 25, 2026 02:22

mysql> show create table edges\G
*************************** 1. row ***************************
       Table: edges
Create Table: CREATE TABLE `edges` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `from_event_id` varchar(64) NOT NULL,
  `to_entity_id` varchar(64) NOT NULL,
  `to_entity_type` int NOT NULL,
  `from_event_type` int NOT NULL,

mzhang77 / or_index.py

Created January 25, 2026 02:20

	import mysql.connector
	import random
	import time

	# ================= 配置区域 =================
	DB_CONFIG = {
	'host': '127.0.0.1', # 替换 TiDB IP
	'port': 4000,
	'user': 'root', # 替换用户名
	'password': '', # 替换密码

mzhang77 / or_limit_simple.sql

Created January 19, 2026 14:46

	mysql> show create table t\G
	************************* 1. row *************************
	Table: t
	Create Table: CREATE TABLE `t` (
	`id` int NOT NULL,
	`a` int DEFAULT NULL,
	`b` int DEFAULT NULL,
	`c` int DEFAULT NULL,
	`padding` varchar(100) DEFAULT NULL,
	PRIMARY KEY (`id`) /T![clustered_index] CLUSTERED /,

mzhang77 / or_limit_simple.py

Created January 19, 2026 14:44


	import pymysql
	import random
	import time

	# --- 数据库配置 ---
	DB_CONFIG = {
	'host': '127.0.0.1', # 默认为本地，如果 TiDB 在远程请修改 IP
	'port': 4000,
	'user': 'root',

mzhang77 / or_limit.sql

Last active January 19, 2026 02:14

	mysql> show create table audit_log_events\G
	************************* 1. row *************************
	Table: audit_log_events
	Create Table: CREATE TABLE `audit_log_events` (
	`id` bigint unsigned NOT NULL AUTO_INCREMENT,
	`event_uuid` varbinary(16) NOT NULL,
	`created_at` timestamp(6) NOT NULL,
	`user_uuid` binary(16) DEFAULT NULL,
	`source_hash` binary(64) DEFAULT NULL,
	`device_code` varchar(32) DEFAULT NULL,

mzhang77 / or_limit.py

Created January 19, 2026 01:57

	import pymysql
	import random
	import time
	import binascii
	from datetime import datetime, timedelta

	# --- Database Configuration ---
	DB_CONFIG = {
	'host': '127.0.0.1',
	'port': 4000,

mzhang77 / slowlog_bin_args.go

Created December 30, 2025 14:28

	package main

	import (
	"crypto/rand"
	"database/sql"
	"encoding/hex"
	"fmt"
	"log"
	"os"
	"strconv"

mzhang77 / ime_test.py

Created October 11, 2025 04:00

	import threading
	import mysql.connector
	from mysql.connector import Error
	import random
	import string
	import time
	from datetime import datetime, timedelta
	from collections import Counter
	import logging
	from logging.handlers import RotatingFileHandler

mzhang77 / compare_schemas.py

Last active August 29, 2025 00:56

	#!/usr/bin/env python3

	config="""
	[data-sources]
	[data-sources.mysql]
	host = "127.0.0.1"
	port = 3306
	user = "root"
	password = ""

mzhang77 / random_insert.py

Created June 20, 2025 00:56

	import random
	import string
	import datetime
	import mysql.connector
	import time

	def random_string(length=10):
	return ''.join(random.choices(string.ascii_lowercase + string.digits, k=length))

	def random_date(start_year=2000, end_year=2025):

Michael Zhang mzhang77