Moderators: enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, s0lid
mysql> select * from vicidial_auto_calls where channel is null and last_update_time>=100;
max_connections=16000
max_heap_table_size=4096M
query_cache_size = 0
# Time: 131105 16:43:30
# User@Host: cron[cron] @ localhost []
# Query_time: 19 Lock_time: 0 Rows_sent: 2000 Rows_examined: 6401430
SELECT lead_id,list_id,gmt_offset_now,phone_number,state,status,modify_date,user,vendor_lead_code FROM vicidial_list where called_since_last_reset='N' and status IN('AA','NEW') and list_id IN('500','202') and lead_id NOT IN('5832389','5832129','5832131','5832881','5832157','5832110','5832101','5832461','5832691','5832852','5832999','5832274','5832608','5832885','5832091','5833016','5832600','5832246','5832207','5832730','5832563','5832831','5832718','5832968','5832212','5832405','5832867','5832752','5832315','5832277','5832455','5832801','5832725','5832306','5832180','5832942','5832784','5832999','5832983','5832971','5832963','5832955','5832947','5832939','5832104','5832931','5832923','5832915','5832907','5832102','5832899','5832514','5832316','5832891','5832704','5832740','5832201','5832883','5832975','5832875','5832867','5832925','5832813','5832954','5832859','5832415','5832625','5832529','5832851','5832788','5832812','5832815','5832692','5832843','5832835','5832827','5832161','5832819','5832911','5832811','5832803','5832795','5832440','5832787','5832394','5832779','5832771','5832763','5832755','5832747','5832739','5832731','5832723','5832715','5832707','5832699','5832691','5832621','5832683','5832675','5832667','5832659','5832651','5832643','5832499','5832467','5832635','5832627','5832619','5832710','5832611','5832914','5832603','5832591','5832575','5832559','5832543','5832527','5832515','5832483','5832451','5832439','5832423','5832407','5832391','5832375','5832359','5832351','5832343','5832335','5832327','5832319','5832311','5832303','5833018','5832295','5832287','5832279','5832915','5832271','5832267','5832251','5832509','5832237','5832227','5832219','5832211','5832273','5832257','5832841','5832241','5832199','5832191','5832183','5832506','5832747','5832175','5832429','5832364','5832167','5832159','5832151','5832143','5832135','5832131','5832119','5832111','5832694','5832103','5832095','5832083','5832087','5832127','5832279','5832817','5832617','5832924','5832242','5832172','5832306','5832906','5832686','5832774','5832696','5832511','5832607','5832779','5832413','5832484','5832355','5832378','5832890','5832209','5833049','5832380','5832580','5832505','5832565','5832421','5833009','5832685','5832717','5832957','5832661','5832343','5832988','5832479','5832289','5832219','5832314','5832614','5832780','5832652','5832123','5832537','5832137','5832281','5832429','5832469','5832605','5832385','5832941','5832741','5832837','5832772','5832585','5832501','5832433','5832564','5832571','5832605','5832919','5832660','5832337','5832151','5832555','5832349','5832458','5832237','5832884','5832120','5832951','5832808','5832460','5833041','5833025','5832325','5832281','5832523','5832760','5832519','5832732','5832596','5832857','5832874','5832412','5832751','5832575','5832656','5832285','5832712','5832088','5832453','5832792','5832557','5832959','5832501','5832521','5832707','5832912','5832589','5832139','5832130','5832673','5832146','5832733','5832162','5832556','5832113','5832082','5832090','5832103','5832098','5832689','5832106','5832114','5832124','5832235','5832140','5832172','5832864','5832497','5832474','5832294','5832310','5832322','5832340','5832358','5832840','5832374','5832398','5832777','5832182','5832190','5832198','5832206','5832756','5832598','5832214','5832222','5833043','5832503','5832230','5832238','5832246','5832224','5832254','5832262','5832373','5832768','5832270','5832278','5832300','5832286','5832302','5832842','5832318','5832213','5832330','5832350','5832366','5832662','5832382','5832390','5832406','5832414','5832422','5832430','5832620','5832973','5832991','5832438','5832446','5832454','5832462','5832470','5832757','5832478','5832486','5832494','5832502','5832612','5832132','5832664','5832647','5832173','5832583','5832510','5832518','5832636','5832526','5832469','5832288','5832534','5832320','5832542','5832657','5832827','5832164','5832546','5832403','5832745','5832554','5832360','5832895','5832562','5832778','5832570','5832578','5832485','5832586','5832594','5832339','5832602','5832610','5832618','5832215','5832257','5832268','5832787','5832626','5832634','5832220','5832721','5832573','5832113','5832642','5832650','5832664','5832674','5832682','5832690','5832698','5832706','5832714','5832722','5832730','5832738','5832746','5832754','5832762','5832770','5833033','5832778','5832786','5832794','5832802','5832156','5832157','5832697','5832810','5832818','5832826','5832830','5833031','5832834','5832441','5832842','5832861','5832850','5832984','5832862','5832878','5832894','5833017','5832906','5832922','5832938','5832907','5832954','5832966','5832974','5832982','5832463','5832990','5832998','5832096','5832252','5833006','5832613','5832304','5833014','5833022','5832417','5833030','5832282','5833040','5832866','5832524','5832882','5832898','5832918','5832475','5832934','5832970','5832950','5833048','5833027','5832973','5832940','5833036','5832161','5832234','5832381','5832386','5832408','5832473','5832244','5832629','5832701','5832765','5832183','5833023','5832322','5832208','5832684','5832796','5832193','5832173','5832197','5832481','5832449','5832673','5832801','5832401','5832505','5832672','5832125','5833013','5833015','5832997','5832537','5833039','5833042','5833026','5833010','5832994','5832978','5832962','5832500','5832401','5832946','5832721','5832930','5832914','5832898','5832093','5832092','5832181','5832882','5832964','5832866','5832921','5832850','5832834','5832818','5832457','5832802','5832627','5832786','5832761','5832770','5832175','5832101','5832728','5832201','5832754','5832345','5832247','5832517','5832738','5832550','5832845','5832722','5832706','5832693','5832690','5832789','5832674','5832933','5832658','5832642','5832177','5832609','5833017','5832618','5832586','5832678','5832570','5832546','5832428','5832530','5832514','5832111','5832379','5832858','5832626','5832594','5832459','5832615','5832266','5833011','5832164','5832482','5832490','5832411','5832458','5832442','5832443','5832467','5832426','5832410','5832479','5832394','5832378','5832511','5832362','5832547','5832346','5832330','5832579','5832314','5832298','5832328','5832987','5832282','5832258','5832734','5832235','5832230','5832927','5832849','5832214','5832264','5832202','5832365','5832186','5832162','5832146','5832122','5832130','5832099','5832392','5832856','5832857','5832098','5832082','5832977','5832152','5832248','5832727','5832445','5832628','5832200','5832805','5832731','5832962','5832717','5832535','5832699','5832334','5832453','5832233','5832875','5832956','5832566','5832905','5832114','5832606','5832969','5832492','5832170','5833036','5832978','5832777','5832333','5832181','5832565','5832986','5832233','5832388','5832587','5832338','5832089','5832669','5832871','5832138','5832828','5833024','5832437','5833049','5832307','5832771','5832545','5832723','5832985','5832939','5832291','5832155','5832419','5832387','5832811','5832650','5832758','5832313','5832097','5832560','5832127','5832929','5832905','5832341','5832489','5832089','5832209','5832250','5832559','5832270','5832097','5832217','5832797','5832402','5832204','5832967','5832685','5832137','5832285','5832922','5832352','5832798','5832817','5832700','5833010','5832681','5832426','5832218','5832979','5832846','5832571','5832539','5832503','5832193','5832267','5832471','5832435','5832403','5832371','5832416','5833051','5832367','5832577','5832106','5832941','5832543','5832963','5832573','5832368','5832109','5832588','5832168','5832466','5833051','5832434','5832793','5833035','5832186','5832347','5833011','5833009','5832800','5832274','5832993','5832179','5832497','5832196','5832538','5832421','5832657','5832926','5832601','5832269','5832821','5833048','5832455','5832488','5832547','5832531','5832890','5833001','5832245','5833019','5832835','5832357','5832423','5832892','5832393','5832958','5832809','5832979','5832323','5832689','5832681','5832156','5832961','5832231','5832804','5833045','5832195','5832863','5832676','5832599','5832312','5832321','5832517','5832241','5832338','5832791','5832649','5832766','5832986','5832933','5832854','5832465','5832189','5832983','5832308','5832287','5832419','5832987','5832645','5832865','5832841','5832277','5832203','5833012','5832610','5832643','5832536','5832437','5832568','5832522','5832433','5832086','5832225','5832110','5832624','5832507','5832102','5832150','5832301','5832945','5832190','5832272','5832218','5832603','5832236','5832266','5832775','5832286','5832790','5832302','5832870','5832318','5832595','5832229','5832334','5832350','5832263','5832366','5832638','5832555','5832513','5832382','5832391','5832398','5833027','5833034','5832414','5832194','5832456','5832430','5832371','5832446','5832633','5832675','5832169','5832470','5832462','5832960','5832494','5832606','5832502','5832518','5832534','5832554','5832869','5832757','5832661','5832621','5832744','5832457','5832313','5832169','5832574','5832324','5832112','5832598','5832820','5832436','5832630','5832646','5832662','5832678','5832981','5832992','5832694','5832710','5832726','5832558','5832742','5832758','5832094','5832853','5832774','5832790','5832822','5832533','5832806','5832321','5832525','5832822','5832561','5832838','5832109','5832854','5832870','5832184','5832886','5832902','5832353','5832918','5832118','5832158','5832893','5832989','5832773','5832198','5832934','5832776','5832950','5832105','5832896','5832966','5832296','5832982','5832998','5833014','5833030','5832086','5832785','5833046','5832538','5832167','5832794','5832671','5832641','5832290','5832305','5832825','5832724','5833003','5832991','5832975','5832967','5832959','5832951','5832943','5832935','5832927','5832919','5832911','5832903','5832532','5832895','5832292','5832129','5832309','5832601','5832873','5832737','5832897','5832887','5832879','5832871','5832863','5832855','5832847','5832839','5832831','5832668','5832823','5832171','5832592','5832815','5832807','5832729','5832799','5832791','5832783','5832345','5832775','5832767','5832759','5832189','5832736','5832751','5832743','5832735','5832727','5832354','5832719','5832945','5832711','5832293','5832703','5832695','5832687','5832530','5832384','5832679','5832663','5832671','5832663','5832655','5832647','5832507','5832284','5832909','5832765','5832475','5832639','5832631','5832623','5832615','5832607','5832197','5832687','5832239','5832485','5832883','5832832','5832336','5832599','5832583','5832567','5832178','5832793','5832551','5832535','5832886','5832519','5832471','5832491','5832459','5832447','5832226','5832548','5832735','5832431','5832932','5832397','5833050','5832415','5832399','5832383','5832367','5832355','5832826','5832347','5832339','5832160','5832508','5832331','5832323','5832315','5832307','5832742','5833034','5832299','5832291','5832122','5832617','5832283','5832275','5832259','5832243','5832477','5832231','5832715','5832223','5832215','5832353','5832207','5832265','5832249','5832960','5832203','5832195','5832944','5832187','5832179','5832432','5832899','5832143','5832171','5832436','5832163','5832155','5832713','5832640','5832147','5832139','5832928','5832079','5832123','5832228','5832115','5832107','5832912','5832099','5832091','5832892','5832259','5832876','5832107','5832972','5832860','5832705','5833038','5832649','5832405','5832499','5833013','5832716','5832714','5832688','5833028','5832138','5833020','5833012','5833004','5832996','5832623','5832988','5832980','5832258','5833002','5832528','5832719','5832972','5832964','5832816','5832948','5832932','5832916','5832904','5832383','5832221','5832900','5832888','5832901','5832872','5832753','5832293','5832133','5832516','5832562','5832856','5832848','5832840','5832513','5832541','5832191','5832165','5832232','5832584','5832340','5832450','5832848','5832832','5832874','5832824','5832816','5832808','5832115','5832800','5832792','5832788','5832776','5832369','5832768','5832753','5832748','5832760','5832147','5832752','5832740','5832724','5832117','5832708','5832736','5832829','5832720','5832572','5832704','5832442','5832696','5832688','5832970','5832680','5832672','5833053','5832660','5832450','5832648','5832640','5832567','5832632','5832145','5832476','5832624','5832616','5833015','5832608','5832600','5832395','5832592','5832782','5832584','5832576','5832568','5832560','5832552','5832404','5832149','5832357','5832785','5832176','5832482','5832225','5832152','5832937','5832769','5832311','5832540','5832949','5832528','5832512','5832708','5832319','5832500','5833008','5832078','5832484','5832178','5832468','5832081','5832847','5832400','5832402','5832646','5832452','5832420','5832404','5832582','5832632','5832799','5832396','5832388','5832658','5832364','5832352','5832953','5832923','5832332','5832083','5832320','5832763','5832304','5832665','5832288','5832938','5832276','5832569','5832809','5832253','5832876','5832260','5832487','5832252','5832244','5832217','5832997','5832236','5832228','5832597','5833052','5832220','5832212','5832204','5832873','5833002','5832196','5833040','5832303','5832188','5832425','5832180','5832888','5832295','5832160','5832659','5832136','5832729','5832120','5832427','5832709','5832853','5832238','5832859','5832079','5832136','5832410','5833043','5832585','5832619','5832112','5832317','5832104','5832569','5832096','5832088','5832080','5832805','5832709','5832549','5832365','5832255','5832356','5832124','5832158','5832670','5832142','5832126','5832885','5832829','5832337','5832271','5832125','5832093','5832409','5832995','5832354','5832679','5832656','5832961','5832298','5832496','5832931','5832407','5832844','5833000','5832726','5832921','5832269','5832372','5832910','5832985','5833005','5833007','5833031','5832622','5832434','5833047','5832506','5832222','5832764','5833028','5832452','5832363','5832395','5832427','5832463','5832495','5832495','5832531','5832855','5833035','5832563','5832595','5833021','5832327','5832154','5833037','5833053','5832448','5832444','5833001','5832965','5832205','5832085','5832145','5832185','5832261','5832229','5832289','5832305','5832634','5832381','5832413','5832445','5832533','5832597','5832227','5832613','5832387','5832629','5832837','5832645','5832897','5832861','5832893','5832677','5832925','5832653','5832669','5832080','5832128','5832733','5832749','5832377','5832574','5832781','5832425','5832797','5832813','5832746','5832461','5832838','5832493','5832917','5832949','5832529','5832833','5832561','5832593','5832239','5832202','5832946','5832370','5832418','5832490','5832980','5832148','5832242','5832276','5832552','5832836','5832245','5832081','5832117','5832153','5832213','5832297','5832329','5832397','5832489','5832581','5832637','5832877','5832909','5832677','5832725','5832773','5832821','5832901','5832957','5832141','5832221','5832698','5832590','5832865','5832326','5832532','5832516','5833029','5832496','5832283','5832431','5832789','5832133','5832480','5832078','5832094','5832887','5832399','5832126','5832464','5832134','5832587','5832170','5832651','5832240','5832210','5832759','5832226','5832823','5832100','5832903','5832176','5832448','5832250','5832278','5832432','5832294','5832310','5832416','5832326','5832342','5832400','5832261','5832358','5832384','5832845','5832362','5832374','5832376','5833018','5832390','5832406','5832360','5832422','5832720','5832336','5832438','5832454','5832342','5832486','5832478','5832308','5832590','5832622','5832292','5832510','5832526','5832272','5832542','5832566','5832582','5832614','5832153','5832638','5832654','5832670','5832686','5832375','5832702','5832718','5832635','5832174','5832734','5832807','5832750','5832766','5832782','5832798','5832223','5832814','5832830','5832872','5832846','5832862','5832309','5832878','5832894','5832910','5832520','5833004','5832926','5832142','5832182','5832256','5832260','5832942','5832958','5832637','5832974','5832084','5832251','5832417','5832990','5832868','5833041','5832576','5833006','5832977','5833022','5832913','5833038','5832118','5832825','5832121','5832194','5832468','5832993','5833044','5832498','5832908','5832880','5832553','5832666','5832996','5832141','5832349','5832589','5832625','5832665','5832761','5832881','5833042','5832465','5833052','5832952','5832444','5832936','5832920','5832900','5832944','5832884','5832483','5832868','5832132','5833044','5833032','5833024','5833016','5833008','5833000','5832992','5833003','5832443','5832984','5832512','5832976','5832639','5832199','5832968','5832956','5832940','5832924','5832908','5832896','5832880','5832864','5832234','5832852','5832844','5832836','5832828','5832820','5832812','5832804','5832255','5832796','5832703','5832902','5832784','5832493','5832780','5832772','5832819','5832764','5832920','5832418','5832756','5832748','5832732','5832716','5832744','5832728','5832712','5832700','5832692','5832936','5832684','5832676','5832889','5832668','5832205','5832652','5832644','5832630','5832636','5833023','5832843','5832579','5832385','5832628','5832620','5832612','5832604','5832596','5832588','5832580','5832917','5832572','5832564','5832556','5832548','5832168','5832916','5832544','5832536','5832144','5832520','5832508','5832346','5832492','5832476','5832460','5832253','5832428','5832412','5832396','5833046','5832380','5833021','5832781','5832593','5832379','5832372','5832929','5832356','5832344','5832324','5832312','5832296','5832280','5832268','5832256','5832248','5832240','5832232','5832224','5832216','5832208','5832200','5832192','5832184','5832174','5832144','5832969','5832128','5832087','5833026','5832544','5832116','5832108','5832100','5832092','5832084','5832449','5832166','5832150','5832134','5832930','5832420','5832317','5832889','5832745','5832913','5832539','5832243','5832609','5833025','5832810','5832851','5832192','5832359','5833007','5832578','5832955','5832491','5832591','5832348','5832877','5832447','5832474','5832333','5832755','5832860','5832481','5832290','5832480','5833029','5833045','5832767','5832121','5832273','5832361','5832701','5832393','5832216','5832441','5832477','5832116','5832737','5832509','5832644','5832971','5832545','5832577','5832602','5832361','5832869','5832211','5832487','5832981','5832373','5832163','5832149','5832299','5832683','5832928','5832952','5832344','5832090','5833033','5832525','5832166','5832247','5832389','5832541','5832325','5832633','5832937','5832705','5832769','5832833','5832953','5832762','5832741','5832341','5833037','5832523','5832743','5832935','5832154','5832424','5832994','5833047','5832524','5832504','5832488','5832377','5832472','5832456','5832254','5832440','5832439','5832424','5832549','5832408','5832392','5832943','5832206','5832783','5832504','5832666','5832368','5832655','5832348','5832328','5832316','5832693','5832300','5832284','5832264','5832581','5832814','5832148','5832904','5832891','5832711','5832527','5832409','5832667','5833019','5832540','5832948','5833039','5832749','5832473','5832803','5832265','5832210','5832165','5832331','5832369','5832551','5832739','5832947','5832976','5832616','5832464','5832188','5832702','5832522','5832521','5832095','5832653','5832472','5832879','5832451','5832611','5832654','5832187','5832553','5832604','5832085','5832363','5832249','5832697','5832989','5832140','5832329','5832386','5832262','5832370','5833032','5832280','5832806','5832515','5832435','5832695','5832995','5832631','5832301','5832680','5832839','5832275','5832411','5833005','5833020','5832550','5832351','5832648','5832177','5832682','5832858','5832466','5832335','5832332','5832376','5832965','5832824','5832108','5832498','5832849','5832713','5832641','5832557','5832263','5832105','5832750','5833050','5832297','5832558','5832795','5832159','5832135','5832185','5832119','0') and ((gmt_offset_now IN('13.00','12.75','12.50','12.25','12.00','11.75','11.50','11.25','11.00','10.75','10.50','10.25','10.00','9.75','9.50','9.25','9.00','8.75','8.50','8.25','8.00','7.75','7.50','7.25','7.00','6.75','6.50','6.25','6.00','5.75','5.50','5.25','5.00','4.75','4.50','4.25','4.00','3.75','3.50','3.25','3.00','2.75','2.50','2.25','2.00','1.75','1.50','1.25','1.00','0.75','0.50','0.25','0.00','-0.25','-0.50','-0.75','-1.00','-1.25','-1.50','-1.75','-2.00','-2.25','-2.50','-2.75','-3.00','-3.25','-3.50','-3.75','-4.00','-4.25','-4.50','-4.75','-5.00','-5.25','-5.50','-5.75','-6.00','-6.25','-6.50','-6.75','-7.00','-7.25','-7.50','-7.75','-8.00','-8.25','-8.50','-8.75','-9.00','-9.25','-9.50','-9.75','-10.00','-10.25','-10.50','-10.75','-11.00','-11.25','-11.50','-11.75','-12.00','-12.25','-12.50','-12.75','99') ) ) order by lead_id asc limit 2000;
max_connections=16000
max_heap_table_size=4096M
query_cache_size = 0
skip-external-locking
key_buffer_size = 640M
max_allowed_packet = 2M
table_open_cache = 8192
sort_buffer_size = 4M
net_buffer_length = 8K
read_buffer_size = 4M
read_rnd_buffer_size = 16M
myisam_sort_buffer_size = 64M
thread_cache_size = 50
thread_concurrency=8
skip-name-resolve
connect_timeout=60
long_query_time=3
log_slow_queries
open_files_limit=24576
expire_logs_days=3
default-storage-engine=MyISAM
table_definition_cache=8192
table_cache=8192
myisam_recover
myisam_repair_threads=1
mysql> DELETE from vicidial_auto_calls where channel is null and (now() - last_update_time)>=100;
Return to ViciDialNow - GoAutoDial
Users browsing this forum: No registered users and 10 guests