- 论坛徽章:
- 0
|
这个问题快一年了也没解决,不过到是没怎么影响应用。
最新新产品上线还是有这个问题。
是我的timeout超时设置的短么,导致语句执行不完中断?
set global wait_timeout = 100;
set global interactive_timeout = 100;
081205 7:11:42 [Warning] Aborted connection 7692834 to db: 'dz_bbs' user: 'mysql2' host: '192.168.1.23' (Got timeout reading communication packets)
081205 7:14:58 [Warning] Aborted connection 7695640 to db: 'dz_bbs' user: 'mysql2' host: '192.168.1.23' (Got timeout reading communication packets)
081205 7:51:46 [Warning] Aborted connection 7729253 to db: 'dz_bbs' user: 'mysql2' host: '192.168.1.23' (Got timeout reading communication packets)
081205 7:51:46 [Warning] Aborted connection 7729326 to db: 'n_ucenter' user: 'mysql2' host: '192.168.1.23' (Got timeout reading communication packets)
081205 7:59:44 [Warning] Aborted connection 7736457 to db: 'dz_bbs' user: 'mysql2' host: '192.168.1.23' (Got timeout reading communication packets)
081205 8:12:42 [Warning] Aborted connection 7749146 to db: 'dz_bbs' user: 'mysql2' host: '192.168.1.23' (Got timeout reading communication packets)
081205 8:14:00 [Warning] Aborted connection 7750427 to db: 'dz_bbs' user: 'mysql2' host: '192.168.1.23' (Got timeout reading communication packets)
081205 8:17:05 [Warning] Aborted connection 7753301 to db: 'dz_bbs' user: 'mysql2' host: '192.168.1.23' (Got timeout reading communication packets)
081205 8:19:03 [Warning] Aborted connection 7755154 to db: 'dz_bbs' user: 'mysql2' host: '192.168.1.23' (Got timeout reading communication packets)
081205 8:37:37 [Warning] Aborted connection 7775896 to db: 'dz_bbs' user: 'mysql2' host: '192.168.1.23' (Got timeout reading communication packets)
081205 9:03:44 [Warning] Aborted connection 7815587 to db: 'dz_bbs' user: 'mysql2' host: '192.168.1.23' (Got timeout reading communication packets)
081205 9:12:42 [Warning] Aborted connection 7830357 to db: 'dz_bbs' user: 'mysql2' host: '192.168.1.23' (Got timeout reading communication packets)
081205 9:14:34 [Warning] Aborted connection 7833952 to db: 'dz_bbs' user: 'mysql2' host: '192.168.1.23' (Got timeout reading communication packets) |
|