Author Topic: showing certificates is slow as hell  (Read 1015 times)

chunk.one

  • Zen Apprentice
  • *
  • Posts: 28
  • Karma: +1/-0
    • View Profile
showing certificates is slow as hell
« on: September 04, 2018, 12:58:48 pm »
Hi,

we have about 900 certificates created. Accessing them is slow as hell from the Webinterface. uwsgi runs with 50% CPU and 25% Mem only.

How to speed up?

Thanks :)

Edit: when I click anything in the webinterface, it looks like every time all about 900 certs will be parsed. For every single click! I've installed snoopy (apt install snoopy).
This should be the cause for. Some of the 900 log lines:

Sep  4 15:56:46 zentyal snoopy[3623]: [uid:111 sid:1275 tty:(none) cwd:/ filename:/usr/bin/openssl]: /usr/bin/openssl
Sep  4 15:56:46 zentyal snoopy[3625]: [uid:111 sid:1275 tty:(none) cwd:/ filename:/usr/bin/openssl]: /usr/bin/openssl
Sep  4 15:56:46 zentyal snoopy[3627]: [uid:111 sid:1275 tty:(none) cwd:/ filename:/usr/bin/openssl]: /usr/bin/openssl
Sep  4 15:56:46 zentyal snoopy[3629]: [uid:111 sid:1275 tty:(none) cwd:/ filename:/usr/bin/openssl]: /usr/bin/openssl
Sep  4 15:56:46 zentyal snoopy[3631]: [uid:111 sid:1275 tty:(none) cwd:/ filename:/usr/bin/openssl]: /usr/bin/openssl
Sep  4 15:56:46 zentyal snoopy[3633]: [uid:111 sid:1275 tty:(none) cwd:/ filename:/usr/bin/openssl]: /usr/bin/openssl
Sep  4 15:56:46 zentyal snoopy[3635]: [uid:111 sid:1275 tty:(none) cwd:/ filename:/usr/bin/openssl]: /usr/bin/openssl
Sep  4 15:56:46 zentyal snoopy[3637]: [uid:111 sid:1275 tty:(none) cwd:/ filename:/usr/bin/openssl]: /usr/bin/openssl
Sep  4 15:56:46 zentyal snoopy[3639]: [uid:111 sid:1275 tty:(none) cwd:/ filename:/usr/bin/openssl]: /usr/bin/openssl
Sep  4 15:56:46 zentyal snoopy[3641]: [uid:111 sid:1275 tty:(none) cwd:/ filename:/usr/bin/openssl]: /usr/bin/openssl
Sep  4 15:56:46 zentyal snoopy[3643]: [uid:111 sid:1275 tty:(none) cwd:/ filename:/usr/bin/openssl]: /usr/bin/openssl
Sep  4 15:56:46 zentyal snoopy[3645]: [uid:111 sid:1275 tty:(none) cwd:/ filename:/usr/bin/openssl]: /usr/bin/openssl
Sep  4 15:56:46 zentyal snoopy[3647]: [uid:111 sid:1275 tty:(none) cwd:/ filename:/usr/bin/openssl]: /usr/bin/openssl
Sep  4 15:56:46 zentyal snoopy[3649]: [uid:111 sid:1275 tty:(none) cwd:/ filename:/usr/bin/openssl]: /usr/bin/openssl
Sep  4 15:56:46 zentyal snoopy[3651]: [uid:111 sid:1275 tty:(none) cwd:/ filename:/usr/bin/openssl]: /usr/bin/openssl
Sep  4 15:56:46 zentyal snoopy[3653]: [uid:111 sid:1275 tty:(none) cwd:/ filename:/usr/bin/openssl]: /usr/bin/openssl
Sep  4 15:56:46 zentyal snoopy[3655]: [uid:111 sid:1275 tty:(none) cwd:/ filename:/usr/bin/openssl]: /usr/bin/openssl
Sep  4 15:56:46 zentyal snoopy[3657]: [uid:111 sid:1275 tty:(none) cwd:/ filename:/usr/bin/openssl]: /usr/bin/openssl
Sep  4 15:56:46 zentyal snoopy[3659]: [uid:111 sid:1275 tty:(none) cwd:/ filename:/usr/bin/openssl]: /usr/bin/openssl
Sep  4 15:56:46 zentyal snoopy[3661]: [uid:111 sid:1275 tty:(none) cwd:/ filename:/usr/bin/openssl]: /usr/bin/openssl
Sep  4 15:56:46 zentyal snoopy[3663]: [uid:111 sid:1275 tty:(none) cwd:/ filename:/usr/bin/openssl]: /usr/bin/openssl
Sep  4 15:56:46 zentyal snoopy[3665]: [uid:111 sid:1275 tty:(none) cwd:/ filename:/usr/bin/openssl]: /usr/bin/openssl
Sep  4 15:56:46 zentyal snoopy[3667]: [uid:111 sid:1275 tty:(none) cwd:/ filename:/usr/bin/openssl]: /usr/bin/openssl
Sep  4 15:56:46 zentyal snoopy[3669]: [uid:111 sid:1275 tty:(none) cwd:/ filename:/usr/bin/openssl]: /usr/bin/openssl
Sep  4 15:56:46 zentyal snoopy[3671]: [uid:111 sid:1275 tty:(none) cwd:/ filename:/usr/bin/openssl]: /usr/bin/openssl
Sep  4 15:56:46 zentyal snoopy[3673]: [uid:111 sid:1275 tty:(none) cwd:/ filename:/usr/bin/openssl]: /usr/bin/openssl
Sep  4 15:56:46 zentyal snoopy[3675]: [uid:111 sid:1275 tty:(none) cwd:/ filename:/usr/bin/openssl]: /usr/bin/openssl
Sep  4 15:56:46 zentyal snoopy[3677]: [uid:111 sid:1275 tty:(none) cwd:/ filename:/usr/bin/openssl]: /usr/bin/openssl
Sep  4 15:56:46 zentyal snoopy[3679]: [uid:111 sid:1275 tty:(none) cwd:/ filename:/usr/bin/openssl]: /usr/bin/openssl
Sep  4 15:56:46 zentyal snoopy[3681]: [uid:111 sid:1275 tty:(none) cwd:/ filename:/usr/bin/openssl]: /usr/bin/openssl
Sep  4 15:56:46 zentyal snoopy[3683]: [uid:111 sid:1275 tty:(none) cwd:/ filename:/usr/bin/openssl]: /usr/bin/openssl
Sep  4 15:56:46 zentyal snoopy[3685]: [uid:111 sid:1275 tty:(none) cwd:/ filename:/usr/bin/openssl]: /usr/bin/openssl
Sep  4 15:56:46 zentyal snoopy[3687]: [uid:111 sid:1275 tty:(none) cwd:/ filename:/usr/bin/openssl]: /usr/bin/openssl
Sep  4 15:56:46 zentyal snoopy[3689]: [uid:111 sid:1275 tty:(none) cwd:/ filename:/usr/bin/openssl]: /usr/bin/openssl
Sep  4 15:56:46 zentyal snoopy[3691]: [uid:111 sid:1275 tty:(none) cwd:/ filename:/usr/bin/openssl]: /usr/bin/openssl
Sep  4 15:56:46 zentyal snoopy[3693]: [uid:111 sid:1275 tty:(none) cwd:/ filename:/usr/bin/openssl]: /usr/bin/openssl
Sep  4 15:56:46 zentyal snoopy[3695]: [uid:111 sid:1275 tty:(none) cwd:/ filename:/usr/bin/openssl]: /usr/bin/openssl
Sep  4 15:56:46 zentyal snoopy[3697]: [uid:111 sid:1275 tty:(none) cwd:/ filename:/usr/bin/openssl]: /usr/bin/openssl
Sep  4 15:56:47 zentyal snoopy[3699]: [uid:111 sid:1275 tty:(none) cwd:/ filename:/usr/bin/openssl]: /usr/bin/openssl
Sep  4 15:56:47 zentyal snoopy[3701]: [uid:111 sid:1275 tty:(none) cwd:/ filename:/usr/bin/openssl]: /usr/bin/openssl
Sep  4 15:56:47 zentyal snoopy[3703]: [uid:111 sid:1275 tty:(none) cwd:/ filename:/usr/bin/openssl]: /usr/bin/openssl
Sep  4 15:56:47 zentyal snoopy[3705]: [uid:111 sid:1275 tty:(none) cwd:/ filename:/usr/bin/openssl]: /usr/bin/openssl
Sep  4 15:56:47 zentyal snoopy[3707]: [uid:111 sid:1275 tty:(none) cwd:/ filename:/usr/bin/openssl]: /usr/bin/openssl
Sep  4 15:56:47 zentyal snoopy[3709]: [uid:111 sid:1275 tty:(none) cwd:/ filename:/usr/bin/openssl]: /usr/bin/openssl
Sep  4 15:56:47 zentyal snoopy[3711]: [uid:111 sid:1275 tty:(none) cwd:/ filename:/usr/bin/openssl]: /usr/bin/openssl
Sep  4 15:56:47 zentyal snoopy[3713]: [uid:111 sid:1275 tty:(none) cwd:/ filename:/usr/bin/openssl]: /usr/bin/openssl
Sep  4 15:56:47 zentyal snoopy[3715]: [uid:111 sid:1275 tty:(none) cwd:/ filename:/usr/bin/openssl]: /usr/bin/openssl
Sep  4 15:56:47 zentyal snoopy[3717]: [uid:111 sid:1275 tty:(none) cwd:/ filename:/usr/bin/openssl]: /usr/bin/openssl
Sep  4 15:56:47 zentyal snoopy[3719]: [uid:111 sid:1275 tty:(none) cwd:/ filename:/usr/bin/openssl]: /usr/bin/openssl
Sep  4 15:56:47 zentyal snoopy[3721]: [uid:111 sid:1275 tty:(none) cwd:/ filename:/usr/bin/openssl]: /usr/bin/openssl
Sep  4 15:56:47 zentyal snoopy[3723]: [uid:111 sid:1275 tty:(none) cwd:/ filename:/usr/bin/openssl]: /usr/bin/openssl
Sep  4 15:56:47 zentyal snoopy[3725]: [uid:111 sid:1275 tty:(none) cwd:/ filename:/usr/bin/openssl]: /usr/bin/openssl
Sep  4 15:56:47 zentyal snoopy[3727]: [uid:111 sid:1275 tty:(none) cwd:/ filename:/usr/bin/openssl]: /usr/bin/openssl
Sep  4 15:56:47 zentyal snoopy[3729]: [uid:111 sid:1275 tty:(none) cwd:/ filename:/usr/bin/openssl]: /usr/bin/openssl


But anyway, my question about creating certs from command line is more important.
« Last Edit: September 04, 2018, 02:06:57 pm by chunk.one »