MySQL報錯合集解決辦法： server has gone away, @@GLOBAL.GTID_PURGED can only be set when @@GLOBAL.GTID_MODE = ON

server has gone away: 如下圖

執行以下命令

    show global variables like '%timeout%';
    set global interactive_timeout=1296000;
    show global variables like 'max_allowed_packet';
    set global max_allowed_packet=268435456;

@@GLOBAL.GTID_PURGED can only be set when @@GLOBAL.GTID_MODE = ON: 如下圖

修改要導入的sql數據文件(data.sql)，註釋或者去掉類似以下內容的代碼：

SET @@GLOBAL.GTID_PURGED='0c655e1c-8360-11e8-b632-883fd358a41a:1-46763628';

SET GLOBAL innodb_file_format = barracuda; 如下圖

執行以下命令

    set global innodb_file_per_table =ON;
    SET GLOBAL innodb_file_format = barracuda;