Hi,
I have some trouble shutting the mysql_transYYYYMMDD.log up, it keeps getting
filled at ridiculous speed. When I start my application, the log fills up
the ~700MB log space within 12 hours! And this is not even running at the max
load to be expected in production.
I think this is way too much debug output:
trans[1001], 17:03:23.876, select r.id c0, r.state c1, r.start_time c2, r.request_interval c3, r.interval_type c4, r.interval_timeout c5, r.timeout c6, r.rep
etitions c7, r.repetitions_done c8, r.operation c9, r.rmon_data_source c10, r.rmon_buckets_requested c11, r.rmon_interval c12, r.rmon_rate_base c13, r.rmon_r
equested_size c14, r.rmon_which_table c15, r.user c16 from requests r where r.state = ?
trans[1001], 17:03:23.889, FindMany exeMicros[12545] rows[0] type[Request] name[] predicates[r.state = ? ] bind[ACTIVE]
trans[1001], 17:03:59.235, select a.id c0, a.hostname c1, a.community c2, a.snmp_version c3 from agents a where a.hostname = ?
trans[1001], 17:03:59.250, FindMany exeMicros[15322] rows[1] type[Agent] name[] predicates[a.hostname = ? ] bind[131.220.241.177]
trans[1002], 17:04:00.989, insert into requests (state, start_time, request_interval, interval_type, interval_timeout, timeout, repetitions, repetitions_done
, operation, rmon_data_source, rmon_buckets_requested, rmon_interval, rmon_rate_base, rmon_requested_size, rmon_which_table, user) values (?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
trans[1002], 17:04:00.996, Binding Insert [requests] set[state=ACTIVE, startTime=Sun Feb 21 17:04:14 CET 2010, requestInterval=10000, intervalType=0, interv
alTimeout=0, timeout=0, repetitions=2, repetitionsDone=null, operation=NLHOST, rmonDataSource=1, rmonBucketsRequested=5, rmonInterval=10, rmonRateBase=3, rmo
nRequestedSize=100, rmonWhichTable=0, user=abochem, ]
trans[1002], 17:04:00.997, Inserted [Request] [6]
trans[1002], 17:04:00.999, insert into request_agent_associations (request_id, agent_id) values (?, ?)
trans[1003], 17:04:01.009, InsertSql table[request_agent_associations] rows[1] bind[6, 1, ]
trans[1002], 17:04:01.018, select r.id c0, r.rmon_requested_size c1, r.state c2, r.request_interval c3, r.repetitions_done c4, r.repetitions c5, r.start_time
c6, r.operation c7, r.interval_type c8, r.rmon_data_source c9, r.interval_timeout c10, r.user c11, r.timeout c12 , ra.id c13, ra.community c14, ra.h
ostname c15, ra.snmp_version c16 from requests r left outer join request_agent_associations raz_ on raz_.request_id = r.id left outer join agents ra on ra.
id = raz_.agent_id where r.id = ? order by r.id
trans[1002], 17:04:01.031, FindById exeMicros[10836] rows[0:1] type[Request] bind[6]
trans[1003], 17:04:01.035, update requests set state=? where id=? and state=?
trans[1003], 17:04:01.035, Binding Update [requests] set[state=RUNNING, ] where[requestId=6, state=ACTIVE, ]
trans[1003], 17:04:01.036, Updated [Request] [6]
trans[1004], 17:04:14.103, insert into nl_host_entries (repetition, host_address, protocol_local_index, in_packets, out_packets, in_octets, out_octets, out_m
ac_non_unicast_pkts, create_time, request_id, agent_id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
...
etc.etc.etc...
I put in my ebean.properties those log-related options:
ebean.log.directory=logs
ebean.log.level=0
ebean.debug.transaction=0
ebean.debug.sql=false
ebean.debug.lazyload=false
ebean.log.share=2
ebean.log.iud=0
ebean.log.findid=0
ebean.log.findmany=0
I thought, all those 0's should do the trick - alas they don't.
I've been picking those options from various places, been desperately
searching for a complete list of all ebean properties to see if I got something
wrong or missed anything... but didn't find anything better.
Can you provide any help?
cheers,
Andreas