执行insert into 语句，报错“ERROR 1064 (HY000): Execute timeout”，会话中临时修改参数到最大“SET query_timeout = 259200;”仍然报错，看是没起作用。
请这个问题应该修改哪些参数？
insert into lineorder_flat (LO_ORDERDATE , LO_ORDERKEY , LO_LINENUMBER , LO_CUSTKEY , LO_PARTKEY , LO_SUPPKEY , LO_ORDERPRIORITY , LO_SHIPPRIORITY , LO_QUANTITY , LO_EXTENDEDPRICE , LO_ORDTOTALPRICE , LO_DISCOUNT , LO_REVENUE , LO_SUPPLYCOST , LO_TAX , LO_COMMITDATE , LO_SHIPMODE , C_NAME , C_ADDRESS , C_CITY , C_NATION , C_REGION , C_PHONE , C_MKTSEGMENT , S_NAME , S_ADDRESS , S_CITY , S_NATION , S_REGION , S_PHONE , P_NAME , P_MFGR , P_CATEGORY , P_BRAND , P_COLOR , P_TYPE , P_SIZE , P_CONTAINER ) SELECT LO_ORDERDATE , LO_ORDERKEY , LO_LINENUMBER , LO_CUSTKEY , LO_PARTKEY , LO_SUPPKEY , LO_ORDERPRIORITY , LO_SHIPPRIORITY , LO_QUANTITY , LO_EXTENDEDPRICE , LO_ORDTOTALPRICE , LO_DISCOUNT , LO_REVENUE , LO_SUPPLYCOST , LO_TAX , LO_COMMITDATE , LO_SHIPMODE , C_NAME , C_ADDRESS , C_CITY , C_NATION , C_REGION , C_PHONE , C_MKTSEGMENT , S_NAME , S_ADDRESS , S_CITY , S_NATION , S_REGION , S_PHONE , P_NAME , P_MFGR , P_CATEGORY , P_BRAND , P_COLOR , P_TYPE , P_SIZE , P_CONTAINER FROM lineorder l INNER JOIN customer c ON (c.C_CUSTKEY = l.LO_CUSTKEY) INNER JOIN supplier s ON (s.S_SUPPKEY = l.LO_SUPPKEY) INNER JOIN part p ON (p.P_PARTKEY = l.LO_PARTKEY);