Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Background:

In reference to 

Jira Legacy
serverJIRA (openedx.atlassian.net)
serverId13fd1930-5608-3aac-a5dd-21b934d3a4b4
keyMA-2678
; we have changed forums implementation with following details (for reference; see PR#192):

...

The load tests were run on 4x c4.2xlarge instances for lms and 3x m4.large instances for forums.

The results of load tests below show differences between the old and new implementation. The two set of results looks quite similar except when it reaches "No. of clients = 336"; where there is huge difference between old and new percentiles as well as sudden rise in percentile for both old and new index with respect to "No. of clients = 224". For all the next tests (i.e. No. of clients = 460, No. of clients = 510, No. of clients = 578), the difference between old and new percentile is minimised and the new index results have lower percentile for most of the endpoints.

I have captured new relic charts too; permaLink_old_index with average rpm = 1.86k and permaLink_new_index with average rpm = 1.81k

 


No. of clients = 300
1. req/s = 
 

Old Index

New Index

No. of clients = 48
req/s = 9.4
Methodsmedian response time95%99%

DELETE_comment

250

3101200

DELETE_thread

160

190200

GET_comment_list

150190310

GET_thread

140180220

GET_thread_list

160370520

PATCH_comment

2303601200

PATCH_thread

190240370

POST_comment_comment

290360430

POST_comment_response

250310450

POST_thread

160190200

auto_auth

200250250
No. of clients = 48
req/s = 8.9
Methodsmedian response timemedian response time95%95%99%95%99%

DELETE_comment

250 270300 470480 520

DELETE_thread

170 160210 300230 310

GET_comment_list

150 160200 260320 350

GET_thread

150 150190 250280 310

GET_thread_list

170 190360 370520 530

PATCH_comment

220 240320 400410 460

PATCH_thread

180 190360 300330 330

POST_comment_comment

290 310340 510490 680

POST_comment_response

250 260300 450390 520

POST_thread

160 160200 250370 340

auto_auth

220 210230 230230 230


No. of clients = 96
req/s = 18.5
Methodsmedian response time95%99%
DELETE_comment

270

340390
DELETE_thread170230330
GET_comment_list170210330
GET_thread160200250
GET_thread_list190440610
PATCH_comment240330360
PATCH_thread200260350
POST_comment_comment310380470
POST_comment_response260330440
POST_thread170210340
auto_auth180220220


No. of clients = 96
req/s = 18.6
Methodsmedian response timemedian response time95%95%99%95%99%
DELETE_comment270 280340 360360 980
DELETE_thread170 170220 230230 290
GET_comment_list160 160210 220340 400
GET_thread160 160200 210270 340
GET_thread_list190 190460 460600 640
PATCH_comment220 230310 310340 460
PATCH_thread190 200260 280350 1000
POST_comment_comment300 310370 410480 680
POST_comment_response260 260330 350420 620
POST_thread170 170210 210340 330
auto_auth180 210230 220230 220


No. of clients = 162
req/s = 31
Methodsmedian response time95%99%

DELETE_comment

320400490

DELETE_thread

190240280

GET_comment_list

190250370

GET_thread

190250340

GET_thread_list

220520660

PATCH_comment

270360390

PATCH_thread

230310370

POST_comment_comment

350450540

POST_comment_response

300400490

POST_thread

190240340

auto_auth

200200200


No. of clients = 162
req/s = 31.6
Methodsmedian response timemedian response time95%95%99%99%

DELETE_comment

310 320410 420590 530

DELETE_thread

190 190240 230250 250

GET_comment_list

190 190250 250380 380

GET_thread

180 180250 250360 340

GET_thread_list

220 210530 520670 660

PATCH_comment

260 250380 3601400 430

PATCH_thread

220 230280 310400 370

POST_comment_comment

340 340450 470540 620

POST_comment_response

290 290400 400510 550

POST_thread

190 190240 230370 360

auto_auth

210 200220 200220 200


No. of clients = 240
req/s = 44.6
Methodsmedian response time95%99%

DELETE_comment

400600700

DELETE_thread

240320530

GET_comment_list

240350480

GET_thread

240360470

GET_thread_list

270630800

PATCH_comment

330510600

PATCH_thread

290420530

POST_comment_comment

420640820

POST_comment_response

360560730

POST_thread

240310440

auto_auth

210210210


No. of clients = 240
req/s = 45.40
Methodsmedian response timemedian response time95%95%99%99%

DELETE_comment

390 410650 6901300 1100

DELETE_thread

240 230370 280430 340

GET_comment_list

230 240350 350500 480

GET_thread

230 240370 370600 520

GET_thread_list

270 270640 630850 790

PATCH_comment

300 310490 4801200 610

PATCH_thread

280 290460 470640 630

POST_comment_comment

410 430670 6601000 970

POST_comment_response

360 360560 600860 850

POST_thread

230 230300 310500 430

auto_auth

190 220 220 
 
210220220220220



No. of clients = 270
req/s = 51.1
Methodsmedian response time95%99%

DELETE_comment

560790010000

DELETE_thread

2806205200

GET_comment_list

30031004000

GET_thread

31034005000

GET_thread_list

33030004200

PATCH_comment

40017006500

PATCH_thread

38051006300

POST_comment_comment

560790010000

POST_comment_response

47061008200

POST_thread

29029003900
auto_auth320320320

No. of clients = 300
req/s = 48
Methodsmedian response time95%99%

DELETE_comment

160046005900

DELETE_thread

46016002500

GET_comment_list

48013001900

GET_thread

56021002900

GET_thread_list

53017002500

PATCH_comment

80028003500

PATCH_thread

71027003600

POST_comment_comment

140043005500

POST_comment_response

100036004800

POST_thread

43011001700
auto_auth240250250
No. of clients = 336
req/s = 53
Methodsmedian response time95%99%

DELETE_comment

250055006500

DELETE_thread

98023002900

GET_comment_list

80021002700

GET_thread

92027003300

GET_thread_list

85024003300

PATCH_comment

150039005000

PATCH_thread

120034004100

POST_comment_comment

230054007000

POST_comment_response

170044005900

POST_thread

74020002700

auto_auth

33013001300


No. of clients = 336
1. req/s = 54.3 2. req/s = 40.2
Methodsmedian response timemedian response time95%95%99%99%

DELETE_comment

1500680053009200120009600120001400011000

DELETE_thread

47035002300410063004600670068005100

GET_comment_list

51027001800500049003700680056004500

GET_thread

59035002100650067004800990077005700

GET_thread_list

58028001800490052003900680061004800

PATCH_comment

810500035007600910064001100110009700

PATCH_thread

79043002900540082006300780091007300

POST_comment_comment

1300640048009300120009300120001300011000

POST_comment_response

10005100370077009700780010000120009600

POST_thread

47026001700460046003500640052004000

auto_auth

320140071032016008303201600830


No. of clients = 460
req/s = 44.5
Methodsmedian response time95%99%

DELETE_comment

5600980012000

DELETE_thread

370062007900

GET_comment_list

370061008100

GET_thread

5200980013000

GET_thread_list

370068008600

PATCH_comment

480079009500

PATCH_thread

460073009900

POST_comment_comment

5500930011000

POST_comment_response

5000830010000

POST_thread

350060009200

auto_auth

200026002600


No. of clients = 460
req/s = 49.1
Methodsmedian response time95%99%

DELETE_comment

61001000011000

DELETE_thread

350057006400

GET_comment_list

300050005700

GET_thread

420071008700

GET_thread_list

310053006200

PATCH_comment

440078008600

PATCH_thread

410069007600

POST_comment_comment

5700990011000

POST_comment_response

4800850010000

POST_thread

300048005500

auto_auth

170027002700


No. of clients = 510
req/s = 32.4
Methodsmedian response time95%99%

DELETE_comment

77001500027000

DELETE_thread

54001200015000

GET_comment_list

63001400031000

GET_thread

86001900036000

GET_thread_list

64001400032000

PATCH_comment

70001400025000

PATCH_thread

69001600035000

POST_comment_comment

74001500036000

POST_comment_response

70001400026000

POST_thread

60001100032000

auto_auth

290040004400


No. of clients = 510
req/s = 33.9
Methodsmedian response time95%99%

DELETE_comment

76001400019000

DELETE_thread

67001100014000

GET_comment_list

67001100016000

GET_thread

94001600022000

GET_thread_list

70001100017000

PATCH_comment

69001200016000

PATCH_thread

69001200021000

POST_comment_comment

76001400019000

POST_comment_response

72001300018000

POST_thread

67001100015000

auto_auth

240032003300


No. of clients = 578
req/s = 26.70
Methodsmedian response time95%99%

DELETE_comment

95002600032000

DELETE_thread

87002500032000

GET_comment_list

86002200031000

GET_thread

130002700040000

GET_thread_list

86002200032000

PATCH_comment

88002200032000

PATCH_thread

88002000029000

POST_comment_comment

92002400031000

OST_comment_response

93002400032000

POST_thread

83002000032000

auto_auth

360052005500


No. of clients = 578
req/s = 40.2
Methodsmedian response time95%99%

DELETE_comment

91002400032000

DELETE_thread

85002200026000

GET_comment_list

81002200032000

GET_thread

120002600040000

GET_thread_list

83002200032000

PATCH_comment

83002300031000

PATCH_thread

80002300028000

POST_comment_comment

90002400032000

OST_comment_response

85002300032000

POST_thread

83002200032000

auto_auth

410051005400