Hello, I was wondering if anybody here is having problems with slow queries (inserts, updates) too, e.g.,:
Code: # Time: 080220 11:37:22 # [EMAIL PROTECTED]: zenoss[zenoss] @ localhost [] # Query_time: 8 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET timestamp=1203507442; insert into status set prodState=1000,firstTime=1203507434.959,severity=3,eventClassKey='topologyChange',component='',DeviceGroups='|',agent='zentrap',summary='snmp trap topologyChange',dedupid='xxx||||3|snmp trap topologyChange',eventKey='',manager='localhost',eventGroup='trap',Location='/MeLocation',device='xxx',DevicePriority=3,message='snmp trap topologyChange',lastTime=1203507434.959,ipAddress='xxx',Systems='|/SAs',DeviceClass='/Monitored',evid='ac1e247b3669a36a54f6db2' on duplicate key update prodState=1000,summary='snmp trap topologyChange',count=count+1,lastTime=1203507434.959; # Time: 080220 11:37:37 # [EMAIL PROTECTED]: zenoss[zenoss] @ localhost [] # Query_time: 19 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET timestamp=1203507457; insert into heartbeat set device='artemis.eu.lan',component='zenactions',timeout=180 on duplicate key update lastTime=Null, timeout=180; # Time: 080220 11:37:42 # [EMAIL PROTECTED]: zenoss[zenoss] @ localhost [] # Query_time: 20 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET timestamp=1203507462; insert into heartbeat set device='localhost',component='zenmodeler',timeout=90 on duplicate key update lastTime=Null, timeout=90; I changed MySQL's innodb settings (enlarging buffers, logs...) but this did not help. Can you suggest me any settings with 2GB of memory? -------------------- m2f -------------------- Read this topic online here: http://community.zenoss.com/forums/viewtopic.php?p=16466#16466 -------------------- m2f -------------------- _______________________________________________ zenoss-users mailing list [email protected] http://lists.zenoss.org/mailman/listinfo/zenoss-users
