The 2020-04-02 T19: ". 460269 + 08:00 49126 [ERROR] [MY - 013132] of The [Server] table '/TMP/# sqld79_bfe6_14e is full!
The 2020-04-02 T19:18:52. 092831 + 08:00 49260 [ERROR] [MY - 013132] (Server) The table '/TMP/# sqld79_c06c_cb is full!
The 2020-04-02 T19:18:58. 351058 + 08:00 49198 [ERROR] [MY - 013132] (Server) The table '/TMP/# sqld79_c02e_151 is full!
The 2020-04-02 T19:18:58. 765038 + 08:00 49276 [ERROR] [MY - 013132] (Server) The table '/TMP/# sqld79_c07c_bf is full!
At 19:00 T19:2020-04-02. 040324 + 08:00 48253 [ERROR] [MY - 013132] of The [Server] table '/TMP/# sqld79_bc7d_385 is full!
The 2020-04-02 T19:19:11. 330283 + 08:00 41496 [ERROR] [MY - 013132] (Server) The table '/TMP/# sqld79_a218_45a is full!
The 2020-04-02 T20:09:14. 106335 + 08:00 65949 [ERROR] [MY - 013132] (Server) The table '/TMP/# sqld79_1019d_18e is full!
The 2020-04-02 T21:42:06. 273942 + 08:00 74050 [ERROR] [MY - 013132] (Server) The table '/TMP/# sqld79_12142_1352 is full!
The T21:2020-04-02 were. 215709 + 08:00 94555 [ERROR] [MY - 013132] of The [Server] table '/TMP/# sqld79_1715b_6f5 is full!
The 2020-04-02 T21: observe. 428102 + 08:00 96589 [ERROR] [MY - 013132] of The [Server] table '/TMP/# sqld79_1794d_124 is full!
My. CNF:
Datadir=/var/lib/mysql
Socket=/var/lib/mysql/mysql. The sock
The log - error=/var/log/mysqld. Log
Pid - file=/var/run/mysqld/mysqld. Pid
Server_id=3 # each machine is not the same as
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
='SET NAMES init_connect 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=20 g
The open files - limit=65535
Both tmp_table_size=5 g
Max_heap_table_size=10 g
CodePudding user response:
Use the temporary table? Take a look at/TMP is full? Clear the/TMP directory, or backup to another location off to try again,