mysql提高导入速度

import mysql.connector
from mysql.connector import errorcode

def import_data(file_path):
    try:
        cnx = mysql.connector.connect(user='user', password='password',
                                      host='host', database='database')
        cursor = cnx.cursor()

        # 禁用索引
        cursor.execute("ALTER TABLE table_name DISABLE KEYS")

        with open(file_path, 'r') as file:
            sql = "INSERT INTO table_name (column1, column2) VALUES (%s, %s)"
            for line in file:
                values = line.strip().split(',')
                cursor.execute(sql, values)

        # 提交事务
        cnx.commit()

        # 重新启用索引
        cursor.execute("ALTER TABLE table_name ENABLE KEYS")

    except mysql.connector.Error as err:
        if err.errno == errorcode.ER_ACCESS_DENIED_ERROR:
            print("Something is wrong with your user name or password")
        elif err.errno == errorcode.ER_BAD_DB_ERROR:
            print("Database does not exist")
        else:
            print(err)
    finally:
        cursor.close()
        cnx.close()

import_data('data.txt')