*************************** 1. row *************************** Type: InnoDB Name: Status: ===================================== 100531 15:02:17 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 36 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 247804 1_second, 247803 sleeps, 24762 10_second, 1170 background, 1158 flush srv_master_thread log flush and writes: 293853 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 15222191, signal count 6430242 --Thread 140074916415760 has waited at ./include/btr0btr.ic line 53 for 1.00 seconds the semaphore: S-lock on RW-latch at 0x7f65e1e8b228 created in file buf/buf0buf.c line 682 a writer (thread id 140074916415760) 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 3009 Last time write locked in file buf/buf0buf.c line 2848 Mutex spin waits 11557846, rounds 110166636, OS waits 2156587 RW-shared spins 11277258, OS waits 11413008; RW-excl spins 296837, OS waits 1565409 Spin rounds per wait: 9.53 mutex, 33.99 RW-shared, 162.03 RW-excl ------------------------ LATEST DETECTED DEADLOCK ------------------------ 100531 12:55:59 *** (1) TRANSACTION: TRANSACTION 933AE894, ACTIVE 0 sec, process no 31223, OS thread id 140074919344400 inserting mysql tables in use 1, locked 1 LOCK WAIT 6 lock struct(s), heap size 1248, 12 row lock(s), undo log entries 3 MySQL thread id 126679, query id 228220265 192.168.0.205 robby update REPLACE INTO crawlers.deleted VALUES (now(),0,'RY_00','premiere ford s-max',0,'NEW','',0,0,0,'0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','DE02010','','2010-05-31 12:55:32=http://www.autohaus.ford.de/woltmann/delmenhorst/463','466c6858424b8fb2c95675a661686b4c~~~~NO GARBAGE','/root/robby/crawled/20100531_proxy.local_ac-prognose-3/3324_BremenMotorsGmbHCoKG/result/0_0000_3324_11_11_1_0_4PremiereF_-63719040.html@proxy.local','1~kommen sie zur premiere des neuen ford s-max am 29. mai 2010!~am 29~~DE02010~ist es endlich so weit~DE~~0~~~0~~',1,'','466c6858424b8fb2c95675a661686b4c','0',0,0,0,0,NULL,0,'0','0','0','0',0,0,'0','2010-05-31 12:55:32~0~0','DFT','N',2000,'PRICE_NOT_FOUND'),(now(),0,'RY_00','',0,'NEW','',0,0,0,'0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','DE','','2010-05-31 12:54:38=http://www.volkswagen-commercial-vehicles. *** (1) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 126 page no 36727 n bits 384 index `md5Hash_2` of table `crawlers`.`deleted` trx id 933AE894 lock_mode X waiting Record lock, heap no 308 PHYSICAL RECORD: n_fields 4; compact format; info bits 32 0: len 30; hex 336538643766653931616635653964343636646239346565643962613033; asc 3e8d7fe91af5e9d466db94eed9ba03; (total 32 bytes); 1: len 3; hex 000000; asc ;; 2: len 3; hex 000000; asc ;; 3: len 8; hex 000000000062729f; asc br ;; *** (2) TRANSACTION: TRANSACTION 933AE8CA, ACTIVE 0 sec, process no 31223, OS thread id 140082198391056 inserting mysql tables in use 1, locked 1 6 lock struct(s), heap size 1248, 47 row lock(s), undo log entries 3 MySQL thread id 126653, query id 228220429 192.168.0.148 robby update REPLACE INTO crawlers.deleted VALUES (now(),0,'RY_00','',0,'NEW','',0,0,0,'0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','DE','','2010-05-31 13:13:09=http://honrath.de/nc/bingen/gebrauchtwagen.html','3e8d7fe91af5e9d466db94eed9ba031d~~~~NO GARBAGE','/root/robby/crawled/20100531_ac-prognose-8_ac-robby-10/13535_HeinrichHonrathKfzGm/result/0_0000_13535_5_5_1_0_1_-483988615.html@ac-prognose-8','1~Heinrich Honrath Kfz GmbH~In der Weide~~DE~Bingen~DE~~0~~~0~~',1,'','3e8d7fe91af5e9d466db94eed9ba031d','0',0,0,0,0,NULL,0,'0','0','0','0',0,0,'0','2010-05-31 13:13:09~0~0','DFT','N',2000,'PRICE_NOT_FOUND'),(now(),0,'RY_00','premiere ford s-max',0,'NEW','',0,0,0,'0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000','DE02010','','2010-05-31 13:12:49=http://www.autohaus.ford.de/eder/markt_schwaben/463','466c6858424b8fb2c95675a661686b4c~~~~NO GARBAGE',' *** (2) HOLDS THE LOCK(S): RECORD LOCKS space id 126 page no 36727 n bits 384 index `md5Hash_2` of table `crawlers`.`deleted` trx id 933AE8CA lock_mode X Record lock, heap no 241 PHYSICAL RECORD: n_fields 4; compact format; info bits 32 0: len 30; hex 336538643766653931616635653964343636646239346565643962613033; asc 3e8d7fe91af5e9d466db94eed9ba03; (total 32 bytes); 1: len 3; hex 000000; asc ;; 2: len 3; hex 000000; asc ;; 3: len 8; hex 0000000000627314; asc bs ;; Record lock, heap no 242 PHYSICAL RECORD: n_fields 4; compact format; info bits 32 0: len 30; hex 336538643766653931616635653964343636646239346565643962613033; asc 3e8d7fe91af5e9d466db94eed9ba03; (total 32 bytes); 1: len 3; hex 000000; asc ;; 2: len 3; hex 000000; asc ;; 3: len 8; hex 000000000062731f; asc bs ;; Record lock, heap no 243 PHYSICAL RECORD: n_fields 4; compact format; info bits 32 0: len 30; hex 336538643766653931616635653964343636646239346565643962613033; asc 3e8d7fe91af5e9d466db94eed9ba03; (total 32 bytes); 1: len 3; hex 000000; asc ;; 2: len 3; hex 000000; asc ;; 3: len 8; hex 000000000062733d; asc bs=;; Record lock, heap no 244 PHYSICAL RECORD: n_fields 4; compact format; info bits 32 0: len 30; hex 336538643766653931616635653964343636646239346565643962613033; asc 3e8d7fe91af5e9d466db94eed9ba03; (total 32 bytes); 1: len 3; hex 000000; asc ;; 2: len 3; hex 000000; asc ;; 3: len 8; hex 0000000000627346; asc bsF;; Record lock, heap no 274 PHYSICAL RECORD: n_fields 4; compact format; info bits 32 0: len 30; hex 336538643766653931616635653964343636646239346565643962613033; asc 3e8d7fe91af5e9d466db94eed9ba03; (total 32 bytes); 1: len 3; hex 000000; asc ;; 2: len 3; hex 000000; asc ;; 3: len 8; hex 000000000062751e; asc bu ;; Record lock, heap no 275 PHYSICAL RECORD: n_fields 4; compact format; info bits 32 0: len 30; hex 336538643766653931616635653964343636646239346565643962613033; asc 3e8d7fe91af5e9d466db94eed9ba03; (total 32 bytes); 1: len 3; hex 000000; asc ;; 2: len 3; hex 000000; asc ;; 3: len 8; hex 000000000062750a; asc bu ;; Record lock, heap no 276 PHYSICAL RECORD: n_fields 4; compact format; info bits 32 0: len 30; hex 336538643766653931616635653964343636646239346565643962613033; asc 3e8d7fe91af5e9d466db94eed9ba03; (total 32 bytes); 1: len 3; hex 000000; asc ;; 2: len 3; hex 000000; asc ;; 3: len 8; hex 00000000006274f5; asc bt ;; Record lock, heap no 277 PHYSICAL RECORD: n_fields 4; compact format; info bits 32 0: len 30; hex 336538643766653931616635653964343636646239346565643962613033; asc 3e8d7fe91af5e9d466db94eed9ba03; (total 32 bytes); 1: len 3; hex 000000; asc ;; 2: len 3; hex 000000; asc ;; 3: len 8; hex 00000000006274b8; asc bt ;; Record lock, heap no 278 PHYSICAL RECORD: n_fields 4; compact format; info bits 32 0: len 30; hex 336538643766653931616635653964343636646239346565643962613033; asc 3e8d7fe91af5e9d466db94eed9ba03; (total 32 bytes); 1: len 3; hex 000000; asc ;; 2: len 3; hex 000000; asc ;; 3: len 8; hex 00000000006274b0; asc bt ;; Record lock, heap no 279 PHYSICAL RECORD: n_fields 4; compact format; info bits 32 0: len 30; hex 336538643766653931616635653964343636646239346565643962613033; asc 3e8d7fe91af5e9d466db94eed9ba03; (total 32 bytes); 1: len 3; hex 000000; asc ;; 2: len 3; hex 000000; asc ;; 3: len 8; hex 000000000062749b; asc bt ;; Record lock, heap no 280 PHYSICAL RECORD: n_fields 4; compact format; info bits 32 0: len 30; hex 336538643766653931616635653964343636646239346565643962613033; asc 3e8d7fe91af5e9d466db94eed9ba03; (total 32 bytes); 1: len 3; hex 000000; asc ;; 2: len 3; hex 000000; asc ;; 3: len 8; hex 0000000000627491; asc bt ;; Record lock, heap no 281 PHYSICAL RECORD: n_fields 4; compact format; info bits 32 0: len 30; hex 336538643766653931616635653964343636646239346565643962613033; asc 3e8d7fe91af5e9d466db94eed9ba03; (total 32 bytes); 1: len 3; hex 000000; asc ;; 2: len 3; hex 000000; asc ;; 3: len 8; hex 0000000000627486; asc bt ;; Record lock, heap no 282 PHYSICAL RECORD: n_fields 4; compact format; info bits 32 0: len 30; hex 336538643766653931616635653964343636646239346565643962613033; asc 3e8d7fe91af5e9d466db94eed9ba03; (total 32 bytes); 1: len 3; hex 000000; asc ;; 2: len 3; hex 000000; asc ;; 3: len 8; hex 000000000062747c; asc bt|;; Record lock, heap no 283 PHYSICAL RECORD: n_fields 4; compact format; info bits 32 0: len 30; hex 336538643766653931616635653964343636646239346565643962613033; asc 3e8d7fe91af5e9d466db94eed9ba03; (total 32 bytes); 1: len 3; hex 000000; asc ;; 2: len 3; hex 000000; asc ;; 3: len 8; hex 0000000000627469; asc bti;; Record lock, heap no 284 PHYSICAL RECORD: n_fields 4; compact format; info bits 32 0: len 30; hex 336538643766653931616635653964343636646239346565643962613033; asc 3e8d7fe91af5e9d466db94eed9ba03; (total 32 bytes); 1: len 3; hex 000000; asc ;; 2: len 3; hex 000000; asc ;; 3: len 8; hex 000000000062745f; asc bt_;; Record lock, heap no 285 PHYSICAL RECORD: n_fields 4; compact format; info bits 32 0: len 30; hex 336538643766653931616635653964343636646239346565643962613033; asc 3e8d7fe91af5e9d466db94eed9ba03; (total 32 bytes); 1: len 3; hex 000000; asc ;; 2: len 3; hex 000000; asc ;; 3: len 8; hex 0000000000627455; asc btU;; Record lock, heap no 286 PHYSICAL RECORD: n_fields 4; compact format; info bits 32 0: len 30; hex 336538643766653931616635653964343636646239346565643962613033; asc 3e8d7fe91af5e9d466db94eed9ba03; (total 32 bytes); 1: len 3; hex 000000; asc ;; 2: len 3; hex 000000; asc ;; 3: len 8; hex 000000000062744a; asc btJ;; Record lock, heap no 287 PHYSICAL RECORD: n_fields 4; compact format; info bits 32 0: len 30; hex 336538643766653931616635653964343636646239346565643962613033; asc 3e8d7fe91af5e9d466db94eed9ba03; (total 32 bytes); 1: len 3; hex 000000; asc ;; 2: len 3; hex 000000; asc ;; 3: len 8; hex 0000000000627440; asc bt@;; Record lock, heap no 288 PHYSICAL RECORD: n_fields 4; compact format; info bits 32 0: len 30; hex 336538643766653931616635653964343636646239346565643962613033; asc 3e8d7fe91af5e9d466db94eed9ba03; (total 32 bytes); 1: len 3; hex 000000; asc ;; 2: len 3; hex 000000; asc ;; 3: len 8; hex 0000000000627436; asc bt6;; Record lock, heap no 289 PHYSICAL RECORD: n_fields 4; compact format; info bits 32 0: len 30; hex 336538643766653931616635653964343636646239346565643962613033; asc 3e8d7fe91af5e9d466db94eed9ba03; (total 32 bytes); 1: len 3; hex 000000; asc ;; 2: len 3; hex 000000; asc ;; 3: len 8; hex 0000000000627410; asc bt ;; Record lock, heap no 290 PHYSICAL RECORD: n_fields 4; compact format; info bits 32 0: len 30; hex 336538643766653931616635653964343636646239346565643962613033; asc 3e8d7fe91af5e9d466db94eed9ba03; (total 32 bytes); 1: len 3; hex 000000; asc ;; 2: len 3; hex 000000; asc ;; 3: len 8; hex 0000000000627419; asc bt ;; Record lock, heap no 291 PHYSICAL RECORD: n_fields 4; compact format; info bits 32 0: len 30; hex 336538643766653931616635653964343636646239346565643962613033; asc 3e8d7fe91af5e9d466db94eed9ba03; (total 32 bytes); 1: len 3; hex 000000; asc ;; 2: len 3; hex 000000; asc ;; 3: len 8; hex 0000000000627405; asc bt ;; Record lock, heap no 292 PHYSICAL RECORD: n_fields 4; compact format; info bits 32 0: len 30; hex 336538643766653931616635653964343636646239346565643962613033; asc 3e8d7fe91af5e9d466db94eed9ba03; (total 32 bytes); 1: len 3; hex 000000; asc ;; 2: len 3; hex 000000; asc ;; 3: len 8; hex 00000000006273f1; asc bs ;; Record lock, heap no 293 PHYSICAL RECORD: n_fields 4; compact format; info bits 32 0: len 30; hex 336538643766653931616635653964343636646239346565643962613033; asc 3e8d7fe91af5e9d466db94eed9ba03; (total 32 bytes); 1: len 3; hex 000000; asc ;; 2: len 3; hex 000000; asc ;; 3: len 8; hex 00000000006273e7; asc bs ;; Record lock, heap no 294 PHYSICAL RECORD: n_fields 4; compact format; info bits 32 0: len 30; hex 336538643766653931616635653964343636646239346565643962613033; asc 3e8d7fe91af5e9d466db94eed9ba03; (total 32 bytes); 1: len 3; hex 000000; asc ;; 2: len 3; hex 000000; asc ;; 3: len 8; hex 00000000006273de; asc bs ;; Record lock, heap no 295 PHYSICAL RECORD: n_fields 4; compact format; info bits 32 0: len 30; hex 336538643766653931616635653964343636646239346565643962613033; asc 3e8d7fe91af5e9d466db94eed9ba03; (total 32 bytes); 1: len 3; hex 000000; asc ;; 2: len 3; hex 000000; asc ;; 3: len 8; hex 00000000006273c9; asc bs ;; Record lock, heap no 296 PHYSICAL RECORD: n_fields 4; compact format; info bits 32 0: len 30; hex 336538643766653931616635653964343636646239346565643962613033; asc 3e8d7fe91af5e9d466db94eed9ba03; (total 32 bytes); 1: len 3; hex 000000; asc ;; 2: len 3; hex 000000; asc ;; 3: len 8; hex 00000000006273b5; asc bs ;; Record lock, heap no 297 PHYSICAL RECORD: n_fields 4; compact format; info bits 32 0: len 30; hex 336538643766653931616635653964343636646239346565643962613033; asc 3e8d7fe91af5e9d466db94eed9ba03; (total 32 bytes); 1: len 3; hex 000000; asc ;; 2: len 3; hex 000000; asc ;; 3: len 8; hex 00000000006273aa; asc bs ;; Record lock, heap no 298 PHYSICAL RECORD: n_fields 4; compact format; info bits 32 0: len 30; hex 336538643766653931616635653964343636646239346565643962613033; asc 3e8d7fe91af5e9d466db94eed9ba03; (total 32 bytes); 1: len 3; hex 000000; asc ;; 2: len 3; hex 000000; asc ;; 3: len 8; hex 00000000006273a0; asc bs ;; Record lock, heap no 299 PHYSICAL RECORD: n_fields 4; compact format; info bits 32 0: len 30; hex 336538643766653931616635653964343636646239346565643962613033; asc 3e8d7fe91af5e9d466db94eed9ba03; (total 32 bytes); 1: len 3; hex 000000; asc ;; 2: len 3; hex 000000; asc ;; 3: len 8; hex 0000000000627397; asc bs ;; Record lock, heap no 300 PHYSICAL RECORD: n_fields 4; compact format; info bits 32 0: len 30; hex 336538643766653931616635653964343636646239346565643962613033; asc 3e8d7fe91af5e9d466db94eed9ba03; (total 32 bytes); 1: len 3; hex 000000; asc ;; 2: len 3; hex 000000; asc ;; 3: len 8; hex 0000000000627382; asc bs ;; Record lock, heap no 301 PHYSICAL RECORD: n_fields 4; compact format; info bits 32 0: len 30; hex 336538643766653931616635653964343636646239346565643962613033; asc 3e8d7fe91af5e9d466db94eed9ba03; (total 32 bytes); 1: len 3; hex 000000; asc ;; 2: len 3; hex 000000; asc ;; 3: len 8; hex 000000000062737a; asc bsz;; Record lock, heap no 302 PHYSICAL RECORD: n_fields 4; compact format; info bits 32 0: len 30; hex 336538643766653931616635653964343636646239346565643962613033; asc 3e8d7fe91af5e9d466db94eed9ba03; (total 32 bytes); 1: len 3; hex 000000; asc ;; 2: len 3; hex 000000; asc ;; 3: len 8; hex 000000000062736f; asc bso;; Record lock, heap no 303 PHYSICAL RECORD: n_fields 4; compact format; info bits 32 0: len 30; hex 336538643766653931616635653964343636646239346565643962613033; asc 3e8d7fe91af5e9d466db94eed9ba03; (total 32 bytes); 1: len 3; hex 000000; asc ;; 2: len 3; hex 000000; asc ;; 3: len 8; hex 0000000000627364; asc bsd;; Record lock, heap no 304 PHYSICAL RECORD: n_fields 4; compact format; info bits 32 0: len 30; hex 336538643766653931616635653964343636646239346565643962613033; asc 3e8d7fe91af5e9d466db94eed9ba03; (total 32 bytes); 1: len 3; hex 000000; asc ;; 2: len 3; hex 000000; asc ;; 3: len 8; hex 0000000000627352; asc bsR;; Record lock, heap no 305 PHYSICAL RECORD: n_fields 4; compact format; info bits 32 0: len 30; hex 336538643766653931616635653964343636646239346565643962613033; asc 3e8d7fe91af5e9d466db94eed9ba03; (total 32 bytes); 1: len 3; hex 000000; asc ;; 2: len 3; hex 000000; asc ;; 3: len 8; hex 00000000006272c7; asc br ;; Record lock, heap no 306 PHYSICAL RECORD: n_fields 4; compact format; info bits 32 0: len 30; hex 336538643766653931616635653964343636646239346565643962613033; asc 3e8d7fe91af5e9d466db94eed9ba03; (total 32 bytes); 1: len 3; hex 000000; asc ;; 2: len 3; hex 000000; asc ;; 3: len 8; hex 000000000062730a; asc bs ;; Record lock, heap no 308 PHYSICAL RECORD: n_fields 4; compact format; info bits 32 0: len 30; hex 336538643766653931616635653964343636646239346565643962613033; asc 3e8d7fe91af5e9d466db94eed9ba03; (total 32 bytes); 1: len 3; hex 000000; asc ;; 2: len 3; hex 000000; asc ;; 3: len 8; hex 000000000062729f; asc br ;; Record lock, heap no 312 PHYSICAL RECORD: n_fields 4; compact format; info bits 32 0: len 30; hex 336538643766653931616635653964343636646239346565643962613033; asc 3e8d7fe91af5e9d466db94eed9ba03; (total 32 bytes); 1: len 3; hex 000000; asc ;; 2: len 3; hex 000000; asc ;; 3: len 8; hex 0000000000627301; asc bs ;; Record lock, heap no 313 PHYSICAL RECORD: n_fields 4; compact format; info bits 32 0: len 30; hex 336538643766653931616635653964343636646239346565643962613033; asc 3e8d7fe91af5e9d466db94eed9ba03; (total 32 bytes); 1: len 3; hex 000000; asc ;; 2: len 3; hex 000000; asc ;; 3: len 8; hex 00000000006272da; asc br ;; Record lock, heap no 314 PHYSICAL RECORD: n_fields 4; compact format; info bits 32 0: len 30; hex 336538643766653931616635653964343636646239346565643962613033; asc 3e8d7fe91af5e9d466db94eed9ba03; (total 32 bytes); 1: len 3; hex 000000; asc ;; 2: len 3; hex 000000; asc ;; 3: len 8; hex 00000000006272e3; asc br ;; Record lock, heap no 315 PHYSICAL RECORD: n_fields 4; compact format; info bits 32 0: len 30; hex 336538643766653931616635653964343636646239346565643962613033; asc 3e8d7fe91af5e9d466db94eed9ba03; (total 32 bytes); 1: len 3; hex 000000; asc ;; 2: len 3; hex 000000; asc ;; 3: len 8; hex 00000000006272ed; asc br ;; Record lock, heap no 316 PHYSICAL RECORD: n_fields 4; compact format; info bits 0 0: len 30; hex 336538643766653931616635653964343636646239346565643962613033; asc 3e8d7fe91af5e9d466db94eed9ba03; (total 32 bytes); 1: len 3; hex 00076b; asc k;; 2: len 3; hex 000000; asc ;; 3: len 8; hex 00000000006238ad; asc b8 ;; *** (2) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 126 page no 7775 n bits 288 index `md5Hash_2` of table `crawlers`.`deleted` trx id 933AE8CA lock_mode X waiting Record lock, heap no 206 PHYSICAL RECORD: n_fields 4; compact format; info bits 32 0: len 30; hex 343636633638353834323462386662326339353637356136363136383662; asc 466c6858424b8fb2c95675a661686b; (total 32 bytes); 1: len 3; hex 000000; asc ;; 2: len 3; hex 000000; asc ;; 3: len 8; hex 000000000062715d; asc bq];; *** WE ROLL BACK TRANSACTION (2) ------------ TRANSACTIONS ------------ Trx id counter 934C59AE Purge done for trx's n:o < 934C59AD undo n:o < 0 History list length 14 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0, not started, process no 31223, OS thread id 140075273287952 MySQL thread id 134300, query id 232447430 localhost root show innodb status ---TRANSACTION 934C592A, not started, process no 31223, OS thread id 140074918279440 mysql tables in use 1, locked 1 MySQL thread id 134290, query id 232446661 localhost support Table lock truncate table crawlers.merged_data_tb_fresh ---TRANSACTION 0, not started, process no 31223, OS thread id 140075254651152 MySQL thread id 134285, query id 232447216 192.168.0.230 petrik ---TRANSACTION 934C30B2, not started, process no 31223, OS thread id 140075238410512 MySQL thread id 134245, query id 232409312 192.168.0.61 crawler ---TRANSACTION 934C555B, not started, process no 31223, OS thread id 140075251988752 MySQL thread id 134201, query id 232442857 192.168.0.42 robby ---TRANSACTION 934C5986, not started, process no 31223, OS thread id 140075243735312 mysql tables in use 3, locked 2 MySQL thread id 134193, query id 232446989 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.krauthahn-berlin.de/gebrauchtwagen/details/125779146/jaguar-xf-30-v6-diesel-s-premium-luxury-navi') WHERE md5hash = '2da94545ab28aae814c19da2aa468f77' AND ABS(CAST(km AS SIGNED) - 1000) <= 1000 AND ABS(CAST(price AS SIGNED) - 59590) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 59590) , ABS(CAST(km AS SIGNED) - 1000) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 934C599E, not started, process no 31223, OS thread id 140075264502032 mysql tables in use 3, locked 2 MySQL thread id 134192, query id 232447127 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=lrfrgtjsvpdn') WHERE md5hash = '6b30bd7a4344d25fd371be52c05a4946' AND ABS(CAST(km AS SIGNED) - 40000) <= 1000 AND ABS(CAST(price AS SIGNED) - 7490) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 7490) , ABS(CAST(km AS SIGNED) - 40000) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 934C5987, not started, process no 31223, OS thread id 140075241339152 mysql tables in use 3, locked 2 MySQL thread id 134189, query id 232446993 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://autohaus.cc/Automarkt/Opel_Omega_2.2_Elegance.1017.html') WHERE md5hash = 'a0432f4127ef17ce2f9e5150c4a904b0' AND ABS(CAST(km AS SIGNED) - 107100) <= 1000 AND ABS(CAST(price AS SIGNED) - 5990) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 5990) , ABS(CAST(km AS SIGNED) - 107100) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 934C5988, not started, process no 31223, OS thread id 140075259443472 mysql tables in use 3, locked 2 MySQL thread id 134184, query id 232446997 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.autohaus-weitkamp.de/go.to/12753105266LWO00G32/3,6,v3rhgp6/hauptseite.html?version=200&sort=price:ASC') WHERE md5hash = '5a35a9349b406b35f0bea059aa2ca837' AND ABS(CAST(km AS SIGNED) - 16800) <= 1000 AND ABS(CAST(price AS SIGNED) - 28870) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 28870) , ABS(CAST(km AS SIGNED) - 16800) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 934C5961, not started, process no 31223, OS thread id 140075260242192 mysql tables in use 3, locked 2 MySQL thread id 134187, query id 232446866 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.autohaus-weitkamp.de/go.to/12753105266LWO00G32/3,5,s1vqj52/hauptseite.html?version=200&sort=price:ASC') WHERE md5hash = 'a7076aff7238f7082f2d019078e848bd' AND ABS(CAST(km AS SIGNED) - 120000) <= 1000 AND ABS(CAST(price AS SIGNED) - 24990) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 24990) , ABS(CAST(km AS SIGNED) - 120000) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 934C59AD, not started, process no 31223, OS thread id 140075249858832 mysql tables in use 3, locked 2 MySQL thread id 134194, query id 232447408 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.ford-maiwald.de/cont_mobile.php4?task=detail&angebot=21&sort=&time=1275310421&fzg=FORD+Fusion+1.4+Style&ka=&gr=&ma=') WHERE md5hash = 'f200975fab249a2ad836135778f06866' AND ABS(CAST(km AS SIGNED) - 9870) <= 1000 AND ABS(CAST(price AS SIGNED) - 11950) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 11950) , ABS(CAST(km AS SIGNED) - 9870) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 934C594A, not started, process no 31223, OS thread id 140075253053712 mysql tables in use 3, locked 2 MySQL thread id 134191, query id 232446777 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=122968529&__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&export=ALSO_EXPORT&grossPrice=true&customerIdsAsString=456604&lang=de&pageNumber=1&partnerHead=true&showZip=false&showMode ---TRANSACTION 934C59A4, not started, process no 31223, OS thread id 140075236014352 mysql tables in use 3, locked 2 MySQL thread id 134185, query id 232447145 192.168.0.41 robby Table lock UPDATE IGNORE merged_data_tb SET crawldatetime = NOW(), full_webaddress=CONCAT(SUBSTRING_INDEX(full_webaddress,'\t',1), '\t',NOW(), ' ', 'ry', '=http://frontend.haendlertool.de/default.php?cc_site=2&fahrzeug_id=724130&cc_lng=de&haendler_id=&start_user=600054&grp_id=225&css=&referer=cc_site%3D1%26start_user%3D600054%26haendler_id%3D%26grp_id%3D225%26cc_lng%3Dde%26cc_limit%3D80%26cc_rows%3D20%26marke%3D%26modell_version%3D%26karosserie%3D%26farbe_id%3D%26fuel_id%3D%26unfall%3D%26metallic%3D%26anz_sitze%3D%26anz_tueren%3D%26km_from%3D%26km_to%3D%26kw_from%3D%26kw_to%3D%26price_from%3D%26price_to ---TRANSACTION 934C598A, not started, process no 31223, OS thread id 140074921740560 mysql tables in use 3, locked 2 MySQL thread id 134188, query id 232447006 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://home.mobile.de/home/showDetails.html?id=120764125&__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&export=ALSO_EXPORT&grossPrice=true&customerIdsAsString=456604&lang=de&pageNumber=1&partnerHead=true&showZip=false&showMode ---TRANSACTION 934C5964, not started, process no 31223, OS thread id 140075250657552 mysql tables in use 3, locked 2 MySQL thread id 134186, query id 232446875 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://as24toyota.sevenval-fit.com/sevenval.fit/7val-fit-encoding=iso-8859-1/7val-fit-cid=1089/7val-fit-sid=3b75562a31272d8885e1bfdc80105f20/7val-fit-url1=http://autoscout24.de/as24merge/toyota/wl/detail?id=b2yta1xogpsv') WHERE md5hash = '9e6fab4f481afbbd490f73ea8ad55355' AND ABS(CAST(km AS SIGNED) - 35515) <= 1000 AND ABS(CAST(price AS SIGNED) - 14890) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 14890) , ABS(CAST(km AS SIGNED) - 35515) ) ---TRANSACTION 934C5996, not started, process no 31223, OS thread id 140075265300752 mysql tables in use 3, locked 2 MySQL thread id 134182, query id 232447068 192.168.0.83 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-weitkamp.de/go.to/12753105266LWO00G32/3,6,u7vqj6k/hauptseite.html?version=200&sort=price:ASC') WHERE md5hash = 'f62591f6a410df7d7ef45da7a7e3c9a0' AND ABS(CAST(km AS SIGNED) - 120000) <= 1000 AND ABS(CAST(price AS SIGNED) - 25990) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 25990) , ABS(CAST(km AS SIGNED) - 120000) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 934C59A8, not started, process no 31223, OS thread id 140075274619152 mysql tables in use 3, locked 2 MySQL thread id 134169, query id 232447193 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://autohaus.cc/Automarkt/Ford_Mondeo_1.8_Trend.927.html') WHERE md5hash = '6c30c43101de519d28f259108d353ef8' AND ABS(CAST(km AS SIGNED) - 56627) <= 1000 AND ABS(CAST(price AS SIGNED) - 8990) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 8990) , ABS(CAST(km AS SIGNED) - 56627) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 934C5982, not started, process no 31223, OS thread id 140075257313552 mysql tables in use 3, locked 2 MySQL thread id 134179, query id 232446980 192.168.0.145 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-weitkamp.de/go.to/12753105266LWO00G32/3,6,jktuf8d/hauptseite.html?version=200&sort=price:ASC') WHERE md5hash = 'd89c24403f8f0d6e80dc171715120205' AND ABS(CAST(km AS SIGNED) - 120000) <= 1000 AND ABS(CAST(price AS SIGNED) - 26990) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 26990) , ABS(CAST(km AS SIGNED) - 120000) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 934C59A5, not started, process no 31223, OS thread id 140075237345552 mysql tables in use 3, locked 2 MySQL thread id 134173, query id 232447150 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.klaus-krohnen.de/go.to/modix/3,,jktmlzj/fahrzeugangebot.html?sort=&ftyp=>yp=&fart=&version=285') WHERE md5hash = '72e93e167487063aea0341bb9f2f287a' AND ABS(CAST(km AS SIGNED) - 64500) <= 1000 AND ABS(CAST(price AS SIGNED) - 3950) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 3950) , ABS(CAST(km AS SIGNED) - 64500) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 934C5947, not started, process no 31223, OS thread id 140075261040912 mysql tables in use 3, locked 2 MySQL thread id 134170, query id 232446783 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://partner.fzg-boerse.de/Kunden/FzgFrontend/FZGDetailansicht.asp?Sprache=de&FahrzeugID=1353811&Innerframe=1') WHERE md5hash = 'fb3a1bbccea44427ea7ded22a80323c6' AND ABS(CAST(km AS SIGNED) - 115334) <= 1000 AND ABS(CAST(price AS SIGNED) - 6390) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 6390) , ABS(CAST(km AS SIGNED) - 115334) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 934C598B, not started, process no 31223, OS thread id 140082197858576 mysql tables in use 3, locked 2 MySQL thread id 134168, query id 232447014 192.168.0.145 robby Table lock UPDATE IGNORE merged_data_tb SET crawldatetime = NOW(), full_webaddress=CONCAT(SUBSTRING_INDEX(full_webaddress,'\t',1), '\t',NOW(), ' ', 'ry', '=http://autohaus.cc/Automarkt/AAA_Kia_Soul_1.6_CVVT_Vanilla.1024.html') WHERE md5hash = 'f91490e63f1f5edbd78203e0f49b3f09' AND ABS(CAST(km AS SIGNED) - 1) <= 1000 AND ABS(CAST(price AS SIGNED) - 18950) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 18950) , ABS(CAST(km AS SIGNED) - 1) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 934C594E, not started, process no 31223, OS thread id 140075251456272 mysql tables in use 3, locked 2 MySQL thread id 134175, query id 232446792 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://frontend.haendlertool.de/default.php?cc_site=2&fahrzeug_id=753966&cc_lng=de&haendler_id=&start_user=600054&grp_id=225&css=&referer=cc_site%3D1%26start_user%3D600054%26haendler_id%3D%26grp_id%3D225%26cc_lng%3Dde%26cc_limit%3D80%26cc_rows%3D20%26marke%3D%26modell_version%3D%26karosserie%3D%26farbe_id%3D%26fuel_id%3D%26unfall%3D%26metallic%3D%26anz_sitze%3D%26anz_tueren%3D%26km_from%3D%26km_to%3D%26kw_from%3D%26kw_to%3D%26price_from%3D%26price_to ---TRANSACTION 934C596C, not started, process no 31223, OS thread id 140075249060112 mysql tables in use 3, locked 2 MySQL thread id 134171, query id 232446899 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://vs.mercedes-benz.de/tge/pkw/pkw/detailansicht/5675/Mercedes-Benz/Kaiserslautern/A-Klasse/A+180+CDI+Limousine') WHERE md5hash = '5c12342f5bfffa351a895e839154abbd' AND ABS(CAST(km AS SIGNED) - 24000) <= 1000 AND ABS(CAST(price AS SIGNED) - 17900) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 17900) , ABS(CAST(km AS SIGNED) - 24000) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 934C596A, not started, process no 31223, OS thread id 140075232020752 mysql tables in use 3, locked 2 MySQL thread id 134176, query id 232446890 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://as24toyota.sevenval-fit.com/sevenval.fit/7val-fit-encoding=iso-8859-1/7val-fit-cid=1089/7val-fit-sid=701f9bd368051ce4ad5ac4e1ded4f120/7val-fit-url1=http://autoscout24.de/as24merge/toyota/wl/detail?id=lhryekdbgeq1') WHERE md5hash = '9d83314bfcb933211d294f7478a5a6c5' AND ABS(CAST(km AS SIGNED) - 57000) <= 1000 AND ABS(CAST(price AS SIGNED) - 12990) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 12990) , ABS(CAST(km AS SIGNED) - 57000) ) ---TRANSACTION 934C596F, not started, process no 31223, OS thread id 140075231222032 mysql tables in use 3, locked 2 MySQL thread id 134172, query id 232446906 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/Details.aspx?id=lhrzmbixuygq') WHERE md5hash = '6fd3d972e7d1ad3a9f03f5c2ee86489f' AND ABS(CAST(km AS SIGNED) - 10) <= 1000 AND ABS(CAST(price AS SIGNED) - 19499) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 19499) , ABS(CAST(km AS SIGNED) - 10) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 934C5999, not started, process no 31223, OS thread id 140075232553232 mysql tables in use 3, locked 2 MySQL thread id 134167, query id 232447135 192.168.0.145 robby Table lock UPDATE IGNORE merged_data_tb SET crawldatetime = NOW(), full_webaddress=CONCAT(SUBSTRING_INDEX(full_webaddress,'\t',1), '\t',NOW(), ' ', 'ry', '=http://autohaus.cc/Automarkt/Ford_Escort_1.6.1023.html') WHERE md5hash = 'ea90e968771ba022046f78fa8cf764fd' AND ABS(CAST(km AS SIGNED) - 1) <= 1000 AND ABS(CAST(price AS SIGNED) - 1950) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 1950) , ABS(CAST(km AS SIGNED) - 1) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 934C593A, not started, process no 31223, OS thread id 140075269028112 mysql tables in use 3, locked 2 MySQL thread id 134174, query id 232446712 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://vs.mercedes-benz.de/bnr/pkw/pkw/detailansicht/911231/Mercedes-Benz/Coburg/E-Klasse/E+350+CDI+BlueEFFICIENCY') WHERE md5hash = '615f39c31cce7ead1417aa42fd33db7d' AND ABS(CAST(km AS SIGNED) - 8000) <= 1000 AND ABS(CAST(price AS SIGNED) - 49900) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 49900) , ABS(CAST(km AS SIGNED) - 8000) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 934C5937, not started, process no 31223, OS thread id 140075237611792 mysql tables in use 3, locked 2 MySQL thread id 134162, query id 232446707 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://car.my-motion.de/30041/car1070008-VW_Touareg_V6_3.0_TDI_BlueMotion_Technology_DPF.html?session=2cc9664177250a088f2159ea9706469d') WHERE md5hash = 'c28677238da41674302c25161845979d' AND ABS(CAST(km AS SIGNED) - 3000) <= 1000 AND ABS(CAST(price AS SIGNED) - 69880) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 69880) , ABS(CAST(km AS SIGNED) - 3000) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 934C59A6, not started, process no 31223, OS thread id 140075266365712 mysql tables in use 3, locked 2 MySQL thread id 134166, query id 232447155 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.klaus-krohnen.de/go.to/modix/3,,u7rkqer/fahrzeugangebot.html?sort=&ftyp=>yp=&fart=&version=285') WHERE md5hash = '3954c01030b2165d1eadae47e5907590' AND ABS(CAST(km AS SIGNED) - 9740) <= 1000 AND ABS(CAST(price AS SIGNED) - 11650) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 11650) , ABS(CAST(km AS SIGNED) - 9740) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 934C595D, not started, process no 31223, OS thread id 140075244001552 mysql tables in use 3, locked 2 MySQL thread id 134159, query id 232446852 192.168.0.145 robby Table lock UPDATE IGNORE merged_data_tb SET crawldatetime = NOW(), full_webaddress=CONCAT(SUBSTRING_INDEX(full_webaddress,'\t',1), '\t',NOW(), ' ', 'ry', '=http://frontend.haendlertool.de/default.php?cc_site=2&fahrzeug_id=743066&cc_lng=de&haendler_id=&start_user=600054&grp_id=225&css=&referer=cc_site%3D1%26start_user%3D600054%26haendler_id%3D%26grp_id%3D225%26cc_lng%3Dde%26cc_limit%3D80%26cc_rows%3D20%26marke%3D%26modell_version%3D%26karosserie%3D%26farbe_id%3D%26fuel_id%3D%26unfall%3D%26metallic%3D%26anz_sitze%3D%26anz_tueren%3D%26km_from%3D%26km_to%3D%26kw_from%3D%26kw_to%3D%26price_from%3D%26price_to ---TRANSACTION 934C593B, not started, process no 31223, OS thread id 140075263170832 mysql tables in use 3, locked 2 MySQL thread id 134157, query id 232446744 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=129761473&__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&export=ALSO_EXPORT&grossPrice=true&customerIdsAsString=456604&lang=de&pageNumber=1&partnerHead=true&showZip=false&showMode ---TRANSACTION 934C592C, not started, process no 31223, OS thread id 140075263969552 mysql tables in use 3, locked 2 MySQL thread id 134160, query id 232446735 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://www.haendlerfahrzeuge.de/ah_showfz.php?SESSAD=8b32ae00efe569c4aa51ee871cabbe6d&aktion=detail&pos=22&seite=1&fznr=10550789') WHERE md5hash = '0067f13df0c458c079d55bebbc10bb55' AND ABS(CAST(km AS SIGNED) - 31883) <= 1000 AND ABS(CAST(price AS SIGNED) - 9950) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 9950) , ABS(CAST(km AS SIGNED) - 31883) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 934C5944, not started, process no 31223, OS thread id 140075244800272 mysql tables in use 3, locked 2 MySQL thread id 134158, query id 232446776 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://www.fischer-buchloe.de/go.to/modix/3,1,10533436/fahrzeuge.html') WHERE md5hash = '918d17f8fb90daf0db98b1fbd1918f9e' AND ABS(CAST(km AS SIGNED) - 70000) <= 1000 AND ABS(CAST(price AS SIGNED) - 7990) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 7990) , ABS(CAST(km AS SIGNED) - 70000) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 934C4C35, not started, process no 31223, OS thread id 140075229890832 MySQL thread id 134154, query id 232434699 192.168.0.59 crawler ---TRANSACTION 934C5998, not started, process no 31223, OS thread id 140075237878032 MySQL thread id 134152, query id 232447083 192.168.0.60 crawler ---TRANSACTION 934C59A3, not started, process no 31223, OS thread id 140075260774672 MySQL thread id 134149, query id 232447139 192.168.0.60 crawler ---TRANSACTION 9349BB88, not started, process no 31223, OS thread id 140075257579792 MySQL thread id 133554, query id 231609912 192.168.0.234 readonly ---TRANSACTION 934C5268, not started, process no 31223, OS thread id 140075220625680 mysql tables in use 6, locked 6 MySQL thread id 132856, query id 232447141 192.168.0.60 crawler Table lock REPLACE INTO merged_data_tb VALUES ('2010-05-31 15:01:41','0','CM_38','mercedes-benz clk 200','2041173','200401','','1000','0','16000','0010000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000','ES25007','0','2010-05-15 09:40:28 Cochesmotos=http://ciudadlleida.coches-motos.com/mercedes-iid-40415202 2010-05-31 15:01:37 Cochesmotos=http://ciudadlleida.coches-motos.com/mercedes-iid-40415202','686ee2d6f503f889c3e1ebc77df8084a~~~~NO GARBAGE','http://192.168.0.204/yare/6/8/6/686ee2d6f503f889c3e1ebc77df8084a_16000_1000.html','0~~~~ES25007~lleida~ES~anonimo~ ---TRANSACTION 0, not started, process no 31223, OS thread id 140075249592592 MySQL thread id 130979, query id 229383981 192.168.0.235 admin ---TRANSACTION 934C5952, not started, process no 31223, OS thread id 140075257047312 mysql tables in use 3, locked 2 MySQL thread id 130676, query id 232446807 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/renault-grand-scenic/6077303.html') WHERE md5hash = 'b4b639834e3f7d40a4c5ff3a5f5ea003' AND ABS(CAST(km AS SIGNED) - 91963) <= 1000 AND ABS(CAST(price AS SIGNED) - 10900) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 10900) , ABS(CAST(km AS SIGNED) - 91963) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 0, not started, process no 31223, OS thread id 140075263437072 MySQL thread id 126554, query id 229736937 192.168.0.235 admin ---TRANSACTION 0, not started, process no 31223, OS thread id 140075262638352 MySQL thread id 126472, query id 232152272 192.168.0.235 admin ---TRANSACTION 0, not started, process no 31223, OS thread id 140075242670352 MySQL thread id 124906, query id 226731867 192.168.0.235 admin ---TRANSACTION 934C5930, not started, process no 31223, OS thread id 140075250125072 mysql tables in use 3, locked 2 MySQL thread id 124796, query id 232446686 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(), ' ', 'Autoreflex', '=http://www.autoreflex.com/voiture-occasion-ford-focus-c-max-c-max-1-8-bioflex-ghia-FVO3437186.htm?increment_fich=27&prov=liste') WHERE md5hash = 'efad9ab0b61ad66ddf47b149a056dbda' AND ABS(CAST(km AS SIGNED) - 31116) <= 1000 AND ABS(CAST(price AS SIGNED) - 11990) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 11990) , ABS(CAST(km AS SIGNED) - 31116) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 934C5962, not started, process no 31223, OS thread id 140075252254992 mysql tables in use 3, locked 2 MySQL thread id 121127, query id 232446868 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=b22esemfcngd&asrc=fa') , picHash = '28da181e56be17b727570b2b972db7c7' WHERE md5hash = '365d1fa0a2d2caa06965726b4841cef5' AND ABS(CAST(km AS SIGNED) - 124049) <= 1000 AND ABS(CAST(price AS SIGNED) - 33333) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 33333) , ABS(CAST(km AS SIGNED) - 124049) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 934C593F, not started, process no 31223, OS thread id 140074916682000 mysql tables in use 3, locked 2 MySQL thread id 119823, query id 232446711 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=vrppjybsywmt') , picHash = '835b23bbeb48912e6f9681fc2e1ce32f' WHERE md5hash = '319781ecc7c0be5218f95d8af0ae240a' AND ABS(CAST(km AS SIGNED) - 57304) <= 1000 AND ABS(CAST(price AS SIGNED) - 23900) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 23900) , ABS(CAST(km AS SIGNED) - 57304) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 934C5742, not started, process no 31223, OS thread id 140075259709712 mysql tables in use 3, locked 2 MySQL thread id 112593, query id 232446670 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=v2y3dlj2qxp3&asrc=fa') , picHash = 'c57028e5d190c4c9de699108e212cc9e' WHERE md5hash = 'a69e6e1ddc7c4ffa8d4b349239fd94bc' AND ABS(CAST(km AS SIGNED) - 20792) <= 1000 AND ABS(CAST(price AS SIGNED) - 12190) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 12190) , ABS(CAST(km AS SIGNED) - 20792) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 934C595B, not started, process no 31223, OS thread id 140082198923536 mysql tables in use 3, locked 2 MySQL thread id 108396, query id 232446845 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(), ' ', 'Autoanzeigen', '=http://www.autoanzeigen.de/smart+smart+regensburg-i62335702_392e7c05facbb8739f70.htm') WHERE md5hash = '1093ecf6d0bd5c81b720897dcae2b2d2' AND ABS(CAST(km AS SIGNED) - 36000) <= 1000 AND ABS(CAST(price AS SIGNED) - 5900) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 5900) , ABS(CAST(km AS SIGNED) - 36000) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 934C597F, not started, process no 31223, OS thread id 140075241871632 mysql tables in use 6, locked 6 MySQL thread id 108006, query id 232447121 192.168.0.60 crawler Table lock REPLACE INTO merged_data_tb VALUES ('2010-05-31 15:01:49','0','SM_03','audi a6 2.0 tdi 4p. -06','2026134','200601','schwarz','58200','0','20600','0101100000000100000000000000000000000000000000000000000001000000000000001000000110000010000000000000','ES50011','0','2010-05-12 08:30:00 Segundamano=http://www.segundamano.es/zaragoza/audi-a6-20-tdi-4p/a19995589/?c=4 2010-05-31 15:01:44 Segundamano=http://www.segundamano.es/zaragoza/audi-a6-20-tdi-4p/a19995589/?c=4','d47822284961eeddca83ce46d4ce8376~~~~NO GARBAGE','http://192.168.0.204/yare/d/4/7/d47822284961eeddca83ce46d4ce8376_20600_58200.html','1~ ---TRANSACTION 934C5995, not started, process no 31223, OS thread id 140074915617040 mysql tables in use 3, locked 2 MySQL thread id 105733, query id 232447054 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/volkswagen-touran-2008-2008-20000-kms_39996430.html') WHERE md5hash = 'b1c4a7f4106bd916cc5e0ccd8ba02daa' AND ABS(CAST(km AS SIGNED) - 20000) <= 1000 AND ABS(CAST(price AS SIGNED) - 17500) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 17500) , ABS(CAST(km AS SIGNED) - 20000) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 934C5989, not started, process no 31223, OS thread id 140075230423312 mysql tables in use 3, locked 2 MySQL thread id 97934, query id 232447004 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=106007574&origin=5&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 = '42ffe801d4b51564f75be97ac190c004' AND ABS(CAST(km AS SIGNED) - 10) <= 1000 AND ABS(CAST(price AS S ---TRANSACTION 934C5938, not started, process no 31223, OS thread id 140075266099472 mysql tables in use 3, locked 2 MySQL thread id 90847, query id 232446664 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(), ' ', 'Renaultgw', '=http://www.renault-gw.de/suche_angebot.php?srcPLZ=&srcUmkreis=50&srcModell=&srcEZ=&srcPreisVon=13000&srcPreisBis=14000&srcKM=&srcMotor=DIESELMOTOR&srcLeistung=&srcGetriebe=&srcFarbe=Schwarz&srcOrder=AP_brutto&srcOrderDir=ASC&suche=2&srcOption1=&srcOption2=&srcOption3=&srcOption4=&srcOption5=&srcOption6=&srcOption7=&srcOption8=&sessionid=c96dd7f50d8f26fb8833a7cb260010ce&suche=2&maxShow=10&pg=10&ref=&type=&mzpg=&bnSiteID=0&bnPlacementID ---TRANSACTION 934C594C, not started, process no 31223, OS thread id 140075270359312 mysql tables in use 3, locked 2 MySQL thread id 83364, query id 232446771 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(), ' ', 'Carbusiness', '=http://carbusiness.it/707438/auto-usata/fiat_panda.ashx') WHERE md5hash = '6694bf93fbeb3672501b92e6841a17b6' AND ABS(CAST(km AS SIGNED) - 15600) <= 1000 AND ABS(CAST(price AS SIGNED) - 8000) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 8000) , ABS(CAST(km AS SIGNED) - 15600) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 934C5997, not started, process no 31223, OS thread id 140075252521232 mysql tables in use 3, locked 2 MySQL thread id 81650, query id 232447077 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=102775150&country=ch&language=de&searchtype=&menutype=makelist') WHERE md5hash = '4de1833395c05bf7236f41afb6e79161' AND ABS(CAST(km AS SIGNED) - 131000) <= 1000 AND ABS(CAST(price AS SIGNED) - 25900) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 25900) , ABS(CAST(km AS SIGNED) - 131000) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 934C5949, not started, process no 31223, OS thread id 140075236813072 mysql tables in use 3, locked 2 MySQL thread id 56602, query id 232446787 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/opel/astra/astra-1.6/GW20XN06G7X2.html') , picHash = '84cb256e8ab14b24428c8731b242c94e' WHERE md5hash = 'cd12bb5c9c592f2157575c85c4ab4c01' AND ABS(CAST(km AS SIGNED) - 86880) <= 1000 AND ABS(CAST(price AS SIGNED) - 8900) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 8900) , ABS(CAST(km AS SIGNED) - 86880) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 934C59A7, not started, process no 31223, OS thread id 140074918013200 mysql tables in use 3, locked 2 MySQL thread id 51195, query id 232447158 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-ford-mondeo-504150.html') WHERE md5hash = '06911245c5305589e1a035bdf4c8a0d2' AND ABS(CAST(km AS SIGNED) - 103144) <= 1000 AND ABS(CAST(price AS SIGNED) - 4800) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 4800) , ABS(CAST(km AS SIGNED) - 103144) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 934C5931, not started, process no 31223, OS thread id 140075271690512 mysql tables in use 3, locked 2 MySQL thread id 8610, query id 232446688 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-10968555.html') WHERE md5hash = '3c9aaa3b9400f40f535693fc1938e4c7' AND ABS(CAST(km AS SIGNED) - 103541) <= 1000 AND ABS(CAST(price AS SIGNED) - 7900) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 7900) , ABS(CAST(km AS SIGNED) - 103541) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 934C5933, not started, process no 31223, OS thread id 140075244534032 mysql tables in use 3, locked 2 MySQL thread id 7815, query id 232446713 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-megane-carro-204260.html') WHERE md5hash = '930c091732dbd037d66be195fef1bf17' AND ABS(CAST(km AS SIGNED) - 90000) <= 1000 AND ABS(CAST(price AS SIGNED) - 16950) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 16950) , ABS(CAST(km AS SIGNED) - 90000) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 934C594F, not started, process no 31223, OS thread id 140075266631952 mysql tables in use 3, locked 2 MySQL thread id 7724, query id 232446804 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=52695906&ANZEIGE_FINANZIERUNG_VON=0&ANZEIGE_FINANZIERUNG_BIS=0&MARKE_ID=0&ANZEIGE_MODELL=&ANZEIGE_EZJAHR_VON=2001&ANZEIGE_EZJAHR_BIS=2002&FZKATEGORIE_ID=1002&ATTRIBUT_ID_FZART=0&ANZEIGE_PREIS_VON=500&ANZEIGE_PREIS_BIS=8000&ATTRIBUT_ID_KRAFTSTOFF=&ATTRG_GETRIEBE=0&ANZEIGE_KMSTAND_VON=&ANZEIGE_KMSTAND_BIS=300000&FARBE_ID=&ANZEIGE_SCHALTDATUM=0&ANZEIGE_ ---TRANSACTION 934C592E, not started, process no 31223, OS thread id 140075255716112 mysql tables in use 3, locked 2 MySQL thread id 7611, query id 232446673 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', '=\'119\',\'0\'') WHERE md5hash = '388791e67470e15ae00c4b220cece35b' AND ABS(CAST(km AS SIGNED) - 55000) <= 1000 AND ABS(CAST(price AS SIGNED) - 15600) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 15600) , ABS(CAST(km AS SIGNED) - 55000) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 934C593C, not started, process no 31223, OS thread id 140075239209232 mysql tables in use 3, locked 2 MySQL thread id 7532, query id 232446718 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=e833b9196f87f2a73cf3f0bf7bba04b8') , picHash = '22e51f40d0eeadaa962f252663731fec' WHERE md5hash = 'e542b67eb16b596ae6df36408336590d' AND ABS(CAST(km AS SIGNED) - 11350) <= 1000 AND ABS(CAST(price AS SIGNED) - 12450) <= 1000 ORDER BY LEAST( ABS(CAST(price AS SIGNED) - 12450) , ABS(CAST(km AS SIGNED) - 11350) ) ASC, CAST(LEFT(full_webaddress, 19) AS DATETIME) ASC LIMIT 1 ---TRANSACTION 934C595F, not started, process no 31223, OS thread id 140074915883280 mysql tables in use 3, locked 2 MySQL thread id 7529, query id 232446857 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(), ' ', 'Car4youat', '=http://www.car4you.at/sea_det.cfm?vehicleid=4473939&&language=de&market=1,2&language=de&searchbodydesc=Kombi&status=9,10,11,12&colorid_list=13&searchfueltypedesc=Diesel&maxprice=500000&stylecode=10&searchmakedesc=OPEL&maxmileage=300000&showtype=0&minlicense=1994&minprice=500&step=30&menutype=search&defaultlist=102745935,102745355,4442621,4440611,102740120,4438072,4435492,4435339,102738342,102738185,4434210,4434016,4433044,102736406,44 ---TRANSACTION 934C4D28, ACTIVE 45 sec, process no 31223, OS thread id 140074916415760 fetching rows mysql tables in use 3, locked 3 168075 lock struct(s), heap size 14973368, 0 row lock(s) MySQL thread id 130424, query id 232435423 192.168.0.230 petrik Sending data CREATE TEMPORARY TABLE recrawl_tmp SELECT sql_runner FROM merged_data_tb WHERE LEFT(crawlpage,2) regexp NAME_CONST('portal',_latin1'\'az\',\'aj\',\'tv\'' COLLATE 'latin1_swedish_ci') -------- 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: doing file i/o (read thread) ev set I/O thread 3 state: doing file i/o (read thread) ev set I/O thread 4 state: doing file i/o (read thread) ev set 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: 207, 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 58362423 OS file reads, 17777387 OS file writes, 1335576 OS fsyncs 3 pending preads, 0 pending pwrites 1000.19 reads/s, 65003 avg bytes/read, 61.94 writes/s, 2.68 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 6, free list len 11133, seg size 11140, 2387846 inserts, 2386990 merged recs, 1013415 merges Hash table size 11413553, node heap has 855 buffer(s) 53.28 hash searches/s, 405.13 non-hash searches/s --- LOG --- Log sequence number 1875464405082 Log flushed up to 1875464380402 Last checkpoint at 1875408878888 0 pending log writes, 0 pending chkp writes 371394 log i/o's done, 0.59 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 5899534336; in additional pool allocated 0 Dictionary memory allocated 118192 Buffer pool size 352000 Free buffers 1 Database pages 350231 Old database pages 129264 Modified db pages 43747 Pending reads 207 Pending writes: LRU 0, flush list 1, single page 0 Pages made young 81765617, not young 0 3872.38 youngs/s, 0.00 non-youngs/s Pages read 68491123, created 1104908, written 19962274 3968.19 reads/s, 0.49 creates/s, 65.43 writes/s Buffer pool hit rate 959 / 1000, young-making rate 40 / 1000 not 0 / 1000 Pages read ahead 3110.92/s, evicted without access 19.49/s LRU len: 350231, unzip_LRU len: 0 I/O sum[58855]:cur[0], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 1 read views open inside InnoDB Main thread process no. 31223, id 140075283544336, state: flushing buffer pool pages Number of rows inserted 11059616, updated 26041949, deleted 4315831, read 714093670 7.86 inserts/s, 13.69 updates/s, 5.56 deletes/s, 43973.42 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================