-
Notifications
You must be signed in to change notification settings - Fork 111
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Database backend for jobs #580
Comments
Hello, Jimmy!
|
Even when clearing the job database with jobs, we still have about 10k as a minimum which takes about 10 min to load on cached files. |
Hej @lithorus did you get anywhere with this? We are hitting the same issue. It would be great to be able and offload the done jobs so:
|
I had a look at replacing the file based json files with a NOSQL database. This way it would keep the same structure, but wanted to test if it was actually any faster. The next step would be to create a proper database structure, but it will be hard to keep compatibility with current implementation. I might have just do a hard fork with the database work to test it out. Also, I'm looking into why it's so slow at loading at times. Startup of one of our afanasy servers with 17k jobs took about atleast 1 hour to start. Also it's worth noting that if you change too many jobs at a time, it will crash with this many jobs, especially if changing priorities on several hundred jobs at a time. |
The current database is only in memory and restarting the afanasy server service can take quite a long time, since it needs to re-add all jobs again from the JSON files.
With a large job queue it can takes up to 30 min.
The other issue with this kind of setup is that what's on disk does not match what's in memory (the recent problem with custom JSON data on blocks).
My suggestions would be :
Another solution could also be something like a redis database, which might be easier to mimic the current implementation.
The text was updated successfully, but these errors were encountered: