hi,
I have run the script mysql_install_db --with-innodb. then I am getting
the
mysql>show variables like "have_innodb";
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| have_innodb | YES |
+---------------+-------+
1 row in set (0.00 sec)
so, do you think I have done the write procedure for doing this...and
is it ensuring the enabling of innodb feature;
Thanks and regards,
Chetan Lavti
-----Original Message-----
From: Arjen Lentz [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 30, 2002 11:18 AM
To: Chetan Lavti
Cc: [EMAIL PROTECTED]
Subject: RE: InnoDB help !!
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
