Berkeley CSUA MOTD:Entry 54274
Berkeley CSUA MOTD
 
WIKI | FAQ | Tech FAQ
http://csua.com/feed/
2024/11/23 [General] UID:1000 Activity:popular
11/23   

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)
2024/11/23 [General] UID:1000 Activity:popular
11/23   

You may also be interested in these entries...
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.
	...
2009/4/28-5/5 [Computer/HW/Drives] UID:52920 Activity:nil
4/28    Anyone here have experience with solid state drives in the server
        environment? I am mostly worried about reliability, longevity, and
        performance. I've read a couple of articles saying that OSes
        really need to be SSD optimized before this can be considered
        truly viable and yet every vendor from Dell to Sun to Apple is
        shipping these. Are they ready for prime-time on an important
	...
2008/8/27-9/3 [Computer/SW/Languages/Ruby] UID:50985 Activity:nil
8/27    Is Ruby on Rails similar to CGI? Or maybe just something with an
        object-relationship mapping between objects and DB?
        \_ it's an entire application server framework.  You define your
          views, your models, your control, and Rails makes all the connecting
          parts.  DB mappings included.  Also it's all written in Ruby,
          which is an odd language.  So, for example, you'd replace not just
	...
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...");
	...