peteralto
Member
- Joined
- Nov 1, 2020
- Messages
- 93
- Solutions
- 1
- Reaction score
- 17
I've been getting two connection loss errors during query.
I used this to go from 10s to 120s:
SET GLOBAL connect_timeout = 120;
And this to go from 30s to 120s:
SET GLOBAL net_read_timeout = 120;
I don't know if I would need to restart mysql to do it, but just running and updating the values I didn't see any results.
TFS 1.3 Downgrade
Code:
[Error - mysql_real_query] Query: INSERT INTO `player_killers` (`death_id`, `killed_by`, `level`, `is_player`) VALUES (77289, '2x Orc Spearman', 0, 0)
Message: Lost connection to server during query
[Error - mysql_real_query] Query: INSERT INTO `market_history` (`player_id`, `sale`, `itemtype`, `amount`, `price`, `expires_at`, `inserted`, `state`) VALUES (39179,0,8869,1,200000,1693783305,1691239028,255)
Message: Lost connection to server during query
I used this to go from 10s to 120s:
SET GLOBAL connect_timeout = 120;
And this to go from 30s to 120s:
SET GLOBAL net_read_timeout = 120;
I don't know if I would need to restart mysql to do it, but just running and updating the values I didn't see any results.
TFS 1.3 Downgrade