potinho
Intermediate OT User
Hello everyone, everything good?
A few days ago I have noticed that my server has been giving errors in some tables (which I always repair in PHPMyAdmin), but they come back. Another thing that caught my attention is the error when reading communication packets, apparently it doesn't affect the game, but I'm afraid of crashing at some point. I read several topics and already increased my settings in SQL, as below:
# enable-named-pipe
key_buffer=16M
max_allowed_packet=256M
sort_buffer_size=512K
net_buffer_length=8K
read_buffer_size=256K
read_rnd_buffer_size=512K
myisam_sort_buffer_size=8M
log_error="mysql_error.log"
2021-11-12 8:09:14 8 [ERROR] mysqld.exe: Table '.\ots\auction_system' is marked as crashed and should be repaired
2021-11-12 8:09:14 8 [Warning] Checking table: '.\ots\auction_system'
2021-11-12 8:09:14 8 [ERROR] mysqld.exe: Table '.\ots\z_ots_comunication' is marked as crashed and should be repaired
2021-11-12 8:09:14 8 [Warning] Checking table: '.\ots\z_ots_comunication'
2021-11-12 8:09:14 8 [ERROR] mysqld.exe: Table '.\ots\z_shop_history_item' is marked as crashed and should be repaired
2021-11-12 8:09:14 8 [Warning] Checking table: '.\ots\z_shop_history_item'
2021-11-12 9:33:05 8 [Warning] Aborted connection 8 to db: 'ots' user: 'xxx' host: 'localhost' (Got an error reading communication packets)
2021-11-12 14:12:52 82 [Warning] Aborted connection 82 to db: 'ots' user: 'xxx' host: 'localhost' (Got an error reading communication packets)
A few days ago I have noticed that my server has been giving errors in some tables (which I always repair in PHPMyAdmin), but they come back. Another thing that caught my attention is the error when reading communication packets, apparently it doesn't affect the game, but I'm afraid of crashing at some point. I read several topics and already increased my settings in SQL, as below:
# enable-named-pipe
key_buffer=16M
max_allowed_packet=256M
sort_buffer_size=512K
net_buffer_length=8K
read_buffer_size=256K
read_rnd_buffer_size=512K
myisam_sort_buffer_size=8M
log_error="mysql_error.log"
2021-11-12 8:09:14 8 [ERROR] mysqld.exe: Table '.\ots\auction_system' is marked as crashed and should be repaired
2021-11-12 8:09:14 8 [Warning] Checking table: '.\ots\auction_system'
2021-11-12 8:09:14 8 [ERROR] mysqld.exe: Table '.\ots\z_ots_comunication' is marked as crashed and should be repaired
2021-11-12 8:09:14 8 [Warning] Checking table: '.\ots\z_ots_comunication'
2021-11-12 8:09:14 8 [ERROR] mysqld.exe: Table '.\ots\z_shop_history_item' is marked as crashed and should be repaired
2021-11-12 8:09:14 8 [Warning] Checking table: '.\ots\z_shop_history_item'
2021-11-12 9:33:05 8 [Warning] Aborted connection 8 to db: 'ots' user: 'xxx' host: 'localhost' (Got an error reading communication packets)
2021-11-12 14:12:52 82 [Warning] Aborted connection 82 to db: 'ots' user: 'xxx' host: 'localhost' (Got an error reading communication packets)