Thanks for the Info Paul I guess since I'm a newbie and the server's not especially loaded or anything, I'll just leave it be.. (for the time being)
Thank Cheers, Mun Heng, Ow H/M Engineering Western Digital M'sia DID : 03-7870 5168 -----Original Message----- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 09, 2003 11:02 AM To: Ow Mun Heng; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Disable InnoDB At 9:46 +0800 7/7/03, Ow Mun Heng wrote: >Hi, > > This may be a stupid question but can I still just ask it? > > Why do you want to disable the use of InnoDB tables? If you don't >use it, couldn't the files still be there? It's not like it's a security >risk (or is it?) or that it takes up lots of space? (maybe this is true as >well?) It's not a security risk, but by starting the server with --skip-innodb, you disable the InnoDB storage engine. As a result, the server won't allocate any InnoDB-related buffers and will use less memory while it runs. > > I'm just starting out and my innoDB files are small. > >Cheers, >Mun Heng, Ow >H/M Engineering >Western Digital M'sia >DID : 03-7870 5168 > > >-----Original Message----- >From: Mike Blezien [mailto:[EMAIL PROTECTED] >Sent: Saturday, July 05, 2003 9:03 AM >To: [EMAIL PROTECTED] >Subject: Re: Disable InnoDB > > >Thanks, that did the trick :) > > >> Jeremy Zawodny wrote: >> On Fri, Jul 04, 2003 at 07:26:54PM -0500, Mike Blezien wrote: >> >>>Hello, >>> >>>Happy 4th to all :) >>> >>>Anyway, I am attempt to temporarily disable InnoDB tables. We just >>>setup on a new RH/Linux 7.3 server that had the MySQL version 4.0.13 >>>from RPM's, pre-installed... but we currently don't need the InnoDB >>>tables but may in the near future... I've commented out all the >>>relavent setting in the my.cnf file in the data >>>dir(/var/lib/mysql/my.cnf).. then restarted the MySQL server, but >>>it's still creates all the data file related to the InnoDB tables. >>> >>>is it not possible to disable the use of InnoDB tables using the >>>my.cnf file or not with RPM's ?? >> >> >> Put "skip-innodb" in your my.cnf file. > > > >-- >Mike<mickalo>Blezien >=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= >Thunder Rain Internet Publishing >Providing Internet Solutions that work! >http://www.thunder-rain.com >Web Hosting >http://www.justlightening.net >Tel: 1(985)902-8484 >MSN: [EMAIL PROTECTED] >=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
