Berkeley CSUA MOTD:Entry 21592
Berkeley CSUA MOTD
 
WIKI | FAQ | Tech FAQ
http://csua.com/feed/
2021/12/06 [General] UID:1000 Activity:popular
12/6    

2001/6/21-2002/2/6 [Computer/SW/Database] UID:21592 Activity:high 80%like:21634 66%like:22367
6/26    [ Kinney's drivel deleted. ]
            \_ Does MySQL really do transactions, ACID, etc now?
               anyone have a URL handy? --oj
               \_ No, MySQL is not presently ACID compliant.  That's why you
                  can corrupt MySQL databases if you throw enough traffic at
                  one.  They just moved their transaction code into the stable
                  release.  Don't know if it's usable yet though.
                  \_ Its not. Our 'database' guy is a rabid MySQL fanatic and
                     had us use it in our project (instead of PostGres which
                     I wanted to use). The transactions code is turning out to
                     be the cause of a lot of our problems. We will probably
                     switch to PostGres in the next version.
                     \_ From what I read the corruption problems were due to
                        real multiuser env where multiple insert and update
                        statements clouded the water.
                        \_ Yup, that's the problem. MySQL "forgets" to do
                           some inserts and updates. We got about 5 daemons
                           reading network and system state and trying to
                           populate the db with this info and sometimes
                           stuff doesn't show up, but the db says everything
                           is okay. It really sucks.
                        My application having only read rights should not be
                        affected; but then again who cares- my master data file
                        is still maintained on my local computer and used only
                        by me. I do an update once and month on my local copy
                        and publish the new tables out to the network.
            \_ Will MySQL ever have transactions? I thought the point
               of MySQL was that it wasn't a real database, just a fast
               data source that could understand SQL.
               \_ Anyone who runs something they really care about with
                  either Access or MySQL is asking for what they'll get. They
                  each have their uses, but so does Excel for that matter.
                  If you want a real database, then use a real database like
                  MS SQL Server, Slimebase, Informix, Oracle, or the like.
                  Postgres/Ingres is about as good as its going to get for the
                  "freeware" camp, and in fact we use it here to catalog
                  near-earth objects and (in another application) store
                  GPS data. Rock solid. --dim
        \_ No Kinney, I don't wonder.  If I'm curious, I read the
           New York Times and the Christian Science Monitor (both
           available free online).  Add in a dash of The Economist
           and a liberal paper (insert SF Guardian or Village
           Voice here) to balance it out, and a grain of salt to
           account for the ridiculous conservative bias in one and
           the loony liberal bias in the other and you come out
           pretty well informed.
         \_ wow.  Tell your boss he is a moron and he shouldn't be making
            these decisions.  Do what is right (PostgreSQL) and then if
            you get fired be GLAD that you now will get a tiny bit of money
            on unemployment while you dick around before getting another job
            which you obviously need to do anyway.
            ( If this database will really stay like it is now forever, then
              yes, mysql is great).
            (Also, ignore the person who said (point 3) that Oracle is faster
              than MySQL.  That person is either a moron, or he typod).
             Finally, to answer another deleted question, MySQL does NOT support
             sub-queries.  (very annoying and another reason to run Postgres).
             One thing Mr. point #3 is Right about is that you should never even
             consider running Access. (so much for "Finally")
             \_ No, really, Oracle is significantly faster than MySQL.
                - Mr. Point 3
                \_ MySql is faster on simple selects.  But when you run join
                   join queries of many tables, mysql slows down significantly.
            \_ Does MySQL really do transactions, ACID, etc now?
               anyone have a URL handy? --oj
               \_ No, MySQL is not presently ACID compliant.  That's why you
                  can corrupt MySQL databases if you throw enough traffic at
                  one.  They just moved their transaction code into the stable
                  release.  Don't know if it's usable yet though.
                  \_ Its not. Our 'database' guy is a rabid MySQL fanatic and
                     had us use it in our project (instead of PostGres which
                     I wanted to use). The transactions code is turning out to
                     be the cause of a lot of our problems. We will probably
                     switch to PostGres in the next version.
        \_ godamn i missed this one before it was purged.  Pray tell it
           wasn't about h07 4zn ch1x?
           \_ D00D U N33D 2 134RN 2 5P311! 175 42N ! 4ZN!
           wasn't about H07 42N CH1X [ 5P3111NG C0RR3C73D ]
        \_ I hope it becomes standard MOTD policy that Kinneydrivel(tm) is
           automatically deleted.
           \_ I hope so too.
              \_ Solidarity, man.
        \_ Oh my god, you deleted kinney!  You bastard!
        \_ what's the average lifetime of Kinney's drivel?
           \_ 3-5 minutes
        \_ Are you on drugs? Do you even know what the ASP model is? This
           is the most nonsensical discussion I've ever seen.
           \_ Please ignore kinney, he is something I like to call a
              'blazing moron.'
        \_ I think "ASP" means something different to most people than
           what it means to you.
           \_ Please ignore kinney, he is something I like to call a
              'blazing moron.'
        \_ goddamn it stop censoring kinney.  Kinney you must share
           your wisdom with the world.  Put it all on a web archive
           or something.
        \_ you guys are fast. did you write an automatic kinneydrivel filter?
           i actually enjoyed the last two drivels.
           \_ yeah, i've yet to see any at all. someone got a repository of it?
           \_ I guess I happened to view the motd at the right moment and then
              immediately deleted it. Knee-jerk reaction I guess =)
        \_ Hey, this was the first one that wasn't drivel.
          \_ wasn't the post signed by psb? and yes, it was total drivel
             and completely random question that didn't follow from
             the story.
             \_ i'm gonna keep putting drivel in motd.kinney even if it might
                be fake kinney. making fake drivel is pretty lame anyway so
                i'm gonna hope no one bothers.
             \_ Did we read the same post? The one I read was a question
                about transmission limits imposed on communications equip.
                by the FCC as it related to a new technology. It seems to
                be a non-drivel question.
        \_ I thought it was cute.  Why'd you purge it?  I was going to have
           some fun with it.
