Entry 53213 (Berkeley CSUA MOTD)

Berkeley CSUA MOTD:Entry 53213

WIKI \| FAQ \| Tech FAQ
`http://csua.com/feed/`

2020/11/23 [General] UID:1000 Activity:popular

11/23

2009/7/28-8/6 [Computer/SW/Database] UID:53213 Activity:nil

7/27    I have an actual technical question here. My MySQL DBA tells me
        that I can't expect a MySQL port to be able to run effectively
        on more than a two CPU box, he says that the extra CPUs will
        sit there unused. Is this true? I have a bunch of new quad core
        servers that I would like to use as Database machines. -ausman
   \_ It's not that simple.  If you stress test your new fancy multi core
      machine, you'll see that mysql doesn't really use all of those
      cores as much as you want.  one way to really use everything is
      shard your data, and run several instances of mysql on one
      machine, then you'll really use all of the cores ! - danh
         \_ http://forums.mysql.com/read.php?24,53893,262315#msg-262315
            (you can probably get it to use four cores)  -tom
            \_ I realize MySQL is free, but what a POS!
               \_ is this a troll?  What do you want?  I've had no problem
                  loading multiple CPUs, yes, you can't have more than one
                  CPU working a a single SQL query, but this has never been
                  a problem for me.  What do you use?
                  \_ Have you ever gone beyond 4?
                     \_ Yes, was not benchmarking and can't be sure how much
                        more throughput I was getting vs. 4 but I have had 8
                        cores processing at near 100% utilization.
                  \_ Well, a modern database should be properly multithreaded.
                     Oracle and MS SQL Server are. A database that slows
                     down when you throw more CPUs at it is a POS.

2020/11/23 [General] UID:1000 Activity:popular

11/23

You may also be interested in these entries...

2013/10/28-2014/2/5 [Computer/SW/Database] UID:54751 Activity:nil

10/28   Oracle software to blame for Obamacare website debacles:
        http://www.forbes.com/sites/theapothecary/2013/10/14/obamacares-website-is-crashing-because-it-doesnt-want-you-to-know-health-plans-true-costs
        \_ Larry Ellison is a secret Tea Party supporter.
           Most of this article is bunk, btw. Boy are the Republicans
           getting desperate.
            \_ Umm, no.  Larry Ellison is a not so secret fascist.
	...

2011/12/20-2012/2/6 [Politics/Foreign/Asia/China, Computer/Rants] UID:54268 Activity:nil

12/20   A higher percentage of people in China than in Pakintan have an
        unfavorable view of China:
        http://www.pewglobal.org/database/?indicator=24&response=Unfavorable
        Go figure.
        \_ damn these self critical liberals!
	...

2011/12/29-2012/2/6 [Computer/SW/Database] UID:54274 Activity:nil

12/29   Is it worthwhile to use ext4 on VMs? Is Journaling necessary on VMs?
         \_ what about DBs?  I read somewhere ext3 was better for DB voumes (mysql)
	...

2011/11/27-2012/1/10 [Computer/HW/Drives] UID:54244 Activity:nil

11/27   CalMail has been down for a few days (hardware failure and database
        corruption -- sounds like fun!) and is starting to come back online.
        Looks like they're planning to outsource all campus mail to either
        Google Apps or Microsoft 365 as part of Operational Excellence.
        <DEAD>kb.berkeley.edu/jivekb/entry!default.jspa?externalID=2915<DEAD>
        \_ http://ist.berkeley.edu/ciocalmailupdates/november-30-2011
	...

2011/2/14-4/20 [Computer/SW/Unix] UID:54039 Activity:nil

2/14    You sure soda isn't running windows in disguise?  It would explain the
        uptimes.
        \_ hardly, My winbox stays up longer.
        \_ Nobody cares about uptime anymore brother, that's what web2.0 has
           taught us.  Everything is "stateless".
           \_ You;d think gamers would care more about uptime.
	...

2010/11/21-2011/1/13 [Computer/SW/Languages/Web] UID:53988 Activity:moderate

11/21   Lifehacker's recommending Dreamhost as a personal web hosting service.
        Apart from csua, who do you guys use? --erikred
        \_ What do you want to use it for? Do you need CGI or PHP?  My
           brother worked for Dreamhost and said they are unethical. In
           fact, he sued them. This refers to their treatment of customers
           and employees both. I don't know who  or what "Lifehacker" is,
	...

2010/8/10-9/7 [Computer/Companies/Google] UID:53919 Activity:nil

8/10    http://www.businessinsider.com/google-puts-wave-out-of-its-misery-2010-8
        Google Wave No More. The people who worked on it were pretty smart.
        They wrote up a super awesome OKR with extremely low bar as a measure
        of success, exceeded everyone's expectations by going above those
        bars, and got big fat bonuses and promotions as a result of their
        planning. Brilliant.
	...

2010/8/12-9/7 [Computer/SW/Languages/Perl] UID:53922 Activity:nil

8/12    Ruby coders, do you mostly DIY your stuff or use the ruby libs out
        there?   How is their quality compared to other libs you have used
        for other langs?  Thx.
        \_ I use Ruby for hobby stuff, etc.  I use libraries for system stuff
           (web access, process, etc.) but that's about it.  Perl libraries are
           much better/more complete.  I assume because of the maturity and
	...

2010/7/11-23 [Computer/SW/Database, Recreation/Sports] UID:53880 Activity:nil

7/11    "Paul the Oracle Octopus goes eight for eight, is amazing"
        http://www.csua.org/u/r4b
        How did one octopus guess something that has 1/256 probability???
        \_ I once rolled eight "1"s in a row at Risk.
           \_ But you would be in the spotlight only after you rolled eight
              "1"s, just like lottery winners.  OTOH that octopus was already
	...

Cache (132 bytes)

forums.mysql.com/read.php?24,53893,262315#msg-262315Rick James () Date: May 12, 2009 08:47PM * HyperThreading should be turned off -- the two cores clobber each other's cached entries.