Python-Mysqlのエラー「pymysql.err.OperationalError: (2013, 'Lost connection to MySQL server during query」

題名の通りです。
下記プログラムを実行しています。

Python
1MYSQL_USER="ユーザー"
2MYSQL_PASSWORD="パスワード"
3MYSQL_HOST="ホスト"
4MYSQL_DATABASE="データベース名"
5MYSQL_PORT="3306"
6CONNECT = mysql.connector.connect(port=MYSQL_PORT,user=MYSQL_USER, password=MYSQL_PASSWORD, host=MYSQL_HOST, database=MYSQL_DATABASE, charset='utf8' )
7CURSOR = CONNECT.cursor(buffered=True)
8query=r"""時間のかかるSQL"""
9CURSOR.execute(query)
10CONNECT.commit()

下記のエラーが出ます

Traceback (most recent call last):
  File "update_db.py", line 93, in <module>
    CURSOR.execute(query)
  File "/usr/lib64/python3.6/site-packages/mysql/connector/cursor.py", line 566, in execute
    self._handle_result(self._connection.cmd_query(stmt))
  File "/usr/lib64/python3.6/site-packages/mysql/connector/connection.py", line 530, in cmd_query
    result = self._handle_result(self._send_cmd(ServerCmd.QUERY, query))
  File "/usr/lib64/python3.6/site-packages/mysql/connector/connection.py", line 304, in _send_cmd
    return self._socket.recv()
  File "/usr/lib64/python3.6/site-packages/mysql/connector/network.py", line 248, in recv_plain
    raise errors.InterfaceError(errno=2013)
mysql.connector.errors.InterfaceError: 2013: Lost connection to MySQL server during query

Mysqlのタイムアウトの問題かと思い、interactive_timeoutやwait_timeoutを確認してみましたが、どちらも8時間の設定になっていました

Mysql
1>>> show global variables like '%timeout%';
2
3connect_timeout	10
4delayed_insert_timeout	300
5have_statement_timeout	YES
6innodb_flush_log_at_timeout	1
7innodb_lock_wait_timeout	50
8innodb_rollback_on_timeout	OFF
9interactive_timeout	28800
10lock_wait_timeout	31536000
11net_read_timeout	30
12net_write_timeout	60
13rpl_semi_sync_master_async_notify_timeout	5000000
14rpl_semi_sync_master_timeout	3000
15rpl_stop_slave_timeout	31536000
16slave_net_timeout	30
17wait_timeout	28800
18
19>>> show global variables like '%wait%';
20
21innodb_lock_wait_timeout	50
22innodb_spin_wait_delay	6
23lock_wait_timeout	31536000
24performance_schema_events_waits_history_long_size	0
25performance_schema_events_waits_history_size	0
26rpl_semi_sync_master_wait_for_slave_count	1
27rpl_semi_sync_master_wait_no_slave	ON
28rpl_semi_sync_master_wait_point	AFTER_SYNC
29wait_timeout	28800