thanks again, It seems, you suggesting that after setting changes in the configuration file the "Show variable....." will list out the 'YES' in front of 'have_innodb' (in table below). right ??
The second thing is that, how do I test for the innoDB support ? specifically whether it is making the my database memory-resident or not. Thank u very much once again. regards, Chetan Lavti -----Original Message----- From: Arjen Lentz [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 30, 2002 3:11 AM To: Chetan Lavti Cc: [EMAIL PROTECTED] Subject: RE: InnoDB help !! Hi, On Wed, 2002-01-30 at 00:06, Chetan Lavti wrote: > thanks for your quick reply !! > > that's fine !! I have done the max.RPM installation part. > but what is "fix up the startup scripts so that > binary will be the one started." > > When I am trying "show variables like "have_%"; > +---------------+-------+ > | Variable_name | Value | > +---------------+-------+ > | have_bdb | NO | > | have_gemini | NO | > | have_innodb | NO | > | have_isam | YES | > | have_raid | NO | > | have_openssl | NO | > +---------------+-------+ > 6 rows in set (0.00 sec) > > It's not showing innoDB support. Ideally it should show after installing > the max.RPM. shouldn't it ?? No. In any 3.23 version, the default for all alternate table types is off. You have to explicitly enable them by specifying their configuration parameters. See http://www.mysql.com/doc/I/n/InnoDB_start.html and the rest of the InnoDB chapter in the online manual for configuration details. Regards, Arjen. -- Get MySQL Training Worldwide, http://www.mysql.com/training/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Arjen G. Lentz <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Writer, Trainer /_/ /_/\_, /___/\___\_\___/ Brisbane, QLD Australia <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
