Hello, thanks for the advice. below step we had take
1. Created a test environment that is the same in terms of server infrastructure, OS, Redis server and others, exactly the same as the Moodle site which has issues, only different in terms of data such as courses, users and so on. However, the test environment does not get the same issue.
2. Checked writing data to the database server and it went well.
3. Turned on debugging but didn't find anything.
4. Tried replacing the Moodle data with an empty one on the Moodle site that has the issue and the result still gets the same issue.
5. Tried using Boost and Classic themes and still has the issue.
6. Check that hardware usage is still low.
7. Remove plugins that intervene during the process of creating and deleting courses.