2020-04-02T19:17:38.447420+08:00 41477 [ERROR] [MY-013132] [Server] The table '/tmp/#sqld79_a205_266' is full!
2020-04-02T19:17:39.460269+08:00 49126 [ERROR] [MY-013132] [Server] The table '/tmp/#sqld79_bfe6_14e' is full!
2020-04-02T19:18:52.092831+08:00 49260 [ERROR] [MY-013132] [Server] The table '/tmp/#sqld79_c06c_cb' is full!
2020-04-02T19:18:58.351058+08:00 49198 [ERROR] [MY-013132] [Server] The table '/tmp/#sqld79_c02e_151' is full!
2020-04-02T19:18:58.765038+08:00 49276 [ERROR] [MY-013132] [Server] The table '/tmp/#sqld79_c07c_bf' is full!
2020-04-02T19:19:00.040324+08:00 48253 [ERROR] [MY-013132] [Server] The table '/tmp/#sqld79_bc7d_385' is full!
2020-04-02T19:19:11.330283+08:00 41496 [ERROR] [MY-013132] [Server] The table '/tmp/#sqld79_a218_45a' is full!
2020-04-02T20:09:14.106335+08:00 65949 [ERROR] [MY-013132] [Server] The table '/tmp/#sqld79_1019d_18e' is full!
2020-04-02T21:42:06.273942+08:00 74050 [ERROR] [MY-013132] [Server] The table '/tmp/#sqld79_12142_1352' is full!
2020-04-02T21:42:15.215709+08:00 94555 [ERROR] [MY-013132] [Server] The table '/tmp/#sqld79_1715b_6f5' is full!
2020-04-02T21:42:20.428102+08:00 96589 [ERROR] [MY-013132] [Server] The table '/tmp/#sqld79_1794d_124' is full!
my.cnf:
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
server_id=3 # 每臺機器不一樣
gtid_mode=ON
enforce_gtid_consistency=ON
binlog_checksum=NONE
innodb_file_per_table=1
character-set-server=utf8mb4
collation-server=utf8mb4_0900_ai_ci
init_connect='SET NAMES utf8mb4'
log_timestamps=SYSTEM
max_connections=10240
max_user_connections=2000
max_connect_errors=1500
connect_timeout=30
wait_timeout=360
interactive_timeout=360
innodb_lock_wait_timeout=500
innodb_buffer_pool_size=20G
open-files-limit=65535
tmp_table_size=5G
max_heap_table_size=10G
uj5u.com熱心網友回復：
用臨時表了嗎？看看/tmp是否滿了？把/tmp目錄清下，或備份到其他位置再清理下試試。轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/23178.html
標籤：MySQL