Berkeley CSUA MOTD:Entry 42713
Berkeley CSUA MOTD
 
WIKI | FAQ | Tech FAQ
http://csua.com/feed/
2025/07/09 [General] UID:1000 Activity:popular
7/9     

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.
        \_ IANAE, but... the data is inside the ibdata* files (see
           innodb_data_file_path setting, but probably named ibdata[0-9]+).
           You can copy them just as you do the myisam files, when the server
           is shutdown.  There is no (free) way to do copies while the db is
           up (can't lock table like you can with myisam) but Innobase, sells
           an ibbackup tool. http://www.innodb.com/order.php -dwc
           \_ oh yea... if you're using 4.1 you could have per-table
              tablespaces.  See
              http://dev.mysql.com/doc/refman/5.0/en/multiple-tablespaces.html
2025/07/09 [General] UID:1000 Activity:popular
7/9     

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/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] 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/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/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.
	...
Cache (2080 bytes)
www.innodb.com/order.php
Questions and comments: Send * Mandatory field Please fill in this form in order to order a free evaluation copy or a commercial license of InnoDB Hot Backup. InnoDB Hot Backup is the ideal solution for online backups of InnoDB tables in MySQL--and for setting up replication. It allows you to back up a running InnoDB database under MySQL without setting any locks or disturbing normal database processing. You get a consistent copy of your database, as if the copy were taken at a precise point in time. InnoDB Hot Backup is also the ideal method of setting up new slaves if you use the MySQL replication on InnoDB tables. com and giving the following information: * Type of license (evaluation, 1-year, or perpetual). You will receive InnoDB Hot Backup in an email attachment containing an executable file. While your 1-year InnoDB Hot Backup license is in force you are entitled to all upgrade versions of InnoDB Hot Backup. If you buy a perpetual license then you are entitled to free InnoDB Hot Backup upgrades for 3 years from the purchase. Normally, the InnoDB Hot Backup license is bound to the hostname of the server computer. You can transfer your license to another computer, as long as you run one licensed copy on one computer only. Non-hostname-bound licenses are available in large volume orders and for special applications. If you are an OEM customer of MySQL Pro, you can buy InnoDB Hot Backup licenses for embedded use with MySQL Pro at a very substantial discount. Latest Releases InnoDB Hot Backup version 30 is available for Microsoft Windows; and Solaris 8 and 10 on 32-bit SPARC (this version works also on Solaris 9). InnoDB Hot Backup version 20 is available for Apple Mac OS X on powerPC; For security reasons, do NOT mention your credit card number in your email. The second payment method is a direct bank ("wire") transfer to the Innobase Oy bank account in Finland. If you are able to do direct bank transfers, please ask for the Innobase Oy bank account information. Use of the trademark InnoDB is prohibited without a permission from Innobase Oy.
Cache (1818 bytes)
dev.mysql.com/doc/refman/5.0/en/multiple-tablespaces.html
This feature is called "multiple tablespaces" because in effect each table has its own tablespace. Using multiple tablespaces can be beneficial to users who want to move specific tables to separate physical disks or who wish to restore backups of single tables quickly without interrupting the use of the remaining InnoDB tables. cnf and restart the server, InnoDB creates tables inside the shared tablespace files again. innodb_file_per_table affects only table creation, not access to existing tables. ibd files, but you can still access tables that exist in the shared tablespace. If you remove the option and restart the server, new tables are created in the shared tablespace, but you can still access any tables that were created using multiple tablespaces. Note: InnoDB always needs the shared tablespace because it puts its internal data dictionary and undo logs there. ibd files between database directories as you can with MyISAM table files. This is because the table definition that is stored in the InnoDB shared tablespace includes the database name, and because InnoDB must preserve the consistency of transaction IDs and log sequence numbers. ibd file, you can restore it to the MySQL installation from which it originated as follows: 1 Issue this ALTER TABLE statement: ALTER TABLE tbl_name DISCARD TABLESPACE; ibd file using the following method: 1 Stop all activity from the mysqld server and commit all transactions. ibd file is to use the commercial InnoDB Hot Backup tool: 1 Use InnoDB Hot Backup to back up the InnoDB installation. ibd file to the "installation from which it originated." ibd>' is 38, but in the InnoDB data dictionary it is 401. When you run: ALTER TABLE <table_name> IMPORT TABLESPACE It is possible to copy InnoDB tables between two databases using mysqldump and mysqlimport.