Re: Fwd: Dynamic enabling of log files
hi Nils! can u show me how to change the long_query_time using sql statement or by using mysqladmin. the set long_query_time=xyz; does not work or is this a valid command. i am using mysql 3.23.52 --- Nils Valentin <[EMAIL PROTECTED]> wrote: > Hi Prem, > > > Which version are you curently using 3.23.xxx ?? > > Whats the XXX in your version ??? > > What do the change log files say at the > www.mysql.com homepage ? > > > Best regards > > Nils Valentin > Tokyo/Japan > > > > Prem Soman wrote: > > Thanks neils! > > > > i have gone thru what u referred long before, i > know > > that this "set" method is not fully supported in > 3.23 > > version, thats why i posed this question, i wanted > to > > know whether there is any other way to do it. > > > > when i make changes to my.cnf file i am able to do > it > > but it is not immediatly reflected since mysqld > reads > > from the my.cnf file only when it restarts i > > thought there must be some sort of command line > > utility or ... to enable and disabke log files > > without restarting the server. > > > > can u also tell me from what version onwards is > this > > type of dynamic setting for log files allowed. > > > > Regards, > > Prem S > > > > --- Nils Valentin <[EMAIL PROTECTED]> wrote: > > > > >>Hi Prem, > >> > >>That question was just here 2 days ago, so easy to > >>answer. ;-) > >> > >> > >> > >>Logs can be enabled/disabled for the session with > >>SET SQL_LOG_OFF | > >>SQL_LOG_BIN | SQL_LOG_UPDATE. But these commands > are > >>not supported in > >>v3.23.52: > >> > http://www.mysql.com/doc/en/SET_OPTION.html > >> > >> > >>Best regards > >> > >>Nils Valenin > >>Tokyo/Japan > >> > >>2003年 8月 13日 水曜日 13:30、Prem Soman > >>さんは書きました: > >> > >>> Note: forwarded message attached. > >>> > >>> > >> > > > > > > >>>Want to chat instantly with your online friends? > >> > >>Get the FREE Yahoo! > >> > >>>Messenger http://uk.messenger.yahoo.com/ > >> > >>-- > >>--- > >>Valentin Nils > >>Internet Technology > >> > >> E-Mail: [EMAIL PROTECTED] > >> URL: http://www.knowd.co.jp > >> Personal URL: http://www.knowd.co.jp/staff/nils > >> > > > > > > > > > Want to chat instantly with your online friends? > Get the FREE Yahoo! > > Messenger http://uk.messenger.yahoo.com/ > > Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://uk.messenger.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Fwd: Dynamic enabling of log files
Prem Soman <[EMAIL PROTECTED]> wrote: > > i have gone thru what u referred long before, i know > that this "set" method is not fully supported in 3.23 > version, thats why i posed this question, i wanted to > know whether there is any other way to do it. > > when i make changes to my.cnf file i am able to do it > but it is not immediatly reflected since mysqld reads > from the my.cnf file only when it restarts i > thought there must be some sort of command line > utility or ... to enable and disabke log files > without restarting the server. In 3.23.xx you must restart MySQL server, if you change server options in my.cnf. > > can u also tell me from what version onwards is this > type of dynamic setting for log files allowed. Since 4.0.3 -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Fwd: Dynamic enabling of log files
Hi Prem, Which version are you curently using 3.23.xxx ?? Whats the XXX in your version ??? What do the change log files say at the www.mysql.com homepage ? Best regards Nils Valentin Tokyo/Japan Prem Soman wrote: Thanks neils! i have gone thru what u referred long before, i know that this "set" method is not fully supported in 3.23 version, thats why i posed this question, i wanted to know whether there is any other way to do it. when i make changes to my.cnf file i am able to do it but it is not immediatly reflected since mysqld reads from the my.cnf file only when it restarts i thought there must be some sort of command line utility or ... to enable and disabke log files without restarting the server. can u also tell me from what version onwards is this type of dynamic setting for log files allowed. Regards, Prem S --- Nils Valentin <[EMAIL PROTECTED]> wrote: > Hi Prem, That question was just here 2 days ago, so easy to answer. ;-) Logs can be enabled/disabled for the session with SET SQL_LOG_OFF | SQL_LOG_BIN | SQL_LOG_UPDATE. But these commands are not supported in v3.23.52: http://www.mysql.com/doc/en/SET_OPTION.html Best regards Nils Valenin Tokyo/Japan 2003å¹´ 8月 13æ—¥ 水曜日 13:30ã€?Prem Soman ã?•ã‚“ã?¯æ›¸ã??ã?¾ã?—ã?Ÿ: Note: forwarded message attached. Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://uk.messenger.yahoo.com/ -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://uk.messenger.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Fwd: Dynamic enabling of log files
Thanks neils! i have gone thru what u referred long before, i know that this "set" method is not fully supported in 3.23 version, thats why i posed this question, i wanted to know whether there is any other way to do it. when i make changes to my.cnf file i am able to do it but it is not immediatly reflected since mysqld reads from the my.cnf file only when it restarts i thought there must be some sort of command line utility or ... to enable and disabke log files without restarting the server. can u also tell me from what version onwards is this type of dynamic setting for log files allowed. Regards, Prem S --- Nils Valentin <[EMAIL PROTECTED]> wrote: > > Hi Prem, > > That question was just here 2 days ago, so easy to > answer. ;-) > > > > Logs can be enabled/disabled for the session with > SET SQL_LOG_OFF | > SQL_LOG_BIN | SQL_LOG_UPDATE. But these commands are > not supported in > v3.23.52: > http://www.mysql.com/doc/en/SET_OPTION.html > > > Best regards > > Nils Valenin > Tokyo/Japan > > 2003年 8月 13日 水曜日 13:30、Prem Soman > さんは書きました: > > Note: forwarded message attached. > > > > > > > Want to chat instantly with your online friends? > Get the FREE Yahoo! > > Messenger http://uk.messenger.yahoo.com/ > > -- > --- > Valentin Nils > Internet Technology > > E-Mail: [EMAIL PROTECTED] > URL: http://www.knowd.co.jp > Personal URL: http://www.knowd.co.jp/staff/nils > Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://uk.messenger.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Fwd: Dynamic enabling of log files
Hi Prem, That question was just here 2 days ago, so easy to answer. ;-) Logs can be enabled/disabled for the session with SET SQL_LOG_OFF | SQL_LOG_BIN | SQL_LOG_UPDATE. But these commands are not supported in v3.23.52: http://www.mysql.com/doc/en/SET_OPTION.html Best regards Nils Valenin Tokyo/Japan 2003年 8月 13日 水曜日 13:30、Prem Soman さんは書きました: > Note: forwarded message attached. > > > Want to chat instantly with your online friends? Get the FREE Yahoo! > Messenger http://uk.messenger.yahoo.com/ -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]