2021/12/06 [General] UID:1000 Activity:popular
12/6    

You may also be interested in these entries...
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)
	...
2009/9/23-10/5 [Computer/SW/Database] UID:53392 Activity:nil
9/23    I never took CS188, is there a good book that's an intro to formal
        database theory, normalization, etc.?  I've got experience with SQL
        (MySQL & MSSQL), and understand tables, etc.
        \_ You mean CS186?
           \_ Oops, yah.  188 is AI or something?
              \_ That's right.
	...
2008/4/29-5/5 [Computer/SW/Languages/Perl, Computer/SW/Languages/Python] UID:49852 Activity:moderate
4/29    Scaling your web app in the real world:
        http://teddziuba.com/2008/04/im-going-to-scale-my-foot-up-y.html
        \_ This article is crap.  While yes, 99.9% of all websites don't
           need any serious scalability plans, if any of them become worth
           anything they will need to scale.  If you write a web application
           without careing about scalability you are writing a webapp that can
	...
2006/4/6-7 [Computer/SW/Database] UID:42713 Activity:kinda low
4/6     mysql expert, I've created a db with mixed innodb and isam tables.
        The isam tables have *.MYD and *.MYI (data and index). However the
        innodb tables only have a small *.FRM file. Copying isam tables
        works (when your db is shutdown) but it's not true with innodb.
        Where is the actual data and index located for innodb and how
        do you copy them? Thanks.
	...
2006/3/25-26 [Computer/SW/OS/FreeBSD] UID:42421 Activity:very high
3/24    Wow!  FreeBSD sure is stable!  After seeing soda's amazing uptime
        record, I sure want to go replace my Linux boxes with FreeBSD!
        Please do not delete this, or burn down Linus' house because I have
        blasphemed the holy FreeBSD.  I'd love to see a genuine discussion with
        examples from both sides comparing the stability of *modern* FreeBSD
        and Linux machines running on x86 hardware. -dans
	...
2006/3/14-16 [Computer/SW/Database] UID:42233 Activity:nil
3/14    Hello Oracle experts. Is there a reason why .getProcedures takes
        so long to execute? I've tried using different jdbc connectors
        from different vendors and have the same results, so I think
        it must be the DB hog backend. Why does it take so long?
        try{
          DatabaseMetaData dbmeta  = con.getMetaData();
	...
2006/2/16-17 [Computer/SW/Languages/Web] UID:41887 Activity:nil
2/16    In PHP, If I loop $result=mysql_query("...SQL here..."); with
        a lot of results, while reusing the variable
        $result without ever using mysql_free_result($result),
        would that make the memory space blow up? Like:
        while (1) {
          $result=mysql_query("...SQL HERE...");
	...
2005/7/22-25 [Computer/SW/Database, Computer/SW/Languages/Misc] UID:38783 Activity:kinda low
7/22    When I do SELECT AVG(col) FROM table, where col is integer, it takes
        2 minutes and returns a float type. I'm suspecting part of the
        problem is that it's doing floating point add? How do I make it
        faster? Thanks.
        \_ How many rows it is querying over?
           \_ about ~2,000,000
	...
2005/7/22-25 [Computer/SW/Database] UID:38784 Activity:nil
7/22    I never took a formal DB theory class, excuse me for asking SQL
        questions. When I create a table, I can choose PRIMARY KEY to be
        based on a single or n-tuple column. When I do that, are indices
        created automatically? Second question is, if the indices are
        created for n-tuple, does that mean all the column have fast
        index, or they are all based on previous columns? For example, if
	...
2005/4/8-10 [Computer/SW/Database] UID:37118 Activity:moderate
4/8     Anyone reccomend a good mysql programming tutorial that goes
        beyond the basic select statements ? I would like to be able
        to do a distinct on specific column and then do a count of all
        the rows that have the corresponding values. thanks  --ramberg
        \_ select t.col, count(*) from tble t group by t.col;
           \_ thanks. --ramberg
	...