Re: Very slow query for no apparent reason
Posted by: Michal Singer
Date: December 08, 2010 02:21AM
Date: December 08, 2010 02:21AM
It takes up to 40 minutes. It depends on the load on the database of other queries.
It can take a few seconds, but on load it starts to increase.
What do you mean by MaxClients? are you refrering to max connections in the data source configuration? Why should this be 10? I have much more clients and connections i need.
BTW, according to the slow query log, the query is very short. (maybe it shows it in the slow query log only because there are no indexes used and not because it is slow)
Here is the full process list and also a few more parameters extracted from innotop:
CXN When Load QPS Slow QCacheHit KCacheHit BpsIn BpsOut
10.206.101.5 Now 0.00 633.96 79 0.00% 100.00% 41.18k 160.47k
10.206.101.5 Total 0.00 464.24 496.30k 0.00% 57.14% 31.24k 108.91k
___________________________________ Pending I/O ____________________________________
CXN Async Rds Async Wrt IBuf Async Rds Sync I/Os Log Flushes Log I/Os
10.206.101.5 0 0 0 0 1 0
_______________________________ File I/O Misc ________________________________
CXN OS Reads OS Writes OS fsyncs Reads/Sec Writes/Sec Bytes/Sec
10.206.101.5 334 3035904 2812704 0.00 11000.00 0
______________________________ Log Statistics ______________________________
CXN Sequence No. Flushed To Last Checkpoint IO Done IO/Sec
10.206.101.5 9 1316102102 9 1316100139 9 1300145750 2797935 11000.00
____________________________________ Buffer Pool ____________________________________
CXN Size Free Bufs Pages Dirty Pages Hit Rate Memory Add'l Pool
10.206.101.5 37.50k 11019 27094 1358 1000 / 1000 640.78M 6.28M
___________________________ Page Statistics ____________________________
CXN Reads Writes Created Reads/Sec Writes/Sec Creates/Sec
10.206.101.5 196 229720 26898 0.00 0.00 0.00
_____________________________ Insert Buffers _____________________________
CXN Inserts Merged Recs Merges Size Free List Len Seg. Size
10.206.101.5 0 0 0 1 5 7
_________________________ Adaptive Hash Index _________________________
CXN Size Cells Used Node Heap Bufs Hash/Sec Non-Hash/Sec
10.206.101.5 241000.00 133000.00
10.206.101.5 3776 root localhost ACTIVE 03:25 0 Select accelerators.acc_id,accelerators.name,accelerators.description,accelerators.timezone
Here is the full process list:
# [localhost] Query Window
# Connection: localhost
# Host: localhost
# Saved: 2010-12-08 11:05:50
#
# Query:
# show full processlist
#
'Id','User','Host','db','Command','Time','State','Info'
'2','root','localhost:4380','fresh','Sleep','3','','[NULL]'
'55','root','localhost:4631','fresh','Sleep','35','','[NULL]'
'2903','root','localhost:3381','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 681863 and linkID=-6 and appID=0'
'3002','root','localhost:3567','fresh','Query','0','statistics','Select * from id_ip_map where acc_id = 714643'
'3034','root','localhost:3668','fresh','Sleep','0','','[NULL]'
'3124','root','localhost:3875','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 714431 and linkID=-100 and appID=694978'
'3132','root','localhost:3895','fresh','Query','0','Searching rows for update','update monitors set acc_id=715452,last_monitoring_update=null,throughput_in=91,throughput_out=91,acceleration_in=0,acceleration_out=0,utilization_in=0,utilization_out=0,crc_errors=0,other_errors=0,dropped_in=-1,dropped_out=-1,license_exceeded=0,ipsec_in=0,ipsec_out=0,ipsec_drop=0 where acc_id = 715452'
'3154','root','localhost:3939','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 681555 and linkID=-100 and appID=700523'
'3336','root','localhost:4558','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 671122 and linkID=-102 and appID=676624'
'3363','root','localhost:4586','fresh','Query','0','freeing items','update monitors_interfaces set eth_out_collisions=0,eth_in_errors=0,eth_out_errors=0 where acc_id=681867 and intf_name='eth_00''
'3371','root','localhost:4594','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 714434 and linkID=-100 and appID=686864'
'3423','root','localhost:4647','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 671462 and linkID=-101 and appID=676777'
'3436','root','localhost:4660','fresh','Sleep','3','','[NULL]'
'3441','root','localhost:4665','fresh','Sleep','4','','[NULL]'
'3452','root','localhost:4676','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 671528 and linkID=-101 and appID=676840'
'3456','root','localhost:4680','fresh','Query','3','Sending data','select id, name from stats_applications where name in ('125','135','127','133','121','123','137','131','129','119')'
'3505','root','localhost:4730','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 714428 and linkID=-100 and appID=697251'
'3526','root','localhost:1115','fresh','Sleep','11','','[NULL]'
'3547','root','localhost:1285','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 671447 and linkID=734153 and appID=676782'
'3555','root','localhost:1316','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 801181 and linkID=-100 and appID=687392'
'3556','root','localhost:1317','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 714733 and linkID=721814 and appID=676834'
'3569','root','localhost:1337','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 715115 and linkID=-100 and appID=698294'
'3590','root','localhost:1502','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 671507 and linkID=-101 and appID=676566'
'3607','root','172.18.206.133:47028','[NULL]','Sleep','75','','[NULL]'
'3612','root','localhost:1733','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 714538 and linkID=-100 and appID=702276'
'3618','root','localhost:1773','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 714637 and linkID=-100 and appID=678498'
'3625','root','localhost:1788','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 669068 and linkID=-100 and appID=686731'
'3629','root','localhost:1792','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 714995 and linkID=-100 and appID=705181'
'3632','root','localhost:1799','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 681899 and linkID=-6 and appID=0'
'3640','root','localhost:1807','fresh','Query','0','freeing items','update monitors set acc_id=668855,last_monitoring_update=null,throughput_in=91,throughput_out=91,acceleration_in=0,acceleration_out=0,utilization_in=0,utilization_out=0,crc_errors=0,other_errors=0,dropped_in=-1,dropped_out=-1,license_exceeded=0,ipsec_in=0,ipsec_out=0,ipsec_drop=0 where acc_id = 668855'
'3645','root','localhost:1813','fresh','Query','0','statistics','Select * from id_ip_map where acc_id = 682238'
'3651','root','localhost:1819','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 681964 and linkID=-99 and appID=0'
'3652','root','localhost:1820','fresh','Query','0','Updating','update alerts set alert_prop_id=23,alert_severity=3,alert_description='CPU utilization below 5%',alert_first_occurrence_date='2010-12-07 12:17:26.000',alert_last_occurrence_date='2010-12-08 09:05:37.000',alert_last_occurrence_acc_time='2010-12-08 11:19:27.000',time_occurs_msec=0,alert_first_occurrence_date_acc_tz='2010-12-07 12:17:26.000',alert_last_occurrence_date_acc_tz='2010-12-08 09:05:37.000',acc_id=681600,link_id=-1,coll_branch_id=-1,alert_status=1,log_treatment='### The dates in this log are represented in GMT ###
12-07-2010 12:17 - The Real value is 3%
12-07-2010 12:47 - The Real value is 5%
12-07-2010 13:47 - The Real value is 5%
12-07-2010 14:47 - The Real value is 5%
12-07-2010 15:32 - The Real value is 3%
12-07-2010 16:32 - The Real value is 5%
12-07-2010 16:47 - The Real value is 1%
12-07-2010 18:17 - The Real value is 0%
12-07-2010 18:32 - The Real value is 4%
12-07-2010 19:32 - The Real value is 0%
12-07-2010 22:47 - The Real value is 0%
12-07-2010 23:33 - The Real value is 3%
12-08-2010 00:18 - The Real value is 1%
12-08-2010 01:18 - The Real value is 5%
12-08-2010 01:48 - The Real value is 2%
12-08-2010 02:18 - The Real value is 5%
12-08-2010 02:48 - The Real value is 0%
12-08-2010 05:02 - The Real value is 4%
12-08-2010 05:32 - The Real value is 0%
12-08-2010 06:02 - The Real value is 5%
12-08-2010 07:02 - The Real value is 3%
12-08-2010 07:47 - The Real value is 2%
12-08-2010 09:05 - The Real value is 0%',count=23 where alert_id = 713443'
'3664','root','localhost:1953','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 671537 and linkID=-102 and appID=676832'
'3690','root','localhost:1979','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 715045 and linkID=732670 and appID=677542'
'3698','root','localhost:1992','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 801231 and linkID=-2 and appID=0'
'3702','root','localhost:1996','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 681678 and linkID=-100 and appID=694178'
'3706','root','localhost:2007','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 671516 and linkID=733434 and appID=0'
'3708','root','localhost:2009','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 714419 and linkID=-100 and appID=686731'
'3713','root','localhost:2014','fresh','Query','0','Updating','update monitors_interfaces set eth_out_collisions=0,eth_in_errors=0,eth_out_errors=0 where acc_id=715659 and intf_name='eth_01''
'3717','root','localhost:2018','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 671411 and linkID=-99 and appID=0'
'3718','root','localhost:2019','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 669119 and linkID=820419 and appID=676810'
'3721','root','localhost:2022','fresh','Sleep','1','','[NULL]'
'3733','root','localhost:2221','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 671309 and linkID=-100 and appID=676804'
'3735','root','localhost:2227','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 671351 and linkID=789637 and appID=676803'
'3740','root','localhost:2232','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 715299 and linkID=-100 and appID=709094'
'3744','root','localhost:2236','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 715024 and linkID=-7 and appID=0'
'3747','root','localhost:2239','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 714592 and linkID=-100 and appID=676834'
'3758','root','localhost:2250','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 681856 and linkID=687196 and appID=676840'
'3762','root','localhost:2254','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 671312 and linkID=-101 and appID=676565'
'3763','root','localhost:2255','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 681951 and linkID=-100 and appID=683831'
'3767','root','localhost:2259','fresh','Query','0','Updating','update monitors_interfaces set eth_out_collisions=0,eth_in_errors=0,eth_out_errors=0 where acc_id=714784 and intf_name='eth_01''
'3776','root','localhost:2268','fresh','Query','137','Sending data','Select accelerators.acc_id,accelerators.name,accelerators.description,accelerators.timezone,accelerators.version,accelerators.configured_bw,accelerators.model,accelerators.acc_kind from accelerators'
'3781','root','localhost:2274','fresh','Sleep','3','','[NULL]'
'3784','root','localhost:2277','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 671468 and linkID=-99 and appID=0'
'3789','root','localhost:2398','fresh','Query','0','Updating','update monitors_interfaces set eth_out_collisions=0,eth_in_errors=0,eth_out_errors=0 where acc_id=667804 and intf_name='eth_01''
'3792','root','localhost:2404','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 714464 and linkID=-100 and appID=676809'
'3797','root','localhost:2409','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 715283 and linkID=-100 and appID=752776'
'3814','root','localhost:2445','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 667824 and linkID=-100 and appID=697762'
'3817','root','localhost:2448','fresh','Query','0','Updating','update monitors_interfaces set eth_out_collisions=0,eth_in_errors=0,eth_out_errors=0 where acc_id=715216 and intf_name='eth_01''
'3821','root','localhost:2465','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 801206 and linkID=801386 and appID=691104'
'3829','root','localhost:2476','fresh','Query','0','Updating','update monitors_interfaces set eth_out_collisions=0,eth_in_errors=0,eth_out_errors=0 where acc_id=681958 and intf_name='eth_00''
'3830','root','localhost:2477','fresh','Sleep','3','','[NULL]'
'3834','root','localhost:2481','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 671300 and linkID=-100 and appID=676782'
'3836','root','localhost:2483','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 669101 and linkID=674741 and appID=676784'
'3845','root','localhost:2492','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 671471 and linkID=733966 and appID=676586'
'3846','root','localhost:2493','fresh','Query','0','freeing items','update monitors set acc_id=715513,last_monitoring_update=null,throughput_in=91,throughput_out=91,acceleration_in=0,acceleration_out=0,utilization_in=0,utilization_out=0,crc_errors=0,other_errors=0,dropped_in=-1,dropped_out=-1,license_exceeded=0,ipsec_in=0,ipsec_out=0,ipsec_drop=0 where acc_id = 715513'
'3848','root','localhost:2495','fresh','Query','0','Searching rows for update','update monitors set acc_id=714817,last_monitoring_update=null,throughput_in=91,throughput_out=91,acceleration_in=0,acceleration_out=0,utilization_in=0,utilization_out=0,crc_errors=0,other_errors=0,dropped_in=-1,dropped_out=-1,license_exceeded=0,ipsec_in=0,ipsec_out=0,ipsec_drop=0 where acc_id = 714817'
'3850','root','localhost:2510','fresh','Query','30','Sending data','select id, name from stats_applications where name in ('241','281','195','197','285','191','283','193','289','287','199','245','243','249','247','203','205','301','303','201','305','169','307','309','271','207','165','273','209','167','275','239','277','279','231','233','235','237','211','263','261','215','319','213','317','179','219','315','177','217','313','311','171','175','173','269','267','265','221','251','223','225','227','323','293','187','229','295','189','321','291','181','297','183','299','185','257','259','253','255')'
'3858','root','localhost:2518','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 714437 and linkID=-100 and appID=676592'
'3864','root','localhost:2524','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 714425 and linkID=732223 and appID=677741'
'3868','root','localhost:2528','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 801163 and linkID=801358 and appID=689334'
'3892','root','localhost:2602','fresh','Query','0','statistics','Select acc_id from accelerators where acc_id = 668855'
'3898','root','localhost:2617','fresh','Sleep','4','','[NULL]'
'3899','root','localhost:2618','fresh','Sleep','3','','[NULL]'
'3901','root','localhost:2624','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 714721 and linkID=-8 and appID=0'
'3903','root','localhost:2626','fresh','Sleep','4','','[NULL]'
'3905','root','localhost:2628','fresh','Query','0','statistics','SELECT alert_id, acc_destination_id FROM alerts, links WHERE links.link_id=726149 and alerts.link_id = 726149'
'3908','root','localhost:2631','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 714586 and linkID=-100 and appID=676630'
'3909','root','localhost:2632','fresh','Query','0','Updating','update monitors_interfaces set eth_out_collisions=0,eth_in_errors=0,eth_out_errors=0 where acc_id=681807 and intf_name='eth_01''
'3910','root','localhost:2633','fresh','Query','0','Sending data','SELECT alerts.* FROM alerts WHERE alerts.acc_id = 671621 AND alert_prop_id = 1 AND link_id = -1'
'3913','root','localhost:2636','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 714739 and linkID=721719 and appID=676607'
'3923','root','localhost:2646','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 717796 and linkID=-102 and appID=687578'
'3938','root','localhost:2676','fresh','Query','338','Sending data','select acc_id, timezone from accelerators'
'3946','root','localhost:2684','fresh','Query','0','statistics','Select acc_id from accelerators where acc_id = 714865'
'3947','root','localhost:2685','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 714440 and linkID=-100 and appID=676814'
'3952','root','localhost:2690','fresh','Query','0','Searching rows for update','update monitors set acc_id=714847,last_monitoring_update=null,throughput_in=91,throughput_out=91,acceleration_in=0,acceleration_out=0,utilization_in=0,utilization_out=0,crc_errors=0,other_errors=0,dropped_in=-1,dropped_out=-1,license_exceeded=0,ipsec_in=0,ipsec_out=0,ipsec_drop=0 where acc_id = 714847'
'3964','root','localhost:2710','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 669038 and linkID=-100 and appID=676838'
'3968','root','localhost:2714','fresh','Query','0','Updating','update monitors_interfaces set eth_out_collisions=0,eth_in_errors=0,eth_out_errors=0 where acc_id=715048 and intf_name='eth_01''
'3977','root','localhost:2723','fresh','Sleep','3','','[NULL]'
'3982','root','localhost:2728','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 669077 and linkID=-100 and appID=676609'
'3984','root','localhost:2730','fresh','Query','0','statistics','Select * from accelerators where acc_id = 684217'
'3986','root','localhost:2732','fresh','Query','0','Searching rows for update','update monitors set acc_id=714434,last_monitoring_update=null,throughput_in=91,throughput_out=91,acceleration_in=0,acceleration_out=0,utilization_in=0,utilization_out=0,crc_errors=0,other_errors=0,dropped_in=-1,dropped_out=-1,license_exceeded=0,ipsec_in=0,ipsec_out=0,ipsec_drop=0 where acc_id = 714434'
'3988','root','localhost:2734','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 681666 and linkID=-100 and appID=676572'
'3990','root','localhost:2736','fresh','Query','9','Sending data','select id, name from stats_applications where name in ('240','280','194','196','284','190','282','192','288','286','198','244','242','248','246','202','300','204','302','304','200','230','306','308','270','272','206','166','274','208','168','276','278','232','234','236','238','262','212','260','210','318','216','316','214','314','178','312','176','218','310','170','174','172','268','266','264','220','250','222','252','224','226','294','188','228','324','296','290','320','292','322','180','182','298','184','186','258','254','256')'
'3991','root','localhost:2737','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 715006 and linkID=732291 and appID=679333'
'3993','root','localhost:2739','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 717790 and linkID=-101 and appID=688804'
'3994','root','localhost:2740','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 671306 and linkID=789598 and appID=676581'
'4006','root','localhost:2752','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 669056 and linkID=-100 and appID=676840'
'4008','root','localhost:2754','fresh','Sleep','3','','[NULL]'
'4010','root','localhost:2756','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 681672 and linkID=687095 and appID=676618'
'4015','root','localhost:2775','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 801164 and linkID=-101 and appID=687894'
'4028','root','localhost:2792','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 671354 and linkID=-2 and appID=0'
'4029','root','localhost:2793','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 714497 and linkID=799286 and appID=0'
'4031','root','localhost:2795','fresh','Query','0','Sending data','select * from waiting_tasks where acc_id=715625'
'4045','root','localhost:2809','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 714422 and linkID=-100 and appID=681089'
'4047','root','localhost:2816','fresh','Query','0','statistics','Select * from alerts_properties where alert_prop_id = 18'
'4048','root','localhost:2817','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 681669 and linkID=686918 and appID=0'
'4049','root','localhost:2818','fresh','Query','0','Searching rows for update','update monitors set acc_id=714550,last_monitoring_update=null,throughput_in=91,throughput_out=91,acceleration_in=0,acceleration_out=0,utilization_in=0,utilization_out=0,crc_errors=0,other_errors=0,dropped_in=-1,dropped_out=-1,license_exceeded=0,ipsec_in=0,ipsec_out=0,ipsec_drop=0 where acc_id = 714550'
'4050','root','localhost:2819','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 714598 and linkID=799320 and appID=676615'
'4057','root','localhost:2826','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 667828 and linkID=-100 and appID=680395'
'4064','root','localhost:2833','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 681549 and linkID=-100 and appID=694487'
'4065','root','localhost:2834','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 714458 and linkID=-102 and appID=676814'
'4067','root','localhost:2836','fresh','Query','0','Sending data','Select * from config where config_id = 668123'
'4075','root','localhost:2844','fresh','Query','0','freeing items','Update stats_sit set end_time = 21529860 where accID= 801144 and linkID=801334 and appID=690227'
'4083','root','localhost:2853','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 715571 and linkID=-102 and appID=676592'
'4086','root','localhost:2856','fresh','Query','0','Updating','update links_backups set acc_source_id=667848,active_link_id=718243,acc_destination_id=717775,link_number=143,link_type=1,name=null,use_default_parameters=0,status=19,acceleration=0,encapsulation=2,tcp_acceleration=1,checksum=0,outbound_bandwidth_value_type='absolute',outbound_bandwidth_size=1357046,inbound_bandwidth_value_type='absolute',inbound_bandwidth_size=1131221,inbound_bandwidth=1,description='L-166.166.166.20',mtu=217,header_compression=1,src=0,ttl=0,tos=1,tos_value=0,code_value=0,code_value_ip_precedence=0,tos_select=0,large_cash_size=0,fragmentation_status=1,fragmentation_size=687,Aggregation_status=1,Aggregation_size=2094,WanId=1,Max_qlen_low=-1,Max_qlen_meduim=-1,Max_qlen_high=-1,Max_qlen_real_time=-1,Max_qlen_passthrough=-1,Max_qlen_discard=-1,Obsolete_low=-1,Obsolete_meduim=-1,Obsolete_high=-1,Obsolete_real_time=-1,Obsolete_passthrough=-1,Obsolete_discard=-1,Weights_low=-1,Weights_meduim=-1,Weights_high=-1,Weights_real_time=-1,Weights_passthrough=-1,Weights_discard=-1,Creation_date='2010-12-07 13:19:40.000',Deletion_date='2030-02-01 00:00:00.000',monitored_applications='',poa_citrix='status=enabled
threshold=1500
limit=256
win_size=10
',poa_default='status=disabled
threshold=1500
limit=256
win_size=10
',poa_custom1='status=enabled
threshold=1500
limit=256
win_size=10
',poa_custom2='status=enabled
threshold=1500
limit=256
win_size=10
',ipsec_enable=0,ipsec_policy_name='Default',is_local_nat_ip_enabled=false,ipsec_local_nat_ip='0.0.0.0',is_remote_nat_ip_enabled=false,ipsec_remote_nat_ip='0.0.0.0',udpEncapSrcPort=0,udpEncapDstPort=1928,system_encapsulation=1,udpSysEncapSrcPort=1928,udpSysEncapDstPort=1928,portsPreservation=false,metric=0 where link_id=718245'
'4088','root','localhost:2858','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 717769 and linkID=-102 and appID=688630'
'4089','root','localhost:2968','fresh','Query','0','Updating','update stats_filesystem set firstfreeslot = 8294'
'4090','root','localhost:2969','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 671474 and linkID=734057 and appID=676799'
'4091','root','localhost:2970','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 671531 and linkID=-102 and appID=676617'
'4095','root','localhost:2974','fresh','Query','5','Sending data','select id, name from stats_applications where name in ('241','281','195','197','285','191','283','193','289','287','199','245','243','249','247','203','205','301','303','201','305','169','307','309','271','207','273','209','167','275','239','277','279','231','233','235','237','211','263','261','215','319','213','317','179','219','315','177','217','313','311','171','175','173','269','267','265','221','251','223','225','227','323','293','187','229','325','295','189','321','291','181','297','183','299','185','257','259','253','255')'
'4097','root','localhost:2976','fresh','Sleep','5','','[NULL]'
'4099','root','localhost:2978','fresh','Query','0','Sending data','Select link_id from links where acc_source_id='667816' and acc_destination_id='671119' and status <> 14'
'4101','root','localhost:2980','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 671303 and linkID=789607 and appID=676788'
'4102','root','localhost:2982','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 715637 and linkID=-101 and appID=676786'
'4103','root','localhost:2983','fresh','Sleep','3','','[NULL]'
'4104','root','localhost:2984','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 671144 and linkID=-101 and appID=676841'
'4106','root','localhost:2986','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 714580 and linkID=-100 and appID=676804'
'4108','root','localhost:2988','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 714449 and linkID=-101 and appID=676595'
'4109','root','localhost:2989','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 714491 and linkID=799271 and appID=676787'
'4111','root','localhost:2991','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 681697 and linkID=685085 and appID=0'
'4112','root','localhost:2992','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 681535 and linkID=-100 and appID=703454'
'4114','root','localhost:2994','fresh','Query','0','Sending data','select * from waiting_tasks where acc_id=801231'
'4117','root','localhost:2997','fresh','Query','0','Updating','update monitors_interfaces set eth_out_collisions=0,eth_in_errors=0,eth_out_errors=0 where acc_id=714649 and intf_name='eth_01''
'4121','root','localhost:3001','fresh','Query','0','Updating','update monitors_interfaces set eth_out_collisions=0,eth_in_errors=0,eth_out_errors=0 where acc_id=681951 and intf_name='eth_01''
'4124','root','localhost:3004','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 681663 and linkID=-100 and appID=679113'
'4125','root','localhost:3005','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 715291 and linkID=-100 and appID=708151'
'4130','root','localhost:3010','fresh','Query','0','freeing items','Update stats_sit set end_time = 21529860 where accID= 669062 and linkID=-100 and appID=676640'
'4135','root','localhost:3015','fresh','Query','0','statistics','Select * from accelerators where acc_id = 684561'
'4136','root','localhost:3016','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 801125 and linkID=-100 and appID=689515'
'4137','root','localhost:3017','fresh','Query','0','Sending data','Select * from config where config_id = 668123'
'4139','root','localhost:3019','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 714446 and linkID=799265 and appID=676850'
'4140','root','localhost:3022','fresh','Query','0','Updating','update monitors_interfaces set eth_out_collisions=0,eth_in_errors=0,eth_out_errors=0 where acc_id=681849 and intf_name='eth_00''
'4141','root','localhost:3023','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 671654 and linkID=-100 and appID=676563'
'4148','root','localhost:3030','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 714461 and linkID=-100 and appID=676574'
'4155','root','localhost:3038','fresh','Query','0','statistics','Select * from accelerators where acc_id = 681561'
'4156','root','localhost:3039','fresh','Query','0','statistics','Select * from accelerators where acc_id = 717787'
'4163','root','localhost:3046','fresh','Query','3','Sending data','select id, name from stats_applications where name in ('jsystem.exe','mstsc.exe','ethereal.exe','token2.exe','winspc.exe','vpn.exe','outlook.exe','vnc.exe','putty.exe','firefox.exe')'
'4164','root','localhost:3047','fresh','Query','0','statistics','select timezone from accelerators where acc_id = '714877''
'4165','root','localhost:3048','fresh','Sleep','3','','[NULL]'
'4167','root','localhost:3050','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 714541 and linkID=-100 and appID=705097'
'4169','root','localhost:3052','fresh','Sleep','4','','[NULL]'
'4174','root','172.18.206.133:52230','[NULL]','Sleep','7','','[NULL]'
'4179','root','localhost:3695','fresh','Query','0','statistics','Select * from accelerators where acc_id = 684186'
'4180','root','localhost:3696','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 714727 and linkID=721874 and appID=676605'
'4181','root','localhost:3697','fresh','Query','0','Searching rows for update','update monitors set acc_id=714877,last_monitoring_update=null,throughput_in=91,throughput_out=91,acceleration_in=0,acceleration_out=0,utilization_in=0,utilization_out=0,crc_errors=0,other_errors=0,dropped_in=-1,dropped_out=-1,license_exceeded=0,ipsec_in=0,ipsec_out=0,ipsec_drop=0 where acc_id = 714877'
'4182','root','localhost:3698','fresh','Query','0','statistics','Select * from id_ip_map where acc_id = 684027'
'4183','root','localhost:3699','fresh','Query','0','Sending data','Select * from links where acc_source_id=671615 and acc_destination_id=667816 and status <> 14'
'4184','root','localhost:3700','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 671651 and linkID=-101 and appID=676832'
'4185','root','localhost:3701','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 714625 and linkID=-100 and appID=689334'
'4186','root','localhost:3702','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 669110 and linkID=-100 and appID=676568'
'4187','root','localhost:3724','fresh','Query','0','[NULL]','show full processlist'
'4188','root','localhost:3734','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 681958 and linkID=699128 and appID=681684'
'4189','root','localhost:3735','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 681681 and linkID=-100 and appID=689160'
'4190','root','localhost:3736','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 671513 and linkID=-102 and appID=676617'
'4191','root','localhost:3737','fresh','Query','0','statistics','select status from links where link_id=685556'
'4192','root','localhost:3740','fresh','Query','0','Updating','update monitors_interfaces set eth_out_collisions=0,eth_in_errors=0,eth_out_errors=0 where acc_id=715378 and intf_name='eth_01''
'4193','root','localhost:3741','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 801205 and linkID=-99 and appID=0'
'4194','root','localhost:3742','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 681685 and linkID=-100 and appID=678900'
'4196','root','localhost:3747','fresh','Query','0','Searching rows for update','update monitors set acc_id=669116,last_monitoring_update=null,throughput_in=91,throughput_out=91,acceleration_in=0,acceleration_out=0,utilization_in=0,utilization_out=0,crc_errors=0,other_errors=0,dropped_in=-1,dropped_out=-1,license_exceeded=0,ipsec_in=0,ipsec_out=0,ipsec_drop=0 where acc_id = 669116'
'4197','root','localhost:3748','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 715303 and linkID=-100 and appID=700177'
'4198','root','localhost:3749','fresh','Sleep','3','','[NULL]'
'4199','root','localhost:3750','fresh','Sleep','4','','[NULL]'
'4200','root','localhost:3751','fresh','Sleep','3','','[NULL]'
'4201','root','localhost:3752','fresh','Query','0','freeing items','Update stats_sit set end_time = 21529860 where accID= 714988 and linkID=732486 and appID=677741'
'4202','root','localhost:3753','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 671366 and linkID=-101 and appID=676788'
'4203','root','localhost:3757','fresh','Sleep','1','','[NULL]'
'4204','root','localhost:3758','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 681945 and linkID=-100 and appID=688453'
'4205','root','localhost:3759','fresh','Query','4','Sending data','select id, name from stats_applications where name in ('134','126','132','128','138','122','136','124','120','130')'
'4206','root','localhost:3760','fresh','Query','0','Sending data','select link_id from links_backups where active_link_id =716059'
'4207','root','localhost:3763','fresh','Query','1','Sending data','SELECT alert_id, acc_destination_id FROM alerts, links WHERE links.link_id=676961 and alerts.link_id = 676961'
'4208','root','localhost:3764','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 669089 and linkID=820513 and appID=676590'
'4209','root','localhost:3765','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 681542 and linkID=-100 and appID=706004'
'4210','root','localhost:3766','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 801106 and linkID=-101 and appID=687894'
'4211','root','localhost:3767','fresh','Query','0','freeing items','update monitors set acc_id=681685,last_monitoring_update=null,throughput_in=91,throughput_out=91,acceleration_in=0,acceleration_out=0,utilization_in=0,utilization_out=0,crc_errors=0,other_errors=0,dropped_in=-1,dropped_out=-1,license_exceeded=0,ipsec_in=0,ipsec_out=0,ipsec_drop=0 where acc_id = 681685'
'4212','root','localhost:3768','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 714443 and linkID=799264 and appID=676592'
'4213','root','localhost:3769','fresh','Query','0','Searching rows for update','update monitors set acc_id=716181,last_monitoring_update=null,throughput_in=91,throughput_out=91,acceleration_in=0,acceleration_out=0,utilization_in=0,utilization_out=0,crc_errors=0,other_errors=0,dropped_in=-1,dropped_out=-1,license_exceeded=0,ipsec_in=0,ipsec_out=0,ipsec_drop=0 where acc_id = 716181'
'4214','root','localhost:3770','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 714646 and linkID=-100 and appID=686366'
'4215','root','localhost:3771','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 715144 and linkID=744440 and appID=697762'
'4216','root','localhost:3772','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 801196 and linkID=801362 and appID=689692'
'4217','root','localhost:3773','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 714751 and linkID=-100 and appID=676620'
'4218','root','localhost:3774','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 714745 and linkID=721770 and appID=676826'
'4219','root','localhost:3775','fresh','Query','0','Updating','update links_backups set acc_source_id=667844,active_link_id=717516,acc_destination_id=716727,link_number=128,link_type=1,name=null,use_default_parameters=0,status=19,acceleration=0,encapsulation=1,tcp_acceleration=0,checksum=1,outbound_bandwidth_value_type='absolute',outbound_bandwidth_size=1543612,inbound_bandwidth_value_type='absolute',inbound_bandwidth_size=251005,inbound_bandwidth=1,description='L-163.163.163.29',mtu=3708,header_compression=0,src=0,ttl=0,tos=1,tos_value=0,code_value=0,code_value_ip_precedence=0,tos_select=0,large_cash_size=0,fragmentation_status=1,fragmentation_size=5483,Aggregation_status=1,Aggregation_size=540,WanId=1,Max_qlen_low=-1,Max_qlen_meduim=-1,Max_qlen_high=-1,Max_qlen_real_time=-1,Max_qlen_passthrough=-1,Max_qlen_discard=-1,Obsolete_low=-1,Obsolete_meduim=-1,Obsolete_high=-1,Obsolete_real_time=-1,Obsolete_passthrough=-1,Obsolete_discard=-1,Weights_low=-1,Weights_meduim=-1,Weights_high=-1,Weights_real_time=-1,Weights_passthrough=-1,Weights_discard=-1,Creation_date='2010-12-07 13:19:31.000',Deletion_date='2030-02-01 00:00:00.000',monitored_applications='',poa_citrix='status=disabled
threshold=1500
limit=256
win_size=10
',poa_default='status=enabled
threshold=1500
limit=256
win_size=10
',poa_custom1='status=enabled
threshold=1500
limit=256
win_size=10
',poa_custom2='status=enabled
threshold=1500
limit=256
win_size=10
',ipsec_enable=0,ipsec_policy_name='Default',is_local_nat_ip_enabled=false,ipsec_local_nat_ip='0.0.0.0',is_remote_nat_ip_enabled=false,ipsec_remote_nat_ip='0.0.0.0',udpEncapSrcPort=0,udpEncapDstPort=1928,system_encapsulation=1,udpSysEncapSrcPort=1928,udpSysEncapDstPort=1928,portsPreservation=false,metric=0 where link_id=717518'
'4220','root','localhost:3776','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 671648 and linkID=-101 and appID=676565'
'4221','root','localhost:3777','fresh','Sleep','4','','[NULL]'
'4222','root','localhost:3778','fresh','Query','0','freeing items','update monitors set acc_id=715036,last_monitoring_update=null,throughput_in=91,throughput_out=91,acceleration_in=0,acceleration_out=0,utilization_in=0,utilization_out=0,crc_errors=0,other_errors=0,dropped_in=-1,dropped_out=-1,license_exceeded=0,ipsec_in=0,ipsec_out=0,ipsec_drop=0 where acc_id = 715036'
'4223','root','localhost:3779','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 671510 and linkID=-101 and appID=676832'
'4224','root','localhost:3780','fresh','Query','0','Sending data','Select * from links where acc_source_id=671375 and acc_destination_id=667816 and status <> 14'
'4225','root','localhost:3782','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 715308 and linkID=-100 and appID=702422'
'4226','root','localhost:3783','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 671417 and linkID=-101 and appID=676586'
Edited 5 time(s). Last edit at 12/08/2010 03:20AM by Michal Singer.
It can take a few seconds, but on load it starts to increase.
What do you mean by MaxClients? are you refrering to max connections in the data source configuration? Why should this be 10? I have much more clients and connections i need.
BTW, according to the slow query log, the query is very short. (maybe it shows it in the slow query log only because there are no indexes used and not because it is slow)
Here is the full process list and also a few more parameters extracted from innotop:
CXN When Load QPS Slow QCacheHit KCacheHit BpsIn BpsOut
10.206.101.5 Now 0.00 633.96 79 0.00% 100.00% 41.18k 160.47k
10.206.101.5 Total 0.00 464.24 496.30k 0.00% 57.14% 31.24k 108.91k
___________________________________ Pending I/O ____________________________________
CXN Async Rds Async Wrt IBuf Async Rds Sync I/Os Log Flushes Log I/Os
10.206.101.5 0 0 0 0 1 0
_______________________________ File I/O Misc ________________________________
CXN OS Reads OS Writes OS fsyncs Reads/Sec Writes/Sec Bytes/Sec
10.206.101.5 334 3035904 2812704 0.00 11000.00 0
______________________________ Log Statistics ______________________________
CXN Sequence No. Flushed To Last Checkpoint IO Done IO/Sec
10.206.101.5 9 1316102102 9 1316100139 9 1300145750 2797935 11000.00
____________________________________ Buffer Pool ____________________________________
CXN Size Free Bufs Pages Dirty Pages Hit Rate Memory Add'l Pool
10.206.101.5 37.50k 11019 27094 1358 1000 / 1000 640.78M 6.28M
___________________________ Page Statistics ____________________________
CXN Reads Writes Created Reads/Sec Writes/Sec Creates/Sec
10.206.101.5 196 229720 26898 0.00 0.00 0.00
_____________________________ Insert Buffers _____________________________
CXN Inserts Merged Recs Merges Size Free List Len Seg. Size
10.206.101.5 0 0 0 1 5 7
_________________________ Adaptive Hash Index _________________________
CXN Size Cells Used Node Heap Bufs Hash/Sec Non-Hash/Sec
10.206.101.5 241000.00 133000.00
10.206.101.5 3776 root localhost ACTIVE 03:25 0 Select accelerators.acc_id,accelerators.name,accelerators.description,accelerators.timezone
Here is the full process list:
# [localhost] Query Window
# Connection: localhost
# Host: localhost
# Saved: 2010-12-08 11:05:50
#
# Query:
# show full processlist
#
'Id','User','Host','db','Command','Time','State','Info'
'2','root','localhost:4380','fresh','Sleep','3','','[NULL]'
'55','root','localhost:4631','fresh','Sleep','35','','[NULL]'
'2903','root','localhost:3381','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 681863 and linkID=-6 and appID=0'
'3002','root','localhost:3567','fresh','Query','0','statistics','Select * from id_ip_map where acc_id = 714643'
'3034','root','localhost:3668','fresh','Sleep','0','','[NULL]'
'3124','root','localhost:3875','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 714431 and linkID=-100 and appID=694978'
'3132','root','localhost:3895','fresh','Query','0','Searching rows for update','update monitors set acc_id=715452,last_monitoring_update=null,throughput_in=91,throughput_out=91,acceleration_in=0,acceleration_out=0,utilization_in=0,utilization_out=0,crc_errors=0,other_errors=0,dropped_in=-1,dropped_out=-1,license_exceeded=0,ipsec_in=0,ipsec_out=0,ipsec_drop=0 where acc_id = 715452'
'3154','root','localhost:3939','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 681555 and linkID=-100 and appID=700523'
'3336','root','localhost:4558','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 671122 and linkID=-102 and appID=676624'
'3363','root','localhost:4586','fresh','Query','0','freeing items','update monitors_interfaces set eth_out_collisions=0,eth_in_errors=0,eth_out_errors=0 where acc_id=681867 and intf_name='eth_00''
'3371','root','localhost:4594','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 714434 and linkID=-100 and appID=686864'
'3423','root','localhost:4647','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 671462 and linkID=-101 and appID=676777'
'3436','root','localhost:4660','fresh','Sleep','3','','[NULL]'
'3441','root','localhost:4665','fresh','Sleep','4','','[NULL]'
'3452','root','localhost:4676','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 671528 and linkID=-101 and appID=676840'
'3456','root','localhost:4680','fresh','Query','3','Sending data','select id, name from stats_applications where name in ('125','135','127','133','121','123','137','131','129','119')'
'3505','root','localhost:4730','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 714428 and linkID=-100 and appID=697251'
'3526','root','localhost:1115','fresh','Sleep','11','','[NULL]'
'3547','root','localhost:1285','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 671447 and linkID=734153 and appID=676782'
'3555','root','localhost:1316','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 801181 and linkID=-100 and appID=687392'
'3556','root','localhost:1317','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 714733 and linkID=721814 and appID=676834'
'3569','root','localhost:1337','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 715115 and linkID=-100 and appID=698294'
'3590','root','localhost:1502','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 671507 and linkID=-101 and appID=676566'
'3607','root','172.18.206.133:47028','[NULL]','Sleep','75','','[NULL]'
'3612','root','localhost:1733','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 714538 and linkID=-100 and appID=702276'
'3618','root','localhost:1773','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 714637 and linkID=-100 and appID=678498'
'3625','root','localhost:1788','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 669068 and linkID=-100 and appID=686731'
'3629','root','localhost:1792','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 714995 and linkID=-100 and appID=705181'
'3632','root','localhost:1799','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 681899 and linkID=-6 and appID=0'
'3640','root','localhost:1807','fresh','Query','0','freeing items','update monitors set acc_id=668855,last_monitoring_update=null,throughput_in=91,throughput_out=91,acceleration_in=0,acceleration_out=0,utilization_in=0,utilization_out=0,crc_errors=0,other_errors=0,dropped_in=-1,dropped_out=-1,license_exceeded=0,ipsec_in=0,ipsec_out=0,ipsec_drop=0 where acc_id = 668855'
'3645','root','localhost:1813','fresh','Query','0','statistics','Select * from id_ip_map where acc_id = 682238'
'3651','root','localhost:1819','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 681964 and linkID=-99 and appID=0'
'3652','root','localhost:1820','fresh','Query','0','Updating','update alerts set alert_prop_id=23,alert_severity=3,alert_description='CPU utilization below 5%',alert_first_occurrence_date='2010-12-07 12:17:26.000',alert_last_occurrence_date='2010-12-08 09:05:37.000',alert_last_occurrence_acc_time='2010-12-08 11:19:27.000',time_occurs_msec=0,alert_first_occurrence_date_acc_tz='2010-12-07 12:17:26.000',alert_last_occurrence_date_acc_tz='2010-12-08 09:05:37.000',acc_id=681600,link_id=-1,coll_branch_id=-1,alert_status=1,log_treatment='### The dates in this log are represented in GMT ###
12-07-2010 12:17 - The Real value is 3%
12-07-2010 12:47 - The Real value is 5%
12-07-2010 13:47 - The Real value is 5%
12-07-2010 14:47 - The Real value is 5%
12-07-2010 15:32 - The Real value is 3%
12-07-2010 16:32 - The Real value is 5%
12-07-2010 16:47 - The Real value is 1%
12-07-2010 18:17 - The Real value is 0%
12-07-2010 18:32 - The Real value is 4%
12-07-2010 19:32 - The Real value is 0%
12-07-2010 22:47 - The Real value is 0%
12-07-2010 23:33 - The Real value is 3%
12-08-2010 00:18 - The Real value is 1%
12-08-2010 01:18 - The Real value is 5%
12-08-2010 01:48 - The Real value is 2%
12-08-2010 02:18 - The Real value is 5%
12-08-2010 02:48 - The Real value is 0%
12-08-2010 05:02 - The Real value is 4%
12-08-2010 05:32 - The Real value is 0%
12-08-2010 06:02 - The Real value is 5%
12-08-2010 07:02 - The Real value is 3%
12-08-2010 07:47 - The Real value is 2%
12-08-2010 09:05 - The Real value is 0%',count=23 where alert_id = 713443'
'3664','root','localhost:1953','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 671537 and linkID=-102 and appID=676832'
'3690','root','localhost:1979','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 715045 and linkID=732670 and appID=677542'
'3698','root','localhost:1992','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 801231 and linkID=-2 and appID=0'
'3702','root','localhost:1996','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 681678 and linkID=-100 and appID=694178'
'3706','root','localhost:2007','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 671516 and linkID=733434 and appID=0'
'3708','root','localhost:2009','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 714419 and linkID=-100 and appID=686731'
'3713','root','localhost:2014','fresh','Query','0','Updating','update monitors_interfaces set eth_out_collisions=0,eth_in_errors=0,eth_out_errors=0 where acc_id=715659 and intf_name='eth_01''
'3717','root','localhost:2018','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 671411 and linkID=-99 and appID=0'
'3718','root','localhost:2019','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 669119 and linkID=820419 and appID=676810'
'3721','root','localhost:2022','fresh','Sleep','1','','[NULL]'
'3733','root','localhost:2221','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 671309 and linkID=-100 and appID=676804'
'3735','root','localhost:2227','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 671351 and linkID=789637 and appID=676803'
'3740','root','localhost:2232','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 715299 and linkID=-100 and appID=709094'
'3744','root','localhost:2236','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 715024 and linkID=-7 and appID=0'
'3747','root','localhost:2239','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 714592 and linkID=-100 and appID=676834'
'3758','root','localhost:2250','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 681856 and linkID=687196 and appID=676840'
'3762','root','localhost:2254','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 671312 and linkID=-101 and appID=676565'
'3763','root','localhost:2255','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 681951 and linkID=-100 and appID=683831'
'3767','root','localhost:2259','fresh','Query','0','Updating','update monitors_interfaces set eth_out_collisions=0,eth_in_errors=0,eth_out_errors=0 where acc_id=714784 and intf_name='eth_01''
'3776','root','localhost:2268','fresh','Query','137','Sending data','Select accelerators.acc_id,accelerators.name,accelerators.description,accelerators.timezone,accelerators.version,accelerators.configured_bw,accelerators.model,accelerators.acc_kind from accelerators'
'3781','root','localhost:2274','fresh','Sleep','3','','[NULL]'
'3784','root','localhost:2277','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 671468 and linkID=-99 and appID=0'
'3789','root','localhost:2398','fresh','Query','0','Updating','update monitors_interfaces set eth_out_collisions=0,eth_in_errors=0,eth_out_errors=0 where acc_id=667804 and intf_name='eth_01''
'3792','root','localhost:2404','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 714464 and linkID=-100 and appID=676809'
'3797','root','localhost:2409','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 715283 and linkID=-100 and appID=752776'
'3814','root','localhost:2445','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 667824 and linkID=-100 and appID=697762'
'3817','root','localhost:2448','fresh','Query','0','Updating','update monitors_interfaces set eth_out_collisions=0,eth_in_errors=0,eth_out_errors=0 where acc_id=715216 and intf_name='eth_01''
'3821','root','localhost:2465','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 801206 and linkID=801386 and appID=691104'
'3829','root','localhost:2476','fresh','Query','0','Updating','update monitors_interfaces set eth_out_collisions=0,eth_in_errors=0,eth_out_errors=0 where acc_id=681958 and intf_name='eth_00''
'3830','root','localhost:2477','fresh','Sleep','3','','[NULL]'
'3834','root','localhost:2481','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 671300 and linkID=-100 and appID=676782'
'3836','root','localhost:2483','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 669101 and linkID=674741 and appID=676784'
'3845','root','localhost:2492','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 671471 and linkID=733966 and appID=676586'
'3846','root','localhost:2493','fresh','Query','0','freeing items','update monitors set acc_id=715513,last_monitoring_update=null,throughput_in=91,throughput_out=91,acceleration_in=0,acceleration_out=0,utilization_in=0,utilization_out=0,crc_errors=0,other_errors=0,dropped_in=-1,dropped_out=-1,license_exceeded=0,ipsec_in=0,ipsec_out=0,ipsec_drop=0 where acc_id = 715513'
'3848','root','localhost:2495','fresh','Query','0','Searching rows for update','update monitors set acc_id=714817,last_monitoring_update=null,throughput_in=91,throughput_out=91,acceleration_in=0,acceleration_out=0,utilization_in=0,utilization_out=0,crc_errors=0,other_errors=0,dropped_in=-1,dropped_out=-1,license_exceeded=0,ipsec_in=0,ipsec_out=0,ipsec_drop=0 where acc_id = 714817'
'3850','root','localhost:2510','fresh','Query','30','Sending data','select id, name from stats_applications where name in ('241','281','195','197','285','191','283','193','289','287','199','245','243','249','247','203','205','301','303','201','305','169','307','309','271','207','165','273','209','167','275','239','277','279','231','233','235','237','211','263','261','215','319','213','317','179','219','315','177','217','313','311','171','175','173','269','267','265','221','251','223','225','227','323','293','187','229','295','189','321','291','181','297','183','299','185','257','259','253','255')'
'3858','root','localhost:2518','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 714437 and linkID=-100 and appID=676592'
'3864','root','localhost:2524','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 714425 and linkID=732223 and appID=677741'
'3868','root','localhost:2528','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 801163 and linkID=801358 and appID=689334'
'3892','root','localhost:2602','fresh','Query','0','statistics','Select acc_id from accelerators where acc_id = 668855'
'3898','root','localhost:2617','fresh','Sleep','4','','[NULL]'
'3899','root','localhost:2618','fresh','Sleep','3','','[NULL]'
'3901','root','localhost:2624','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 714721 and linkID=-8 and appID=0'
'3903','root','localhost:2626','fresh','Sleep','4','','[NULL]'
'3905','root','localhost:2628','fresh','Query','0','statistics','SELECT alert_id, acc_destination_id FROM alerts, links WHERE links.link_id=726149 and alerts.link_id = 726149'
'3908','root','localhost:2631','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 714586 and linkID=-100 and appID=676630'
'3909','root','localhost:2632','fresh','Query','0','Updating','update monitors_interfaces set eth_out_collisions=0,eth_in_errors=0,eth_out_errors=0 where acc_id=681807 and intf_name='eth_01''
'3910','root','localhost:2633','fresh','Query','0','Sending data','SELECT alerts.* FROM alerts WHERE alerts.acc_id = 671621 AND alert_prop_id = 1 AND link_id = -1'
'3913','root','localhost:2636','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 714739 and linkID=721719 and appID=676607'
'3923','root','localhost:2646','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 717796 and linkID=-102 and appID=687578'
'3938','root','localhost:2676','fresh','Query','338','Sending data','select acc_id, timezone from accelerators'
'3946','root','localhost:2684','fresh','Query','0','statistics','Select acc_id from accelerators where acc_id = 714865'
'3947','root','localhost:2685','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 714440 and linkID=-100 and appID=676814'
'3952','root','localhost:2690','fresh','Query','0','Searching rows for update','update monitors set acc_id=714847,last_monitoring_update=null,throughput_in=91,throughput_out=91,acceleration_in=0,acceleration_out=0,utilization_in=0,utilization_out=0,crc_errors=0,other_errors=0,dropped_in=-1,dropped_out=-1,license_exceeded=0,ipsec_in=0,ipsec_out=0,ipsec_drop=0 where acc_id = 714847'
'3964','root','localhost:2710','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 669038 and linkID=-100 and appID=676838'
'3968','root','localhost:2714','fresh','Query','0','Updating','update monitors_interfaces set eth_out_collisions=0,eth_in_errors=0,eth_out_errors=0 where acc_id=715048 and intf_name='eth_01''
'3977','root','localhost:2723','fresh','Sleep','3','','[NULL]'
'3982','root','localhost:2728','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 669077 and linkID=-100 and appID=676609'
'3984','root','localhost:2730','fresh','Query','0','statistics','Select * from accelerators where acc_id = 684217'
'3986','root','localhost:2732','fresh','Query','0','Searching rows for update','update monitors set acc_id=714434,last_monitoring_update=null,throughput_in=91,throughput_out=91,acceleration_in=0,acceleration_out=0,utilization_in=0,utilization_out=0,crc_errors=0,other_errors=0,dropped_in=-1,dropped_out=-1,license_exceeded=0,ipsec_in=0,ipsec_out=0,ipsec_drop=0 where acc_id = 714434'
'3988','root','localhost:2734','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 681666 and linkID=-100 and appID=676572'
'3990','root','localhost:2736','fresh','Query','9','Sending data','select id, name from stats_applications where name in ('240','280','194','196','284','190','282','192','288','286','198','244','242','248','246','202','300','204','302','304','200','230','306','308','270','272','206','166','274','208','168','276','278','232','234','236','238','262','212','260','210','318','216','316','214','314','178','312','176','218','310','170','174','172','268','266','264','220','250','222','252','224','226','294','188','228','324','296','290','320','292','322','180','182','298','184','186','258','254','256')'
'3991','root','localhost:2737','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 715006 and linkID=732291 and appID=679333'
'3993','root','localhost:2739','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 717790 and linkID=-101 and appID=688804'
'3994','root','localhost:2740','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 671306 and linkID=789598 and appID=676581'
'4006','root','localhost:2752','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 669056 and linkID=-100 and appID=676840'
'4008','root','localhost:2754','fresh','Sleep','3','','[NULL]'
'4010','root','localhost:2756','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 681672 and linkID=687095 and appID=676618'
'4015','root','localhost:2775','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 801164 and linkID=-101 and appID=687894'
'4028','root','localhost:2792','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 671354 and linkID=-2 and appID=0'
'4029','root','localhost:2793','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 714497 and linkID=799286 and appID=0'
'4031','root','localhost:2795','fresh','Query','0','Sending data','select * from waiting_tasks where acc_id=715625'
'4045','root','localhost:2809','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 714422 and linkID=-100 and appID=681089'
'4047','root','localhost:2816','fresh','Query','0','statistics','Select * from alerts_properties where alert_prop_id = 18'
'4048','root','localhost:2817','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 681669 and linkID=686918 and appID=0'
'4049','root','localhost:2818','fresh','Query','0','Searching rows for update','update monitors set acc_id=714550,last_monitoring_update=null,throughput_in=91,throughput_out=91,acceleration_in=0,acceleration_out=0,utilization_in=0,utilization_out=0,crc_errors=0,other_errors=0,dropped_in=-1,dropped_out=-1,license_exceeded=0,ipsec_in=0,ipsec_out=0,ipsec_drop=0 where acc_id = 714550'
'4050','root','localhost:2819','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 714598 and linkID=799320 and appID=676615'
'4057','root','localhost:2826','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 667828 and linkID=-100 and appID=680395'
'4064','root','localhost:2833','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 681549 and linkID=-100 and appID=694487'
'4065','root','localhost:2834','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 714458 and linkID=-102 and appID=676814'
'4067','root','localhost:2836','fresh','Query','0','Sending data','Select * from config where config_id = 668123'
'4075','root','localhost:2844','fresh','Query','0','freeing items','Update stats_sit set end_time = 21529860 where accID= 801144 and linkID=801334 and appID=690227'
'4083','root','localhost:2853','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 715571 and linkID=-102 and appID=676592'
'4086','root','localhost:2856','fresh','Query','0','Updating','update links_backups set acc_source_id=667848,active_link_id=718243,acc_destination_id=717775,link_number=143,link_type=1,name=null,use_default_parameters=0,status=19,acceleration=0,encapsulation=2,tcp_acceleration=1,checksum=0,outbound_bandwidth_value_type='absolute',outbound_bandwidth_size=1357046,inbound_bandwidth_value_type='absolute',inbound_bandwidth_size=1131221,inbound_bandwidth=1,description='L-166.166.166.20',mtu=217,header_compression=1,src=0,ttl=0,tos=1,tos_value=0,code_value=0,code_value_ip_precedence=0,tos_select=0,large_cash_size=0,fragmentation_status=1,fragmentation_size=687,Aggregation_status=1,Aggregation_size=2094,WanId=1,Max_qlen_low=-1,Max_qlen_meduim=-1,Max_qlen_high=-1,Max_qlen_real_time=-1,Max_qlen_passthrough=-1,Max_qlen_discard=-1,Obsolete_low=-1,Obsolete_meduim=-1,Obsolete_high=-1,Obsolete_real_time=-1,Obsolete_passthrough=-1,Obsolete_discard=-1,Weights_low=-1,Weights_meduim=-1,Weights_high=-1,Weights_real_time=-1,Weights_passthrough=-1,Weights_discard=-1,Creation_date='2010-12-07 13:19:40.000',Deletion_date='2030-02-01 00:00:00.000',monitored_applications='',poa_citrix='status=enabled
threshold=1500
limit=256
win_size=10
',poa_default='status=disabled
threshold=1500
limit=256
win_size=10
',poa_custom1='status=enabled
threshold=1500
limit=256
win_size=10
',poa_custom2='status=enabled
threshold=1500
limit=256
win_size=10
',ipsec_enable=0,ipsec_policy_name='Default',is_local_nat_ip_enabled=false,ipsec_local_nat_ip='0.0.0.0',is_remote_nat_ip_enabled=false,ipsec_remote_nat_ip='0.0.0.0',udpEncapSrcPort=0,udpEncapDstPort=1928,system_encapsulation=1,udpSysEncapSrcPort=1928,udpSysEncapDstPort=1928,portsPreservation=false,metric=0 where link_id=718245'
'4088','root','localhost:2858','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 717769 and linkID=-102 and appID=688630'
'4089','root','localhost:2968','fresh','Query','0','Updating','update stats_filesystem set firstfreeslot = 8294'
'4090','root','localhost:2969','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 671474 and linkID=734057 and appID=676799'
'4091','root','localhost:2970','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 671531 and linkID=-102 and appID=676617'
'4095','root','localhost:2974','fresh','Query','5','Sending data','select id, name from stats_applications where name in ('241','281','195','197','285','191','283','193','289','287','199','245','243','249','247','203','205','301','303','201','305','169','307','309','271','207','273','209','167','275','239','277','279','231','233','235','237','211','263','261','215','319','213','317','179','219','315','177','217','313','311','171','175','173','269','267','265','221','251','223','225','227','323','293','187','229','325','295','189','321','291','181','297','183','299','185','257','259','253','255')'
'4097','root','localhost:2976','fresh','Sleep','5','','[NULL]'
'4099','root','localhost:2978','fresh','Query','0','Sending data','Select link_id from links where acc_source_id='667816' and acc_destination_id='671119' and status <> 14'
'4101','root','localhost:2980','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 671303 and linkID=789607 and appID=676788'
'4102','root','localhost:2982','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 715637 and linkID=-101 and appID=676786'
'4103','root','localhost:2983','fresh','Sleep','3','','[NULL]'
'4104','root','localhost:2984','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 671144 and linkID=-101 and appID=676841'
'4106','root','localhost:2986','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 714580 and linkID=-100 and appID=676804'
'4108','root','localhost:2988','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 714449 and linkID=-101 and appID=676595'
'4109','root','localhost:2989','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 714491 and linkID=799271 and appID=676787'
'4111','root','localhost:2991','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 681697 and linkID=685085 and appID=0'
'4112','root','localhost:2992','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 681535 and linkID=-100 and appID=703454'
'4114','root','localhost:2994','fresh','Query','0','Sending data','select * from waiting_tasks where acc_id=801231'
'4117','root','localhost:2997','fresh','Query','0','Updating','update monitors_interfaces set eth_out_collisions=0,eth_in_errors=0,eth_out_errors=0 where acc_id=714649 and intf_name='eth_01''
'4121','root','localhost:3001','fresh','Query','0','Updating','update monitors_interfaces set eth_out_collisions=0,eth_in_errors=0,eth_out_errors=0 where acc_id=681951 and intf_name='eth_01''
'4124','root','localhost:3004','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 681663 and linkID=-100 and appID=679113'
'4125','root','localhost:3005','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 715291 and linkID=-100 and appID=708151'
'4130','root','localhost:3010','fresh','Query','0','freeing items','Update stats_sit set end_time = 21529860 where accID= 669062 and linkID=-100 and appID=676640'
'4135','root','localhost:3015','fresh','Query','0','statistics','Select * from accelerators where acc_id = 684561'
'4136','root','localhost:3016','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 801125 and linkID=-100 and appID=689515'
'4137','root','localhost:3017','fresh','Query','0','Sending data','Select * from config where config_id = 668123'
'4139','root','localhost:3019','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 714446 and linkID=799265 and appID=676850'
'4140','root','localhost:3022','fresh','Query','0','Updating','update monitors_interfaces set eth_out_collisions=0,eth_in_errors=0,eth_out_errors=0 where acc_id=681849 and intf_name='eth_00''
'4141','root','localhost:3023','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 671654 and linkID=-100 and appID=676563'
'4148','root','localhost:3030','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 714461 and linkID=-100 and appID=676574'
'4155','root','localhost:3038','fresh','Query','0','statistics','Select * from accelerators where acc_id = 681561'
'4156','root','localhost:3039','fresh','Query','0','statistics','Select * from accelerators where acc_id = 717787'
'4163','root','localhost:3046','fresh','Query','3','Sending data','select id, name from stats_applications where name in ('jsystem.exe','mstsc.exe','ethereal.exe','token2.exe','winspc.exe','vpn.exe','outlook.exe','vnc.exe','putty.exe','firefox.exe')'
'4164','root','localhost:3047','fresh','Query','0','statistics','select timezone from accelerators where acc_id = '714877''
'4165','root','localhost:3048','fresh','Sleep','3','','[NULL]'
'4167','root','localhost:3050','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 714541 and linkID=-100 and appID=705097'
'4169','root','localhost:3052','fresh','Sleep','4','','[NULL]'
'4174','root','172.18.206.133:52230','[NULL]','Sleep','7','','[NULL]'
'4179','root','localhost:3695','fresh','Query','0','statistics','Select * from accelerators where acc_id = 684186'
'4180','root','localhost:3696','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 714727 and linkID=721874 and appID=676605'
'4181','root','localhost:3697','fresh','Query','0','Searching rows for update','update monitors set acc_id=714877,last_monitoring_update=null,throughput_in=91,throughput_out=91,acceleration_in=0,acceleration_out=0,utilization_in=0,utilization_out=0,crc_errors=0,other_errors=0,dropped_in=-1,dropped_out=-1,license_exceeded=0,ipsec_in=0,ipsec_out=0,ipsec_drop=0 where acc_id = 714877'
'4182','root','localhost:3698','fresh','Query','0','statistics','Select * from id_ip_map where acc_id = 684027'
'4183','root','localhost:3699','fresh','Query','0','Sending data','Select * from links where acc_source_id=671615 and acc_destination_id=667816 and status <> 14'
'4184','root','localhost:3700','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 671651 and linkID=-101 and appID=676832'
'4185','root','localhost:3701','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 714625 and linkID=-100 and appID=689334'
'4186','root','localhost:3702','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 669110 and linkID=-100 and appID=676568'
'4187','root','localhost:3724','fresh','Query','0','[NULL]','show full processlist'
'4188','root','localhost:3734','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 681958 and linkID=699128 and appID=681684'
'4189','root','localhost:3735','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 681681 and linkID=-100 and appID=689160'
'4190','root','localhost:3736','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 671513 and linkID=-102 and appID=676617'
'4191','root','localhost:3737','fresh','Query','0','statistics','select status from links where link_id=685556'
'4192','root','localhost:3740','fresh','Query','0','Updating','update monitors_interfaces set eth_out_collisions=0,eth_in_errors=0,eth_out_errors=0 where acc_id=715378 and intf_name='eth_01''
'4193','root','localhost:3741','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 801205 and linkID=-99 and appID=0'
'4194','root','localhost:3742','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 681685 and linkID=-100 and appID=678900'
'4196','root','localhost:3747','fresh','Query','0','Searching rows for update','update monitors set acc_id=669116,last_monitoring_update=null,throughput_in=91,throughput_out=91,acceleration_in=0,acceleration_out=0,utilization_in=0,utilization_out=0,crc_errors=0,other_errors=0,dropped_in=-1,dropped_out=-1,license_exceeded=0,ipsec_in=0,ipsec_out=0,ipsec_drop=0 where acc_id = 669116'
'4197','root','localhost:3748','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 715303 and linkID=-100 and appID=700177'
'4198','root','localhost:3749','fresh','Sleep','3','','[NULL]'
'4199','root','localhost:3750','fresh','Sleep','4','','[NULL]'
'4200','root','localhost:3751','fresh','Sleep','3','','[NULL]'
'4201','root','localhost:3752','fresh','Query','0','freeing items','Update stats_sit set end_time = 21529860 where accID= 714988 and linkID=732486 and appID=677741'
'4202','root','localhost:3753','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 671366 and linkID=-101 and appID=676788'
'4203','root','localhost:3757','fresh','Sleep','1','','[NULL]'
'4204','root','localhost:3758','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 681945 and linkID=-100 and appID=688453'
'4205','root','localhost:3759','fresh','Query','4','Sending data','select id, name from stats_applications where name in ('134','126','132','128','138','122','136','124','120','130')'
'4206','root','localhost:3760','fresh','Query','0','Sending data','select link_id from links_backups where active_link_id =716059'
'4207','root','localhost:3763','fresh','Query','1','Sending data','SELECT alert_id, acc_destination_id FROM alerts, links WHERE links.link_id=676961 and alerts.link_id = 676961'
'4208','root','localhost:3764','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 669089 and linkID=820513 and appID=676590'
'4209','root','localhost:3765','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 681542 and linkID=-100 and appID=706004'
'4210','root','localhost:3766','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 801106 and linkID=-101 and appID=687894'
'4211','root','localhost:3767','fresh','Query','0','freeing items','update monitors set acc_id=681685,last_monitoring_update=null,throughput_in=91,throughput_out=91,acceleration_in=0,acceleration_out=0,utilization_in=0,utilization_out=0,crc_errors=0,other_errors=0,dropped_in=-1,dropped_out=-1,license_exceeded=0,ipsec_in=0,ipsec_out=0,ipsec_drop=0 where acc_id = 681685'
'4212','root','localhost:3768','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 714443 and linkID=799264 and appID=676592'
'4213','root','localhost:3769','fresh','Query','0','Searching rows for update','update monitors set acc_id=716181,last_monitoring_update=null,throughput_in=91,throughput_out=91,acceleration_in=0,acceleration_out=0,utilization_in=0,utilization_out=0,crc_errors=0,other_errors=0,dropped_in=-1,dropped_out=-1,license_exceeded=0,ipsec_in=0,ipsec_out=0,ipsec_drop=0 where acc_id = 716181'
'4214','root','localhost:3770','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 714646 and linkID=-100 and appID=686366'
'4215','root','localhost:3771','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 715144 and linkID=744440 and appID=697762'
'4216','root','localhost:3772','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 801196 and linkID=801362 and appID=689692'
'4217','root','localhost:3773','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 714751 and linkID=-100 and appID=676620'
'4218','root','localhost:3774','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 714745 and linkID=721770 and appID=676826'
'4219','root','localhost:3775','fresh','Query','0','Updating','update links_backups set acc_source_id=667844,active_link_id=717516,acc_destination_id=716727,link_number=128,link_type=1,name=null,use_default_parameters=0,status=19,acceleration=0,encapsulation=1,tcp_acceleration=0,checksum=1,outbound_bandwidth_value_type='absolute',outbound_bandwidth_size=1543612,inbound_bandwidth_value_type='absolute',inbound_bandwidth_size=251005,inbound_bandwidth=1,description='L-163.163.163.29',mtu=3708,header_compression=0,src=0,ttl=0,tos=1,tos_value=0,code_value=0,code_value_ip_precedence=0,tos_select=0,large_cash_size=0,fragmentation_status=1,fragmentation_size=5483,Aggregation_status=1,Aggregation_size=540,WanId=1,Max_qlen_low=-1,Max_qlen_meduim=-1,Max_qlen_high=-1,Max_qlen_real_time=-1,Max_qlen_passthrough=-1,Max_qlen_discard=-1,Obsolete_low=-1,Obsolete_meduim=-1,Obsolete_high=-1,Obsolete_real_time=-1,Obsolete_passthrough=-1,Obsolete_discard=-1,Weights_low=-1,Weights_meduim=-1,Weights_high=-1,Weights_real_time=-1,Weights_passthrough=-1,Weights_discard=-1,Creation_date='2010-12-07 13:19:31.000',Deletion_date='2030-02-01 00:00:00.000',monitored_applications='',poa_citrix='status=disabled
threshold=1500
limit=256
win_size=10
',poa_default='status=enabled
threshold=1500
limit=256
win_size=10
',poa_custom1='status=enabled
threshold=1500
limit=256
win_size=10
',poa_custom2='status=enabled
threshold=1500
limit=256
win_size=10
',ipsec_enable=0,ipsec_policy_name='Default',is_local_nat_ip_enabled=false,ipsec_local_nat_ip='0.0.0.0',is_remote_nat_ip_enabled=false,ipsec_remote_nat_ip='0.0.0.0',udpEncapSrcPort=0,udpEncapDstPort=1928,system_encapsulation=1,udpSysEncapSrcPort=1928,udpSysEncapDstPort=1928,portsPreservation=false,metric=0 where link_id=717518'
'4220','root','localhost:3776','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 671648 and linkID=-101 and appID=676565'
'4221','root','localhost:3777','fresh','Sleep','4','','[NULL]'
'4222','root','localhost:3778','fresh','Query','0','freeing items','update monitors set acc_id=715036,last_monitoring_update=null,throughput_in=91,throughput_out=91,acceleration_in=0,acceleration_out=0,utilization_in=0,utilization_out=0,crc_errors=0,other_errors=0,dropped_in=-1,dropped_out=-1,license_exceeded=0,ipsec_in=0,ipsec_out=0,ipsec_drop=0 where acc_id = 715036'
'4223','root','localhost:3779','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 671510 and linkID=-101 and appID=676832'
'4224','root','localhost:3780','fresh','Query','0','Sending data','Select * from links where acc_source_id=671375 and acc_destination_id=667816 and status <> 14'
'4225','root','localhost:3782','fresh','Query','0','statistics','SELECT * from stats_sit where accID= 715308 and linkID=-100 and appID=702422'
'4226','root','localhost:3783','fresh','Query','0','Updating','Update stats_sit set end_time = 21529860 where accID= 671417 and linkID=-101 and appID=676586'
Edited 5 time(s). Last edit at 12/08/2010 03:20AM by Michal Singer.
Subject
Views
Written By
Posted
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.