关于clickhouse:ClickHouse-Mysql引擎-POPULATE-导入数据丢失链接

July 27, 2022 · 1 min · jiezi

Table of Contents

错误信息

Mysql 失落链接

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)

解决方案

设置Mysql innodb_buffer_pool_size 参数，使得innodb_buffer_pool_size可用内存空间大于须要导入的数据表占用内存大小。

查问`innodb_buffer_pool_size`可应用内存大小，单位字节

SELECT @@innodb_buffer_pool_size;

长期更改 Mysql `innodb_buffer_pool_size`内存大小。

set global innodb_buffer_pool_size = 6442450944;

猜想