mysql导入数据太大

LOAD DATA INFILE 'data.csv'
INTO TABLE table_name
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n';

START TRANSACTION;
LOAD DATA INFILE 'data.csv'
INTO TABLE table_name
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n';
COMMIT;

[mysqld]
innodb_buffer_pool_size = 1G
innodb_log_file_size = 256M
innodb_flush_log_at_trx_commit = 2

import mysql.connector

db = mysql.connector.connect(
    host="localhost",
    user="yourusername",
    password="yourpassword",
    database="yourdatabase"
)

cursor = db.cursor()

batch_size = 1000
for i in range(0, total_rows, batch_size):
    sql = f"INSERT INTO table_name (column1, column2, column3) VALUES "
    values = []
    for j in range(i, min(i + batch_size, total_rows)):
        values.append((data[j][0], data[j][1], data[j][2]))
    sql += ', '.join(map(lambda x: f"({x[0]}, {x[1]}, {x[2]})", values))
    cursor.execute(sql)
    db.commit()