Results 1 to 3 of 3

Thread: best engine

  1. #1
    Join Date
    Nov 2008

    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
    Toronto, Canada
    that would be InnoDB | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Sep 2009
    San Sebastian, Spain
    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 here
    Ronan Cashell
    Certified Oracle DBA/Certified MySQL Expert (DBA & Cluster DBA)
    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