| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Mitchell Maltenfort | Date: | April 3 2010 12:50am |
| Subject: | Re: MyISAM better than innodb for large files? | ||
| View as plain text | |||
>> 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.
| Thread | ||
|---|---|---|
| • MyISAM better than innodb for large files? | Mitchell Maltenfort | 2 Apr |
| • Re: MyISAM better than innodb for large files? | Carsten Pedersen | 2 Apr |
| • RE: MyISAM better than innodb for large files? | Gavin Towey | 2 Apr |
| • Re: MyISAM better than innodb for large files? | Dan Nelson | 2 Apr |
| • Re: MyISAM better than innodb for large files? | Mitchell Maltenfort | 3 Apr |
| • Re: MyISAM better than innodb for large files? | Walter Heck - OlinData.com | 3 Apr |
| • Re: MyISAM better than innodb for large files? | Mitchell Maltenfort | 3 Apr |
| • Re: MyISAM better than innodb for large files? | Kyong Kim | 6 Apr |
| • RE: MyISAM better than innodb for large files? | Jan Steinman | 5 Apr |
| • Re: MyISAM better than innodb for large files? | Kyong Kim | 8 Apr |
| • Re: MyISAM better than innodb for large files? | mos | 8 Apr |
| • Re: MyISAM better than innodb for large files? | Kyong Kim | 9 Apr |
| • Re: MyISAM better than innodb for large files? | mos | 9 Apr |
| • Re: MyISAM better than innodb for large files? | Lucky Wijaya | 10 Apr |
