Stories
Slash Boxes
Comments
NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

All the Perl that's Practical to Extract and Report

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.

MyISAM versus InnoDB 8 Comments More | Login | Reply /

 Full
 Abbreviated
 Hidden
More | Login | Reply
Loading... please wait.
  • > There are legitimate uses for MyISAM, but not many.

    Like maybe a counter script, or some sort of simple log table, which about the most sophisticated things I've ever used it for.
    • As far as I know (I don't use MySQL) the only reason is full text search.

      -Dom

      • As far as I know (I don't use MySQL) the only reason is full text search.

        If it was primarily a read-only server with heavy usage and only being written to in an extremely controlled manner, MyISAM might be a reasonable choice if you can't get performance any other way (short of paying for Oracle).

        • If it was primarily a read-only server with heavy usage and only being written to in an extremely controlled manner

          We use MyISAM for a dimensional data warehouse. The data in the warehouse is extracted from other databases (which are InnoDB) and are used by clients and software mostly to make complicated reports that just wouldn't be feasible on the normalized InnoDB tables. Since we already know the data is good we just want fast access to the extracted parts.

          • A lot of people have never realized that this was MySQL's target task for many, many years.

            • I initially laughed my head off at that because I thought you were talking about using MySQL to support broken Web counters :)

Stories, comments, journals, and other submissions on use Perl; are Copyright 1998-2006, their respective owners.