- Feature Articles
- CodeSOD
- Error'd
- Forums
-
Other Articles
- Random Article
- Other Series
- Alex's Soapbox
- Announcements
- Best of…
- Best of Email
- Best of the Sidebar
- Bring Your Own Code
- Coded Smorgasbord
- Mandatory Fun Day
- Off Topic
- Representative Line
- News Roundup
- Editor's Soapbox
- Software on the Rocks
- Souvenir Potpourri
- Sponsor Post
- Tales from the Interview
- The Daily WTF: Live
- Virtudyne
Admin
Maybe he was referring to raid systems that in the past didn't allowed parallel reads?
Maybe you should read yours and some before you post.
Admin
Parasites? Someone has been playing a little too much Bioshock.
vindico - What Frank Fontaine felt
Admin
Really??? Every sysadmin I've ever known has had a company provided server at home, purportedly to "test installations of new server packages in their free time". Most of them have hosted websites on them for a personal profit.
Admin
Possibly he is, but lets look at this:
RAID 1 refers to a conceptual way of arranging data on disks. It hasn't changed. It's a concept. If the concept changes, they call it something else.
The RAID controllers have changed dramatically. If this was his intent, I would expect him to say something like: "RAID controllers have improved over previous designs" OR "RAID is now faster than it used to be"
Instead he stated that a single concept had changed that hasn't. Basically that's like me saying that RAID 5 is faster than it was ten years ago. When I actually mean, you can now run a RAID 5 configuration on faster drives with a faster bus on a faster server. Which one would be the correct way to say it?
Admin
Admin
Databases get disk-bound very easily - network and CPU just won't help, and neither will RAM if what you're querying won't fit.
in that order.
Anybody in this discussion heard of WAFL?
Admin
No way dude, that is like totally insane!
Lou www.privacy-news.us.tc
Admin
While the numbers may not be "interchangeable", they are directly proportional in almost every case due to the nature of our jobs.
Hardware / 2 == Software / 2
It's an inevitable decline.
Admin
users are only happy when they're making stupid meaningless requests, and developers are only happy when they're running poorly performing development code on live servers. ;-) (I'm a DBA by the way)
Admin
Which Moran? Dylan? Caitlin? Surely not Kevin...
Admin
Even assuming these were Velociraptors, order 10 drives like that is nothing compared to SANs and other enterprise hardware. So a few hard drives is nothing. And if they were standard consumer 7,200 RPM drives, then we're talking even LESS money.
Admin
Yes it was. We had this fellow entertain (i.e. torment) us with his "ideas" about "optimalization". What the story fails to tell you, is that the same fellow found a way to taunt Oracle into throwing a critical error every time a package was loaded into memory (instead of the more usual "Package state has been discarded" error). This fellow did not stop at this point, but kept on increasing optimalization by enforcing the Oracle instance to unload a package from memory once the execution flow of the called procedure was finished. In case you wonder, this is where my company started experiencing an insane turnover.
I have no idea how it is even humanly possible to make a living the way he did. I still cannot even grasp how he avoided all kinds of lawsuits due to this.
I have no love for Oracle (actually I loathe it), but this certain fellow made my up-until-then distaste for Oracle seem benign compared to what I feel now. If someone encounters this DBA, the only viable option, apart from homicide, is to tender their resignation.
Admin
Does anyone have the magazine article scanned? Seems like that would settle it.
Thought I'd mention that in case no one else does.
Admin
Sounds like that other guy I can't stand... Whatshisface again? Burle-something? Says the same sort of stuff that once WAS valid, in 1836 or so...
yeah, here's some: http://www.dba-oracle.com/t_raid.htm
Admin
Real world testing trumps theory. Especially when the theory is wrong.
People are inclined to believe what they read or believe in ideas instead of testing to see if it's really true.
The certified DBA read somewhere that this crazy RAID setup would help (or he was just padding his consulting hours) (or the whole story could be made up) instead testing different configurations himself and seeing what worked best in the real world.
Admin
Meanwhile, back in the real world...
Admin
If, as a sysadmin, you'd like to ship servers to your home, you should consider shipping a real life to your home instead.
Admin
You have to be careful handing out unqualified advice like "RAID-5 = unhappy users". We use RAID5 for practically everything and with our light load we have happy users, happy DBAs, and a happy SA.
Admin
In our SANs we've got huge write caches. Our writes are magnitudes faster than our reads. I'd assume in most decent raid configs you've got a similar situation.
Admin
Admin
The concept of the outer tracks of the disk giving better throughput than the inner tracks is perfectly valid - Pillar Data do exactly this on their storage hardware as part of the QoS system in the SAN. Even a quick and dirty test with a 7.2krpm SATA drive shows >100MB/s on the outside tracks and closer to 50MB/s on the inner tracks.
Of course once you start reading and writing from all over the disk at random, of course you'll see a penalty, but the idea of only using the outer tracks of 10krpm disks and adding more spindles should result in some pretty astounding performance.
Admin
The first moronity, foreshadowing all the subsequent moronity, was declaring that "the outer edge of the disk is fastest." Well, linear velocity, yes; but it's the same rotational velocity. I/O is the same rate regardless of which cylinder is being read.
Admin
Totally agree. The biggest moron in the story is Paul.
Admin
It might help to search by author. Start with the name "Mikkel."
Admin
I also don't understand why people don't benchmark these configurations before making assertions.
Admin
*moron
Yes the disk configuration is relevant but your statement lacks any understanding of the disk subsystem. I could put 100 LUNs on a single RAID-10 array and you would have horrible performance. Some times I wish some DBAs could be SAN admins for a couple months. :(
Admin
Imbecility on this scale should not be anonymous: if that guys managed to infect some "serious" publication with its "knowledge", his name should be made public.
Admin
True, but it is only the sequential read/write speed that get increased, not the seek time, and I think that the db would be limited by seek time in most cases.
And I still find the thought of doing raid on partitions interesting, but I can't imagine how the dba thought it would be faster then doing it on the entire disk.
Admin
Admin
so was he a mormon or a moron? I can't tell if you are being a jerk or just condescending
Admin
I can't say that I've ever arranged to have a developer tell management that the specs on the server weren't great enough, but then our database is puny and all of our applications run on the clients.
However I have inherited servers from work, especially as we virtualized. Of course this was back in the heady days of being a tenant and having my utilities included in my rent. Now I'm down to 2.
Admin
As a system administrator I'd say using Hardware RAID will accelerate the heck out of the system far more than any partitioning system. Plus having separate arrays (and battery backed cache controllers) for the OS/SWAP/Logs/Databases (if you really can push the boat out get separate array for tables). Additionally if you can ensure that you have enough PCI(e/X) lines so that you don't have a bus bandwidth issue that's even better. Built one box a few years ago, three separate PCI-X buses, two cache controller and the network card on separate buses system ran sweet, front screen access was slow though.
Admin
I don't think that sarcasm was warranted but massive respect for getting Keving Moran into a TDWTF comment! :o)
Admin
Admin
Admin
This sounds like some of the articles that I've seen in MSDN and CodeProject. I can't count the number of times I've had to rip out code copied from one of these "expert" provided articles. Any idiot can write an article or a tech book apparently.
Admin
And for anyone who didn't get it, "moran" wasn't a typo, it was a reference to the internet meme:
[image]Admin
So TRWTF is that Paul allowed this total nonsense article to go out in a trade magazine, read by other DBAs, perpetuating a myth about partitioning.
How was Paul supposed to stop it? The article doesn't even claim Paul knew about it in advance of publication.
Yeah, blame him for not knowing the incompetent DBA was going to publish something and somehow stopping him (how?).
Good call, there.
Admin
Did a bot just get past the capcha software? This definitely looks like advertising bot spam.
Admin
I think you mean he was a morOn...
Admin
Sorry, but I've seen stuff submitted to CS journals and been to CS conferences, and most of the bullshit I see there wouldn't pass the laugh test at even a low end hard science journal (physics, chemistry, biology, etc).
Admin
A moran? The irony here is thrilling
Admin
The purpose of this article was what???
Admin
Admin
Not sure what SANs you've been using, but the ones I've come into contact with actively work to optimize data storage based on performance profiling, moving data where appropriate to ensure that you get as good performance as possible.
Admin
All the partitioning BS is moronic, but I always thought that using only the outer 25% actually does help boost performance, known as "short-stroking."
Admin
Am I the only one to question the 'Certifiable DBA's' claim that the "outer ring" was the only decent usable space on the drive because it is furthest distance from the center?
True, a point on the outside of the disc travels at a greater linear speed than a point nearer the center, but both points travel at the same angular velocity 7,200 or 10K rpm.
Not only does this DBA know more (or so he thinks) than the sysadmin, he also knows things about platten hardware manufacturing than Maxtor and Seagate.
Hey Mr. DBA, when you were 12 and listened to vinyl records, (remember those things with one loooooong spiral groove?) did you only listen to the first song because the others were considered of 'impure quality'?
Admin
Have none of you seen that photo floating around the internet?
It was even linked to already, just scroll up a bit.
Admin
Started as a sysadmin, many many moons ago, then started doing DBA work with Oracle 5.1, then backup in SAN and sysadmin work.
RAID-5 bad for Oracle, not true. At one time Oracle published that, but later removed that statement.
What RAID-5 is bad for is small sequential writes to a file that you never go back and read.... Hey that sounds like just like an on-line redo log! To make matters worse is when someone takes a large number of physical drives and puts them in one RAID-5 set. All the extra reads to then compute parity will kill you.
It's not just Oracle, I had someone put an Exchange server and it's database on a SAN I controlled. He claimed he need at least 14 drives in the RAID set to get good performance. The array by default only used 4 drives in a RAID-5 set because of how the back end end data channels worked. The thing was many times faster than any of his other setups where he setup a RAID array himself.
The biggest issue I have seen and still have to deal with my local DBAs is the the difference between a mount point they see and physical spindles. The Oracle doc just doesn't make this clear. Now add in all the other layers of volume managers, SANs, LUNs, RAID sets, and it gets confusing for them fast.
Not saying that all DBAs are the problem, a SAN guy recently didn't understand the issue either and he would create a BIG RAID set, then break that in into a few LUNs. Each of these LUNs went to a different database on different servers. So heavy IO on server A hurt server B. With the DBAs and customers screaming, one week that he was on vacation we moved a few LUNs around and fixed the problem.
He still doesn't understand why what hid did caused a problem.
It real simple
(usable space) * (performance) * (easy admin) / $$$$ = a constant.
Admin
Lol @ those commenting about linear/rotation velocity. In say, 1/4 of a rotation, where will the head cover more surface? Inside? Outside? Doesn't matter? The only way reading/writing would have same speed on the inner rings as the outer rings would be if packing density on the rings varied. While this would make the reading/writing speed constant, it would also be a waste of disk area if the head can support reading more at those speeds (7.2, 10k).