Re: [ADMIN] Log msg
Jie Liang wrote: Hi,All, How to config log file to log statement without CONTEXT stuff? I want log query, but not the detail unless there is a problem, e.g. Delete aaa from mytable where mysqlfunction(bbb); I want log this statement, but not any CONTEXT inside mysqlfunction, because it will easily filled up my disk if mytable have millions of entries, meanwhile, the log file become useless. But if I set log_statement = true, log file will log millions of statement in mysqlfunction, but I set log_statement=false, log file won't log query at all. Simply say, I want log what I execute(my query), but not how execute (process) . Decrease the verbosity of your logs using: log_error_verbosity = terse Regards Gaetano Mendola ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
[ADMIN] Log msg
Hi,All, How to config log file to log statement without CONTEXT stuff? I want log query, but not the detail unless there is a problem, e.g. Delete aaa from mytable where mysqlfunction(bbb); I want log this statement, but not any CONTEXT inside mysqlfunction, because it will easily filled up my disk if mytable have millions of entries, meanwhile, the log file become useless. But if I set log_statement = true, log file will log millions of statement in mysqlfunction, but I set log_statement=false, log file won't log query at all. Simply say, I want log what I execute(my query), but not how execute (process) . Jie Liang ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster ---(end of broadcast)--- TIP 8: explain analyze is your friend
[ADMIN] Log msg
How to config log file to log statement without CONTEXT stuff? I want log query, but not the detail unless there is a problem, e.g. Delete aaa from mytable where mysqlfunction(bbb); I want log this statement, but not any CONTEXT inside mysqlfunction, because it will easily filled up my disk if mytable have millions of entries, meanwhile, the log file become useless. But if I set log_statement = true, log file will log millions of statement in mysqlfunction, but I set log_statement=false, log file won't log query at all. Simply say, I want log what I execute(my query), but not how execute (process) . Jie Liang ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster