Sidehistorik
...
A background index took 20 hours.
| Archived Issues (Total) | 13426 |
| Archived Projects | 29 |
| Attachments | 297804 |
| Comments | 3375476 |
| Components | 212 |
| Custom Fields | 767 |
| Groups | 449 |
| Individually Archived Issues | 0 |
| Issue Security Levels | 4 |
| Issue Types | 139 |
| Issues | 595471 |
| Issues In Archived Projects | 13426 |
CPUs: 8
Memory: 24 GB (16 for Jira)
...
Test: Background Reindex directly after cloning
For at se om der er samme lousy performace
Background Reindex started 08:54
...
5% at 09:35 (41 min) → 8min/% → 800 minutes estimate
Stopping, as the clone klon has proven significant significan "slowness" as in production.
...
postgresql.conf is changed:
| Kodeblok |
|---|
root@serverroot@docs02:/etc/postgresql/14/main# diff postgresql.conf postgresql.conf.prenpn 126,127d125 < # < dynamic_shared_memory_type = posix 165c163 < #wal_level = replica # minimal, archive, or hot_standby --- > wal_level = replica # minimal, archive, or hot_standby 177c175 < #full_page_writes = on # recover from partial page writes --- > full_page_writes = on # recover from partial page writes 190c188 < #checkpoint_completion_target = 0.9 --- > checkpoint_completion_target = 0.9 192,193c190,191 < max_wal_size = 1GB < min_wal_size = 80MB --- > max_wal_size = 4GB > min_wal_size = 1GB root@serverroot@docs02:/etc/postgresql/14/main# |
...
Stopping, as there has been no improvement at all.
Test: Missing Index - Customfields
https://jira.atlassian.com/browse/JRASERVER-38598
The clone is rolled back to snapshot
| Kodeblok |
|---|
postgres=# \c jira
You are now connected to database "jira" as user "postgres".
jira=# create index idx_netic_customfield on customfieldvalue (customfield);
CREATE INDEX
jira=# \q
|
Background Reindex started 09:01
1% 10 min
2% 19 min
TEST: Disk Speed
Test Instance on Fast Storage:
| Kodeblok | ||
|---|---|---|
| ||
TOTALS
---- ---- ---- ---- ----
stat avg median min max
---- ---- ---- ---- ----
open 77,581 63,649 29,970 3,852,387
r/w 50,339 44,585 24,717 316,925
close 47,438 42,527 23,729 232,508
delete 3,157 2,643 1,771 53,527
---- ---- ---- ---- ----
All times are in nanoseconds.
root@docs02:/pack/jira-data#
|
Test Instance - Standard Storage:
| Kodeblok | ||
|---|---|---|
| ||
TOTALS
---- ---- ---- ---- ----
stat avg median min max
---- ---- ---- ---- ----
open 212,426 102,273 34,011 10,787,925
r/w 120,548 65,447 26,104 11,182,308
close 185,517 60,635 24,043 58,844,839
delete 4,037 3,312 1,648 41,369
---- ---- ---- ---- ----
All times are in nanoseconds.
root@docs02:~#
|
Prod:
| Kodeblok | ||
|---|---|---|
| ||
TOTALS
---- ---- ---- ---- ----
stat avg median min max
---- ---- ---- ---- ----
open 283,197 217,224 142,270 3,443,233
r/w 209,608 148,299 99,537 14,991,509
close 181,996 142,584 98,883 1,275,311
delete 12,966 10,342 8,765 53,228
---- ---- ---- ---- ----
|