[DiscordArchive] hmmm i do not know that one. Do you know how I check that?
[DiscordArchive] hmmm i do not know that one. Do you know how I check that?
Original source
hmmm i do not know that one. Do you know how I check that?
rektbyfaith
04-21-2025, 06:50 PM #1Archived author: Mr Speedo Man • Posted: 2025-04-21T18:50:45.482000+00:00
Original source
hmmm i do not know that one. Do you know how I check that?
Original source
It says in worldserver console during shutdown
rektbyfaith
04-21-2025, 06:51 PM #2Archived author: Mithria • Posted: 2025-04-21T18:51:03.379000+00:00
Original source
It says in worldserver console during shutdown
Original source
i have a .bat that shutdowns restarts the server every day at 5am so I have not been checking or looking for that. I can manually shut it down and check the log to see I would think
rektbyfaith
04-21-2025, 06:52 PM #3Archived author: Mr Speedo Man • Posted: 2025-04-21T18:52:35.633000+00:00
Original source
i have a .bat that shutdowns restarts the server every day at 5am so I have not been checking or looking for that. I can manually shut it down and check the log to see I would think
Original source
```
# INNODB stuff
innodb_buffer_pool_size = 32G #set this to half of your RAM
innodb_io_capacity = 500
innodb_io_capacity_max = 2500
innodb_use_fdatasync = ON
innodb_buffer_pool_instances = 12
innodb_log_buffer_size = 32M
join_buffer_size = 1M
thread_cache_size = 12
# Prevent SQL Deadlocks as much as possible
transaction_isolation="READ-COMMITTED"
```
You can try adding these lines to your mysql configuration file and then restart mysql so it takes effect. Also if you do so try bumping the worker threads and synch threads in playerbots.conf to 2
rektbyfaith
04-21-2025, 06:53 PM #4Archived author: Mithria • Posted: 2025-04-21T18:53:54.052000+00:00
Original source
```
# INNODB stuff
innodb_buffer_pool_size = 32G #set this to half of your RAM
innodb_io_capacity = 500
innodb_io_capacity_max = 2500
innodb_use_fdatasync = ON
innodb_buffer_pool_instances = 12
innodb_log_buffer_size = 32M
join_buffer_size = 1M
thread_cache_size = 12
# Prevent SQL Deadlocks as much as possible
transaction_isolation="READ-COMMITTED"
```
You can try adding these lines to your mysql configuration file and then restart mysql so it takes effect. Also if you do so try bumping the worker threads and synch threads in playerbots.conf to 2
Original source
Mysql config can be in different locations depending on your os. It is typically called either my.cnf or my.ini
rektbyfaith
04-21-2025, 06:55 PM #5Archived author: Mithria • Posted: 2025-04-21T18:55:25.059000+00:00
Original source
Mysql config can be in different locations depending on your os. It is typically called either my.cnf or my.ini
Original source
I don't know if it is wise but I had put my PlayerbotsDatabase.WorkerThreads = 16 but I am now noticing that PlayerbotsDatabase.SyncThreads = 1. Not sure if that is messing things up
rektbyfaith
04-21-2025, 06:56 PM #6Archived author: Mr Speedo Man • Posted: 2025-04-21T18:56:55.122000+00:00
Original source
I don't know if it is wise but I had put my PlayerbotsDatabase.WorkerThreads = 16 but I am now noticing that PlayerbotsDatabase.SyncThreads = 1. Not sure if that is messing things up
Original source
The computer is on windows 11. I am trying to find those files now
rektbyfaith
04-21-2025, 06:58 PM #7Archived author: Mr Speedo Man • Posted: 2025-04-21T18:58:51.173000+00:00
Original source
The computer is on windows 11. I am trying to find those files now
Original source
Google probably has more knowledge on its location than I do there. I'm not familiar with windows
rektbyfaith
04-21-2025, 07:03 PM #8Archived author: Mithria • Posted: 2025-04-21T19:03:34.522000+00:00
Original source
Google probably has more knowledge on its location than I do there. I'm not familiar with windows
Original source
Alright I was able to find the location (had to create it in my build case), apply it, and confirm it was applied. Restarted the server and now the max ping is down to 121ms but I am still getting the dsync lag spikes.
rektbyfaith
04-21-2025, 09:23 PM #9Archived author: Mr Speedo Man • Posted: 2025-04-21T21:23:14.383000+00:00
Original source
Alright I was able to find the location (had to create it in my build case), apply it, and confirm it was applied. Restarted the server and now the max ping is down to 121ms but I am still getting the dsync lag spikes.
Original source
Here's a video of what I am experiencing https://streamable.com/555zqo
[Embed: Watch World of Warcraft_replay_2025.04.21-14.18_clip_1 | Streamable]
Watch "World of Warcraft_replay_2025.04.21-14.18_clip_1" on Streamable.
https://streamable.com/555zqo
rektbyfaith
04-21-2025, 09:23 PM #10Archived author: Mr Speedo Man • Posted: 2025-04-21T21:23:21.656000+00:00
Original source
Here's a video of what I am experiencing https://streamable.com/555zqo
[Embed: Watch World of Warcraft_replay_2025.04.21-14.18_clip_1 | Streamable]
Watch "World of Warcraft_replay_2025.04.21-14.18_clip_1" on Streamable.
https://streamable.com/555zqo
1 Guest(s)
1 Guest(s)