Slashdot Mirror


George Takei Helps Facebook Troubleshoot MySQL

miller60 writes "Actor George Takei recently helped the Facebook infrastructure team troubleshoot issues with its MySQL databases. Takei, a veteran of the original Star Trek series, now has more than 1.2 million fans on Facebook. Takei recently noticed that some status updates were missing or appearing inconsistently. That led to a dialogue with the Facebook Engineering team, which gave Takei a shout-out on its latest blog post, which also included some technical discussion of Facebook's challenges in scaling MySQL (a topic of previous discussion here at Slashdot)."

86 comments

  1. Facebook only listens if you're famous, apparently by Anonymous Coward · · Score: 5, Insightful

    People have been reporting these problems for months, if not years.

  2. Worst association ever... by arse+maker · · Score: 5, Insightful

    He helped troubleshoot? Seems like devs were just following him and reading his posts saying something was wrong.

    Not only that, they only took interest because they knew of that issue and were already working on it.

    In that case every user on facebook is helping to troubleshoot MySQL.

    1. Re:Worst association ever... by Eponymous+Hero · · Score: 2

      agreed, this headline is absolutely stupid. the real story was a day-in-the-life of facebook's engineering team, and in passing, toward the end, Takei is briefly mentioned. and he's only mentioned because this particular engineer recognized Takei apart from the other millions of users. and if it wasn't Takei it would have been some other celebrity. as he said, they were already aware of the issue. this headline is a cheap pandering to sci-fi tastes to get attention, because any headline with the word facebook in it better be justified. this one wasn't. notice how the blog's headline doesn't mention Takei at all. without reading it you'd never know, and probably still don't care.

      --
      insensitive clod overlords obligatory xkcd car analogy russian reversals whoosh pedant fanbois ftfy in 3...2...1..PROFIT
    2. Re:Worst association ever... by fuzzyfuzzyfungus · · Score: 4, Funny

      What they didn't mention, for competitive reasons, are the parts of their datacenter now running MySQL on 23rd century technology, helpfully provided through some sort of plot hopefully less lame than that one with time-travel and whale extinction...

    3. Re:Worst association ever... by sjames · · Score: 2

      He did what technical people WISH more users did: He reported the probvlem clearly, characterizing exactly what was going wrong and didn't throw in a metric assload of obvious irrelevancies. That *IS* quite helpful.

      "It doesn't work!" = not terribly helpful.

      "I entered xyz test in the title box, abc in the body box, and clicked submit and it said error 2343" (and none of that is correct) = not at all helpful.

      Same as above, but the information is correct = very helpful

      Same as above but add (for about 30 minutes) "I think it might be because I gave my car beefy delight instead of seafood surprise! He's not as fond of beefy delight you know, I think it's definitely fish related. NO, wait a minute, I had a tuna sandwich on wheat bread, so that's not it, do you think I should try rye bread tomorrow? Or maybe I should give Jake (he's my cat you know, it's kinda funny because my best friend's uncle's auto mechanic's brother is named Jake, but I don't think that caused the bug) Well, anyway, should I try giving Jake Chicken? Do you think that will help? I could try another mouse, I think Jake batted this one off the desk yesterday, I tried washing it in the dishwasher, but I'm not sure that helped. I can ......." = *REALLY* not helpful! Just get a life PLEASE!

    4. Re:Worst association ever... by bill_mcgonigle · · Score: 2

      Oh, come now, Sulu was helmsman, not engineering.

      --
      My God, it's Full of Source!
      OUTSIDE_IP=$(dig +short my.ip @outsideip.net)
    5. Re:Worst association ever... by Anonymous Coward · · Score: 4, Funny

      The great thing about George is you actually think for a second that maybe he knows MySQL, and are disappointed. If the headline was "Chuck Norris Helps Facebook Troubleshoot MySQL" then you'd know it wasn't with the code.

      Remember that: George Takei beats Chuck Norris.

    6. Re:Worst association ever... by FrootLoops · · Score: 3, Interesting

      I'm pretty sure the whole whale plot was intentionally silly. I view Star Trek IV as an experiment in something different and funny/oddball ("Nuclear Wessles", "Cap'n, there be whales here!", "[Said into mouse] Hello computer", etc.). It contrasts well with Star Trek II and III which were both very serious/dramatic (especially II).

      If you want a truly flimsy TOS-era plot, there's always Spock's Brain and its many ridiculous moments

      .

    7. Re:Worst association ever... by antdude · · Score: 1

      It reminds me of him being a project manager (PM) in the previous/last Celebriity Apprentice episode. :P

      --
      Ant(Dude) @ Quality Foraged Links (AQFL.net) & The Ant Farm (antfarm.ma.cx / antfarm.home.dhs.org).
    8. Re:Worst association ever... by jd2112 · · Score: 4, Funny

      Oh, come now, Sulu was helmsman, not engineering.

      He want fixing the problem, just pointing them on the right direction.

      --
      Any insufficiently advanced magic is indistinguishable from technology.
    9. Re:Worst association ever... by tverbeek · · Score: 1

      If I had users who were half as helpful in reporting problems as Mr Takei was in this instance, I might like my job.

      --
      http://alternatives.rzero.com/
    10. Re:Worst association ever... by Anonymous Coward · · Score: 3, Funny

      Same as above but add (for about 30 minutes) "I think it might be because I gave my car beefy delight instead of seafood surprise! ...

      Car analogy fail!

    11. Re:Worst association ever... by JamesP · · Score: 1

      Well, call me when Brent Spinner helps debug MySQL

      --
      how long until /. fixes commenting on Chrome?
  3. Actually Takei just called Scotty, who said.. by Anonymous Coward · · Score: 0

    Mr. Sulu, the database, she canna take no more of this stress!

    And Sulu said "The Captain says you fix it or we all die!"

    But fortunately, Spock was there, for some reason, to help. Unfortunately, it was also Pom'Far time, and well, Ensign Rand was on her period, so...

    1. Re:Actually Takei just called Scotty, who said.. by Rene+S.+Hollan · · Score: 4, Informative

      Pon farr not Pom'Far.

      --
      In Liberty, Rene
    2. Re:Actually Takei just called Scotty, who said.. by geekoid · · Score: 1

      Jamie Farr

      --
      The Kruger Dunning explains most post on /. http://en.wikipedia.org/wiki/Dunning%E2%80%93Kruger_effect
    3. Re:Actually Takei just called Scotty, who said.. by Anonymous Coward · · Score: 5, Funny

      I'm vaguely disturbed by your knowledge of Vulcan sexuality.

      I'm even more disturbed by how you got a +4 informative.

    4. Re:Actually Takei just called Scotty, who said.. by Lije+Baley · · Score: 1

      I thought it said "Porn'Far" and I was OK with that.

      --
      Strange things are afoot at the Circle-K.
    5. Re:Actually Takei just called Scotty, who said.. by Anonymous Coward · · Score: 0

      Rand was a yeoman.

    6. Re:Actually Takei just called Scotty, who said.. by Anonymous Coward · · Score: 1

      Porn Star

    7. Re:Actually Takei just called Scotty, who said.. by Rene+S.+Hollan · · Score: 1

      +5 LOL :-)

      --
      In Liberty, Rene
    8. Re:Actually Takei just called Scotty, who said.. by Zontar+The+Mindless · · Score: 2

      Rand was a yeoman.

      She started out as one, yes...

      --
      Il n'y a pas de Planet B.
    9. Re:Actually Takei just called Scotty, who said.. by Sulphur · · Score: 2

      Mr. Sulu, the database, she canna take no more of this stress!

      And Sulu said "The Captain says you fix it or we all die!"

      But fortunately, Spock was there, for some reason, to help. Unfortunately, it was also Pom'Far time, and well, Ensign Rand was on her period, so...

      Later Spock served spaghetti. Its the logical thing to do.

    10. Re:Actually Takei just called Scotty, who said.. by Sulphur · · Score: 3, Funny

      I'm vaguely disturbed by your knowledge of Vulcan sexuality.

      I'm even more disturbed by how you got a +4 informative.

      I find your lack of faith in the +4 th disturbing.

  4. Re:Facebook only listens if you're famous, apparen by stonedcat · · Score: 4, Funny

    But they weren't Sulu.

    --
    You can't take the sky from me.
  5. Not so much by Dogtanian · · Score: 4, Informative

    From reading the links, it sounds like Takei had some problems, and reported them to the Facebook team with some helpful to-and-fro exchange of information (i.e. giving them a useful bug report) before they fixed them in the usual manner.

    No disrespect to him intended, it just sounds like someone is trying to make this story sound like a bigger deal than it is. The Slashdot headline doesn't help, compounding the misleading impression (probably intentionally) that Takei was sitting alongside the Facebook techies debugging nested right joins.

    --
    "Slashdot - News and Chat Sites Deviant". (Click "homepage" link above for details).
    1. Re:Not so much by jd · · Score: 5, Insightful

      Do you know how rare *good* bug reports are?

      --
      It's a small world and it smells funny; I'd buy another if it wasn't for the money; Take back what I paid (SoM)
    2. Re:Not so much by Dogtanian · · Score: 2

      Sure I know how useless bug reports (and reports of problems in general) can be coming from the man on the street- hence why I mentioned the word "useful", realising that Takei still probably has more technical competence than most people. (Assuming they didn't slant the story that much and his bug reports *were* useful!)

      Still, the angle of this story is a somewhat poor attempt to give a misleading impression.

      --
      "Slashdot - News and Chat Sites Deviant". (Click "homepage" link above for details).
    3. Re:Not so much by dubbreak · · Score: 4, Funny

      Mod parent up. Good bug reports are rarer than good sex (for most slashdotters).

      And if you think you maybe had a good bug report but aren't sure.. then you haven't had a good bug report before.

      --
      "If you are going through hell, keep going." - Winston Churchill
    4. Re:Not so much by msobkow · · Score: 2

      Don't forget the ability of someone with a million followers to draw attention to a problem and ensure everyone knows about it, not just the dev team, such that it becomes an embarrassment to the company that they have to fix to save face.

      Think of accounts like George's as being those of the president and board of the user's union...

      --
      I do not fail; I succeed at finding out what does not work.
    5. Re:Not so much by 1u3hr · · Score: 1

      Do you know how rare it is for a web company to respond to any bug reports? I gave up on Yahoo years ago. No matter how detailed the bug report, it was either ignored or autoresponded to by a cut and paste from an irrelevant FAQ that had a few words in common with my report.I cancelled my "mail plus account" and moved on. And good luck to even find in an address to make a bug report to Google. I never did.

  6. As Takei might say.. by Anonymous Coward · · Score: 1

    Oooh myyy

    1. Re:As Takei might say.. by Anonymous Coward · · Score: 5, Funny

      Oooh MyyySQL

      FTFY

  7. Talented by Sponge+Bath · · Score: 4, Funny

    Swordsman and technical troubleshooter: a potent combination, particularly when done shirtless.

    1. Re:Talented by Anonymous Coward · · Score: 0

      Oh myyy.

    2. Re:Talented by Anonymous Coward · · Score: 0

      And thus we receive a concise and convincing explanation for your username.

  8. Facebook uses MySQL? by Anonymous Coward · · Score: 1

    Too stupid for Postgres and too cheap for Oracle?

    1. Re:Facebook uses MySQL? by Anonymous Coward · · Score: 0

      They invented Cassandra, actually.

    2. Re:Facebook uses MySQL? by Anonymous Coward · · Score: 0

      I've only ever used Mongo for NoSQL work, so I didn't know that they developed Cassandra. Previous snark semi-retracted!

    3. Re:Facebook uses MySQL? by Bill,+Shooter+of+Bul · · Score: 2

      Yes, they are too cheap for Oracle. Who the hell on their scale isn't? Also, They're the ones who manage Facebook's data. What is the largest size of database on Postgres? What minute fraction of Facebook's data is it?

      The reality is they're on mysql, because they started with mysql. Mark Calligan ( the author of the post) has said in the past, that it was just what people picked up due to its easy setup and easy built in replication. Oracle was/is expensive, and Postgres was more difficult to setup.

      Its better to be easy, understandable and quirky, than difficult and correct.

      FYI, they invented Cassandra, but don't really use it anymore. I think they migrated to Hadoop for facebook messages.

      --
      Well.. maybe. Or Maybe not. But Definitely not sort of.
    4. Re:Facebook uses MySQL? by Coriolis · · Score: 1

      Yes, they are too cheap for Oracle. Who the hell on their scale isn't?

      Of course, you're joking. The cost of Oracle licenses for their infrastructure would in all probability be dwarfed by the cost of the person-hours they've put into developing and supporting Cassandra and their Heath Robinson MySQL setup.

      --
      Rgasuya aata! : I have been coding Perl and cannot tell where my fingers are now!
    5. Re:Facebook uses MySQL? by Bill,+Shooter+of+Bul · · Score: 1

      No, I'm not. Oracle is expensive as hell aprox 36,000 per standard edition dual cpu socket server. And Facebook has a hell of a lot of database servers aprox 60,000. So thats what 2. 1 Billion? Vs what ever the costs were to do what they've done now, where they have the software experts in house and on call 24/7. I think they chose correctly. Feel free to update me on the real costs of Oracle, its sort of tough to find accurate pricing on the web.

      --
      Well.. maybe. Or Maybe not. But Definitely not sort of.
  9. Should have simply used a better DB by Monkey-Man2000 · · Score: 1

    I hear Mongo DB is web scale.

    --
    This post was generated by a Cadre of Uber Monkeys for Monkey-Man2000 (603495).
    1. Re:Should have simply used a better DB by Grishnakh · · Score: 4, Funny

      MongoDB may be webscale, but /dev/null is even higher performing. Facebook should just switch to writing to /dev/null for the best possible performance; it's not like their users are going to notice that much.

    2. Re:Should have simply used a better DB by Zontar+The+Mindless · · Score: 1

      Facebook should just switch to writing to /dev/null for the best possible performance...

      Now that you mention it, MySQL has had this option for years.

      --
      Il n'y a pas de Planet B.
  10. Duh everyone knows this is what happened by Anonymous Coward · · Score: 0

    1. Takei posts a picture of him bashing typical left wing boogymen like Jesus, Republicans, and now Rick Santorum
    2. 1.2mil people blindly hit share
    3. Half of those people click like
    4. Facebook is overwhelmed
    5. ?????
    6. PROFIT (Fix the problem by forcing Takei to pay a monthly fee for 1.2mil of his subscribers- you would pay to host 1.2mil people in a large event right?)

    1. Re:Duh everyone knows this is what happened by Anonymous Coward · · Score: 0

      Actually, usually if you could host an event considered likely to draw 1.2 million people you'd have people lining up to pay you to market to them, from commercial sponsors down to hotdog vendors.

  11. Re:Facebook only listens if you're famous, apparen by tqk · · Score: 1

    But they weren't Sulu.

    George is a little odd (from my point of view; see the Shatner roast), but that's allowed. Besides, he looks great wielding a katana.

    --
    "Tongue tied and twisted, just an Earth bound misfit ..." -- Pink Floyd.
  12. Re:Facebook only listens if you're famous, apparen by ackthpt · · Score: 3, Insightful

    But they weren't Sulu.

    There's something to be said for celebrity - it get's your messages noticed more often than us ordinary slobs.

    --

    A feeling of having made the same mistake before: Deja Foobar
  13. Re:Absolutely ridiculous by Megahard · · Score: 2

    They had to resort to Takei because Kim Jong-il is no longer available.

    --
    I eat only the real part of complex carbohydrates.
  14. OOOhhhhhh by circletimessquare · · Score: 1

    MMMyyyyyyyyy

    --
    intellectual property law is philosophically incoherent. it is your moral duty to ignore it or sabotage it
  15. Re:Absolutely ridiculous by Zorque · · Score: 2

    He wasn't looking through their databases or anything, he was offering them in-depth details of the errors he was getting. Nobody said he knows the slightest thing about SQL.

  16. Re:Absolutely ridiculous by Anonymous Coward · · Score: 1

    Troubleshooting MySQL is advanced computer science?

  17. Re:As Takei might say..OBLIG Star Trek quote by hguorbray · · Score: 1

    Helmsman Lojur: She'll fly apart!
    Captain Hikaru Sulu: *Fly her apart then!*

  18. Dammit, Jim by caywen · · Score: 1

    I'm an engineer, not a navigator!

  19. Re:Absolutely ridiculous by Tablizer · · Score: 1

    Just because an actor was in a sci-fi TV series doesn't mean they automatically excel in advanced computer science.

    But he knows who to ask to get the warp-drive to reroute the MySql signals thru the deflector dish using aluminized tribbles disguised as phaser-cannon cleaning brushes while nosy Klingons are onboard. Not your average user.

  20. Re:Absolutely ridiculous by Tablizer · · Score: 1

    Nope. All you have to do is press the "Upgrade to PostGreSql" button ;-)

  21. Re:Absolutely ridiculous by hjf · · Score: 1

    Dude, people stop actors who play medical roles on TV and ask them medical questions. They have to explain they're not real doctors.

  22. Ahh, I see how this works... by tool462 · · Score: 5, Funny

    This just in--Slashdot helps load test web servers.

  23. Re:Facebook only listens if you're famous, apparen by Bill,+Shooter+of+Bul · · Score: 3, Funny

    No, they noticed Takai's posts, because they liked his page. They apparently either ignore your page, or openly hate it. Either way, they don't read what they don't read.

    --
    Well.. maybe. Or Maybe not. But Definitely not sort of.
  24. Re:Facebook only listens if you're famous, apparen by Jesse_vd · · Score: 4, Insightful

    George Takei has a lot of fans with us and since we've all Liked his Page, a while back some of us saw an update from him about an inconsistency in his Facebook experience. We realized what he was experiencing was an issue we were already trying to fix on the database side, so when we saw him post, it gave us more information that helped us get closer to resolving the issue. This allowed us to improve his experience, and in turn, the experience of everyone else on Facebook.

    They were already aware of the problem and working on a solution

  25. VoltDB? by geoffrobinson · · Score: 1

    Maybe a new DB technology like VoltDB would be better...

    I can only imagine the pain and horror their DBA's experience. But what do I know?

    --
    Except for ending slavery, the Nazis, communism, & securing American independence, war has never solved anything.
  26. Re:Facebook only listens if you're famous, apparen by Anonymous Coward · · Score: 4, Funny

    Seriously? Anyone knows 69 isnt ATM... it's P2P... DUH.

  27. Comment Subject by Anonymous Coward · · Score: 0

    Interesting thing going on here. After over an hour, First Post has not been modded at all yet. Your post is modded funny even though FP said same thing. My personal opinion is that this has occurred from the interaction between the First Post Phenomenon and putting the 'being famous sentiment' in his subject.

    1. Re:Comment Subject by Anonymous Coward · · Score: 0

      great link, fyi - very informative

    2. Re:Comment Subject by Anonymous Coward · · Score: 0

      Awwww... What a cute way to spell "404".

  28. Re:Facebook only listens if you're famous, apparen by Anonymous Coward · · Score: 2, Funny

    There's something to be said for celebrity - it get's your messages noticed more often than us ordinary slobs.

    failing celebrity status, you can get extra attention to your messages by using apostrophe's.

  29. Re:Facebook only listens if you're famous, apparen by Anonymous Coward · · Score: 0

    You also have to have a real page.

    What the heck, they might even listen to me, if my page didn't just say "this page intentionally left blank."

  30. Re:As Takei might say..OBLIG Star Trek quote by FrootLoops · · Score: 2

    Captain Hikaru Sulu: *Fly her apart then!*

    I swear there's a gay joke in there somewhere....

  31. Re:Facebook only listens if you're famous, apparen by EdIII · · Score: 2, Insightful

    He's not "a little odd", he's openly homosexual. Why do you have such a problem with a man inserting his penis into another man's (willing) asshole? Or two men performing an ass-to-mouth 69 on each other?

    I have always found him a little bit odd as well, and that was before I even knew he was gay. Odd is not bad, at least I don't take it to be that way. Besides, hes fucking Sulu. He rocks man.

    As for your ass-to-mouth 69 comment..... I think somebody would flunk "spatial mechanics" on the Starfleet entrance exam. I suggest you get a couple of dolls and try to work out your "theory" there.

    Find me a great actor that is not a little odd anyways....

  32. good bug reports are incredibly important by Anonymous Coward · · Score: 0

    to any successfull software project. programmers mean nothing without testers and bug reporters. often times the lines between those three blur. its like you need hydrogen and oxygen to make water.

  33. Re:Facebook only listens if you're famous, apparen by Anonymous Coward · · Score: 1, Informative

    I guess I've been doing it wrong. When I do 69 with another man, I usually have his dick in my mouth, and mine in his.

  34. Re:Absolutely ridiculous by Larryish · · Score: 0

    Maybe if the "S" stood for Sucking.

    And the "Q" stood for Queer.

    But I'm not sure what the "L" would stand for.

    Lads, maybe!?

  35. Re:Facebook only listens if you're famous, apparen by MichaelSmith · · Score: 1

    Sulu would have fixed the bug himself and used his sword to cut the head off the person who created it.

  36. Re:Absolutely ridiculous by Per+Wigren · · Score: 1

    Lube.

    --
    My other account has a 3-digit UID.
  37. Re:Facebook only listens if you're famous, apparen by Anonymous Coward · · Score: 5, Funny

    Besides, hes fucking Sulu.

    No, he is Sulu.
    It's the other guy who's fucking Sulu.

  38. Re:Facebook only listens if you're famous, apparen by Canazza · · Score: 2

    Time travel man, Time Travel.

    --
    It pays to be obvious, especially if you have a reputation for being subtle.
  39. Oblig by g0bshiTe · · Score: 1

    Full query ahead Mr. Sulu.

    In something totally unrelated why is the only thing I've seen George in been Star Trek and Heroes? I've always thought he was a good actor.

    --
    I am Bennett Haselton! I am Bennett Haselton!
  40. Re:Absolutely ridiculous by Anonymous Coward · · Score: 0

    Tee hee! You're the first person to allude to George Takei being homosexual with a hilariously clever comment.

    Oh wait... you're not and it's not.

  41. I can imagine the message exchanges... by Tomsk70 · · Score: 1

    "The new screens held!"

  42. Re:Facebook only listens if you're famous, apparen by mcgrew · · Score: 1

    Indeed, I'm certainly an oddball (if you're reading this you probably are too), but I'm not gay.