Huge testlink case pool and MySQL tunig

Ask community to help.

Moderators: Amaradana, TurboPT, TL Developers

Huge testlink case pool and MySQL tunig

Postby narsu » Sat Dec 15, 2012 4:03 pm

Hello!


I would like to know some good advises to tune MySQL database to serve testlink 1.9.4/5

There is one quite huge project with >8000 cases. Now I would like to tune little bit MySQL server speed (This database is running currently 1.9.3)
Also there is several project also in same database :)
I am going to use XAMPP package in Windows with huge_my.cfg. Is it wise at all?
Should I install pure MySQL server ? Is there any sense to change engine in MySQL ?
Please throw some ideas?

What I should check first? :roll:


PS. How much could be estimated performance difference between 1.9.3 and 1.9.5 in database handling
narsu
Advanced user
 
Posts: 43
Joined: Sat Feb 17, 2007 2:07 pm

Re: Huge testlink case pool and MySQL tunig

Postby fman » Sun Dec 16, 2012 9:41 am

Doing search on forum for 'Performance ' provide this

viewtopic.php?f=11&t=6898&p=17094&hilit=performance&sid=153cb0683b869dc783352a61a0beac06#p17094

One of our worst nightmare was tree building and rendering.
The use of results.class.php was one of the reason, because this class followed the wrong rule '...do more that what is needed ...'.
Due to tree nature of TestLink items, and the approach used to represent it on DB (the simple approach of nodes with parent and child),
we need to use methods with recursive calls, and surely this do not help on performance when you talk of thousands test cases and test suites.
Test plan are build using links, this means again tree walking backwards (from leaf to root) in order to build test plan tree for navigation.

All these factors affects performance. Due to lack of resources (people,hardware, realistic sample date, time) we are not able to do any kind of deep benchmarking when changing approach from one version to other.

It would be great i community can help with this kind of work
fman
Member of TestLink Community
 
Posts: 3063
Joined: Tue Nov 15, 2005 7:19 am


Return to Installation and configuration



Who is online

Users browsing this forum: No registered users and 5 guests