臨時(shí)表大小不足
一般是臨時(shí)表數(shù)據(jù)量太大造成
The maximum size of internal in-memory temporary tables
解決辦法
[mysqld]下增加屬性
tmp_table_size=1073741824
不支持分組
which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
解決辦法
[mysqld]下增加屬性
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
不支持emoji表情包
這種情況一般出現(xiàn)在應(yīng)用層
解決辦法
[mysqld]下增加屬性
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
并且刪除鏈接時(shí)的編碼睡腿，像這樣，不再顯式的指定字符集
jdbc:mysql://192.168.0.115:3306/xxx?allowMultiQueries=true&autoReconnect=true&useSSL=false
