Join 34,000+ subscribers and receive articles from our
blog about software quality, testing, QA and security.

Performance issues


#1

Hi,

while TestRail does perform quite well for us, we encounter some performance issues which are restricted to certain actions / processes. For example closing a test run does take a lot of time, and deleting a milestone prompted an error message that said “Lock wait timeout exceeded” repeatedly.
Are these known issues and if yes, is there a solution in sight for them?
Regards,

Chris


Getting Lock wait timeout exceeded error while deleting test runs
#2

Hello Chris,

Thanks for your posting! This usually indicates a performance or configuration issue with the database backend and we have a general optimization guide for the database configuration here:

http://docs.gurock.com/testrail-admin/admin-optimizing

Assuming you use MySQL for the database backend, changing just 1-2 options can already make a huge difference compared to the default settings (e.g. innodb_buffer_pool_size). We are happy to provide additional feedback if you can share a few more details about your setup (ideally via email at contact@gurock.com).

Cheers,
Tobias


#3

Thanks for the info, things are working now!


#4

Thanks, Chris, that’s great to hear :slight_smile:

Cheers,
Tobias