RE: Considering migration from MyISAM to InnoDB

2005-06-15 Thread Stembridge, Michael
PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 14, 2005 7:00 PM To: Stembridge, Michael Cc: mysql@lists.mysql.com Subject: Re: Considering migration from MyISAM to InnoDB see the my.cnf examples in the install dir, and look at innodb* variables. you can migrate each table just using

RE: Considering migration from MyISAM to InnoDB

2005-06-15 Thread James Nobis
] Sent: Tuesday, June 14, 2005 7:00 PM To: Stembridge, Michael Cc: mysql@lists.mysql.com Subject: Re: Considering migration from MyISAM to InnoDB see the my.cnf examples in the install dir, and look at innodb* variables. you can migrate each table just using : alter table toto engine=innodb; Mathias

Re: Considering migration from MyISAM to InnoDB

2005-06-15 Thread Atle Veka
If it works fine currently, the rule usually is: don't mess with it. :) I would stick with MyISAM if I were you, it should be plenty good enough for such a small table and usage as you described. If you are experiencing performance issues, I would recommend looking at indexes if you haven't

Re: Considering migration from MyISAM to InnoDB

2005-06-14 Thread mfatene
see the my.cnf examples in the install dir, and look at innodb* variables. you can migrate each table just using : alter table toto engine=innodb; Mathias Selon Stembridge, Michael [EMAIL PROTECTED]: I currently use MyISAM on an internal web application server; our data takes up 10mb at