Hello LimeSurvey Community,We've been experiencing an issue in our LimeSurvey installation where processes on the server, pending database queries that take longer than expected, remain indefinitely in a waiting state, consuming server memory. Instead of terminating after a reasonable timeout, these processes linger indefinitely. We suspect this might be related to MySQL's execution times or timeout settings.Could anyone provide guidance on how we could adjust the configuration settings for process execution times or maximum wait times in MySQL to mitigate this issue? We're looking to optimize our server performance and prevent prolonged waits for database queries.Any insights or recommendations on tweaking these settings would be greatly appreciated.Thank you in advance for your help!Best regards,

No information about your version, where and how you host it, nothing. You even deleted the standard questions asked at the beginning of each new post.