A simple request causing the message "server is gone"

Question

Just got a surprise and will appreciate some of the suggestions. The simple query below updates the table. I used it separately, without problems, but now it does not work, as usual, forcing the MySQL server to leave. What may be responsible. Thank.

UPDATE rmc_raw_data 
    INNER
    JOIN handover_main
        ON handover_main.handover_time = rmc_raw_data.rmc_time
        AND handover_main.handover_date = rmc_raw_data.rmc_date
        SET rmc_raw_data.handovers = 'Handover'

Answer 1

Increase the session timeout. Most likely, it will be 5 minutes or so, which is too short for lengthy requests.

Here are the details from the mysql documentation: http://dev.mysql.com/doc/refman/5.1/en/gone-away.html

: http://dev.mysql.com/doc/refman/5.1/en/mysql-options.html

Answer 2

- / .

, .

, SQL, .

(-), , , / script, , , php (/ ), , JDBC/ODBC.

, ( mysql).