Re: Disable innodb status info in err log
Jesper, I dont have a table called innodb_monitor on any of my databases, i gone through the links which you mentioned here.. but no luck.. Thanks Anand S On Wed, Mar 17, 2010 at 5:06 PM, Jesper Wisborg Krogh wrote: > On 17/03/2010, at 9:10 PM, Anand kumar wrote: > > you are right sir , the variables innodb_status_file will write the "show >> innodb status" information on to the file innodb_status.PID ... however >> for >> me the innodb status is logging into the default error log file... i dont >> have any clue on how to stop it from writing... >> >> Any help would be appreciated >> > > Do you happen to have a table called "innodb_monitor"? If that is present, > then that will cause the result of SHOW ENGINE INNODB STATUS to be outputted > every 15 seconds. See also > http://dev.mysql.com/doc/refman/5.0/en/innodb-monitors.html or > http://dev.mysql.com/doc/refman/5.1/en/innodb-monitors.html > > Cheers, > Jesper > >
Re: Disable innodb status info in err log
On 17/03/2010, at 9:10 PM, Anand kumar wrote: you are right sir , the variables innodb_status_file will write the "show innodb status" information on to the file innodb_status.PID ... however for me the innodb status is logging into the default error log file... i dont have any clue on how to stop it from writing... Any help would be appreciated Do you happen to have a table called "innodb_monitor"? If that is present, then that will cause the result of SHOW ENGINE INNODB STATUS to be outputted every 15 seconds. See also http://dev.mysql.com/doc/ refman/5.0/en/innodb-monitors.html or http://dev.mysql.com/doc/refman/ 5.1/en/innodb-monitors.html Cheers, Jesper
Re: Disable innodb status info in err log
you are right sir , the variables innodb_status_file will write the "show innodb status" information on to the file innodb_status.PID ... however for me the innodb status is logging into the default error log file... i dont have any clue on how to stop it from writing... Any help would be appreciated Thanks Anand On Wed, Mar 17, 2010 at 3:24 PM, RaMeSh wrote: > Greetings. > > Try with the variable innodb_status_file. > > I wont get logged in mysqlerr.log file. > > > > On 17 March 2010 15:15, Shanmugam, Dhandapani < > dhandapani.shanmu...@eds.com> wrote: > >> anand >> >> Do you use innodb engine at all further >> -D >> >> -Original Message- >> From: sanan...@gmail.com [mailto:sanan...@gmail.com] On Behalf Of Anand >> Sent: Wednesday, March 17, 2010 3:00 PM >> To: mysql@lists.mysql.com >> Subject: Disable innodb status info in err log >> >> Hi All, >> >> Innodb status information is getting logged on to my mysql error log >> file for every 15 seconds, can someone help in disabling it ? >> >> Thanks >> Anand >> >> -- >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe:http://lists.mysql.com/mysql?unsub=rames...@gmail.com >> >> > > > -- > Ramesh >
Re: Disable innodb status info in err log
Greetings. Try with the variable innodb_status_file. I wont get logged in mysqlerr.log file. On 17 March 2010 15:15, Shanmugam, Dhandapani wrote: > anand > > Do you use innodb engine at all further > -D > > -Original Message- > From: sanan...@gmail.com [mailto:sanan...@gmail.com] On Behalf Of Anand > Sent: Wednesday, March 17, 2010 3:00 PM > To: mysql@lists.mysql.com > Subject: Disable innodb status info in err log > > Hi All, > > Innodb status information is getting logged on to my mysql error log > file for every 15 seconds, can someone help in disabling it ? > > Thanks > Anand > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql?unsub=rames...@gmail.com > > -- Ramesh
RE: Disable innodb status info in err log
anand Do you use innodb engine at all further -D -Original Message- From: sanan...@gmail.com [mailto:sanan...@gmail.com] On Behalf Of Anand Sent: Wednesday, March 17, 2010 3:00 PM To: mysql@lists.mysql.com Subject: Disable innodb status info in err log Hi All, Innodb status information is getting logged on to my mysql error log file for every 15 seconds, can someone help in disabling it ? Thanks Anand -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Disable InnoDB
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. > > > >-- >MikeBlezien >=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= >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]
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. -- MikeBlezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= 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]
RE: Disable InnoDB
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?) 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. -- MikeBlezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= 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] =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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. -- MikeBlezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= 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] =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Disable InnoDB
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. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.13: up 31 days, processed 979,860,785 queries (357/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Disable InnoDB
JFL> Can i get more speed by disabling InnoDB tables, if I'm only using JFL> MyISAM and HEAP tables? JFL> Any warnings about this? If your server is need more resources ( memory , etc... ), Yes. The InnoDB only uses processor if the tables typped "InnoDB" are used , but the memory is allocated. to disable the InnoDB only put this line: skip-innodb in your my.cnf on [mysqld] section. but, only disable InnoDb not get more speed in your application , check the variables: key_buffer join_buffer sort_buffer This variables are very important in case of MyISAM tables. no warnings bye, - ++ Dyego Souza do Carmo ++ Dep. Desenvolvimento - E S C R I B A I N F O R M A T I C A - The only stupid question is the unasked one (somewhere in Linux's HowTo) Linux registred user : #230601 -- $ look into "my eyes" look: cannot open my eyes - Reply: [EMAIL PROTECTED] - 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
