RE: InnoDB help !! OS: Linux 7.1
hi, I have run the script mysql_install_db --with-innodb. then I am getting the mysqlshow 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
RE: InnoDB help !!
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 ?? Please, help me as much you can !! I have been stuck at this place. Thanks and regards, Chetan Lavti -Original Message- From: Arjen Lentz [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 29, 2002 10:42 AM To: Chetan Lavti Cc: [EMAIL PROTECTED] Subject: Re: InnoDB help !! Hi, On Tue, 2002-01-29 at 14:10, Chetan Lavti wrote: I have downloaded and installed MySQL ( rpm's). Now, I want to configure it with InnoDB option, as given in the manual, but can't see the below configure file anywhere. // cd /path/to/source/of/mysql-3.23.37 ./configure --with-innodb can anybody help me about this.. The info you mention is used when compiling from the source. You do not need to do this. Download the -Max .RPMs for your 3.23.xx version, and install those (keep the normal RPM you have already installed). This will set up a binary with InnoDB support, and fix up the startup scripts so that binary will be the one started. 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
RE: InnoDB help !!
Matthew, Tuesday, January 29, 2002, 6:37:32 AM, you wrote: MW You can only do this while compiling it from source. MW Matthew Walker MW Ecommerce Project Manager MW Mountain Top Herbs MW -Original Message- MW From: Chetan Lavti [mailto:[EMAIL PROTECTED]] MW Sent: Monday, January 28, 2002 9:11 PM MW To: [EMAIL PROTECTED] MW Subject: InnoDB help !! MW hi, MW I have downloaded and installed MySQL ( rpm's). Now, I want to configure MW it with InnoDB option, as given in the manual, MW but can't see the below configure file anywhere. MW // cd /path/to/source/of/mysql-3.23.37 MW./configure --with-innodb Yes, the configure script is only available in source tree. Take the MySQL-Max distribution from http://www.mysql.com/ and read http://www.mysql.com/doc/I/n/InnoDB.html to do the initial setup. -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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
RE: InnoDB help !!
Chetan, Tuesday, January 29, 2002, 7:02:18 AM, you wrote: CL thanks for reply, CL but I have installed MySQL on Linux using the RPM files and while using CL RPM files should I have to give the option while installing? As while CL using the RPM files there is no compilation. CL It is no where mentioned in the manual with the RPM files. can you CL please, help me out in details. Simply install and run the MySQL-Max server version. Don't forget to read the manual: http://www.mysql.com/doc/I/n/InnoDB.html CL Chetan Lavti -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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
RE: InnoDB help !!
Chetan, Tuesday, January 29, 2002, 4:06:30 PM, you wrote: CL thanks for your quick reply !! CL that's fine !! I have done the max.RPM installation part. CL but what is fix up the startup scripts so that CL binary will be the one started. CL When I am trying show variables like have_%; CL +---+---+ CL | Variable_name | Value | CL +---+---+ CL | have_bdb | NO| CL | have_gemini | NO| CL | have_innodb | NO| CL | have_isam | YES | CL | have_raid | NO| CL | have_openssl | NO| CL +---+---+ CL 6 rows in set (0.00 sec) CL It's not showing innoDB support. Ideally it should show after installing CL the max.RPM. shouldn't it ?? CL Please, help me as much you can !! I have been stuck at this place. Did you run mysqld-max after installation? If you don't have my.cnf, create it in /etc Specify configuration parameters in my.cnf. You can find startup information at: http://www.mysql.com/doc/I/n/InnoDB_start.html CL Chetan Lavti -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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
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
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
RE: InnoDB help !!
You can only do this while compiling it from source. Matthew Walker Ecommerce Project Manager Mountain Top Herbs -Original Message- From: Chetan Lavti [mailto:[EMAIL PROTECTED]] Sent: Monday, January 28, 2002 9:11 PM To: [EMAIL PROTECTED] Subject: InnoDB help !! hi, I have downloaded and installed MySQL ( rpm's). Now, I want to configure it with InnoDB option, as given in the manual, but can't see the below configure file anywhere. // cd /path/to/source/of/mysql-3.23.37 ./configure --with-innodb can anybody help me about this.. Thanks and regards, Chetan Lavti - 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 --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.317 / Virus Database: 176 - Release Date: 1/21/2002 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.317 / Virus Database: 176 - Release Date: 1/21/2002 - 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
Re: InnoDB help !!
Hi, On Tue, 2002-01-29 at 14:10, Chetan Lavti wrote: I have downloaded and installed MySQL ( rpm's). Now, I want to configure it with InnoDB option, as given in the manual, but can't see the below configure file anywhere. // cd /path/to/source/of/mysql-3.23.37 ./configure --with-innodb can anybody help me about this.. The info you mention is used when compiling from the source. You do not need to do this. Download the -Max .RPMs for your 3.23.xx version, and install those (keep the normal RPM you have already installed). This will set up a binary with InnoDB support, and fix up the startup scripts so that binary will be the one started. 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