Results 1 to 3 of 3

Thread: best engine

  1. #1
    Join Date
    Nov 2008
    Posts
    117

    Unanswered: best engine

    which is best storage engine for mysql?
    My application is going to handle lots of users
    And there is a lots of transaction on the database
    And there will be a number of concurrent users

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    that would be InnoDB
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Sep 2009
    Location
    San Sebastian, Spain
    Posts
    880
    You should look carefully at all of the engines available. InnoDB does offer transaction support, as does NDB, however, determining the right table is dependent on what the application is going to do. For example, session type information, such as data relating to login and session set data could be handled more efficiently with the memory engine.

    I have a written a page summarizing the various engines and also the command on how to determine which engines are supported by your database server.click here
    Ronan Cashell
    Certified Oracle DBA/Certified MySQL Expert (DBA & Cluster DBA)
    http://www.it-iss.com
    Follow me on Twitter

Posting Permissions

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