Berkeley CSUA MOTD:Entry 33727
Berkeley CSUA MOTD
 
WIKI | FAQ | Tech FAQ
http://csua.com/feed/
2025/04/04 [General] UID:1000 Activity:popular
4/4     

2004/9/23-24 [Computer/SW/Database] UID:33727 Activity:kinda low
9/23    SQL/MySQL question:  If I create a DB with a field that's a
        varchar(256), will I be wasting a lot of disk if the data is typically
        only 5-10 chars long?
        \_ No.  It's not 1981 anymore.
           \_ I just wanted to be sure I wasn't setting up something in a
              horribly inefficient way.
           \_ But what about my Atari 2600?!?  NOOOOOO!
              \_ You have MySQL for Atari?
                 \_ Yeah, but it can only hold 128 bytes of data.
                    \_ Dude, my Sinclair ZX-81 version of LISP totally
                       r0x0rs your Atari MySQL.
                       \_ Do you need to use the 16K RAM expansion to hold
                          all the parenthesis?
 __  __  ___   ___  _
|  \/  |/ _ \ / _ \| |
| |\/| | | | | | | | |
| |  | | |_| | |_| |_|
|_|  |_|\___/ \___/(_)
        \_ You mean varchar(255)
           \_ I guess, but would it really matter? -op
           \_ yes. limit is 255 in mysql
        \_ YES it'll take the same amount of space. If space is an issure
           use TEXT or VARCHAR, but you'll trace space with time. Nothing
           comes in free.
2025/04/04 [General] UID:1000 Activity:popular
4/4     

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.
	...
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/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/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
	...
2004/11/22-23 [Computer/SW/OS/OsX] UID:35021 Activity:low
11/22   What's a good database program for Mac OSX? I just found out they
        don't make MS Access for macs. I did a quick search and found a
        Filemaker. Can anyone recommend any others? Thanks.
        \_ what's your need?  FileMaker is fine (better than Access) for
           personal/home use.  -tom
        \_ MySQL?  as above, what do you need it for?  I also like
	...
2004/3/25 [Computer/SW/Database] UID:12849 Activity:nil
3/25    Ok please tell me the pros/cons of mysql vs. postgreSQL. For me
        speed is really really important. On the other hand, packaging
        (ease of install, consistent commands, etc) is also very important
        for development. I've just tried mysql for the first time and I'm
        NOT very impressed. The documentation that came with it was outdated
        (some of the tutorials didn't work) and it didn't even pass all of
	...
2003/10/29-30 [Computer/SW/Languages/Web] UID:10849 Activity:nil
10/29   Hosting question...
        So what are some recomendations for very cheap and reliable
        hosting options? I want DB support (MySQL, or postgres), JSP/servlet
        stuff, and other general scripting things like PErl, PHP. I'd also
        like to get a couple domains, and dont have any access to servers
        to do name serving. thanks.
	...
2003/4/3 [Computer/SW/Database] UID:27973 Activity:high
4/2     any known tools to make HTML form / db connection easier?
        I have heard of Namo Webeditor.  Any others? open source ?
        \_ Define "easier".  I played with phprojekt, which does php/mysql
           pretty nicely.  Seemed very straightforward.  -John
        \_ vi, a cup & string and a whistle.
	...
2003/3/12-13 [Computer/SW/Database] UID:27673 Activity:very high
3/12    mySQL vs. postgreSQL: Thoughts? Likes? Dislikes? Horror stories?
        Success stories?  Thanks.
        \_ I have found mySQL to be surprisingly good. I built a network
           and system management product using mySQL for the db backend.
           This system has been deployed in several dozen sites worldwide
           with between 100-500 nodes managed per site. Most of the sites
	...