Professional Web Applications Themes

InnoDB VS MyISAM - MySQL

Hi, 1. I heard that under some suitation, InnoDB is faster then MyISAM (when indexing on a key is blah blah blah...i forgot...) Is this factor important when designing a database schema when we want use InnoDB, instead of MyISAM? Thanks....

  1. #1

    Default InnoDB VS MyISAM

    Hi,

    1. I heard that under some suitation, InnoDB is faster then MyISAM
    (when indexing on a key is blah blah blah...i forgot...)

    Is this factor important when designing a database schema when we want
    use InnoDB, instead of MyISAM?

    Thanks.

    howachen@gmail.com Guest

  2. #2

    Default Re: InnoDB VS MyISAM

    [email]howachen[/email] wrote:
    > Hi,
    >
    > 1. I heard that under some suitation, InnoDB is faster then MyISAM
    > (when indexing on a key is blah blah blah...i forgot...)
    >
    > Is this factor important when designing a database schema when we want
    > use InnoDB, instead of MyISAM?
    >
    > Thanks.
    >
    Hi howachen,

    maybe blah blah blah is an important factor. But maybe we don't get your
    question here at all?

    Regards, Hakan
    --
    Hakan Kuecuekyilmaz
    Hakan Kuecuekyilmaz Guest

  3. #3

    Default Re: InnoDB VS MyISAM

    <howachen> wrote in message
    news:1151337125.707998.207040i40g2000cwc.googlegr oups.com...
    > Hi,
    >
    > 1. I heard that under some suitation, InnoDB is faster then MyISAM
    > (when indexing on a key is blah blah blah...i forgot...)
    >
    > Is this factor important when designing a database schema when we want
    > use InnoDB, instead of MyISAM?
    >
    > Thanks.
    >
    Apart from InnoDB having desirable transaction features, using an InnoDB is
    generally faster than MyISAM if there are simultaneous readers and writers.
    Under MyISAM, readers block on any insert taking place, since MyISAM locks
    the whole table for in insert. Under InnoDB this is not the case, and
    therefore readers can read even when inserts are active.

    -- John


    John Smith Guest

Similar Threads

  1. #39509 [NEW]: mySQL without InnoDB
    By tinu at humbapa dot ch in forum PHP Bugs
    Replies: 2
    Last Post: November 15th, 04:30 PM
  2. Auto synchronization between MyISAM & Memory table?
    By howachen@gmail.com in forum MySQL
    Replies: 4
    Last Post: July 9th, 11:35 AM
  3. Is InnoDB dead?
    By howachen@gmail.com in forum MySQL
    Replies: 3
    Last Post: June 15th, 11:14 PM
  4. MyISAM VS InnoDB VS Memory
    By howachen@gmail.com in forum MySQL
    Replies: 0
    Last Post: June 11th, 02:07 PM
  5. Myisam Table size
    By alfred wallace in forum MySQL
    Replies: 0
    Last Post: June 3rd, 10:01 AM

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
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139