Hi,
On Wed, 2002-01-30 at 15:19, Chetan Lavti wrote:
> 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 ??
Indeed.
> The second thing is that, how do I test for the innoDB support ?
In exactly the same way. You can run the above query from your
application too, no prob. For instance:
SHOW VARIABLES LIKE "have_innodb"
If the result set contains at least 1 row and the "Value" (2nd) column
of the result set is "YES", then you know that InnoDB is enabled in the
server.
> specifically whether it is making the my database memory-resident or
> not.
What do you mean?
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
