SitePoint Sponsor

User Tag List

Results 1 to 5 of 5
  1. #1
    SitePoint Zealot phpguru's Avatar
    Join Date
    Sep 2005
    Posts
    189
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Table type: MyISAM & InnoDB

    I just ALTER my table type to InnoDB,
    my table is having ~ 200.000 records.

    And time to execute one small query is longer than MyISAM??!
    What's goin on?

  2. #2
    SitePoint Zealot
    Join Date
    Jun 2007
    Posts
    150
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    InnoDB is effected heavily by buffer pool settings etc, as both indexes and raw data are cached in RAM.

  3. #3
    SitePoint Zealot phpguru's Avatar
    Join Date
    Sep 2005
    Posts
    189
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    so, which one should I use?
    i need the high performance, and quick

  4. #4
    SitePoint Zealot
    Join Date
    Jun 2007
    Posts
    150
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    What operations will the database require?

    Many INSERT, DELETE and concurrent SELECT's would be best suited to InnoDB. You can always alter your my.cnf file so that InnoDB has more memory to play with.

    If the database is mostly read only then stick with MyISAM.

  5. #5
    reads the ********* Crier silver trophybronze trophy longneck's Avatar
    Join Date
    Feb 2004
    Location
    Tampa, FL (US)
    Posts
    9,854
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    you need to reconfigure your server. by default, innodb has very conservative settings that should not be used for anything other than a development server. there's a whole section on innodb in the mysql manual that includes information on optimizing your configuration.


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
  •