mysql导入数据内存溢出

import mysql.connector

def import_data_in_batches(file_path, batch_size=1000):
    conn = mysql.connector.connect(user='user', password='password', host='host', database='database')
    cursor = conn.cursor()
    
    with open(file_path, 'r') as file:
        batch = []
        for line in file:
            batch.append(tuple(line.strip().split(',')))
            if len(batch) >= batch_size:
                insert_query = "INSERT INTO table_name (column1, column2, column3) VALUES (%s, %s, %s)"
                cursor.executemany(insert_query, batch)
                conn.commit()
                batch = []
        
        if batch:
            insert_query = "INSERT INTO table_name (column1, column2, column3) VALUES (%s, %s, %s)"
            cursor.executemany(insert_query, batch)
            conn.commit()
    
    cursor.close()
    conn.close()

import_data_in_batches('data.csv')