Sysadmin Mega Thread

Oh yeah def.

The stock heatsink actually did a pretty good job. The server still idles at the same temp as it did with the stock, however, I expect the real gains to be when it is under full load it will stay within thermal margins to maintain all-core max boost clock of 2.9 GHz.

1 Like

Oh, maybe.

We might need to adjust your title to “vue shill”

I imagine it’s designed to do exactly good enough.

Tbh it’s mostly those fans. They were dummy thicc.

Those things on full tilt are like a ram jet

OP delivers.

@SgtAwesomesauce

BTW: it also works without issues so now I’m going to load up.

3 Likes

when it clicked

:sweat_drops:
:sweat_drops:

1 Like

thanks babe :stuck_out_tongue:

Anyone use manageiq?

Ordered two more sticks (32GiB)

It has begun.

2 Likes

I spent 4 hours building a fucking query for the business team to do some analytics.

I get it working perfectly and one guy jumps on slack, on his phone, assuming that the query doesn’t work and will return duplicates, by UUID.

I tried to explain the query to him. He didn’t understand. I offered to hop on a call and explain it. He wasn’t available.

Finally, I just gpg’d the results over, told him to look at this:

cat Result.csv  | cut -d \, -f 1 | uniq -d

I’ve knocked over every conditional and he just says “it’s still not right”

How the fuck is it not right? Because I used subqueries the way he doesn’t like? I returned the right data. I didn’t lock the database. I didn’t knock it over trying to process half a billion records.

time to let my anger out on the iron

4 Likes

Iirc, uniq only works on sorted lists?

1 Like

Ahhha, SQL queries.

Do you ever get that one guy who writes huge sequential queries? Because your database is on ridiculous NVMe storage and it can stream sequential scans at 6 GB/s and they’re all like, “What!? It doesn’t matter, it runs fast like it is.”

1 Like

the list is sorted by postgres.

But yes.

Either way:

cat Result.csv  | cut -d \, -f 1  | sort | uniq -d

Gave the same reults.

yay unix!


We don’t have super complex databases, so no.

But that would probably be me.

Just thicccccc row counts.

1 Like

select * always!

its much easier than typing out all those field names and who knows, you might need something later in the line of SQL you’re writing :rofl:

1 Like

If any of you smart sysadmins have insight here, I’d appreciate it…

Trolling for protips -

Does anyone have suggestions or documentation for creating a SLES15 template in VMWare?

cotton

So, one thing I tried for the first time today that works (as it should, but neat).

Mixing Powershell and Unix CLI tools (on my Mac, but linux too)

e.g.,

PS /Users/jrose> get-vm  | select name,notes | ft | grep -i radius
per-w2k12-17                        Windows 2012R2 virtual machine for NPS (Radius)
per-w2k12-7                         Windows 2012R2 virtual machine for NPS (Radius)
PS /Users/jrose> 

nice, if you get a table you want and then just want to filter it for example :smiley:

Obviously grep works on the TEXT output of powershell and not on the object pipeline, but that’s fine sometimes :slight_smile:

Accidentally got a barebones server on ebay that’s incompatible with the E5v2 CPUs I already had to put in it, so now I’m getting E5v3 CPUs too.
Sadly also incompatible with the 80GB of DDR3 reg ECC I ordered to go with the 16GB I already have, so now I’m getting 128GB DDR4 reg ECC and that really hurts. :expressionless:
Anyone need some DDR3 server memory T_T

1 Like

GitLab 13.0 is going to ship May 22nd and is going to be an exciting release. One of the main features I am excited about is the security scanning like how GitHub does it.

Kickoff Review

Breaking Changes

2 Likes

I’ve had luck buying directly from Unix Surplus. If they’re not too busy, they’ll spec something custom for you and they readily have compatibility info on their units.