mzhang77

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

#!/usr/bin/env python3

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

mzhang77

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):

mzhang77

import mysql.connector
import json
import os
import random
import string
from datetime import datetime, timedelta

# Config — replace with your actual TiDB credentials

mzhang77

import time
import os
import subprocess
import json
import sys
from threading import Thread
from queue import Queue

# global variables
cnt = {'total': 0, 'need compaction': 0, 'skipped': 0}

mzhang77

'''
#!/bin/bash

for i in {1..19}
do
  echo "Starting sbtest$i..."
  nohup python3 gc_test.py sbtest$i > "sbtest$i.out" 2>&1 &
  sleep 5
done
'''

mzhang77

import mysql.connector
import time
from concurrent.futures import ThreadPoolExecutor

def prepare_test_data(cursor, conn):
    cursor.execute("DROP TABLE IF EXISTS institutions")
    cursor.execute("""
        CREATE TABLE institutions (
            id INT PRIMARY KEY,
            data VARCHAR(255)

mzhang77

import mysql.connector
import time

# Connect to MySQL database
conn = mysql.connector.connect(
    host="127.0.0.1",
    user="root",
    port="4000",
    database="test"
)

mzhang77

import threading
import time
import mysql.connector
import uuid
import random

'''
create table tb (

mzhang77

import mysql.connector
from mysql.connector import pooling
from concurrent.futures import ThreadPoolExecutor, as_completed
import logging
import time
import sys
import random
import string

# Database connection details