查看mysql server超时时间：

MariaDB [(none)]> use xspeeder;

MariaDB [xspeeder]> show global variables like '%timeout%';

+----------------------------+----------+

| Variable_name              | Value    |

+----------------------------+----------+

| connect_timeout            |        |

| deadlock_timeout_long      |  |

| deadlock_timeout_short     |     |

| delayed_insert_timeout     |       |

| innodb_lock_wait_timeout   |        |

| innodb_rollback_on_timeout | OFF      |

| interactive_timeout        |     |

| lock_wait_timeout          |  |

| net_read_timeout           |        |

| net_write_timeout          |        |

| slave_net_timeout          |      |

| thread_pool_idle_timeout   |        |

| wait_timeout               |     |

+----------------------------+----------+

设置超时时间，临时生效（以秒为单位）： 

  msyql> set global wait_timeout=;

  msyql> set global interactive_timeout=;

修改配置文件/etc/my.cnf.d/server.conf

        在 [mysqld]下添加

            wait_timeout=86400

默认超时时间是28800即8个小时
86400为24个小时