I love it when you find a SO Q/A where the accepted answer actually edits their answer and says "I'm not right, you should accept this other guy's answer", the other guy's answer has like 15x more votes... and the original answer is still accepted.
I need to create an index on a ~5M rows mysql table. It is a production table, i fear a complete block of everything if I run a CREATE INDEX statement...
Is there a way to create that index without blocking inserts and selects ?
Just wondering I have not to stop, create index and restart my sy...
@TheCleaner I would say "no," but at the same time, we're not a vendor-support substitute. "Minimal understanding" is the close reason to use for questions where the OP has no support, and doesn't know the gear well enough to troubleshoot it.
Damn @EvanAnderson is answering Windows questions slightly faster than me again today. >:/ If this keeps up, I'm serious danger of actually working at work today,
Hmmm... I should start a kickstarter for node.js-as-a-service. Cloud-node.js seems like it should make a fortune while doing nothing and requiring no effort.
+1 for so many things in that answer. Didn't realize the P600 was so old, but I guess HP support told him he was a really funny guy, having that RAID setup.
RAID5 isn't life support for servers, it's like smoking for servers. Only it doesn't make servers look cool. Or give them a nicotine buzz. And it kills faster.
Dear people of the internet: only run your important stuff on hardware that has a support contract (or an on-premises supply of spare parts and people capable of doing the repairs).
The time to plan the retirement of a server is when you purchase the server.
@freiheit Yeah, that's why I don't plan server retirements. Because if I'm still working at the same place in 5 years, I'm gonna blow my brains out instead.
@HopelessN00b Well, to be honest, we do it on an annual basis, around the fiscal year... A bit before the start of our FY, I look at the hardware that "expires" over the next 5 quarters and we plan what to do with it...
The simple reality of IT is that it's a constant refresh churn for servers and desktops.
@HopelessN00b The butt is (theoretically) a good way to outsource the hardware support stuff...
@freiheit Well, it should be, at least. I can verify, from first-hand experience, that a big, huge chunk of the world doesn't do it the way it should be done.
@HopelessN00b I was just having a related discussion this morning with some co-workers about this...
Setting up your own server outside of the IT dept is so much easier than getting IT to to it for you, because you ignore all of the things that IT/sysadmins actually do (patching, maintenance, security, h/w refresh, OS refresh, application refresh).
if it's tar.gz: gz is not a deterministic output format
dennis@spirit:/tmp$ date > foobar
dennis@spirit:/tmp$ tar c foobar | md5sum
4045830733621e1d6fbfcbfe3960bda9 -
dennis@spirit:/tmp$ tar c foobar | md5sum
4045830733621e1d6fbfcbfe3960bda9 -
dennis@spirit:/tmp$ tar c foobar | gzip | md5sum
06ee1220e8f6111d5bfd06f7d353781b -
dennis@spirit:/tmp$ tar c foobar | gzip | md5sum
8ec2118fdb7c6f82551421b435864943 -
-n --no-name
When compressing, do not save the original file name and time
stamp by default. (The original name is always saved if the name
had to be truncated.) When decompressing, do not restore the
original file name if present (remove only the gzip suffix from
the compressed file name) and do not restore the original time
stamp if present (copy it from the compressed file). This option
is the default when decompressing.
@MichaelHampton "Typing." In his defense, on boot, it throws an inaccessible boot device error, so it probably is something Bitlocker did.
Or, more accurately, something we made Bitlocker do, because our CIO/CTO is a dumbass, who's treated like head janitor, and is desperately trying to impress our monumentally fucktarded board of directors...
@MichaelHampton Well, can't say for sure, but lemme show you the command we're using on account of those politics, and see if you can guess where it may have gone wrong.
Bingo. But then that would require a reboot before we could start encryption. And that would mean that the deployment would "take too long," as in: the CTO couldn't honestly say all our laptops are encrypted at the next board meeting.
Though it certainly helps if you can do some of this math in your head. For instance, if your extents are 4MB, and you have a 2048 extent LV, then how much space is that? No calculator!!
@MichaelHampton because the masses get all pissy when they're told that they have no say in the political system, and pissy masses make the political authorities nervous.
@Wesley Dennis Nedry: [laughs] I am totally unappreciated in my time. You can run this whole park from this room with minimal staff for up to 3 days. You think that kind of automation is easy? Or cheap? You know anybody who can network 8 connection machines and debug 2 million lines of code for what I bid for this job? devops
The Chevrolet Traverse is a seven or eight seat, full-size crossover SUV built on the GM Lambda platform that underpins the GMC Acadia and Buick Enclave. It is a successor to both the Uplander and TrailBlazer EXT. The Traverse was built in Spring Hill, Tennessee from its introduction until late 2009, when production was moved to the same Delta Township Assembly plant in Lansing, Michigan that produces the other Lambda-platform crossovers as a replacement for the Saturn Outlook because of GM phasing out the Saturn brand. However, Saturn Outlook production resumed for a short time during early 2010...
@TomO'Connor Ugh, I hate those fucking rental car categories. The people who made them clearly have no idea what a premium, luxury, or sports car actually is.
We were trying to get USB passthrough to work, but vmware didn't like the USB drive for whatever reason (it's the Autodesk proprietary one, apparently)
So i ended up sharing the entire drive so we can install the license server on a server, lol
I'm so witty to include that Youtube link...I crack myself up
"university hypothetical project (That won't be realized) in which they propose a set of needs and the students in groups work to define a solution." If that's the case, then why not tell them the price is $(insert made up price here)? youtube.com/watch?v=YlVDGmjz7eM Or call CDW or Tiger Direct and ask them as if you were buying. — TheCleaner1 min ago
I need this for a university hypothetical project (That won't be realized) in which they propose a set of needs and the students in groups work to define a solution. Propose that you supply a pirated version. Cost of $0, and/or profit of whatever you bill the client for the software you supplied. — HopelessN00b15 secs ago
I like that one because of this part: Web Dude: This on call number is for emergencies only, not application support! Chip: Well I'm telling you that this is an emergency, this is a, uh, customer facing issue. Web Dude: Sigh... just... what is it.
"YOU SALES GUYS THINK YOU CAN DO EVERYTHING WITH POWERPOINT! YOU'D PROBABLY BROWSE THE WEB WITH POWERPOINT!"
Yes I can quote almost every episode verbatim from heart. =)
Okay was I mean?
Downvoted because we don't do homework for people. — Wesley4 mins ago
I really miss the good ol' days, before everything went online... you know, back when students would try to improve their grade in a class by offering sexual favors to their professors (or people claiming to be their professors). Now, with all this "do my homework for me" activity online, I haven't gotten a good blowjob in I don't even remember how long. — HopelessN00b43 secs ago
Cronyism is partiality to long-standing friends, especially by appointing them to positions of authority, regardless of their qualifications. Hence, cronyism is contrary in practice and principle to meritocracy.
Cronyism exists when the appointer and the beneficiary are in social contact; often, the appointer is inadequate to hold his or her own job or position of authority, and for this reason the appointer appoints individuals who will not try to weaken him or her, or express views contrary to those of the appointer. Politically, "cronyism" is derogatorily used.
== Etymology ==
The word "crony...
And, keep in mind, that not all the moderators are in this chat room. If you aren't careful you'll find yourself face to face with one of the others...
@MichaelHampton face to face? How cool would it be to piss off an SE mod so bad that they show up at your work? That could make SE history right there!
@Wesley I just got done hunting through the neighbours rubbish bin for food cos the left the lid off and I'm pretty sure I stuck my nose in a dirty nappy, so yeah let's hugs!
I'd guess that the Produce companies are more worried about losing produce due to loss of refrigeration than about some computers going down the wrong way...
Driving here in April of 2010 there were ~7foot snow drifts against cabins in the mountains and then it was like 75 and sunny two hours later when we got into Phoenix.
@ewwhite I don't get why those are such a problem, honestly. Seems silly that in this day and age, the systems can't just mark that block/sector whatever as corrupt and move on to the next one. "Sector [foo] is unreadable, file(s) [snorf] are corrupt, continueing."
@HopelessN00b I'm sure I could find a decent setup for a few thousand. I just have to convince the powers that be it that it's worth spending it instead of just sticking with our Western Digitial Passport from Newegg or whatever.
We're currently using RDX here. Much easier to start with (the drive is cheap), but the media's expensive. Works if you have little data and/or short retention.
@kce Enh. Well, to play devil's advocate/argue the business case, that's actually a good enough solution, so long as you verify your back ups, and then copy them off to something else (copy not mirror) - can even be another USB drive you keep offline, in a different location (except for when you're copying to it). Did that for years at a previous job. Worked fine. Except for th apin in the ass of manual copying and hooking up the USB drive every day.
Over a period of three weeks, I experienced six complete failures of LTO-1 and LTO-2 tape drives at client sites. Some had failed mechanisms. Others lost the ability to write reliably. These were HP Ultrium 232, 448 and 460 drives. Most of these units were deployed between 2006 and 2008, so the t...
I looked at tape libraries on eBay a while back, but at the end of the day two NAS's with a 20MB link between them was a whole lot less physical work and was cheaper
@kce Definitely the better option, then. I've also found that women get less crazy as they get older, so I tend to prefer cougars to women my age... or, heaven forbid, younger than me.