-

Tue, 25 Oct 2022 20:16:34 +0200 Expires: Sun, 23 Apr 2023 20:13:00 +0200

When my (streams)stream takes 10 to 20 seconds to load I should do:

show all 10 Comments

Wed, 26 Oct 2022 19:57:42 +0200

I had 2GB RAM and gave it another 2GB. That made a huge impact. Also I had done some MYSQL tuning, but there I am not that sure what I am doing (hopefully mysqltuner.pl knows). But, it works much better now. Thank you very much for your hints.

st.reams (closed instance)

Mon, 21 Nov 2022 16:20:25 +0100

O dear, it is slow again since some weeks now... I have seen, there have been some database updates, which should be installed manually? At the moment I got back to 1262, in the GUI there is something to do for 1261, but I guess that could not applied because I am on 1262. I have updated to 1263, then there have been DB updates for 1261 and 1263. But still, 1261 isn't working (obviously, if I understand that correctly), and with 1263 I get a 504 error.

How could I apply this DB updates now?

Oliver

Mon, 21 Nov 2022 16:37:40 +0100

Fun fact: If I go to /admin/site and just click on "save" somewhere, after that the stream loads very fast

st.reams (closed instance)

Mon, 21 Nov 2022 16:51:32 +0100

That's funny. It doesn't work on my side, but lucky you. Did you do the DB updates manually?

Adam Robertson

Mon, 21 Nov 2022 18:46:07 +0100

I have my Streams instance hosted on a Vultr VPS (one of the $3.50/month VPS). My mariadb server is on a seperate VPS (same type) and they have a private network between the two.

Once I switched over from having db server and webserver on the same VPS the performance increased quite a bit, even though both VPS are low-end.

I also have my email/jabber server on yet another VPS, which solved some other issues I was having. Going forward I will probably try to keep my various services separate like this, as it makes administration easier and fixes some performance issues ( and I think adds some security, but that might just be an illusion..not sure internet security exists anymore)

Oliver

Mon, 21 Nov 2022 18:58:43 +0100

@st.reams all DB updates went fine so far via regular updates

st.reams (closed instance)

Mon, 21 Nov 2022 22:04:15 +0100

This is also very tempting, having the DB server for various services on a dedicated device. This is really something I should try in the near future.

Oliver

Thu, 24 Nov 2022 09:21:13 +0100

@st.reams Another option (works very well for me):
admin/site/
Expiration period in days for imported streams and cached images: 14

st.reams (closed instance)

Thu, 24 Nov 2022 17:48:00 +0100

Thanks, I will test this settings.

st.reams (closed instance)

Thu, 24 Nov 2022 17:49:34 +0100

Meanwhile the error with 1263 is gone, still there is the upgrade 1261 available, but doesn't work via GUI.