Z
ZITADEL
Z
ZITADEL
Zitadel Login Performance issue
Original message was deleted
ZITADEL
Join
ZITADEL - Identity infrastructure, simplified for you.
4,316
Members
View on Discord
F
FFO
•
7/24/24, 6:47 AM
That is defenitly too slow
, not sure why though
.
What version do you run and what CPU
/memory do you assign to zitadel and the DB
?
F
FFO
•
7/24/24, 6:47 AM
To me it looks like a CPU constraint issue
, since password hashing might take some time here
.
F
fabienne
•
7/24/24, 9:18 AM
in the defauls yaml you can find the configuration for the passwordHasher
F
FFO
•
7/24/24, 9:50 AM
have you checked the query analyzer in the cockroachDB
, maybe something takes too long to process
.
F
FFO
•
7/24/24, 9:50 AM
though we have not seen many such cases I would start looking into that
R
raju
Can you please share the command
F
FFO
•
7/24/24, 11:40 AM
CockroachDB has a UI for that
R
raju
If i change the hash cost 14 to 11, do i need update anything in db? will this c...
F
FFO
•
7/24/24, 11:40 AM
That only reduces the strain on zitadel not on the DB
F
FFO
•
7/24/24, 11:40 AM
I guess you should start sharing some metrics you see
Like CPU
/Memory usage and then investigage in the DB for slow queries
F
FFO
•
7/24/24, 3:02 PM
Why is you CRDB so high in CPU
?
What does zitadel do
?
F
FFO
•
7/24/24, 6:57 PM
You should really check the CockroachDB UI for expensive queries
R
raju
SELECT projections.current_states.last_updated, projections.current_states.event...
F
FFO
•
7/28/24, 5:49 PM
Hm that current state is certainly an issue
.
I wonder why that is so slow though
.
F
FFO
•
7/28/24, 5:49 PM
Contention 900ms is kind of the issue there
, question is why there is congestion
.
That usually mean that the same thing is being called many times in parallel
.
F
FFO
•
7/28/24, 5:51 PM
You can try to catch a debug log in CRDB there
, that might help us understand why this breaks
.
F
FFO
•
7/29/24, 8:39 AM
well that does not look to healthy
F
FFO
•
7/29/24, 8:39 AM
is that a CRDB cluster
?
F
FFO
•
7/29/24, 12:12 PM
you know that CRDB is not designed for a two server setup
?
R
raju
so how many server we should use to setup CRDB cluster?
F
FFO
•
7/29/24, 2:43 PM
at least 3
F
FFO
•
7/29/24, 2:44 PM
but maybe you should look into postgres as alternative
F
FFO
•
7/29/24, 2:59 PM
https://zitadel.com/docs/self-hosting/manage/cli/mirror
Next page