MantisBT - TestLink
View Issue Details
0008629TestLinkDatabase Generalpublic2019-04-11 07:002019-05-03 10:11
cyuste 
fman 
lowfeature requesthave not tried
assignedopen 
1.9.19 (2019 Q1) 
 
Postgres v10.5
0008629: Multiple testlink instances configured to the same DB
Hello,

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
No tags attached.
gz gettprojectnodes.php.gz (2,419) 2019-04-16 18:08
http://mantis.testlink.org/file_download.php?file_id=5138&type=bug
Issue History
2019-04-11 07:00cyusteNew Issue
2019-04-11 20:59fmanNote Added: 0028702
2019-04-12 09:33cyusteNote Added: 0028711
2019-04-12 09:33cyusteNote Edited: 0028711bug_revision_view_page.php?bugnote_id=28711#r5814
2019-04-12 09:49fmanNote Added: 0028713
2019-04-15 13:46cyusteNote Added: 0028724
2019-04-15 18:18fmanNote Added: 0028725
2019-04-16 18:08fmanNote Added: 0028732
2019-04-16 18:08fmanFile Added: gettprojectnodes.php.gz
2019-04-16 18:09fmanAssigned To => fman
2019-04-16 18:09fmanStatusnew => feedback
2019-04-23 09:09cyusteNote Added: 0028761
2019-04-23 09:09cyusteStatusfeedback => assigned
2019-05-03 10:11cyusteNote Added: 0028810

Notes
(0028702)
fman   
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.

regards
(0028711)
cyuste   
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

(0028713)
fman   
2019-04-12 09:49   
20 users are not a lot.

You can give a look to ticket note
http://mantis.testlink.org/view.php?id=5534#c28686 [^]

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?

regards
(0028724)
cyuste   
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:
https://i.nth.sh/xKZbHi87M2 [^]
https://i.nth.sh/YK9R1rTwwu [^]
https://i.nth.sh/YBNEbF9Lbq [^]
https://i.nth.sh/xKZbHi87M2 [^]
https://i.nth.sh/hZSiKobVJN [^]

About sharing the DB I will ask but I don't think it's possible as we have some sensitive data there
(0028725)
fman   
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.
(0028732)
fman   
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 https://i.nth.sh/hZSiKobVJN [^]

please provide feedback
(0028761)
cyuste   
2019-04-23 09:09   
Installed, so far it looks better but these days were holidays, I'll keep you updated, thanks
(0028810)
cyuste   
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!