ClickHouse Mysql engine POPULATE import data lost link

error message

Mysql lost link

 Code: 1000. DB::Exception: Received from localhost:9000. 
DB::Exception: mysqlxx::Exception: Lost connection to MySQL server during query (127.0.0.1:3306). (POCO_EXCEPTION)

solution

Set the Mysql innodb_buffer_pool_size parameter, so that the innodb_buffer_pool_size available memory space is larger than the memory size of the data table to be imported.

Query innodb_buffer_pool_size usable memory size, in bytes

 SELECT @@innodb_buffer_pool_size;

Temporarily change Mysql innodb_buffer_pool_size memory size.

 set global innodb_buffer_pool_size = 6442450944;

guess