From: Martin Gainty Date: August 16 2008 2:12pm Subject: RE: another INNODB vs MYISAM question List-Archive: http://lists.mysql.com/mysql/214134 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="_8e0bf7c4-3a3f-43db-a30f-eae553166f7a_" --_8e0bf7c4-3a3f-43db-a30f-eae553166f7a_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Good Morning Mike and Brent Ive been following and implementing MYSQL tuning suggestions at http://dev.mysql.com/doc/refman/5.1/en/innodb-tuning.html I did'nt see any suggestions on converting the entire DB to INNODB=20 or converting the individual tables to INNODB Suggestions? Martin=20 ______________________________________________=20 Disclaimer and confidentiality note=20 Everything in this e-mail and any attachments relates to the official busin= ess of Sender. This transmission is of a confidential nature and Sender doe= s not endorse distribution to any party other than intended recipient. Send= er does not necessarily endorse content contained within this transmission.= =20 > From: brenttech@stripped > To: mikesz@stripped > Subject: Re: another INNODB vs MYISAM question > Date: Sat=2C 16 Aug 2008 08:52:51 -0400 > CC: mysql@stripped >=20 > First=2C databases do not have a table type=2C they are mainly just a =20 > logical grouping of tables. Mixing table types in a database is quite =20 > alright and is what you are supposed to do. I generally use MYISAM=2C =20 > but if I have a table with lots of activity (inserts=2C deletes=2C =20 > selects) or needs transaction support=2C I use InnoDB. >=20 > What you did was not only switch the default table type=2C but you =20 > disabled the InnoDB table type. As you may already know=2C MySQL's table = =20 > types are different engines that are really plug-ins. You can disable =20 > those plug-ins if you like=2C which is what you did. Just re-enable the = =20 > InnoDB stuff and you should be alright. You can leave your default =20 > engine as MYISAM and if you like=2C you can use ALTER TABLE to convert =20 > your InnoDB tables to MYISAM. >=20 > -- > Brent Baisley >=20 >=20 > On Aug 15=2C 2008=2C at 1:01 AM=2C mikesz@stripped wrote: >=20 > > Hello mysql=2C > > > > As I have previously mentioned=2C I installed WAMPSERVER 2.0 on my > > Windows XP pro box recently. It installed INNODB as the Default > > Engine. > > > > All of my legacy Databases are MYISAM and after the installation=2C I > > copied them all into the DATA folder and everything worked=2C even > > adding new tables etc. but the new stuff was INNODB. So I ended up > > with some MYISAM databases that contained INNODB tables in them. > > > > After a few weeks I got to thinking that mixing INNODB and MYISAM > > might not be a good thing and switched the Default Engine to MYISAM in > > my.ini file. I didn't just switch the default=2C I commented out all th= e > > INNODB calls in the my.ini file as well. > > > > As I half expected=2C all the databases that I had added INNODB tables > > failed when I tried to fire up the applications that used them. > > > > Although I am not new to mysql=2C I have had a bit of MYISAM "tunnel > > vision" with it so my question is=2C if I had just switched the default > > engine and NOT disabled the INNODB calls in my.ini=2C would that have > > prevented the "problem"? I restored all the MYISAM files and got > > everything back working again. > > > > I don't want to go through the "lengthy" reproduction exercise of > > reinstalling everything to test the theory so if someone has had some > > experience with this=2C I would appreciate hearing from them. > > > > --=20 > > Best regards=2C > > mikesz mailto:mikesz@stripped > > > > > > --=20 > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dbrenttech@gmail= .com > > >=20 >=20 > --=20 > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dmgainty@stripped= om >=20 _________________________________________________________________ Talk to your Yahoo! Friends via Windows Live Messenger. Find out how. http://www.windowslive.com/explore/messenger?ocid=3DTXT_TAGLM_WL_messenger_= yahoo_082008= --_8e0bf7c4-3a3f-43db-a30f-eae553166f7a_--