Error Code: 2013. Lost connection to MySQL server during query
Pulling my hair out with this one, very grateful if someone can help.
I am running a MySQL local server on the laptop which runs as a service in the background and using it to develop a SNOMED database. I have many tables and populated majority using the 'LOAD DATA INFILE' script. I am stuck a particular table where the .txt files are very large (>2mil rows) and as a result the query takes long to run, which is ok. Problem is after the 30 second mark, i keep getting following error:
"Error Code: 2013. Lost connection to MySQL server during query"
I have searched the depths of the ocean and set all GLOBAL VARIABLES that have 'timeout' in name to '1000' or more however error persists.
Some of the variables i have changed include:
'mysqlx_connect_timeout'
'mysqlx_idle_worker_thread_timeout'
'mysqlx_read_timeout''
'mysqlx_write_timeout'
'net_read_timeout'
'net_write_timeout'
'replica_net_timeout'
'slave_net_timeout'
Someone please help with this. Many many thanks in advance.
Subject
Views
Written By
Posted
Error Code: 2013. Lost connection to MySQL server during query
1862
September 16, 2023 03:50PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.