*************************** 1. row *************************** Type: InnoDB Name: Status: ===================================== 100528 18:02:26 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 6 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 71680 1_second, 71678 sleeps, 7155 10_second, 953 background, 948 flush srv_master_thread log flush and writes: 91156 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 6305719, signal count 2211838 --Thread 140075253852432 has waited at ./include/btr0btr.ic line 53 for 1.00 seconds the semaphore: S-lock on RW-latch at 0x7f65e28a50d8 created in file buf/buf0buf.c line 682 a writer (thread id 140075253852432) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row/row0sel.c line 2842 Last time write locked in file buf/buf0buf.c line 2848 --Thread 140075257047312 has waited at ./include/btr0btr.ic line 53 for 1.00 seconds the semaphore: S-lock on RW-latch at 0x7f65e28a50d8 created in file buf/buf0buf.c line 682 a writer (thread id 140075253852432) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row/row0sel.c line 2842 Last time write locked in file buf/buf0buf.c line 2848 Mutex spin waits 4887920, rounds 44809470, OS waits 833133 RW-shared spins 4582025, OS waits 4808517; RW-excl spins 122057, OS waits 630396 Spin rounds per wait: 9.17 mutex, 34.67 RW-shared, 158.66 RW-excl ------------------------ LATEST DETECTED DEADLOCK ------------------------ 100528 18:02:02 *** (1) TRANSACTION: TRANSACTION 90A2A823, ACTIVE 51 sec, process no 31223, OS thread id 140074916149520 setting auto-inc lock mysql tables in use 6, locked 6 LOCK WAIT 15 lock struct(s), heap size 3112, 12 row lock(s), undo log entries 7 MySQL thread id 34273, query id 75640808 192.168.0.56 crawler REPLACE INTO merged_data_tb VALUES ('2010-05-28 17:58:35','54970','3A_61','toyota aygo 1.0 vvti up 5p','1093814','200611','','86500','0','12990','0010010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','FR17000','0','2010-01-18 11:37:11 Autocadre=http://www.autocadre.com/toyota-aygo-2261601.html 2010-05-28 18:13:03 Auto321=http://occasion.321auto.com/occasion-auto/annonce-40002034.html','6154caf5dd44993db098dc92ce3fd020~~~~NO GARBAGE','http://192.168.0.204/yare/6/1/5/6154caf5dd44993db098dc92ce3fd020_12990_86500.html','0~~~~FR17000~~FR~~~~~~~','1','','6154caf5dd44993db098dc92ce3fd020','KW',b'1',b'1',b'1','0',null,b'1','0','0','0','1','0','0','0','2010-05-28 17:58:35~12990~86500','EUR','N','0',''),('2010-05-28 17:58:47','0','3A_44','opel zafira cosmo pack','0','200407','gold','87500','0','9000','0000010001010101100100100010000100010000000001000000000000000001000000000000000000000000000000000000','FR27000 *** (1) WAITING FOR THIS LOCK TO BE GRANTED: TABLE LOCK table `crawlers`.`merged_data_tb` trx id 90A2A823 lock mode AUTO-INC waiting *** (2) TRANSACTION: TRANSACTION 90A2A9F1, ACTIVE 36 sec, process no 31223, OS thread id 140075259709712 setting auto-inc lock mysql tables in use 6, locked 6 14 lock struct(s), heap size 3112, 10 row lock(s), undo log entries 4 MySQL thread id 63, query id 75652065 192.168.0.67 crawler Sending data INSERT IGNORE INTO merged_data_tb_fresh SELECT * FROM merged_data_tb WHERE md5Hash = NEW.md5Hash AND KM = NEW.KM AND price = NEW.price AND (@presentAcid * NEW.acid) = 0 AND NEW.acid <> 1 AND IF(NEW.crawldatetime IS NULL, 1, NEW.crawldatetime >= DATE_ADD(NOW(),INTERVAL -3 DAY)) *** (2) HOLDS THE LOCK(S): TABLE LOCK table `crawlers`.`merged_data_tb` trx id 90A2A9F1 lock mode AUTO-INC *** (2) WAITING FOR THIS LOCK TO BE GRANTED: TABLE LOCK table `crawlers`.`merged_data_tb_fresh` trx id 90A2A9F1 lock mode AUTO-INC waiting *** WE ROLL BACK TRANSACTION (2) ------------ TRANSACTIONS ------------ Trx id counter 90A2B0B2 Purge done for trx's n:o < 90A1A6B7 undo n:o < 0 History list length 20265 ... truncated... d, process no 31223, OS thread id 140075232020752 MySQL thread id 35864, query id 75655039 192.168.0.230 petrik ---TRANSACTION 90A29148, not started, process no 31223, OS thread id 140075233618192 MySQL thread id 35673, query id 75475749 192.168.0.61 crawler ---TRANSACTION 90A2749B, not started, process no 31223, OS thread id 140075259177232 MySQL thread id 35031, query id 75448430 192.168.0.55 crawler ---TRANSACTION 90A2ACBF, not started, process no 31223, OS thread id 140074920675600 mysql tables in use 3, locked 2 MySQL thread id 34991, query id 75654687 192.168.0.56 crawler Table lock UPDATE IGNORE crawlers.merged_data_tb SET crawldatetime = NOW(), full_webaddress=CONCAT(SUBSTRING_INDEX(full_webaddress,'\t',1), '\t',NOW(), ' ', 'Annoncenet', '=http://www.annoncenet.fr/pa/annonce/annonce_detail.asp?NUM=39546846') WHERE md5hash = '3b68f0e51d95a0d39a17fe393aa6ca5e' AND ABS(CAST(km AS SIGNED) - 14800) <= 1000 AND ABS(CAST(price AS SIGNED) - 39800) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 39800) , ABS(CAST(km AS SIGNED) - 14800) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 90A2B028, not started, process no 31223, OS thread id 140075229624592 mysql tables in use 3, locked 2 MySQL thread id 34980, query id 75653574 192.168.0.55 crawler Table lock UPDATE IGNORE crawlers.merged_data_tb SET crawldatetime = NOW(), full_webaddress=CONCAT(SUBSTRING_INDEX(full_webaddress,'\t',1), '\t',NOW(), ' ', 'Vlanauto', '=http://www.vlanauto.be/fr/voiture-occasion/Mini/Cooper/1.6i_16v_L_P_I-3977022-a-vendre?id=3977022&zid=78524282&cc=56') WHERE md5hash = '3232b9bac47f284b19a2c7ff48d5eee3' AND ABS(CAST(km AS SIGNED) - 136000) <= 1000 AND ABS(CAST(price AS SIGNED) - 8990) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 8990) , ABS(CAST(km AS SIGNED) - 136000) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 90A2B045, not started, process no 31223, OS thread id 140075271956752 MySQL thread id 34972, query id 75652929 192.168.0.55 crawler ---TRANSACTION 90A2B087, not started, process no 31223, OS thread id 140075255183632 mysql tables in use 3, locked 2 MySQL thread id 34933, query id 75654785 192.168.0.55 crawler Table lock UPDATE IGNORE crawlers.merged_data_tb SET crawldatetime = NOW(), full_webaddress=CONCAT(SUBSTRING_INDEX(full_webaddress,'\t',1), '\t',NOW(), ' ', 'Spazioauto', '=http://www.spazioauto.it/scheda_auto.asp?id=GA-358735') WHERE md5hash = '7906117648662c72d253c2c369eb5166' AND ABS(CAST(km AS SIGNED) - 2630) <= 1000 AND ABS(CAST(price AS SIGNED) - 22500) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 22500) , ABS(CAST(km AS SIGNED) - 2630) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 90A29590, not started, process no 31223, OS thread id 140075258378512 MySQL thread id 34759, query id 75479394 192.168.0.59 crawler ---TRANSACTION 90A2AC58, not started, process no 31223, OS thread id 140075274086672 mysql tables in use 3, locked 2 MySQL thread id 34489, query id 75654689 192.168.0.59 crawler Table lock UPDATE IGNORE crawlers.merged_data_tb SET crawldatetime = NOW(), full_webaddress=CONCAT(SUBSTRING_INDEX(full_webaddress,'\t',1), '\t',NOW(), ' ', 'Priceminister', '=http://www.priceministerauto.com/annonces-occasion_auto/mazda-2007-53000-kms_39847956.html') WHERE md5hash = 'fab7f30f107e012cb3ae6f302d51f1c6' AND ABS(CAST(km AS SIGNED) - 53000) <= 1000 AND ABS(CAST(price AS SIGNED) - 14990) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 14990) , ABS(CAST(km AS SIGNED) - 53000) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 90A2B06A, not started, process no 31223, OS thread id 140075244267792 mysql tables in use 3, locked 2 MySQL thread id 34467, query id 75654555 192.168.0.67 crawler Table lock UPDATE IGNORE crawlers.merged_data_tb SET crawldatetime = NOW(), full_webaddress=CONCAT(SUBSTRING_INDEX(full_webaddress,'\t',1), '\t',NOW(), ' ', 'DHD24Auto', '=http://www.dhd24.com/azl/index.php?anz_id=72431242') , picHash = 'af64004ae929bc176cc42f8f1550cdb7' WHERE md5hash = 'aa24ceb52fd7e45bee26a9e9b657c0b4' AND ABS(CAST(km AS SIGNED) - 176000) <= 1000 AND ABS(CAST(price AS SIGNED) - 8800) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 8800) , ABS(CAST(km AS SIGNED) - 176000) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 90A2B01B, not started, process no 31223, OS thread id 140075247462672 mysql tables in use 3, locked 2 MySQL thread id 34448, query id 75653562 192.168.0.67 crawler Table lock UPDATE IGNORE crawlers.merged_data_tb SET crawldatetime = NOW(), full_webaddress=CONCAT(SUBSTRING_INDEX(full_webaddress,'\t',1), '\t',NOW(), ' ', 'Opel', '=http://www.opelautoboerse.de/used/search/details.jhtml;$sessionid$TL1URKSNK5SDXAVJJQSRSKY?ID=1480794&pgRef=extended') WHERE md5hash = '2892ec65a7e3ee3a78540bc5f8ca38d3' AND ABS(CAST(km AS SIGNED) - 58046) <= 1000 AND ABS(CAST(price AS SIGNED) - 6690) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 6690) , ABS(CAST(km AS SIGNED) - 58046) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 90A2B030, not started, process no 31223, OS thread id 140075248261392 mysql tables in use 3, locked 2 MySQL thread id 34428, query id 75654353 192.168.0.55 crawler Table lock UPDATE IGNORE crawlers.merged_data_tb SET crawldatetime = NOW(), full_webaddress=CONCAT(SUBSTRING_INDEX(full_webaddress,'\t',1), '\t',NOW(), ' ', 'Fahrzeugnet', '=http://www.fahrzeugnet.ch/auto/text/OPEL-Insignia-1-8-Edition-Occasion-215792.html') WHERE md5hash = 'b5233a674880bae9675e2e8d85a65015' AND ABS(CAST(km AS SIGNED) - 7000) <= 1000 AND ABS(CAST(price AS SIGNED) - 38900) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 38900) , ABS(CAST(km AS SIGNED) - 7000) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 90A2B052, not started, process no 31223, OS thread id 140075270093072 mysql tables in use 3, locked 2 MySQL thread id 34415, query id 75654377 192.168.0.61 crawler Table lock UPDATE IGNORE crawlers.merged_data_tb SET crawldatetime = NOW(), full_webaddress=CONCAT(SUBSTRING_INDEX(full_webaddress,'\t',1), '\t',NOW(), ' ', 'Portalcar', '=http://www.portalcar.pt/peugeot-306-20-hdi-carro-91021.html') WHERE md5hash = '492ce693defb4f05f6d9553b1e1107b3' AND ABS(CAST(km AS SIGNED) - 170000) <= 1000 AND ABS(CAST(price AS SIGNED) - 6500) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 6500) , ABS(CAST(km AS SIGNED) - 170000) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 90A2B041, not started, process no 31223, OS thread id 140075251722512 mysql tables in use 3, locked 2 MySQL thread id 34394, query id 75652891 192.168.0.56 crawler Table lock UPDATE IGNORE crawlers.merged_data_tb SET crawldatetime = NOW(), full_webaddress=CONCAT(SUBSTRING_INDEX(full_webaddress,'\t',1), '\t',NOW(), ' ', 'Autoselection', '=http://www.auto-selection.com/voiture-occasion/audi-tt/5734503.html') WHERE md5hash = '750cb743a016a3117aa3e97b5d1d15b7' AND ABS(CAST(km AS SIGNED) - 27700) <= 1000 AND ABS(CAST(price AS SIGNED) - 26990) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 26990) , ABS(CAST(km AS SIGNED) - 27700) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 90A2AF53, not started, process no 31223, OS thread id 140075270359312 mysql tables in use 6, locked 6 MySQL thread id 34376, query id 75653974 192.168.0.65 crawler Table lock REPLACE INTO merged_data_tb VALUES ('2010-05-28 18:02:04','0','TS_50','renault -','0','200603','rot~rot','95700','74','11781','0000010000001000100001100010000100000000000001000000000000000000000000000000000000000000000000000000','DE54634','0','2010-05-28 17:10:18 Truckscout=http://www.truckscout24.de/search/ger/detail.asp?vehicletype_id=2&vehicle_id=11755485&make=0&mid=12&page=2&allownext=1&language=ger','a3055b80c21ef490f37e51f6be5639de~~~~NO GARBAGE','http://192.168.0.204/yare/a/3/0/a3055b80c21ef490f37e51f6be5639de_11781_95700.html','1~autohaus raiffeisen~brauereistrasse~~DE54634~bitburg~DE~ ---TRANSACTION 90A2B05C, not started, process no 31223, OS thread id 140074920941840 mysql tables in use 3, locked 2 MySQL thread id 34371, query id 75654496 192.168.0.61 crawler Table lock UPDATE IGNORE crawlers.merged_data_tb SET crawldatetime = NOW(), full_webaddress=CONCAT(SUBSTRING_INDEX(full_webaddress,'\t',1), '\t',NOW(), ' ', 'Autosapo', '=http://auto.sapo.pt/vehicleDetails.aspx?vid=647bdf5523fc4e11&bid=41&fid=0&mp=0&xp=0&my=0&xy=0&mk=0&xk=0&m=&tid=2&cyd=0&did=&cuid=&btml=0&btxl=0&btmh=0&btxh=0&ismarket=False&so=&po=&ageOrder=&wp=') WHERE md5hash = 'a7e3c703e9b5f4a787d663b93bea2811' AND ABS(CAST(km AS SIGNED) - 124500) <= 1000 AND ABS(CAST(price AS SIGNED) - 17999) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 17999) , ABS(CAST(km AS SIGNED) - 124500) ) AS ---TRANSACTION 90A2B08B, not started, process no 31223, OS thread id 140075240007952 mysql tables in use 3, locked 2 MySQL thread id 34360, query id 75654788 192.168.0.56 crawler Table lock UPDATE IGNORE crawlers.merged_data_tb SET crawldatetime = NOW(), full_webaddress=CONCAT(SUBSTRING_INDEX(full_webaddress,'\t',1), '\t',NOW(), ' ', 'Automarche', '=http://www.automarche.fr/annonce-voitures-occasion-PEUGEOT-107-annonce-8265838.html') WHERE md5hash = '79f56d0cd21c9be66d5437f46d3907e4' AND ABS(CAST(km AS SIGNED) - 14945) <= 1000 AND ABS(CAST(price AS SIGNED) - 8000) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 8000) , ABS(CAST(km AS SIGNED) - 14945) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 90A2B047, not started, process no 31223, OS thread id 140075258910992 mysql tables in use 3, locked 2 MySQL thread id 34346, query id 75654368 192.168.0.65 crawler Table lock UPDATE IGNORE crawlers.merged_data_tb SET crawldatetime = NOW(), full_webaddress=CONCAT(SUBSTRING_INDEX(full_webaddress,'\t',1), '\t',NOW(), ' ', 'Pkw', '=http://autos.pkw.de/mitsubishi/grandis/gebrauchtwagen/325038873049396783.html') WHERE md5hash = '6fc6a8fa187c78bc2dd203ff9ea3b0a8' AND ABS(CAST(km AS SIGNED) - 3029) <= 1000 AND ABS(CAST(price AS SIGNED) - 24990) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 24990) , ABS(CAST(km AS SIGNED) - 3029) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 90A2A9B9, not started, process no 31223, OS thread id 140075252521232 mysql tables in use 6, locked 6 MySQL thread id 34345, query id 75654910 192.168.0.61 crawler Table lock REPLACE INTO merged_data_tb VALUES ('2010-05-28 18:01:56','0','BI_01','alfa romeo 159 sportwagon turismo 2.4 jtdm 20v neuwagen','0','210001','customized~waehlbar','0','147','30008','0010010011001100100111111010000100010000000001000000000000000000000000000000000000001100000000000000','DE33619','0','2010-05-28 18:01:27 Autobild=http://motoso.autobild.de/index.php?id=vehicleoverview&sid=6d8c0f3e0237fb9067aab7b469ea056ebfdad406&SU_marke=16&SU_erstzulvon=1994&SU_kilomb=300000&SU_preisv=500&SU_preisb=500000&CO_page=22&vehicle=AB07604827&ii=3&ic=472','f7a4836cf018fdca63f96a1177334ccf~~~~NO GARBAGE',' ---TRANSACTION 90A284BD, not started, process no 31223, OS thread id 140075233884432 MySQL thread id 34322, query id 75462380 192.168.0.60 crawler ---TRANSACTION 90A2B020, not started, process no 31223, OS thread id 140075242936592 mysql tables in use 3, locked 2 MySQL thread id 34303, query id 75654374 192.168.0.60 crawler Table lock UPDATE IGNORE crawlers.merged_data_tb SET crawldatetime = NOW(), full_webaddress=CONCAT(SUBSTRING_INDEX(full_webaddress,'\t',1), '\t',NOW(), ' ', 'Automercado', '=http://www.automercado.es/coche-seminuevo/Renault-2.2-dCi-Dynamique/172835/9') WHERE md5hash = 'e84cc590c617d4b605ca9732397e3731' AND ABS(CAST(km AS SIGNED) - 25026) <= 1000 AND ABS(CAST(price AS SIGNED) - 11775) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 11775) , ABS(CAST(km AS SIGNED) - 25026) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 90A2B090, not started, process no 31223, OS thread id 140074916149520 mysql tables in use 3, locked 2 MySQL thread id 34273, query id 75654816 192.168.0.56 crawler Table lock UPDATE IGNORE crawlers.merged_data_tb SET crawldatetime = NOW(), full_webaddress=CONCAT(SUBSTRING_INDEX(full_webaddress,'\t',1), '\t',NOW(), ' ', 'Auto321', '=http://occasion.321auto.com/occasion-auto/annonce-40000255.html') WHERE md5hash = '9aa97964ccf6af04820f13624d214106' AND ABS(CAST(km AS SIGNED) - 65292) <= 1000 AND ABS(CAST(price AS SIGNED) - 12500) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 12500) , ABS(CAST(km AS SIGNED) - 65292) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 90A2B098, not started, process no 31223, OS thread id 140075249060112 mysql tables in use 3, locked 2 MySQL thread id 34244, query id 75654803 192.168.0.66 crawler Table lock UPDATE IGNORE crawlers.merged_data_tb SET crawldatetime = NOW(), full_webaddress=CONCAT(SUBSTRING_INDEX(full_webaddress,'\t',1), '\t',NOW(), ' ', 'Autokomplex', '=http://www.autokomplex.de/sys/det.ak?TYP=Mercedes&Modell_F=&Pvon=500&Pbis=7500&Farbe_F=&KM=beliebig&EZ=beliebig&Kategorie=beliebig&Leistung=beliebig&Land=beliebig&PLZ=&Sort=Preis&x=11&y=9&START=121+11125954+20100527064238+sdb+pkw') , picHash = 'bc750fdb2f8a2b22721eac4b0ebfffe7' WHERE md5hash = '2f84474c5030ae8e4eb6d135dfa389eb' AND ABS(CAST(km AS SIGNED) - 76500) <= 1000 AND ABS(CAST(price AS SIGNED) - 4790) <= 1000 ORDER BY ---TRANSACTION 90A2B040, not started, process no 31223, OS thread id 140075272489232 mysql tables in use 3, locked 2 MySQL thread id 34177, query id 75653586 192.168.0.218 crawler Table lock UPDATE IGNORE crawlers.merged_data_tb SET crawldatetime = NOW(), full_webaddress=CONCAT(SUBSTRING_INDEX(full_webaddress,'\t',1), '\t',NOW(), ' ', 'Mercedes', '=http://e-services.mercedes-benz.com/dsc_de/globalsessionid/DSC_de68356C3A6033610DFF010D0755565600/dsc_locale/de_DE/appId/DSC_de/siteLocale/de_DE/VSCDetailView.jam2;jsessionid=0000v1rByIU6vwK6L4svZ2Yu9U5:14k114qn4?VehicleId=4913') WHERE md5hash = 'a2b0ee28ef45d04051a3321ef6efaba0' AND ABS(CAST(km AS SIGNED) - 15000) <= 1000 AND ABS(CAST(price AS SIGNED) - 59990) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 59990) , ABS(C ---TRANSACTION 0, not started, process no 31223, OS thread id 140075263437072 MySQL thread id 33658, query id 69918124 192.168.0.237 robby ---TRANSACTION 90A2B077, not started, process no 31223, OS thread id 140075240806672 mysql tables in use 3, locked 2 MySQL thread id 32099, query id 75654656 192.168.0.60 crawler Table lock UPDATE IGNORE crawlers.merged_data_tb SET crawldatetime = NOW(), full_webaddress=CONCAT(SUBSTRING_INDEX(full_webaddress,'\t',1), '\t',NOW(), ' ', 'Anuncios', '=http://www.anunciosdecoches.com/ver-anuncios-coches-47170.html') WHERE md5hash = '2897d5c22e3a3bb740bcef4f0c843e99' AND ABS(CAST(km AS SIGNED) - 130500) <= 1000 AND ABS(CAST(price AS SIGNED) - 3000) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 3000) , ABS(CAST(km AS SIGNED) - 130500) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 90A2A1AB, not started, process no 31223, OS thread id 140075265300752 MySQL thread id 32098, query id 75492658 192.168.0.60 crawler ---TRANSACTION 90A2B061, not started, process no 31223, OS thread id 140075230689552 mysql tables in use 3, locked 2 MySQL thread id 29958, query id 75654467 192.168.0.241 robby Table lock UPDATE IGNORE merged_data_tb SET crawldatetime = NOW(), full_webaddress=CONCAT(SUBSTRING_INDEX(full_webaddress,'\t',1), '\t',NOW(), ' ', 'ry', '=http://www.autoscout24.de/custom/toyota/detail.asp?id=174028138&language=ger&layout=199908888') WHERE md5hash = 'c6c36d4b26282714394893ca7db879cd' AND ABS(CAST(km AS SIGNED) - 52353) <= 1000 AND ABS(CAST(price AS SIGNED) - 13990) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 13990) , ABS(CAST(km AS SIGNED) - 52353) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 90A2B08F, not started, process no 31223, OS thread id 140082198124816 mysql tables in use 3, locked 2 MySQL thread id 29952, query id 75654792 192.168.0.241 robby Table lock UPDATE IGNORE merged_data_tb SET crawldatetime = NOW(), full_webaddress=CONCAT(SUBSTRING_INDEX(full_webaddress,'\t',1), '\t',NOW(), ' ', 'ry', '=http://www.fordwernsing.de/go.to/modix/3,3,18642304/gebrauchtwagen.html?sort=&ftyp=>yp=&fart=') WHERE md5hash = 'e9b37e57c8859e755fcfa4cf41c6d344' AND ABS(CAST(km AS SIGNED) - 1950) <= 1000 AND ABS(CAST(price AS SIGNED) - 16880) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 16880) , ABS(CAST(km AS SIGNED) - 1950) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 90A2B051, not started, process no 31223, OS thread id 140074920143120 mysql tables in use 3, locked 2 MySQL thread id 29940, query id 75654351 192.168.0.223 robby Table lock UPDATE IGNORE merged_data_tb SET crawldatetime = NOW(), full_webaddress=CONCAT(SUBSTRING_INDEX(full_webaddress,'\t',1), '\t',NOW(), ' ', 'ry', '=http://www.zolleis.de/go.to/modix/3,1,v3q3xew/schnellsuche.html?manufacturer=&model=&bauart=&farbe=&km_from=&km_to=&price_from=&price_to=&kw_from=&kw_to=&antrieb=&gas=&ez=&sort=&zip=PLZ+f%FCr+Umkreissuche&radius=0&search_vehicles=1&version=285&request_uid=yes') WHERE md5hash = '8b8f3314835cbaa919720bf9b98f87c0' AND ABS(CAST(km AS SIGNED) - 22500) <= 1000 AND ABS(CAST(price AS SIGNED) - 14480) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 14 ---TRANSACTION 90A2ADF6, not started, process no 31223, OS thread id 140075232553232 mysql tables in use 6, locked 6 MySQL thread id 29930, query id 75654401 192.168.0.223 robby Table lock REPLACE INTO crawlers.merged_data_tb VALUES (now(),0,'RY_03','audi a3 sportback attraction 1.6 neuwagen 75 102 kw ps 5-gan',0,'201005','schwarz~brillantschwarz',150,75,20990,'0000010010101100100101111010000100000000010011000000000000010000001000000000000000000000000010100000','DE40670','','2010-05-26 19:48:55=http://www.webmobil24.com/web/de/haendler_homepages/vw-audi-nauen/detail.htm?showid=52662854&pagina=0&lastshow=&offset=&bgcolor=&background=&printmode=&nomenu=1&offset=&ignoremenu=&customdesign=&clog=&nomenu=1&DIESEL=&FARBE_ID=&INTERNERCODE=&MARKE_ID=&PREISKAT_ID=&MODELL=&MWSTAUSW=&SORTIE ---TRANSACTION 90A2B064, not started, process no 31223, OS thread id 140075240540432 mysql tables in use 3, locked 2 MySQL thread id 17196, query id 75654486 192.168.0.241 robby Table lock UPDATE IGNORE merged_data_tb SET crawldatetime = NOW(), full_webaddress=CONCAT(SUBSTRING_INDEX(full_webaddress,'\t',1), '\t',NOW(), ' ', 'ry', '=http://www.autoscout24.de/partnerext/dealerstocklist/ger/detail.asp?ts=6476146&id=lrwkalejjtlz&member_id=63150833&lng=ger') WHERE md5hash = '41dcc21ce9eec2556ac7d926a4b3a042' AND ABS(CAST(km AS SIGNED) - 92226) <= 1000 AND ABS(CAST(price AS SIGNED) - 6990) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 6990) , ABS(CAST(km AS SIGNED) - 92226) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 90A2B050, not started, process no 31223, OS thread id 140075269826832 mysql tables in use 3, locked 2 MySQL thread id 12521, query id 75654355 192.168.0.237 robby Table lock UPDATE IGNORE merged_data_tb SET crawldatetime = NOW(), full_webaddress=CONCAT(SUBSTRING_INDEX(full_webaddress,'\t',1), '\t',NOW(), ' ', 'ry', '=http://www.webmobil24.com/web/de/haendler_homepages/gg-automobile-c-weise/detail.htm?showid=52706111&pagina=150&lastshow=&offset=&bgcolor=&background=&printmode=&nomenu=&offset=&ignoremenu=&customdesign=&clog=&nomenu=&DIESEL=&FARBE_ID=&INTERNERCODE=&MARKE_ID=&PREISKAT_ID=&MODELL=&MWSTAUSW=&SORTIERUNG=&STANDORT=&FAHRZEUGTYP=&KRAFTSTOFF=&GETRIEBE=&TUEREN=&ANZEIGE_EZJAHR_VON=&ANZEIGE_EZJAHR_BIS=&ANZEIGE_PREIS_VON=&ANZEIGE_PREIS_BIS=&ANZEIGE_KMSTAND_VON= ---TRANSACTION 90A2B048, not started, process no 31223, OS thread id 140075251190032 mysql tables in use 3, locked 2 MySQL thread id 12454, query id 75654363 192.168.0.149 robby Table lock UPDATE IGNORE merged_data_tb SET crawldatetime = NOW(), full_webaddress=CONCAT(SUBSTRING_INDEX(full_webaddress,'\t',1), '\t',NOW(), ' ', 'ry', '=http://www.haendlerfahrzeuge.de/ah_showfz.php?aktion=detail&pos=81&seite=3&fznr=10520104') WHERE md5hash = '2af02030bb2476b63ef3f074a2172f8f' AND ABS(CAST(km AS SIGNED) - 12079) <= 1000 AND ABS(CAST(price AS SIGNED) - 26450) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 26450) , ABS(CAST(km AS SIGNED) - 12079) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 90A2B0AE, not started, process no 31223, OS thread id 140075220093200 MySQL thread id 12412, query id 75655063 192.168.0.42 robby ---TRANSACTION 90A2ADC6, not started, process no 31223, OS thread id 140075260774672 mysql tables in use 6, locked 6 MySQL thread id 12421, query id 75654408 192.168.0.149 robby Table lock REPLACE INTO crawlers.merged_data_tb VALUES (now(),0,'RY_38','mercedes benz sl 320 leder',0,'199606','silber~silber',69000,170,17900,'0011010010010110110101100010000100010110000011000100000001010001000000000000000000000000000000010000','DE92648','','2010-05-28 18:00:49=http://home.mobile.de/home/showDetails.html?id=2890479&__lp=2&scopeId=AV&sortOption.sortBy=makeModelDescriptionSortField&sortOption.sortOrder=ASCENDING&makeModelVariant1.searchInFreetext=false&makeModelVariant2.searchInFreetext=false&makeModelVariant3.searchInFreetext=false&siteId=GERMANY&damageUnrepaired=ALSO_DAMAGE_UNREPAIRED& ---TRANSACTION 90A2B04D, not started, process no 31223, OS thread id 140075221424400 mysql tables in use 3, locked 2 MySQL thread id 12382, query id 75653579 192.168.0.147 robby Table lock UPDATE IGNORE merged_data_tb SET crawldatetime = NOW(), full_webaddress=CONCAT(SUBSTRING_INDEX(full_webaddress,'\t',1), '\t',NOW(), ' ', 'ry', '=http://home.mobile.de/home/showDetails.html?id=124585069&__lp=6&scopeId=AV&sortOption.sortBy=makeModelDescriptionSortField&sortOption.sortOrder=ASCENDING&makeModelVariant1.searchInFreetext=false&makeModelVariant2.searchInFreetext=false&makeModelVariant3.searchInFreetext=false&siteId=GERMANY&damageUnrepaired=ALSO_DAMAGE_UNREPAIRED&export=ALSO_EXPORT&grossPrice=true&customerIdsAsString=457301&lang=de&pageNumber=2&partnerHead=false&showZip=false&showMod ---TRANSACTION 90A2B0A3, not started, process no 31223, OS thread id 140075250923792 mysql tables in use 3, locked 2 MySQL thread id 9188, query id 75654869 192.168.0.59 crawler Table lock UPDATE IGNORE crawlers.merged_data_tb SET crawldatetime = NOW(), full_webaddress=CONCAT(SUBSTRING_INDEX(full_webaddress,'\t',1), '\t',NOW(), ' ', 'Autoscout24', '=http://www.autoscout24.de/Details.aspx?id=b2om2zhffftw') , picHash = '20278928803a789343962ea084d27f60' WHERE md5hash = 'dd77a3337b31dbde8c5de874c561a73e' AND ABS(CAST(km AS SIGNED) - 5) <= 1000 AND ABS(CAST(price AS SIGNED) - 18590) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 18590) , ABS(CAST(km AS SIGNED) - 5) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 90A2B024, not started, process no 31223, OS thread id 140075242137872 mysql tables in use 3, locked 2 MySQL thread id 8651, query id 75653563 192.168.0.56 crawler Table lock UPDATE IGNORE crawlers.merged_data_tb SET crawldatetime = NOW(), full_webaddress=CONCAT(SUBSTRING_INDEX(full_webaddress,'\t',1), '\t',NOW(), ' ', 'Caradisiac', '=http://occasions-pro.caradisiac.com/bmw-x5_e70-0-1b396535c9123e8f56c7e605f2c5971c.htm') WHERE md5hash = '2271d00dde4f6c793e5a3b33a80bcb5c' AND ABS(CAST(km AS SIGNED) - 44000) <= 1000 AND ABS(CAST(price AS SIGNED) - 39990) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 39990) , ABS(CAST(km AS SIGNED) - 44000) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 90A2AB0D, not started, process no 31223, OS thread id 140074917480720 MySQL thread id 8621, query id 75643635 192.168.0.59 crawler ---TRANSACTION 90A2B081, not started, process no 31223, OS thread id 140075271690512 mysql tables in use 3, locked 2 MySQL thread id 8610, query id 75654753 192.168.0.59 crawler Table lock UPDATE IGNORE crawlers.merged_data_tb SET crawldatetime = NOW(), full_webaddress=CONCAT(SUBSTRING_INDEX(full_webaddress,'\t',1), '\t',NOW(), ' ', 'Lacentrale', '=http://www.lacentrale.fr/auto-occasion-annonce-11047478.html') WHERE md5hash = 'facedc11155e1565336e259cabc4cea7' AND ABS(CAST(km AS SIGNED) - 12719) <= 1000 AND ABS(CAST(price AS SIGNED) - 20990) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 20990) , ABS(CAST(km AS SIGNED) - 12719) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 90A2B036, not started, process no 31223, OS thread id 140075246663952 mysql tables in use 3, locked 2 MySQL thread id 8370, query id 75654350 192.168.0.59 crawler Table lock UPDATE IGNORE crawlers.merged_data_tb SET crawldatetime = NOW(), full_webaddress=CONCAT(SUBSTRING_INDEX(full_webaddress,'\t',1), '\t',NOW(), ' ', 'Cuboauto', '=http://www.cuboauto.it/annunci/auto-usata-audi-a3-495136.html') WHERE md5hash = '6b2e416ce0e991fef012a91e2c534831' AND ABS(CAST(km AS SIGNED) - 20276) <= 1000 AND ABS(CAST(price AS SIGNED) - 23900) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 23900) , ABS(CAST(km AS SIGNED) - 20276) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 90A2B0A4, not started, process no 31223, OS thread id 140075274352912 mysql tables in use 3, locked 2 MySQL thread id 8276, query id 75654915 192.168.0.55 crawler Table lock UPDATE IGNORE crawlers.merged_data_tb SET crawldatetime = NOW(), full_webaddress=CONCAT(SUBSTRING_INDEX(full_webaddress,'\t',1), '\t',NOW(), ' ', 'Car4youch', '=http://www.car4you.ch//sea_det.cfm?step=30&vehicleid=4319717&country=ch&language=de&searchtype=,&menutype=makelist') WHERE md5hash = '662519d7b926cd979912b544208a2d3a' AND ABS(CAST(km AS SIGNED) - 93900) <= 1000 AND ABS(CAST(price AS SIGNED) - 15980) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 15980) , ABS(CAST(km AS SIGNED) - 93900) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 90A2B06F, not started, process no 31223, OS thread id 140075235481872 mysql tables in use 3, locked 2 MySQL thread id 8269, query id 75654615 192.168.0.66 crawler Table lock UPDATE IGNORE crawlers.merged_data_tb SET crawldatetime = NOW(), full_webaddress=CONCAT(SUBSTRING_INDEX(full_webaddress,'\t',1), '\t',NOW(), ' ', 'Autom', '=http://www.webauto.de/index.cfm?fnlist=1-65609592%2C9-92969808%2C9-93704590%2C9-93919586%2C9-93692650%2C9-93871224%2C9-93839760%2C9-93825400%2C9-93871225%2C9-93900847%2C9-93908466%2C9-93220325%2C9-93919170%2C9-74435756%2C9-93911033%2C9-93688714%2C9-93885619%2C1-65474778%2C7-99768195%2C9-93812346%2C1-65474765%2C2-57458831%2C9-93866457%2C2-57455824%2C9-93903185%2C&pgnr=1&fuseaction=home.vdet&v=home.vehsearch&lay=2&vid=106144153&origin=9&acc ---TRANSACTION 90A2B088, not started, process no 31223, OS thread id 140075231754512 mysql tables in use 3, locked 2 MySQL thread id 8255, query id 75654759 192.168.0.55 crawler Table lock UPDATE IGNORE crawlers.merged_data_tb SET crawldatetime = NOW(), full_webaddress=CONCAT(SUBSTRING_INDEX(full_webaddress,'\t',1), '\t',NOW(), ' ', 'Comparis', '=http://www.comparis.ch/Carfinder/marktplatz/Details.aspx?id=11116856') WHERE md5hash = '51647d9a9385d065359a216cee418b66' AND ABS(CAST(km AS SIGNED) - 86000) <= 1000 AND ABS(CAST(price AS SIGNED) - 9800) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 9800) , ABS(CAST(km AS SIGNED) - 86000) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 90A2B046, not started, process no 31223, OS thread id 140075233351952 mysql tables in use 3, locked 2 MySQL thread id 8240, query id 75654386 192.168.0.55 crawler Table lock UPDATE IGNORE crawlers.merged_data_tb SET crawldatetime = NOW(), full_webaddress=CONCAT(SUBSTRING_INDEX(full_webaddress,'\t',1), '\t',NOW(), ' ', 'Vendiauto', '=http://www.vendiauto.com/rivenditori/ALFA_ROMEO-147-397593.html') WHERE md5hash = '1f1553964f74f0ce4d978bbe771621e1' AND ABS(CAST(km AS SIGNED) - 61000) <= 1000 AND ABS(CAST(price AS SIGNED) - 10500) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 10500) , ABS(CAST(km AS SIGNED) - 61000) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 90A2B044, not started, process no 31223, OS thread id 140075244001552 mysql tables in use 3, locked 2 MySQL thread id 8020, query id 75654375 192.168.0.59 crawler Table lock UPDATE IGNORE crawlers.merged_data_tb SET crawldatetime = NOW(), full_webaddress=CONCAT(SUBSTRING_INDEX(full_webaddress,'\t',1), '\t',NOW(), ' ', 'Annunciautousate', '=http://www.annunciautousate.it/vendita/ferrari_612_auto_usata_497085.html') WHERE md5hash = '8e755ea4d4ed4b5822431dab745a2d7a' AND ABS(CAST(km AS SIGNED) - 24000) <= 1000 AND ABS(CAST(price AS SIGNED) - 98900) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 98900) , ABS(CAST(km AS SIGNED) - 24000) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 90A2AA60, not started, process no 31223, OS thread id 140075260508432 mysql tables in use 3, locked 2 MySQL thread id 7946, query id 75654662 192.168.0.61 crawler Table lock UPDATE IGNORE crawlers.merged_data_tb SET crawldatetime = NOW(), full_webaddress=CONCAT(SUBSTRING_INDEX(full_webaddress,'\t',1), '\t',NOW(), ' ', 'Autoscout24', '=http://www.autoscout24.de/details.aspx?id=bhzrcu2sgplw') , picHash = 'ab6e081a24aa7c0ce9980fd0accb4984' WHERE md5hash = '0f3141fbf9f5f22d8a3241a778a950e0' AND ABS(CAST(km AS SIGNED) - 150000) <= 1000 AND ABS(CAST(price AS SIGNED) - 6500) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 6500) , ABS(CAST(km AS SIGNED) - 150000) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 90A2B08A, not started, process no 31223, OS thread id 140075244534032 mysql tables in use 3, locked 2 MySQL thread id 7815, query id 75654777 192.168.0.61 crawler Table lock UPDATE IGNORE crawlers.merged_data_tb SET crawldatetime = NOW(), full_webaddress=CONCAT(SUBSTRING_INDEX(full_webaddress,'\t',1), '\t',NOW(), ' ', 'Motores24h', '=http://www.motores24h.pt/renault-clio-clio-iii-soci-eacute-t-eacute-diesel-carro-254734.html') WHERE md5hash = '7c0c5a22fd94ca09f302535f97f818aa' AND ABS(CAST(km AS SIGNED) - 58890) <= 1000 AND ABS(CAST(price AS SIGNED) - 10750) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 10750) , ABS(CAST(km AS SIGNED) - 58890) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 90A2B08E, not started, process no 31223, OS thread id 140075266631952 mysql tables in use 3, locked 2 MySQL thread id 7724, query id 75654751 192.168.0.66 crawler Table lock UPDATE IGNORE crawlers.merged_data_tb SET crawldatetime = NOW(), full_webaddress=CONCAT(SUBSTRING_INDEX(full_webaddress,'\t',1), '\t',NOW(), ' ', 'Webmobil24', '=http://www.webmobil24.com/web/de/suchen/p/index.htm?nopic=&EVENT=DETAIL&OMS=2&showid=51403056&ANZEIGE_FINANZIERUNG_VON=0&ANZEIGE_FINANZIERUNG_BIS=0&MARKE_ID=1042&ANZEIGE_MODELL=&ANZEIGE_EZJAHR_VON=2007&ANZEIGE_EZJAHR_BIS=2008&FZKATEGORIE_ID=1036&ATTRIBUT_ID_FZART=0&ANZEIGE_PREIS_VON=500&ANZEIGE_PREIS_BIS=500000&ATTRIBUT_ID_KRAFTSTOFF=&ATTRG_GETRIEBE=0&ANZEIGE_KMSTAND_VON=&ANZEIGE_KMSTAND_BIS=300000&FARBE_ID=&ANZEIGE_SCHALTDATUM=0&ANZ ---TRANSACTION 90A2B09F, not started, process no 31223, OS thread id 140075269560592 MySQL thread id 7696, query id 75654797 192.168.0.60 crawler ---TRANSACTION 90A2B08D, not started, process no 31223, OS thread id 140075254651152 mysql tables in use 3, locked 2 MySQL thread id 7689, query id 75654768 192.168.0.66 crawler Table lock UPDATE IGNORE crawlers.merged_data_tb SET crawldatetime = NOW(), full_webaddress=CONCAT(SUBSTRING_INDEX(full_webaddress,'\t',1), '\t',NOW(), ' ', 'Car4you', '=http://www.webauto.de/portal/index.cfm?fuseaction=dotcom.vehdet&v=dotcom.vehlist&lay=5&vid=81063478&origin=1&body=&dvx=2&fcolorid=&fcountryat=4&fcountrych=3&fcountryd=1&fcountryes=7&fcountryfr=6&fcountryit=5&fcountryot=500&fdoors=&ffry=&ffuelid=&fmileage=&ftransid=&lg=de&make=888&modell=&pid=4&power=&prmax=&prmin=') WHERE md5hash = '71e86277fc706b3f9beb151bad6e679b' AND ABS(CAST(km AS SIGNED) - 179554) <= 1000 AND ABS(CAST(price A ---TRANSACTION 90A2B09A, not started, process no 31223, OS thread id 140075242670352 MySQL thread id 7690, query id 75654773 192.168.0.60 crawler ---TRANSACTION 90A2B0A2, not started, process no 31223, OS thread id 140075237079312 mysql tables in use 3, locked 2 MySQL thread id 7682, query id 75654839 192.168.0.60 crawler Table lock UPDATE IGNORE crawlers.merged_data_tb SET crawldatetime = NOW(), full_webaddress=CONCAT(SUBSTRING_INDEX(full_webaddress,'\t',1), '\t',NOW(), ' ', 'Autocasion', '=http://www.autocasion.com/coches-segunda-mano/AUDI-A4-ocasion/2.0-TDI-ref694457') WHERE md5hash = '822af06c7fa0d9050eafffe8f73c1ce8' AND ABS(CAST(km AS SIGNED) - 45000) <= 1000 AND ABS(CAST(price AS SIGNED) - 26000) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 26000) , ABS(CAST(km AS SIGNED) - 45000) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 90A2B09B, not started, process no 31223, OS thread id 140075236014352 mysql tables in use 3, locked 2 MySQL thread id 7679, query id 75654786 192.168.0.60 crawler Table lock UPDATE IGNORE crawlers.merged_data_tb SET crawldatetime = NOW(), full_webaddress=CONCAT(SUBSTRING_INDEX(full_webaddress,'\t',1), '\t',NOW(), ' ', 'Cochesdeocasion', '=http://www.cochesdeocasion.com/coche_segundamano/bmw-serie_3-madrid-1d8NPqmcPl4UFM9j6Rtr.html') WHERE md5hash = '1146fcea4bc185f6aa0885a27a6c7d65' AND ABS(CAST(km AS SIGNED) - 59000) <= 1000 AND ABS(CAST(price AS SIGNED) - 16500) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 16500) , ABS(CAST(km AS SIGNED) - 59000) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 90A2B08C, not started, process no 31223, OS thread id 140075255716112 mysql tables in use 3, locked 2 MySQL thread id 7611, query id 75654790 192.168.0.65 crawler Table lock UPDATE IGNORE crawlers.merged_data_tb SET crawldatetime = NOW(), full_webaddress=CONCAT(SUBSTRING_INDEX(full_webaddress,'\t',1), '\t',NOW(), ' ', 'Audionline', '=\'42\',\'0\'') WHERE md5hash = 'dc0265e80ed68e7d56aacd7d080983b2' AND ABS(CAST(km AS SIGNED) - 88215) <= 1000 AND ABS(CAST(price AS SIGNED) - 25890) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 25890) , ABS(CAST(km AS SIGNED) - 88215) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 90A2B03D, not started, process no 31223, OS thread id 140075256248592 mysql tables in use 3, locked 2 MySQL thread id 7588, query id 75654364 192.168.0.66 crawler Table lock UPDATE IGNORE crawlers.merged_data_tb SET crawldatetime = NOW(), full_webaddress=CONCAT(SUBSTRING_INDEX(full_webaddress,'\t',1), '\t',NOW(), ' ', 'Autoscout24', '=http://www.autoscout24.de/details.aspx?id=v2zddrk1bpa1') , picHash = 'd251bfe7da46c6336a18cf8ebb3ed0b8' WHERE md5hash = 'f4f416ff795378efeaab27f764c25679' AND ABS(CAST(km AS SIGNED) - 105000) <= 1000 AND ABS(CAST(price AS SIGNED) - 5800) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 5800) , ABS(CAST(km AS SIGNED) - 105000) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 90A2B089, not started, process no 31223, OS thread id 140075239209232 mysql tables in use 3, locked 2 MySQL thread id 7532, query id 75654804 192.168.0.65 crawler Table lock UPDATE IGNORE crawlers.merged_data_tb SET crawldatetime = NOW(), full_webaddress=CONCAT(SUBSTRING_INDEX(full_webaddress,'\t',1), '\t',NOW(), ' ', 'Daz', '=http://www.daz24.de/21_suche/detail.php?fz_id=ec80b8544b1390216fe0e7b875d3f593') , picHash = '2ac48842dd170f226b5da6b43ad7a22c' WHERE md5hash = '33c98002c035bfcb234bda64525c7b44' AND ABS(CAST(km AS SIGNED) - 84000) <= 1000 AND ABS(CAST(price AS SIGNED) - 10750) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 10750) , ABS(CAST(km AS SIGNED) - 84000) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 90A2B043, not started, process no 31223, OS thread id 140074915883280 mysql tables in use 3, locked 2 MySQL thread id 7529, query id 75653571 192.168.0.65 crawler Table lock UPDATE IGNORE crawlers.merged_data_tb SET crawldatetime = NOW(), full_webaddress=CONCAT(SUBSTRING_INDEX(full_webaddress,'\t',1), '\t',NOW(), ' ', 'Autowebat', '=http://www.gebrauchtwagen.at/detailansicht.php?id_fahrzeug=969831') WHERE md5hash = 'b43b180054053501cdd1350729bfa940' AND ABS(CAST(km AS SIGNED) - 77000) <= 1000 AND ABS(CAST(price AS SIGNED) - 9980) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 9980) , ABS(CAST(km AS SIGNED) - 77000) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 90A2A7A4, not started, process no 31223, OS thread id 140075249326352 MySQL thread id 7397, query id 75640484 192.168.0.41 robby ---TRANSACTION 90A2B04B, not started, process no 31223, OS thread id 140075245598992 mysql tables in use 3, locked 2 MySQL thread id 7336, query id 75654383 192.168.0.223 robby Table lock UPDATE IGNORE merged_data_tb SET crawldatetime = NOW(), full_webaddress=CONCAT(SUBSTRING_INDEX(full_webaddress,'\t',1), '\t',NOW(), ' ', 'ry', '=http://www.autoscout24.de/Details.aspx?id=lrv4vuzsanmd') WHERE md5hash = '52e9aa39faae07357e2a6d3efa5f9079' AND ABS(CAST(km AS SIGNED) - 10) <= 1000 AND ABS(CAST(price AS SIGNED) - 12899) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 12899) , ABS(CAST(km AS SIGNED) - 10) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 90A2B058, not started, process no 31223, OS thread id 140075241072912 mysql tables in use 3, locked 2 MySQL thread id 7344, query id 75654387 192.168.0.54 robby Table lock UPDATE IGNORE merged_data_tb SET crawldatetime = NOW(), full_webaddress=CONCAT(SUBSTRING_INDEX(full_webaddress,'\t',1), '\t',NOW(), ' ', 'ry', '=http://www.gebrauchtwagen-iserlohn.de/go.to/127506180244IZ2SMM2/3,3,u7rszwl/hauptseite.html?version=300') WHERE md5hash = '51e15631d10ae437a8980f000af05ff1' AND ABS(CAST(km AS SIGNED) - 15) <= 1000 AND ABS(CAST(price AS SIGNED) - 11990) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 11990) , ABS(CAST(km AS SIGNED) - 15) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 90A2B092, not started, process no 31223, OS thread id 140075251456272 mysql tables in use 3, locked 2 MySQL thread id 7332, query id 75654749 192.168.0.38 robby Table lock UPDATE IGNORE merged_data_tb SET crawldatetime = NOW(), full_webaddress=CONCAT(SUBSTRING_INDEX(full_webaddress,'\t',1), '\t',NOW(), ' ', 'ry', '=http://home.mobile.de/home/showDetails.html?id=128706426&__lp=6&scopeId=AV&sortOption.sortBy=makeModelDescriptionSortField&sortOption.sortOrder=ASCENDING&makeModelVariant1.searchInFreetext=false&makeModelVariant2.searchInFreetext=false&makeModelVariant3.searchInFreetext=false&siteId=GERMANY&damageUnrepaired=ALSO_DAMAGE_UNREPAIRED&export=ALSO_EXPORT&grossPrice=true&customerIdsAsString=457301&lang=de&pageNumber=2&partnerHead=false&showZip=false&showMod ---TRANSACTION 90A2B0A6, not started, process no 31223, OS thread id 140074918811920 mysql tables in use 3, locked 2 MySQL thread id 7329, query id 75654908 192.168.0.205 robby Table lock UPDATE IGNORE merged_data_tb SET crawldatetime = NOW(), full_webaddress=CONCAT(SUBSTRING_INDEX(full_webaddress,'\t',1), '\t',NOW(), ' ', 'ry', '=http://www.autoscout24.de/custom/toyota/detail.asp?id=174028122&language=ger&layout=199908888') WHERE md5hash = 'f899f8e232d38c8a94277224ae724601' AND ABS(CAST(km AS SIGNED) - 5822) <= 1000 AND ABS(CAST(price AS SIGNED) - 9990) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 9990) , ABS(CAST(km AS SIGNED) - 5822) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 90A2B062, not started, process no 31223, OS thread id 140075248527632 mysql tables in use 3, locked 2 MySQL thread id 7334, query id 75654481 192.168.0.241 robby Table lock UPDATE IGNORE merged_data_tb SET crawldatetime = NOW(), full_webaddress=CONCAT(SUBSTRING_INDEX(full_webaddress,'\t',1), '\t',NOW(), ' ', 'ry', '=http://www.autoscout24.de/Details.aspx?id=vrfuvgwbe1iu') WHERE md5hash = '82dcbd9db17549575057ce9f7b2fa565' AND ABS(CAST(km AS SIGNED) - 86500) <= 1000 AND ABS(CAST(price AS SIGNED) - 8250) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 8250) , ABS(CAST(km AS SIGNED) - 86500) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 90A2ADBF, not started, process no 31223, OS thread id 140075266898192 mysql tables in use 6, locked 6 MySQL thread id 7353, query id 75654417 192.168.0.148 robby Table lock REPLACE INTO crawlers.merged_data_tb VALUES (now(),0,'RY_65','vw caddy kasten economy 2.0 sdi',0,'200910','weiss~weiss',12000,51,14450,'0100000000000000000001000010000100000000000010000000000000000000000000000000000000000000000010100000','DE04523','','2010-05-26 19:43:22=http://car.my-motion.de/12290/car1048896-VW_Caddy_Kasten_Economy_2.0_SDI.html?session=3c67a8bbe0791c4390c1f27dd2522a1f 2010-05-28 18:16:44=http://car.my-motion.de/12290/car1048896-VW_Caddy_Kasten_Economy_2.0_SDI.html?session=58151bfd65ed91fa2063c6ac47cd193e','c536444dc2e2e5c9614ac2a3e857869d~~~~NO GARBAGE','/root/robby/crawled ---TRANSACTION 90A2A7C0, not started, process no 31223, OS thread id 140075250391312 mysql tables in use 6, locked 6 MySQL thread id 7342, query id 75653862 192.168.0.83 robby Table lock REPLACE INTO crawlers.merged_data_tb VALUES (now(),0,'RY_44','opel astra 1.9 cdti caravan edition gr ne plakette',0,'200509','blau~blau',89311,110,8899,'0000010001011000100111100010000000000000010011000000000000000000000000001000000000000000000000010000','DE01127','','2010-05-28 17:52:59=http://home.mobile.de/home/showDetails.html?id=129455294&__lp=1&scopeId=AV&sortOption.sortBy=makeModelDescriptionSortField&sortOption.sortOrder=ASCENDING&makeModelVariant1.searchInFreetext=false&makeModelVariant2.searchInFreetext=false&makeModelVariant3.searchInFreetext=false&siteId=GERMANY&damageUnrepaired=AL ---TRANSACTION 90A2B0B0, not started, process no 31223, OS thread id 140075238676752 MySQL thread id 7324, query id 75655074 192.168.0.145 robby ---TRANSACTION 90A2AE48, not started, process no 31223, OS thread id 140075267963152 mysql tables in use 6, locked 6 MySQL thread id 7327, query id 75654413 192.168.0.147 robby Table lock REPLACE INTO crawlers.merged_data_tb VALUES (now(),0,'RY_50','renault modus 1.5 dci fap van 5 dynamique wagennummer: 50685',0,'200704','gruen~gruen',26541,63,10690,'0100000001000010110011100010000100000000000011000100001000000000000000000000000000000000000000000000','DE50825','','2010-05-28 18:22:24=http://dirkes-gruppe.web-disposition.de/web/Detailansicht/506853/PKW/Gebrauchtwagen/Renault/Modus/1.5_dCi_FAP_Van_5_Dynamique/Kombi/Diesel/Handschaltung/Gr%C3%BCn_gr%C3%BCn_metallic/506853__Renault_Modus_1.5_dCi_FAP_Van_5_Dynamique.html?hID=11&tan=h5Gs6y3736d','7062d79529293418138dacb979599d1c~~~~N ---TRANSACTION 90A2B06E, not started, process no 31223, OS thread id 140075262105872 mysql tables in use 3, locked 2 MySQL thread id 7316, query id 75654613 192.168.0.148 robby Table lock UPDATE IGNORE merged_data_tb SET crawldatetime = NOW(), full_webaddress=CONCAT(SUBSTRING_INDEX(full_webaddress,'\t',1), '\t',NOW(), ' ', 'ry', '=http://www.autohaus-heilmann.eu/index.php?iRubrikID=1517&fCarSearchDetail=1&sMarke=&sPreis=&sModell=&iErstzulassung=&sSessID=m41haftecjapc5rlnbma12akb5&ID=822188&sTemplate=FrameFahrzeugsuche&FahrzeugHandelsNummer=FL00-H3090H2') WHERE md5hash = 'dc0532ad8ee03ee0df1c321b538a45bb' AND ABS(CAST(km AS SIGNED) - 27960) <= 1000 AND ABS(CAST(price AS SIGNED) - 15370) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 15370) , ABS(CAST(km AS SIGNED) - 27 ---TRANSACTION 90A2AC96, not started, process no 31223, OS thread id 140074919610640 mysql tables in use 6, locked 6 MySQL thread id 7325, query id 75654414 192.168.0.149 robby Table lock REPLACE INTO crawlers.merged_data_tb VALUES (now(),0,'RY_03','audi a3 sportback 2.0 tdi ambition',0,'200902','blau~tiefseeblau',11000,103,25460,'0000010010010100100101000110000100010000000011000100000000000000000000000000000100000000000001000000','DE71083','','2010-05-26 16:34:23=http://www.haendlerfahrzeuge.de/ah_showfz.php?SESSAD=1207b25be40c5ef851b8797414400bcb&aktion=detail&pos=66&seite=3&fznr=10340060 2010-05-28 18:00:44=http://www.haendlerfahrzeuge.de/ah_showfz.php?SESSAD=ce32ffe0bff61283cb60082934d5e7f8&aktion=detail&pos=60&seite=3&fznr=10340060','26a08ec181be7df0e72aafb740f25669~~~~NO ---TRANSACTION 90A2AEB9, not started, process no 31223, OS thread id 140075221158160 mysql tables in use 6, locked 6 MySQL thread id 7312, query id 75654416 192.168.0.147 robby Table lock REPLACE INTO crawlers.merged_data_tb VALUES (now(),0,'RY_55','skoda , fabia ii 1,2 cool edition klima el. fenster , 44kw',0,'200904','schwarz~schwarz',26900,44,10250,'0000110000000000110001101010000100000000000010000000000001000000000000000000000000000000000001000000','DE64732','','2010-05-27 13:57:52=http://www.autohaus-heilmann.eu/index.php?iRubrikID=1517&fCarSearchDetail=1&sMarke=&sPreis=&sModell=&iErstzulassung=&sSessID=0sd6njpbrmjubg76kffbnavn52&ID=790308&sTemplate=FrameFahrzeugsuche&FahrzeugHandelsNummer=SE00-20826-1 2010-05-28 18:20:14=http://www.autohaus-heilmann.eu/index.php?iRubrikID ---TRANSACTION 90A2B04E, not started, process no 31223, OS thread id 140075241339152 mysql tables in use 3, locked 2 MySQL thread id 7323, query id 75654365 192.168.0.148 robby Table lock UPDATE IGNORE merged_data_tb SET crawldatetime = NOW(), full_webaddress=CONCAT(SUBSTRING_INDEX(full_webaddress,'\t',1), '\t',NOW(), ' ', 'ry', '=http://www.haendlerfahrzeuge.de/ah_showfz.php?SESSAD=f8b554a05116412a1ca4cc40671687b6&aktion=detail&pos=40&seite=2&fznr=10551626') WHERE md5hash = 'efe705eb747096b200574075e6a20722' AND ABS(CAST(km AS SIGNED) - 14500) <= 1000 AND ABS(CAST(price AS SIGNED) - 19290) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 19290) , ABS(CAST(km AS SIGNED) - 14500) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 90A2B049, not started, process no 31223, OS thread id 140074921740560 mysql tables in use 3, locked 2 MySQL thread id 7319, query id 75653040 192.168.0.147 robby Table lock UPDATE IGNORE merged_data_tb SET crawldatetime = NOW(), full_webaddress=CONCAT(SUBSTRING_INDEX(full_webaddress,'\t',1), '\t',NOW(), ' ', 'ry', '=http://home.mobile.de/home/showDetails.html?id=125184290&__lp=6&scopeId=AV&sortOption.sortBy=makeModelDescriptionSortField&sortOption.sortOrder=ASCENDING&makeModelVariant1.searchInFreetext=false&makeModelVariant2.searchInFreetext=false&makeModelVariant3.searchInFreetext=false&siteId=GERMANY&damageUnrepaired=ALSO_DAMAGE_UNREPAIRED&export=ALSO_EXPORT&grossPrice=true&customerIdsAsString=457301&lang=de&pageNumber=1&partnerHead=false&showZip=false&showMod ---TRANSACTION 90A2AC52, not started, process no 31223, OS thread id 140075245332752 mysql tables in use 6, locked 6 MySQL thread id 7315, query id 75654410 192.168.0.145 robby Table lock REPLACE INTO crawlers.merged_data_tb VALUES (now(),0,'RY_50','renault megane iii 5-tuerer dynamique dci 130 fap 19.350 km,',0,'200909','silber~grau',19350,96,17990,'0000010001011100110111100010000100010000000011000000000000010001000000010001000000000000000001010000','DE32139','','2010-05-28 18:11:23=http://www.autohaus-landermann.de/go.to/modix/3,2,18641084/fahrzeuge.html','f9d6699bd372f534713488ca4f3598b9~~~~NO GARBAGE','/root/robby/crawled/20100528_ac-prognose-5_ac-robby-4/8497_AutohausLandermannGm/result/1_1111_8497_2_2_2_0_21RenaultMeg_-165834569.html@ac-prognose-5','1~autohaus landermann~ ---TRANSACTION 90A2B04A, not started, process no 31223, OS thread id 140074921208080 mysql tables in use 3, locked 2 MySQL thread id 7318, query id 75653585 192.168.0.148 robby Table lock UPDATE IGNORE merged_data_tb SET crawldatetime = NOW(), full_webaddress=CONCAT(SUBSTRING_INDEX(full_webaddress,'\t',1), '\t',NOW(), ' ', 'ry', '=http://home.mobile.de/home/showDetails.html?id=124640041&__lp=6&scopeId=AV&sortOption.sortBy=makeModelDescriptionSortField&sortOption.sortOrder=ASCENDING&makeModelVariant1.searchInFreetext=false&makeModelVariant2.searchInFreetext=false&makeModelVariant3.searchInFreetext=false&siteId=GERMANY&damageUnrepaired=ALSO_DAMAGE_UNREPAIRED&export=ALSO_EXPORT&grossPrice=true&customerIdsAsString=457301&lang=de&pageNumber=2&partnerHead=false&showZip=false&showMod ---TRANSACTION 90A2ADD1, not started, process no 31223, OS thread id 140074916948240 mysql tables in use 6, locked 6 MySQL thread id 7313, query id 75654415 192.168.0.145 robby Table lock REPLACE INTO crawlers.merged_data_tb VALUES (now(),0,'RY_61','toyota aygo multi mode city mit klima',0,'200909','',4990,50,11690,'0110010000000000100001100010000100000000000010000100000000000000001000000000000000000000000000000000','DE69168','','2010-05-27 02:07:16=http://www.autoscout24.de/custom/toyota/detail.asp?id=174028177&language=ger&layout=199908888 2010-05-28 18:16:20=http://www.autoscout24.de/custom/toyota/detail.asp?id=174028177&language=ger&layout=199908888','536b7fe7c0d273701e644770fd9673d5~~~~NO GARBAGE','/root/robby/crawled/20100528_ac-prognose-5_ac-robby-6/10596_AutoOswaldGmbH/ ---TRANSACTION 90A2B074, not started, process no 31223, OS thread id 140075190356240 mysql tables in use 3, locked 2 MySQL thread id 7311, query id 75654634 192.168.0.149 robby Table lock UPDATE IGNORE merged_data_tb SET crawldatetime = NOW(), full_webaddress=CONCAT(SUBSTRING_INDEX(full_webaddress,'\t',1), '\t',NOW(), ' ', 'ry', '=http://www.autoscout24.de/custom/toyota/detail.asp?id=174028173&language=ger&layout=199908888') WHERE md5hash = '16843c1922ae416156bb4cf647e96ad6' AND ABS(CAST(km AS SIGNED) - 10278) <= 1000 AND ABS(CAST(price AS SIGNED) - 12990) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 12990) , ABS(CAST(km AS SIGNED) - 10278) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 90A2AFAD, not started, process no 31223, OS thread id 140075239741712 mysql tables in use 6, locked 6 MySQL thread id 7307, query id 75654412 192.168.0.145 robby Table lock REPLACE INTO crawlers.merged_data_tb VALUES (now(),0,'RY_20','ford focus 1.6 trend 5-tuerer',0,'200511','silber~silber',35700,74,7990,'0000010000000100110001111010000100010000000011000000001001000001000000000000000000000100000000000000','DE89537','','2010-05-27 08:17:20=http://kx15645.x.modix.de/go.to/modix/3,1,u7ubt6w/fahrzeugsuche.html?search_vehicles=1&version=320 2010-05-28 18:05:04=http://kx15645.x.modix.de/go.to/modix/3,1,u7ubt6w/fahrzeugsuche.html?manufacturer=&model=&bauart=&farbe=&km_from=&km_to=&price_from=&price_to=&kw_from=&kw_to=&antrieb=&gas=&ez=&sort=&zip=PLZ+f%FCr+Umkreissuche& ---TRANSACTION 90A2AB59, not started, process no 31223, OS thread id 140075272755472 mysql tables in use 3, locked 2 MySQL thread id 14, query id 75654677 192.168.0.67 crawler Table lock UPDATE IGNORE crawlers.merged_data_tb SET crawldatetime = NOW(), full_webaddress=CONCAT(SUBSTRING_INDEX(full_webaddress,'\t',1), '\t',NOW(), ' ', 'Autoscout24', '=http://www.autoscout24.de/Details.aspx?id=l2rdengoymyo') , picHash = 'd157c1c5b52098c78b02a15f33236c27' WHERE md5hash = 'fae7c420549adfb126ce48799cf9acb0' AND ABS(CAST(km AS SIGNED) - 200000) <= 1000 AND ABS(CAST(price AS SIGNED) - 4250) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 4250) , ABS(CAST(km AS SIGNED) - 200000) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 90A2B027, not started, process no 31223, OS thread id 140075259709712 mysql tables in use 3, locked 2 MySQL thread id 63, query id 75654381 192.168.0.67 crawler Table lock UPDATE IGNORE crawlers.merged_data_tb SET crawldatetime = NOW(), full_webaddress=CONCAT(SUBSTRING_INDEX(full_webaddress,'\t',1), '\t',NOW(), ' ', 'Gebrauchtwagen', '=http://www.gebrauchtwagen.de/autos/ford/escort/escort-turnier/GW20XMZOIRDF.html') , picHash = 'dec63cdece9c11d0766f99ee8aadc219' WHERE md5hash = '56cd9444ea4b992944e36d3c0d1d04d7' AND ABS(CAST(km AS SIGNED) - 228000) <= 1000 AND ABS(CAST(price AS SIGNED) - 480) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 480) , ABS(CAST(km AS SIGNED) - 228000) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 90A2AD41, ACTIVE 43 sec, process no 31223, OS thread id 140075234949392 starting index read mysql tables in use 3, locked 2 LOCK WAIT 3 lock struct(s), heap size 1248, 2 row lock(s) MySQL thread id 34350, query id 75645826 192.168.0.65 crawler init UPDATE IGNORE crawlers.merged_data_tb SET crawldatetime = NOW(), full_webaddress=CONCAT(SUBSTRING_INDEX(full_webaddress,'\t',1), '\t',NOW(), ' ', 'Meinauto', '=http://www.meinauto.at/auto-149751-Ford_S_MAX_Titanium_2_0_TDCi_DPF_5_tuerig_103KW.html') WHERE md5hash = 'c3feff57cf06582cfc84fff30d2ef220' AND ABS(CAST(km AS SIGNED) - 69000) <= 1000 AND ABS(CAST(price AS SIGNED) - 19890) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 19890) , ABS(CAST(km AS SIGNED) - 69000) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ------- TRX HAS BEEN WAITING 43 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 125 page no 105055 n bits 88 index `PRIMARY` of table `crawlers`.`merged_data_tb` trx id 90A2AD41 lock_mode X locks rec but not gap waiting Record lock, heap no 12 PHYSICAL RECORD: n_fields 41; compact format; info bits 0 0: len 8; hex 19999999a36d82ad; asc m ;; 1: len 6; hex 00008781985c; asc \;; 2: len 7; hex 0000004da6246d; asc M $m;; 3: len 8; hex 80001247fdbf2b58; asc G +X;; 4: len 4; hex 80000000; asc ;; 5: len 5; hex 4d415f3230; asc MA_20;; 6: len 30; hex 466f726420732d6d617820746974616e69756d2032203020746463692064; asc Ford s-max titanium 2 0 tdci d; (total 32 bytes); 7: len 4; hex 00000000; asc ;; 8: len 6; hex 323030363036; asc 200606;; 9: len 13; hex 73696c6265727e73696c626572; asc silber~silber;; 10: len 3; hex 013a74; asc :t;; 11: len 2; hex 0067; asc g;; 12: len 3; hex 004a2e; asc J.;; 13: len 30; hex 303130313031303030313131303130303031303131313130303031303030; asc 010101000111010001011110001000; (total 100 bytes); 14: len 6; hex 415433343730; asc AT3470;; 15: len 1; hex 30; asc 0;; 16: len 30; hex 323031302d30332d32392030363a31313a3534204d65696e6175746f3d68; asc 2010-03-29 06:11:54 Meinauto=h; (total 233 bytes); 17: len 30; hex 633366656666353763663036353832636663383466666633306432656632; asc c3feff57cf06582cfc84fff30d2ef2; (total 46 bytes); 18: len 30; hex 2f686f6d652f6163652f594152452f776f726b436f6e66696746696c6559; asc /home/ace/YARE/workConfigFileY; (total 204 bytes); 19: len 30; hex 317e6175746f20677261667e696e64757374726965737472617373652032; asc 1~auto graf~industriestrasse 2; (total 90 bytes); 20: len 1; hex 01; asc ;; 21: len 0; hex ; asc ;; 22: len 30; hex 633366656666353763663036353832636663383466666633306432656632; asc c3feff57cf06582cfc84fff30d2ef2; (total 32 bytes); 23: len 1; hex 01; asc ;; 24: len 1; hex 01; asc ;; 25: len 1; hex 01; asc ;; 26: len 1; hex 01; asc ;; 27: SQL NULL; 28: len 1; hex 01; asc ;; 29: len 1; hex 01; asc ;; 30: len 1; hex 03; asc ;; 31: len 1; hex 04; asc ;; 32: len 1; hex 01; asc ;; 33: len 8; hex 0000000000000000; asc ;; 34: len 2; hex 07cd; asc ;; 35: len 8; hex 0000000000000000; asc ;; 36: len 30; hex 323031302d30332d32392030363a31383a34337e31383939307e38303530; asc 2010-03-29 06:18:43~18990~8050; (total 31 bytes); 37: len 3; hex 455552; asc EUR;; 38: len 1; hex 01; asc ;; 39: len 3; hex 000000; asc ;; 40: len 0; hex ; asc ;; ------------------ ---TRANSACTION 90A2A23E, ACTIVE 111 sec, process no 31223, OS thread id 140075253852432 fetching rows mysql tables in use 3, locked 2 320945 lock struct(s), heap size 28588472, 146849 row lock(s) MySQL thread id 36052, query id 75493153 192.168.0.230 petrik update merged_data_tb set recrawl = 'Y' where left(crawlpage,2) IN ('lc','m5','gt','ma','ck') ---TRANSACTION 90A2734F, ACTIVE 331 sec, process no 31223, OS thread id 140075257047312 fetching rows mysql tables in use 1, locked 0 MySQL thread id 36071, query id 75447417 192.168.0.11 sqlrunner Sending data SELECT * INTO OUTFILE '/home/DataIncoming/ac-sqlrunner-1_man_results_old.csv' FIELDS TERMINATED BY '|' LINES TERMINATED BY '\r\n' FROM crawlers.merged_data_tb WHERE crawldatetime >= '2010-05-25 17:57:03' OR (crawlpage LIKE 'RY%' AND crawldatetime >= '2010-05-23 17:57:03') Trx read view will not see trx with id >= 90A27350, sees < 90A1A6AD ---TRANSACTION 90A1A6AD, ACTIVE 887 sec, process no 31223, OS thread id 140075243202832 fetching rows mysql tables in use 1, locked 0 MySQL thread id 35904, query id 75118867 192.168.0.12 sqlrunner Sending data SELECT * INTO OUTFILE '/home/DataIncoming/ac-sqlrunner-2_man_results_old.csv' FIELDS TERMINATED BY '|' LINES TERMINATED BY '\r\n' FROM crawlers.merged_data_tb WHERE crawldatetime >= '2010-05-25 17:47:37' OR (crawlpage LIKE 'RY%' AND crawldatetime >= '2010-05-23 17:47:37') Trx read view will not see trx with id >= 90A1A6B3, sees < 90A1A4B2 -------- FILE I/O -------- I/O thread 0 state: waiting for i/o request (insert buffer thread) I/O thread 1 state: waiting for i/o request (log thread) I/O thread 2 state: waiting for i/o request (read thread) I/O thread 3 state: doing file i/o (read thread) ev set I/O thread 4 state: waiting for i/o request (read thread) I/O thread 5 state: waiting for i/o request (read thread) I/O thread 6 state: waiting for i/o request (write thread) I/O thread 7 state: waiting for i/o request (write thread) I/O thread 8 state: waiting for i/o request (write thread) I/O thread 9 state: waiting for i/o request (write thread) Pending normal aio reads: 43, aio writes: 0, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 1 23628921 OS file reads, 6538434 OS file writes, 411227 OS fsyncs 1 pending preads, 0 pending pwrites 146.98 reads/s, 39269 avg bytes/read, 127.98 writes/s, 5.67 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 18, free list len 11121, seg size 11140, 844937 inserts, 841683 merged recs, 336278 merges Hash table size 11413553, node heap has 420 buffer(s) 0.17 hash searches/s, 13.33 non-hash searches/s --- LOG --- Log sequence number 1844716249289 Log flushed up to 1844716248650 Last checkpoint at 1844092469196 0 pending log writes, 0 pending chkp writes 106392 log i/o's done, 0.50 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 5899534336; in additional pool allocated 0 Dictionary memory allocated 103640 Buffer pool size 352000 Free buffers 1 Database pages 349834 Old database pages 129117 Modified db pages 8233 Pending reads 43 Pending writes: LRU 2, flush list 0, single page 0 Pages made young 33337647, not young 0 330.94 youngs/s, 0.00 non-youngs/s Pages read 28755738, created 363799, written 7361669 346.28 reads/s, 0.00 creates/s, 138.81 writes/s Buffer pool hit rate 976 / 1000, young-making rate 22 / 1000 not 0 / 1000 Pages read ahead 222.96/s, evicted without access 88.49/s LRU len: 349834, unzip_LRU len: 0 I/O sum[14867]:cur[218], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 3 read views open inside InnoDB Main thread process no. 31223, id 140075283544336, state: sleeping Number of rows inserted 3712038, updated 11913186, deleted 1412400, read 262703826 0.00 inserts/s, 0.50 updates/s, 0.00 deletes/s, 9622.73 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================