mysql windows
查询过大,联表匹配啥的操作偏多就会出现这个问题!
my.inf 设置是不太敢该,之前就是改完不知道怎么就运行不了重装的。
show global variables like "%timeout%";
| connect_timeout | 10 |
| delayed_insert_timeout | 300 |
| have_statement_timeout | YES |
| innodb_flush_log_at_timeout | 1 |
| innodb_lock_wait_timeout | 50 |
| innodb_rollback_on_timeout | OFF |
| interactive_timeout | 86400 |
| lock_wait_timeout | 31536000 |
| mysqlx_connect_timeout | 30 |
| mysqlx_idle_worker_thread_timeout | 60 |
| mysqlx_interactive_timeout | 28800 |
| mysqlx_port_open_timeout | 0 |
| mysqlx_read_timeout | 30 |
| mysqlx_wait_timeout | 28800 |
| mysqlx_write_timeout | 60 |
| net_read_timeout | 120 |
| net_write_timeout | 900 |
| rpl_stop_slave_timeout | 31536000 |
| slave_net_timeout | 60 |
| wait_timeout | 86400 |
error 2013 duration 是100sec
show global variables like 'max_allowed_packet';
| max_allowed_packet | 2097152 |
求问如何解决!!!!