Doh! Forgot earlier in the night, so here you are... technically Saturday.

CPU:

The lemmy devs have made some major strides in improving performance recently, as you can see by the overall reduced CPU load.

Memory:

I need to figure out why swap is continuing to be used, when there is cache/buffer available to be used. But as you can see, the upgrade to 8GB of RAM is being put to good use.

Network:

The two large spikes here are from some backups being uploaded to object storage. Apart from that, traffic levels are fine.

Storage:

A HUGE win here this week, turns out a huge portion of the database is data we don't need, and can be safely deleted pretty much any time. The large drop in storage on the 9th was from me manually deleting all but the most recent ~100k rows in the guilty table. Devs are aware of this issue, and are actively working on making DB storage more efficient. While a better fix is being worked on, I have a cronjob running every hour to delete all but the most recent 200k rows.

Cloudflare caching:

Cloudflare still saving us substantial egress traffic from the VPS, though no 14MB "icons" being grabbed thousands of times this week 😀

Summary:

All things considered, we're in a much better place today than a week ago. Storage is much less of a concern, and all other server resources are doing well... though I need to investigate swap usage.

Longer term it still looks as though storage will become the trigger for further upgrades. However storage growth will be much more slow and under our control. The recent upward trend is predominantly from locally cached images from object storage, which can be deleted at any time as required.

As usual, feel free to ask questions.

There have been quite a few posts in the Australia community about the upcoming referendum and naturally invite a variety of views and (mostly) interesting conversation.

Since Lemmy has nothing equivalent to post 'flairs' at this stage I think it would be helpful to have a community where people can discuss, ask questions about, share news about or share their views on the proposed constitutional amendment. The dedicated community should be changed to only allow moderators to post after the referendum is completed.

With all the talk about lemmy.ml defederating from threads I’ve been wondering what Aussie.zone’s stance is on the matter.

Noting this here for my own reference, and any other lemmy server admins that don't happen to be database administrators by day 🙂

I am not a DBA, if I'm doing something bad/incorrect here... please post! Yes, I've reset the password and TOTP token on the example account below.

2FA flags are stored in the local_user table, however that does not show usernames. To find the person_id for the user account you want to disable 2FA for, you'll need to check the person table. I'll use my test account here as an example:

SELECT * from person where name = 'guineapig' and local = 't';

Giving:

Note the number 781227, this is the person_id for this account on my instance. To confirm:
SELECT * from local_user where person_id = '781227';

Yep, the 2FA string has the expected username in it. Now to disable 2FA on the account we need to NULL out both totp_2fa_url and totp_2fa_secret rows:

UPDATE local_user  
SET totp_2fa_url = NULL  
WHERE person_id = 781227;  

UPDATE local_user
SET totp_2fa_secret = NULL
WHERE person_id = 781227;

Should give output like this:

And checking the local_user table again, both TOTP fields should be empty:

I'll be upgrading lemmy to 0.18.2 shortly. Expect a minute or so downtime.

Hey I mod the adhd_australia on reddit. Can we set one up with the same name here? I'd like to direct people here as an alternative. Don't want it to be confused with other general ADHD Lemmee communities.

Could probably do with one for Autism or ASD too.

More Graphs in the post Users: 1,613 Last 6 months active users: 610 Last month active users: 608 Posts: 1,679 Comments: 18,775

The server will be undergoing a reboot shortly to add additional RAM.

https://sh.itjust.works/post/923025

Could we get a community set up for all things coffee? There are a couple around Lemmy already, but thought there should be an aussie based community to discuss local roasters, share set ups and not wonder why everyone is posting summer drink ideas during our winter.

Happy to help moderate if needed.

I've tried signing into Memmy using:

• Server: aussie.zone
• Username: @blendedracer (as shows on my profile page)
• Password: blah blah

And it throws an error, saying it "couldn't_find_that_user-name_or_email". Should I be formatting the server and/or username differently?

I'm new to Lemmy & Aussie.Zone and have been doing some reading to better understand how it all works.

