Starship Posted December 30, 2023 Posted December 30, 2023 Hi, folks! I have been using Achievements for my community from the beginning, and I love it. However, I've noticed that Achievements has been gradually slowing down my community every month. My server's CPU is constantly overloaded, essentially struggling to handle 'mariadb' requests. My community has a fairly large user base, featuring numerous user groups, ranks, and badges. I decided to disable Achievements, and now my community is running fast. Any advice? Thank you!
teraßyte Posted December 30, 2023 Posted December 30, 2023 You likely have a huge achievements activity log, and the bigger the table grows, the slower the site is. I've seen it happen before. Try enabling the setting to prune the old logs and see if it helps: Starship and Marc 2
Marc Posted January 1 Posted January 1 I would also ask if there is something specific leading you to believe achievements is the cause? I so, indeed the above would be the first thing to look at. Starship 1
Starship Posted January 1 Author Posted January 1 @teraßyte Thank you! I've set up the system to automatically prune old logs every 30 days. This has significantly improved performance, but it's still no perfect. @Marc Stridgen I've conducted several tests with the Achievements feature both enabled and disabled. Also, I'm having issues with managing Badges, the page constantly times out after 60 seconds. Before when I had just couple Badges I had no issues at all. Thanks!
Jim M Posted January 1 Posted January 1 While it may be faster with less in the log, have you had your hosting provider review the server and mysql server for performance? It could simply be it isn’t optimized and thus, would indeed be slower if it’s not optimized.
Marc Posted January 2 Posted January 2 You appear to be on quite an older release. Please upgrade to the latest release of the platform in the first instance
Donnie95 Posted January 24 Posted January 24 (edited) I have the same problem, the achievements logs table is so big. I want to lower the "Clear activity log" setting from 1 year to 6 months, but I'm afraid it will delete important information, such as the date a badge was earned or cause some other issues... Edited January 24 by Donnie95
Marc Posted January 24 Posted January 24 Im not sure what question it is you are asking here. You appear to be saying both that you want to do something and dont want to do something
Donnie95 Posted January 25 Posted January 25 (edited) 20 hours ago, Marc Stridgen said: Im not sure what question it is you are asking here. You appear to be saying both that you want to do something and dont want to do something Exactly, I'm hesitant to change the setting and risk deleting important information. Edited January 25 by Donnie95
Nathan Explosion Posted January 25 Posted January 25 (edited) They want to clear the content of the core_achievements_log table down by chaning the setting that prunes it. They are concenred that it will have an effect on the badges that have been awarded to the users already. Here's my input... Awarded badges are stored in core_member_badges, so should be unaffected by changing that. However, I suspect that if you clicked the option to rebuild achievements at a later point then there may be an effect on automatically awarded badges at that time. Edited January 25 by Nathan Explosion
Marc Posted January 25 Posted January 25 Ah I see. You can safely clear the contents of that. It shouldnt affect automatically awarded ones if you rebuild, as they would be rebuilt with the same content.
Recommended Posts