SitePoint Sponsor

User Tag List

Results 1 to 2 of 2

Thread: InnoDB in MySQL

Hybrid View

  1. #1
    SitePoint Wizard westmich's Avatar
    Join Date
    Mar 2000
    Location
    Muskegon, MI
    Posts
    2,328
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    InnoDB in MySQL

    I came across some links before on InnoDB when I was wondering about doing transactions and heavy inserts/updates. Is InnoDB simply a type of table? Could I use InnoDB tables for certain functions within a standard MySQL database? Or would I have to make my whole database use InnoDB?
    Westmich
    Smart Web Solutions for Smart Clients
    http://www.mindscapecreative.com

  2. #2
    Making a better wheel silver trophy DR_LaRRY_PEpPeR's Avatar
    Join Date
    Jul 2001
    Location
    Missouri
    Posts
    3,428
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    yeah, InnoDB is just a table type. you can use it for a single table. MySQL has to be compiled w/ InnoDB support, though, which it don't think it is by default. you would just specify it in your CREATE TABLE statement like this:

    CREATE TABLE table (.....) TYPE=InnoDB;

    there are some different behaviors with InnoDB compared to the default MyISAM (i don't know exactly what). so watch out for those.
    - Matt ** Ignore old signature for now... **
    Dr.BB - Highly optimized to be 2-3x faster than the "Big 3."
    "Do not enclose numeric values in quotes -- that is very non-standard and will only work on MySQL." - MattR


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •