mysql写入数据过大

ALTER TABLE your_table MODIFY your_column TEXT;

import mysql.connector

db = mysql.connector.connect(host="localhost", user="user", password="password", database="your_database")
cursor = db.cursor()

data_to_insert = [
    ("value1", "value2"),
    ("value3", "value4"),
    # ...
]

for i in range(0, len(data_to_insert), 1000):
    batch = data_to_insert[i:i+1000]
    query = "INSERT INTO your_table (column1, column2) VALUES (%s, %s)"
    cursor.executemany(query, batch)
    db.commit()

try:
    cursor.execute("START TRANSACTION")
    for i in range(0, len(data_to_insert), 1000):
        batch = data_to_insert[i:i+1000]
        query = "INSERT INTO your_table (column1, column2) VALUES (%s, %0)"
        cursor.executemany(query, batch)
    db.commit()
except mysql.connector.Error as error:
    db.rollback()
    print("Failed to insert record into MySQL table {}".format(error))
finally:
    cursor.close()
    db.close()

SET GLOBAL innodb_buffer_pool_size = 2G;

SET GLOBAL innodb_log_file_size = 512M;