mysql如何模拟大数据

# 安装dbFit
wget http://dbfit.github.io/dbfit/dbfit-0.5.1.zip
unzip dbfit-0.5.1.zip
cd dbfit-0.5.1

# 编写数据生成脚本
echo "CREATE TABLE users (id INT PRIMARY KEY, name VARCHAR(255), email VARCHAR(255));" > test.sql
echo "INSERT INTO users (id, name, email) VALUES (1, 'User1', 'user1@example.com');" >> test.sql
echo "INSERT INTO users (id, name, email) VALUES (2, 'User2', 'user2@example.com');" >> test.sql
# 添加更多插入语句以模拟大数据

# 运行脚本
java -jar dbfit.jar -c mysql -u root -p test.sql

import mysql.connector
import random
import string

# 连接到MySQL数据库
db = mysql.connector.connect(
  host="localhost",
  user="root",
  password="password",
  database="testdb"
)

cursor = db.cursor()

# 创建表
cursor.execute("CREATE TABLE IF NOT EXISTS users (id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(255), email VARCHAR(255));")

# 插入数据
for i in range(1000000):  # 插入100万条数据
    name = ''.join(random.choices(string.ascii_uppercase + string.digits, k=10))
    email = f"{name}@example.com"
    cursor.execute("INSERT INTO users (name, email) VALUES (%s, %s)", (name, email))

db.commit()
cursor.close()
db.close()

# 导出数据
mysqldump -u root -p testdb users > users.sql

# 修改导出的SQL文件，增加数据量
sed -i 's/INSERT INTO users VALUES (1, "User1", "user1@example.com");/INSERT INTO users VALUES (1, "User1", "user1@example.com");\nINSERT INTO users VALUES (2, "User2", "user2@example.com");/g' users.sql

# 导入数据
mysql -u root -p testdb < users.sql

ALTER TABLE users DISABLE KEYS;
-- 插入数据
ALTER TABLE users ENABLE KEYS;

INSERT INTO users (name, email) VALUES
('User1', 'user1@example.com'),
('User2', 'user2@example.com'),
-- 添加更多插入语句
;

for i in range(0, 1000000, 1000):  # 每次插入1000条数据
    # 插入数据的代码