List:General Discussion« Previous MessageNext Message »
From:Walter Heck - OlinData.com Date:April 3 2010 1:24am
Subject:Re: MyISAM better than innodb for large files?
View as plain text  
Ah, if you are single-user and updating really is a special occasion
that is completely in your control, you could even use compressed
MyISAM. That makes the table read-only though, but it does give
performance benefits:
http://dev.mysql.com/doc/refman/4.1/en/myisampack.html

good luck!

Walter Heck
Engineer @ Open Query (http://openquery.com)

On Sat, Apr 3, 2010 at 08:50, Mitchell Maltenfort <mmalten@stripped> wrote:
>>> You want the crash safety and data integrity that comes with InnoDB.
>  Even
>>> more so as your dataset grows.  It's performance is far better than
> myisam
>>> tables for most OLTP users, and as your number of concurrent readers and
>>> writers grows, the improvement in performance from using innodb over
>>> myisam becomes more pronounced.
>>
>> His scenario is "perhaps updated once a year", though, so crash recovery and
>> multiple writer performance is not important.
>
> And the concurrent reader and writer number is set at one, unless I
> undergo mitosis or something.
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>
Thread
MyISAM better than innodb for large files?Mitchell Maltenfort2 Apr
  • Re: MyISAM better than innodb for large files?Carsten Pedersen2 Apr
    • RE: MyISAM better than innodb for large files?Gavin Towey2 Apr
      • Re: MyISAM better than innodb for large files?Dan Nelson2 Apr
        • Re: MyISAM better than innodb for large files?Mitchell Maltenfort3 Apr
          • Re: MyISAM better than innodb for large files?Walter Heck - OlinData.com3 Apr
            • Re: MyISAM better than innodb for large files?Mitchell Maltenfort3 Apr
          • Re: MyISAM better than innodb for large files?Kyong Kim6 Apr
RE: MyISAM better than innodb for large files?Jan Steinman5 Apr
  • Re: MyISAM better than innodb for large files?Kyong Kim8 Apr
    • Re: MyISAM better than innodb for large files?mos8 Apr
      • Re: MyISAM better than innodb for large files?Kyong Kim9 Apr
        • Re: MyISAM better than innodb for large files?mos9 Apr
          • Re: MyISAM better than innodb for large files?Lucky Wijaya10 Apr