Mantis Bugtracker 

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0008629TestLinkDatabase Generalpublic2019-04-11 07:002020-01-02 16:04
Assigned Tofman 
PrioritylowSeverityfeature requestReproducibilityhave not tried
PlatformOSOS Version
Product Version1.9.19 (2019 Q1) 
Fixed in Version1.9.20 
Summary0008629: Multiple testlink instances configured to the same DB

He are having performance issues with our current testlink instalation. We think that the issue is that there are too many users using the tool at the same time and the QoS degradates. We were thinking on dockerizing the front and configuring all the containers to use the same DB. We would like to confirm if this approach is valid and we will not have a corrupted db in a near future or at least confirm with you experts that it is worth a try

Thank you very much
TagsNo tags attached.
Database (MySQL,Postgres,etc)Postgres v10.5
PHP Version
QA Team - Task Workflow StatusREADY FOR TESTING
Attached Filesgz file icon gettprojectnodes.php.gz [^] (2,419 bytes) 2019-04-16 18:08

- Relationships

-  Notes
fman (administrator)
2019-04-11 20:59

never done.
How many users are using concurrently testlink?
before doing nothing, it will be important to get some performance data, to understand if your proposed solution is not going to be just wasted time.

cyuste (reporter)
2019-04-12 09:33
edited on: 2019-04-12 09:33

We are around 20 people using it. What we have observed is, for example, that test suites takes a few seconds to be displayed whereas when we installed it was almost immediate.

As you suggest, we will install first a performance probe and check for bottlenecks. It doesn't look like insufficient hardware, CPU never reaches 10% usage and free mem is quite high. DB is running in another physical instance with plenty of resources too

fman (administrator)
2019-04-12 09:49

20 users are not a lot.

You can give a look to ticket note [^]

and may be contact user, because he said it has 2500 users.

It's possible for you to share your db with me to try to do some tests?

cyuste (reporter)
2019-04-15 13:46

Hi again!

We have installed new relic probe and obtained some performance metrics. Maybe these are within "standard" performance, but people complains about the time that takes to navigate the testcases tree. Just to clarify, the application is perfectly usable right now, but QAs report that the response times are increasing as more people is registered in it and I'm worried that in the long term this will be an issue. I can give you access to the performance portal if you like as we don't have anything else there, anyway here are some screenshots: [^] [^] [^] [^] [^]

About sharing the DB I will ask but I don't think it's possible as we have some sensitive data there
fman (administrator)
2019-04-15 18:18

after given a look to some of your pictures, I'm going to a refactoring and provide it to you for testing.
fman (administrator)
2019-04-16 18:08

please save your current file gettprojectnodes.php, and try with attached .
I've removed use of testproject object and I think this is going to help, according what I've seen in [^]

please provide feedback
cyuste (reporter)
2019-04-23 09:09

Installed, so far it looks better but these days were holidays, I'll keep you updated, thanks
cyuste (reporter)
2019-05-03 10:11

Hello again,

Most of the users report that the application performs better with this change. Nobody has reported any side-effect problem

Thank you very much for your help!

- Issue History
Date Modified Username Field Change
2019-04-11 07:00 cyuste New Issue
2019-04-11 20:59 fman Note Added: 0028702
2019-04-12 09:33 cyuste Note Added: 0028711
2019-04-12 09:33 cyuste Note Edited: 0028711 View Revisions
2019-04-12 09:49 fman Note Added: 0028713
2019-04-15 13:46 cyuste Note Added: 0028724
2019-04-15 18:18 fman Note Added: 0028725
2019-04-16 18:08 fman Note Added: 0028732
2019-04-16 18:08 fman File Added: gettprojectnodes.php.gz
2019-04-16 18:09 fman Assigned To => fman
2019-04-16 18:09 fman Status new => feedback
2019-04-23 09:09 cyuste Note Added: 0028761
2019-04-23 09:09 cyuste Status feedback => assigned
2019-05-03 10:11 cyuste Note Added: 0028810
2020-01-02 16:04 fman QA Team - Task Workflow Status => READY FOR TESTING
2020-01-02 16:04 fman Status assigned => resolved
2020-01-02 16:04 fman Fixed in Version => 1.9.20
2020-01-02 16:04 fman Resolution open => fixed

Copyright © 2000 - 2020 MantisBT Team
Powered by Mantis Bugtracker