LinuxQuestions.org - Musings on technology, philosophy, and life in the corporate world

Hi. I'm jon.404, a Unix/Linux/Database/Openstack/Kubernetes Administrator, AWS/GCP/Azure Engineer, mathematics enthusiast, and amateur philosopher. This is where I rant about that which upsets me, laugh about that which amuses me, and jabber about that which holds my interest most: *nix.

24 divided by 4 is not an integer power of 2! (WTF Microsoft?)

Posted 10-27-2009 at 06:08 PM by rocket357 (Musings on technology, philosophy, and life in the corporate world)
Updated 10-27-2009 at 06:38 PM by rocket357

Today I discovered quite possibly the most WTF of all quirks in a Microsoft product...the power of 2 failures in SQL Server 2005.

To back up, my company has a ton of aged Win2k SQL Server 2k machines that are about to fall apart. Some time ago, we got permission from the execs to spend around $35k on a server that would replace them all. So we purchase a new machine: 4 sockets (each socket stuffed with a 6-core Xeon), 64 GB of RAM, and 30+ 15k SAS disks. It's on par with the top...

rocket357

Member

Posted in Microsoft Rants

Views 3658 Comments 2 rocket357 is offline

Stupid little konsole trick

Posted 10-07-2009 at 03:21 AM by rocket357 (Musings on technology, philosophy, and life in the corporate world)
Updated 10-27-2009 at 06:41 PM by rocket357 (doh..."ksh-ism"...)

Ok, so I have a dual-head setup at work (running OpenBSD-4.6), and I am usually ssh'd into dozens of machines at a time. My desktop tends to look like a fuster-cluck of aterms.

So I discovered a cool little trick with konsole. Using dcop, you can open new terminals as a new session (tab) in an existing konsole window and then send commands to said sessions (and even rename the sessions to match what commands you sent to it).

But, there's only one problem. I'm running...

rocket357

Member

Posted in OpenBSD

Views 3005 Comments 0 rocket357 is offline

PostgreSQL - installation/configuration/benchmarking - on Dell servers Part II

Posted 03-27-2009 at 08:02 PM by rocket357 (Musings on technology, philosophy, and life in the corporate world)
Updated 10-27-2009 at 06:44 PM by rocket357

(Continued from this blog post)

Now test the setup:

Code:

linux ~ # hdparm -tT /dev/sdc

/dev/sdc:
 Timing cached reads:   11464 MB in  2.00 seconds = 5739.66 MB/sec
 Timing buffered disk reads:  1816 MB in  3.00 seconds = 604.39 MB/sec

Looks good. Now let's format the partition:

I like xfs. I use xfs. You might not...so run "man mkfs.<your_favorite_filesystem>" to read up on how to convert...

rocket357

Member

Posted in PostgreSQL Stuff

Views 5032 Comments 0 rocket357 is offline

PostgreSQL - installation/configuration/benchmarking - on Dell servers

Posted 03-27-2009 at 07:20 PM by rocket357 (Musings on technology, philosophy, and life in the corporate world)
Updated 12-31-2009 at 10:44 PM by rocket357

Dell has historically had a pretty low-end line of RAID cards (the PowerEdge Expandable RAID Controller, or PERC for short) that have required tons of time and care to get them operating at a reasonable level. This blog post will cover my experiences with the PERC6/E line of cards (which aren't that bad, especially compared to previous versions) and how to get optimal performance out of them on Dell 1950/2950 machines, as well as PostgreSQL general configuration.

DISCLAIMER: I don't...

rocket357

Member

Posted in PostgreSQL Stuff

Views 4124 Comments 0 rocket357 is offline

Remote management of Linux systems via Python and ssh (Part 2)

Posted 02-03-2009 at 08:44 PM by rocket357 (Musings on technology, philosophy, and life in the corporate world)
Updated 10-27-2009 at 06:50 PM by rocket357 (modified code)

My last blogpost on Python/SSH seemed to be popular, so here I am again with a more in-depth look at what can be accomplished with this pairing.

To recap, I manage 300 databases, some M$ SQL Server, some PostgreSQL. There are a ton of Apache/Linux machines on our network and quite a few "traffic cops" based on Linux and BSD (as well as a few Cisco machines) for routing external traffic to internal machines. Pretty standard stuff. The IT department has a director, a network...

rocket357

Member

Posted in Python

Views 6203 Comments 0 rocket357 is offline

Page 35 of 38

« First

Last »