One thing that came up was that each Lemmy instance has the ability to block other instances.

I just wanted to know, does Aussie.Zone block any other instances? If so where can we see a list of these?

Just saw this posted in another thread.

A new tool for instance relocation if you wish. If you're impatient before it is officially supported.

Another week... another set of nerd graphs!

CPU:

Some of the variations in CPU usage in the last week correlate with upgrades to the lemmy software. If you look closely, you can see a drop in CPU usage starting late on Thursday, this was when I upgraded to 0.18.1-rc.10 which includes some major DB query optimisations.

Memory:

The spikey memory utilisation between the 28th of June and the 4th of July were due to a lemmy software issue. It resulted in huge resource consumption for varying amounts of time, before returning to normal. This specific issue seems to have been resolved in one of the upates this week.

Network:

The unusually high traffic levels between the 1st and 4th were caused by a large community icon.. 14MB. Thankfully, Cloudflare saved us by caching this file and saved us ~800GB of traffic on this file alone before it was shrunk to a more appropriate size 🙂

Storage:

As expected, disk space is being used up at a relatively consistent rate. The drop on the 28th was when cached object storage images were deleted due to a server reboot that was required when adding 2 vCPUs. I have a scheduled job that runs every hour to delete cached objects older than a threshold. As the disk used by the cache increases (or the disk gets closer to being full), I'll decrease the age threshold.

Cloudflare caching:

Cloudflare caching is saving us a lot of egress traffic. It is saving us less since the 14MB "icon" was shrunk, however this shows the value in the service. Even now, it is saving ~40GB of egress traffic per day.

Summary

Everything is looking pretty good right now, thanks mostly to the ongoing improvements in lemmy making things run more smoothly. In the next week or so I'll be upgrading the storage on the VPS to cater for the ever increasing database. Admins are already discussing ways we can manage the increasing storage requirements, I'm optimistic we'll have good solutions before we hit a VPS scaling limit.

As always, happy to answer any questions.

Noticed they are quite a large server with similar rules to ours (Be respectful, no bigotry, no porn, etc). Looking at their front page, it seems pretty tame, just anti-capitalist memes and discussion. Is there a reason we have blocked them?

About to upgrade aussie.zone to lemmy 0.18.1-rc.10 and lemmy-ui to 0.18.1-rc.10. This includes some substantial database improvements.

I'll unpin this once down... expect 2-3 minutes downtime.

Would it be possible to create a community called ServiceNow?

As reported to the lemmy devs here there is no sanity checking of links in posts currently in lemmy. Please be careful in the links you click!

Further discussion and context from the reporter here.

As far as I'm aware, these 2 communities should be kept identical by federation. The first link shows 4 posts, but the second link shows 0 posts.
What could be done to fix this?

https://lemmy.ml/c/nissan_leaf
https://aussie.zone/c/[email protected]

cross-posted from: https://aus.social/users/ajsadauskas/statuses/110663331294822520

Here's a quick tip for folks on Aussie.zone who are new to Lemmy.

As well as appearing on Lemmy, your posts and replies are visible across all the apps on the Fediverse.

That includes Mastodon, KBin, Calckey, and others.

If you want more people to see and reply to your comments and replies, make sure you include a hashtag e.g. #AFL [#AFL](https://aus.social/tags/AFL)

It makes your posts/comments/replies easier to find across all the Fediverse apps.

@[email protected]

Edit: Testing simple tags with this post - https://aussie.zone/post/297508 - doesn't work. They may need to be hyperlinked. Testing a hyperlinked edit into post also does not appear. This may be fake news, it may only work Mastodon into Lemmy, not out.

need pics n stuff? Some cursory steals from the net

Icon -

Banner - https://www.icentralcoast.com/images/central-coast-best-beaches-avoca-100.jpg

A photography community would be nice to see. Not that I’m looking to step up and mod it.

Loved the old reddit one for good deals and recipies and stuff. I think there are a few on other instances but none seem to have taken off.

These communities might be/stay small, but tend to contain very useful information to those looking for it.