Mantis Bugtracker          
testlink.org

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0008629TestLinkDatabase Generalpublic2019-04-11 07:002019-04-23 09:09
Reportercyuste 
Assigned Tofman 
PrioritylowSeverityfeature requestReproducibilityhave not tried
StatusassignedResolutionopen 
PlatformOSOS Version
Product Version1.9.19 (2019 Q1) 
Fixed in Version 
Summary0008629: Multiple testlink instances configured to the same DB
DescriptionHello,

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
Browser
PHP Version
TestCaseID
QA Team - Task Workflow Status
Attached Filesgz file icon gettprojectnodes.php.gz [^] (2,419 bytes) 2019-04-16 18:08

- Relationships

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

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

(0028713)
fman (administrator)
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 (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:
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 (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.
(0028732)
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 https://i.nth.sh/hZSiKobVJN [^]

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

Installed, so far it looks better but these days were holidays, I'll keep you updated, thanks

- 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



Copyright © 2000 - 2019 MantisBT Team
Powered by Mantis Bugtracker