| InnoDB | | ===================================== 090106 13:21:05 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 50 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 3998999, signal count 3070128 Mutex spin waits 0, rounds 482828140, OS waits 3418634 RW-shared spins 635063, OS waits 80758; RW-excl spins 2309499, OS waits 101902 ------------ TRANSACTIONS ------------ Trx id counter 1 4021546069 Purge done for trx's n:o < 1 4021545616 undo n:o < 0 0 History list length 20 ... truncated... and country_id = '221' ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1290799424 MySQL thread id 1022587, query id 28572091 10.1.0.200 Opening tables select id from profiles join profile_thumbs on id = profile_id order by profile_id desc limit 10 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1290266944 MySQL thread id 1022583, query id 28572074 10.1.0.202 Opening tables select p.*, fm.name as first_name, ln.name as last_name, mn.name as middle_name from profiles as p inner join first_names2 as fm on fm.id = p.first_name inner join last_names2 as ln on ln.id = p.last_name left join middle_names2 as mn on mn.id = p.middle_name where p.id = 30426961 and p.links >= 0 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1290533184 MySQL thread id 1022584, query id 28572077 10.1.0.202 Opening tables select p.*, fm.name as first_name, ln.name as last_name, mn.name as middle_name from profiles as p inner join first_names2 as fm on fm.id = p.first_name inner join last_names2 as ln on ln.id = p.last_name left join middle_names2 as mn on mn.id = p.middle_name where p.id = 30426961 and p.links >= 0 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1288137024 MySQL thread id 1022579, query id 28572047 10.1.0.201 Opening tables SELECT id FROM last_names2 WHERE name = BINARY LOWER('Main') ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1288403264 MySQL thread id 1022551, query id 28571886 10.1.0.201 Opening tables SELECT country_id,id,name FROM regions WHERE name="Maryland" AND country_id=222 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1288935744 MySQL thread id 1022550, query id 28571868 10.1.0.202 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1287072064 MySQL thread id 1022530, query id 28571762 10.1.0.200 Opening tables select p.*, fm.name as first_name, ln.name as last_name, mn.name as middle_name from profiles as p inner join first_names2 as fm on fm.id = p.first_name inner join last_names2 as ln on ln.id = p.last_name left join middle_names2 as mn on mn.id = p.middle_name where p.id = 128457594 and p.links >= 0 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1286805824 MySQL thread id 1022529, query id 28571767 10.1.0.202 Opening tables select id from first_names2 where name = binary lower('Travis') ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1286539584 MySQL thread id 1022528, query id 28571749 10.1.0.202 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1286007104 MySQL thread id 1022521, query id 28571712 10.1.0.202 Opening tables SELECT COUNT(first_name) AS cnt FROM profiles AS p force index (first_last_middle_links_sex_age_id) WHERE first_name=8977 AND last_name=451499 and p.links >= 0 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1285740864 MySQL thread id 1022520, query id 28571699 10.1.0.202 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1285208384 MySQL thread id 1022518, query id 28571694 10.1.0.200 Opening tables select id from first_names2 where name = binary lower('Antonio') ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1284942144 MySQL thread id 1022517, query id 28571684 10.1.0.200 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1284409664 MySQL thread id 1022515, query id 28571679 10.1.0.200 Opening tables select profile_id, profile_id_other, type from profile_relations where profile_id = 7061771 or profile_id_other = 7061771 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1283610944 MySQL thread id 1022510, query id 28571647 10.1.0.200 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1283344704 MySQL thread id 1022509, query id 28571642 10.1.0.200 Opening tables select p.*, fm.name as first_name, ln.name as last_name, mn.name as middle_name from profiles as p inner join first_names2 as fm on fm.id = p.first_name inner join last_names2 as ln on ln.id = p.last_name left join middle_names2 as mn on mn.id = p.middle_name where p.id = 127551925 and p.links >= 0 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1283078464 MySQL thread id 1022505, query id 28571622 10.1.0.202 Opening tables select id from last_names2 where name = binary lower('Vermilye') ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1282545984 MySQL thread id 1022501, query id 28571601 10.1.0.200 Opening tables select id from first_names2 where name = binary lower('JOHN') ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1282013504 MySQL thread id 1022499, query id 28571587 10.1.0.200 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1281747264 MySQL thread id 1022495, query id 28571576 10.1.0.201 Opening tables SELECT id FROM last_names2 WHERE name = BINARY LOWER('Arguelles') ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1280948544 MySQL thread id 1022492, query id 28571551 10.1.0.200 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1279617344 MySQL thread id 1022483, query id 28571507 10.1.0.200 Opening tables SELECT * FROM countrys WHERE name='tom beal' OR code='tom_beal' ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1279084864 MySQL thread id 1022480, query id 28571491 10.1.0.202 Opening tables select id from last_names2 where name = binary lower('Pendergrall') ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1278818624 MySQL thread id 1022478, query id 28571474 10.1.0.202 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1278552384 MySQL thread id 1022472, query id 28571439 10.1.0.202 Opening tables select id from profiles join profile_thumbs on id = profile_id order by profile_id desc limit 10 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1278286144 MySQL thread id 1022466, query id 28571405 10.1.0.200 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1277221184 MySQL thread id 1022456, query id 28571359 10.1.0.202 Opening tables SELECT id FROM last_names2 WHERE name = BINARY LOWER('Emby') ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1276954944 MySQL thread id 1022455, query id 28571357 10.1.0.201 Opening tables SELECT id FROM last_names2 WHERE name = BINARY LOWER('Breitkreuz') ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1275889984 MySQL thread id 1022431, query id 28571211 10.1.0.202 Opening tables select p.*, fm.name as first_name, ln.name as last_name, mn.name as middle_name from profiles as p inner join first_names2 as fm on fm.id = p.first_name inner join last_names2 as ln on ln.id = p.last_name left join middle_names2 as mn on mn.id = p.middle_name where p.id = 657274 and p.links >= 0 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1275623744 MySQL thread id 1022418, query id 28571129 10.1.0.201 Opening tables select p.*, fm.name as first_name, ln.name as last_name, mn.name as middle_name from profiles as p inner join first_names2 as fm on fm.id = p.first_name inner join last_names2 as ln on ln.id = p.last_name left join middle_names2 as mn on mn.id = p.middle_name where p.id = 455634 and p.links >= 0 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1273227584 MySQL thread id 1022410, query id 28571079 10.1.0.200 Opening tables select id from profiles join profile_thumbs on id = profile_id order by profile_id desc limit 10 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1275091264 MySQL thread id 1022402, query id 28571032 10.1.0.201 Opening tables select p.*, fm.name as first_name, ln.name as last_name, mn.name as middle_name from profiles as p inner join first_names2 as fm on fm.id = p.first_name inner join last_names2 as ln on ln.id = p.last_name left join middle_names2 as mn on mn.id = p.middle_name where p.id = 142491417 and p.links >= 0 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1274292544 MySQL thread id 1022391, query id 28570967 10.1.0.202 Opening tables select p.*, fm.name as first_name, ln.name as last_name, mn.name as middle_name from profiles as p inner join first_names2 as fm on fm.id = p.first_name inner join last_names2 as ln on ln.id = p.last_name left join middle_names2 as mn on mn.id = p.middle_name where p.id = 657274 and p.links >= 0 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1274026304 MySQL thread id 1022390, query id 28570969 10.1.0.200 Opening tables select p.*, fm.name as first_name, ln.name as last_name, mn.name as middle_name from profiles as p inner join first_names2 as fm on fm.id = p.first_name inner join last_names2 as ln on ln.id = p.last_name left join middle_names2 as mn on mn.id = p.middle_name where p.id = 149780950 and p.links >= 0 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1273493824 MySQL thread id 1022384, query id 28570925 10.1.0.200 Opening tables select id from profiles join profile_thumbs on id = profile_id order by profile_id desc limit 10 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1272162624 MySQL thread id 1022353, query id 28570752 10.1.0.200 Opening tables select first_name_else from multifname where first_name = 28353 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1271363904 MySQL thread id 1022331, query id 28570648 10.1.0.200 Opening tables Select cry.name as country_name, r.region_code as region_abbrev, r.name as region_name, c.name as city_name from regions as r inner join citys as c on r.id = c.region_id join countrys as cry on r.country_id = cry.id where r.id = '3827' AND c.id = '1883392' ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1269500224 MySQL thread id 1022304, query id 28570471 10.1.0.202 Opening tables select id from first_names2 where name = binary lower('Eric') ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1268701504 MySQL thread id 1022300, query id 28570450 10.1.0.201 Opening tables select id from first_names2 where name = binary lower('Ann Marie') ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1268169024 MySQL thread id 1022295, query id 28570422 10.1.0.200 Opening tables SELECT COUNT(first_name) AS cnt FROM profiles AS p force index (first_last_middle_links_sex_age_id) WHERE first_name=4578 AND last_name=451499 and p.links >= 0 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1267370304 MySQL thread id 1022294, query id 28570410 10.1.0.200 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1266837824 MySQL thread id 1022288, query id 28570399 10.1.0.202 Opening tables SELECT profile_id FROM search_city_3827 AS p /* /var/www/LIVE0A0A/search.class.php 1752 72.14.193.67 build_query */ ORDER BY links DESC LIMIT 0,20 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1267104064 MySQL thread id 1022289, query id 28570394 10.1.0.200 Opening tables SELECT * FROM countrys WHERE name='Latoya Carter' OR code='Latoya_Carter' ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1266305344 MySQL thread id 1022286, query id 28570362 10.1.0.201 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1265240384 MySQL thread id 1022280, query id 28570343 10.1.0.201 Opening tables select id from first_names2 where name = binary lower('JOHN') ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1264974144 MySQL thread id 1022279, query id 28570335 10.1.0.202 Opening tables select id from first_names2 where name = binary lower('Teresa') ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1264707904 MySQL thread id 1022278, query id 28570317 10.1.0.201 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1264441664 MySQL thread id 1022276, query id 28570306 10.1.0.202 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1263909184 MySQL thread id 1022274, query id 28570320 10.1.0.202 Opening tables select p.*, fm.name as first_name, ln.name as last_name, mn.name as middle_name from profiles as p inner join first_names2 as fm on fm.id = p.first_name inner join last_names2 as ln on ln.id = p.last_name left join middle_names2 as mn on mn.id = p.middle_name where p.id = 56066217 and p.links >= 0 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1263642944 MySQL thread id 1022273, query id 28570301 10.1.0.201 Opening tables select id from citys where name = 'Stockton' and region_id = '3827' ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1263110464 MySQL thread id 1022269, query id 28570272 10.1.0.200 Opening tables select id from first_names2 where name = binary lower('Eric') ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1262844224 MySQL thread id 1022267, query id 28570256 10.1.0.200 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1262311744 MySQL thread id 1022262, query id 28570233 10.1.0.200 Opening tables select id from first_names2 where name = binary lower('Susan') ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1261779264 MySQL thread id 1022251, query id 28570163 10.1.0.200 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1260714304 MySQL thread id 1022229, query id 28570043 10.1.0.202 Opening tables select p.*, fm.name as first_name, ln.name as last_name, mn.name as middle_name from profiles as p inner join first_names2 as fm on fm.id = p.first_name inner join last_names2 as ln on ln.id = p.last_name left join middle_names2 as mn on mn.id = p.middle_name where p.id = 143426233 and p.links >= 0 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1260181824 MySQL thread id 1022228, query id 28570040 10.1.0.200 Opening tables select id from citys where name = 'Awards' and region_id = '' ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1260448064 MySQL thread id 1022210, query id 28569921 10.1.0.202 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1259116864 MySQL thread id 1022199, query id 28569870 10.1.0.201 Opening tables SELECT id FROM usernames WHERE name="strawberry89babe" ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1258584384 MySQL thread id 1022180, query id 28569746 10.1.0.202 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1258318144 MySQL thread id 1022172, query id 28569701 10.1.0.202 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1257519424 MySQL thread id 1022166, query id 28569686 10.1.0.200 Opening tables SELECT id FROM usernames WHERE name="39" ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1256986944 MySQL thread id 1022144, query id 28569544 10.1.0.201 Opening tables select id from profiles join profile_thumbs on id = profile_id order by profile_id desc limit 10 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1256188224 MySQL thread id 1022136, query id 28569513 10.1.0.202 Opening tables select p.*, fm.name as first_name, ln.name as last_name, mn.name as middle_name from profiles as p inner join first_names2 as fm on fm.id = p.first_name inner join last_names2 as ln on ln.id = p.last_name left join middle_names2 as mn on mn.id = p.middle_name where p.id = 3854146 and p.links >= 0 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1255921984 MySQL thread id 1022135, query id 28569504 10.1.0.200 Opening tables SELECT id FROM last_names2 WHERE name = BINARY LOWER('Fic') ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1255123264 MySQL thread id 1022134, query id 28569506 10.1.0.201 Opening tables SELECT * FROM countrys WHERE name='Rabia Iqbal' OR code='Rabia_Iqbal' ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1251395904 MySQL thread id 1022122, query id 28569423 10.1.0.200 Opening tables select id from citys where name = 'Concord' and region_id = '' ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1248999744 MySQL thread id 1022120, query id 28569409 10.1.0.200 Opening tables SELECT id FROM first_names2 WHERE name = BINARY LOWER('MELODY') ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1237285184 MySQL thread id 1022116, query id 28569388 10.1.0.202 Opening tables SELECT id FROM last_names2 WHERE name = BINARY LOWER('McMenemy') ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1247136064 MySQL thread id 1022109, query id 28569349 10.1.0.202 Opening tables Select u.id as UID, u.username, u.password,u.salt,u.type,a.id as AID, active from users as u inner join actors_new as a on u.id = a.user_id where username = 'susanorourke' ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1240746304 MySQL thread id 1022098, query id 28569297 10.1.0.200 Opening tables select p.*, fm.name as first_name, ln.name as last_name, mn.name as middle_name from profiles as p inner join first_names2 as fm on fm.id = p.first_name inner join last_names2 as ln on ln.id = p.last_name left join middle_names2 as mn on mn.id = p.middle_name where p.id = 111939374 and p.links >= 0 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1239148864 MySQL thread id 1022097, query id 28569283 10.1.0.200 Opening tables select id from regions where name = 'school' and country_id = '' ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1238882624 MySQL thread id 1022095, query id 28569258 10.1.0.202 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1231161664 MySQL thread id 1022071, query id 28569136 10.1.0.200 Opening tables select p.*, fm.name as first_name, ln.name as last_name, mn.name as middle_name from profiles as p inner join first_names2 as fm on fm.id = p.first_name inner join last_names2 as ln on ln.id = p.last_name left join middle_names2 as mn on mn.id = p.middle_name where p.id = 47944295 and p.links >= 0 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1232759104 MySQL thread id 1022062, query id 28569086 10.1.0.201 Opening tables SELECT id FROM last_names2 WHERE name = BINARY LOWER('Fic') ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1227966784 MySQL thread id 1022050, query id 28569013 10.1.0.202 Opening tables select id from first_names2 where name = binary lower('Scott') ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1227700544 MySQL thread id 1022049, query id 28568999 10.1.0.202 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1226635584 MySQL thread id 1022047, query id 28568994 10.1.0.200 Opening tables SELECT COUNT(first_name) AS cnt FROM profiles AS p force index (first_last_middle_links_sex_age_id) WHERE first_name=4181 AND last_name=451499 and p.links >= 0 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1182705984 MySQL thread id 1022046, query id 28568982 10.1.0.200 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1223973184 MySQL thread id 1022042, query id 28568966 10.1.0.200 Opening tables SELECT * FROM countrys WHERE name='anthony gordon' OR code='anthony_gordon' ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1222109504 MySQL thread id 1022037, query id 28568938 10.1.0.200 Opening tables SELECT COUNT(first_name) AS cnt FROM profiles AS p force index (first_last_middle_links_sex_age_id) WHERE first_name=4181 AND last_name=451499 and p.links >= 0 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1221310784 MySQL thread id 1022036, query id 28568926 10.1.0.200 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1219447104 MySQL thread id 1022032, query id 28568908 10.1.0.201 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1216784704 MySQL thread id 1022026, query id 28568883 10.1.0.202 Opening tables SELECT COUNT(first_name) AS cnt FROM profiles AS p force index (first_last_middle_links_sex_age_id) WHERE first_name=29786 AND last_name=515183 and p.links >= 0 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1215985984 MySQL thread id 1022022, query id 28568849 10.1.0.202 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1215453504 MySQL thread id 1022021, query id 28568865 10.1.0.200 Opening tables select id from first_names2 where name = binary lower('Susan') ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1214388544 MySQL thread id 1022018, query id 28568833 10.1.0.201 Opening tables SELECT COUNT(first_name) AS cnt FROM profiles AS p force index (first_last_middle_links_sex_age_id) WHERE first_name=43366 AND last_name=541919 and p.links >= 0 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1213856064 MySQL thread id 1022015, query id 28568809 10.1.0.201 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1213589824 MySQL thread id 1022010, query id 28568795 10.1.0.202 Opening tables SELECT id FROM last_names2 WHERE name = BINARY LOWER('Nlsn') ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1212524864 MySQL thread id 1022004, query id 28568749 10.1.0.200 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1209862464 MySQL thread id 1022000, query id 28568727 10.1.0.200 Opening tables select id from profiles join profile_thumbs on id = profile_id order by profile_id desc limit 10 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1206933824 MySQL thread id 1021993, query id 28568691 10.1.0.200 Opening tables select id from first_names2 where name = binary lower('JOHN') ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1206667584 MySQL thread id 1021992, query id 28568681 10.1.0.200 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1205336384 MySQL thread id 1021988, query id 28568664 10.1.0.202 Opening tables select p.*, fm.name as first_name, ln.name as last_name, mn.name as middle_name from profiles as p inner join first_names2 as fm on fm.id = p.first_name inner join last_names2 as ln on ln.id = p.last_name left join middle_names2 as mn on mn.id = p.middle_name where p.id = 455634 and p.links >= 0 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1196284224 MySQL thread id 1021974, query id 28568599 10.1.0.200 Opening tables SELECT COUNT(first_name) AS cnt FROM profiles AS p force index (first_last_middle_links_sex_age_id) WHERE first_name=29786 AND last_name=515183 and p.links >= 0 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1195485504 MySQL thread id 1021973, query id 28568574 10.1.0.200 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1194420544 MySQL thread id 1021969, query id 28568557 10.1.0.201 Opening tables SELECT * FROM countrys WHERE name='white, dorian,' OR code='white,_dorian,' ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1191225664 MySQL thread id 1021962, query id 28568519 10.1.0.200 Opening tables SELECT * FROM countrys WHERE name='register' OR code='register' ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1186699584 MySQL thread id 1021961, query id 28568514 10.1.0.200 Opening tables Select co.name as country, c.id as city_id, c.name as city, r.name as region, r.id as region_id from citys as c inner join regions as r on r.id = c.region_id inner join countrys as co on co.id = r.country_id where c.name = 'East Providence' and (r.name like 'RI%' or r.region_code like 'RI%') and r.country_id = 222 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1188030784 MySQL thread id 1021951, query id 28568457 10.1.0.200 Opening tables SELECT id FROM first_names2 WHERE name = BINARY LOWER('jeff') ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1186433344 MySQL thread id 1021940, query id 28568398 10.1.0.202 Opening tables select id from first_names2 where name = binary lower('Sheila') ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1218648384 MySQL thread id 1021928, query id 28568323 10.1.0.200 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1185900864 MySQL thread id 1021919, query id 28568297 10.1.0.202 Opening tables select name from citys where id =1934199 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1202407744 MySQL thread id 1021905, query id 28568198 10.1.0.202 Opening tables select id from regions where name = 'school' and country_id = '' ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1207466304 MySQL thread id 1021898, query id 28568166 10.1.0.202 Opening tables select id from last_names2 where name = binary lower('Femia') ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1228233024 MySQL thread id 1021894, query id 28568133 10.1.0.201 Opening tables select p.*, fm.name as first_name, ln.name as last_name, mn.name as middle_name from profiles as p inner join first_names2 as fm on fm.id = p.first_name inner join last_names2 as ln on ln.id = p.last_name left join middle_names2 as mn on mn.id = p.middle_name where p.id = 1029979 and p.links >= 0 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1200277824 MySQL thread id 1021892, query id 28568116 10.1.0.201 Opening tables SELECT profile_id from search_country_222 as sloc where sloc.first_name=53500 AND sloc.last_name=331423 limit 1 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1254058304 MySQL thread id 1021887, query id 28568091 10.1.0.201 Opening tables SELECT id FROM usernames WHERE name="loverofhearts" ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1243674944 MySQL thread id 1021881, query id 28568064 10.1.0.202 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1231427904 MySQL thread id 1021877, query id 28568050 10.1.0.202 Opening tables select id from last_names2 where name = binary lower('Hillman') ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1236752704 MySQL thread id 1021874, query id 28568019 10.1.0.202 Opening tables SELECT id FROM first_names2 WHERE name = BINARY LOWER('juan carlos') ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1234090304 MySQL thread id 1021870, query id 28568011 10.1.0.202 Opening tables SELECT * FROM countrys WHERE name='Emma Emeka' OR code='Emma_Emeka' ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1235687744 MySQL thread id 1021868, query id 28567984 10.1.0.202 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1251928384 MySQL thread id 1021856, query id 28567918 10.1.0.202 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1086835008 MySQL thread id 1021855, query id 28567932 10.1.0.202 Opening tables SELECT profile_id FROM search_city_3832 AS p WHERE p.first_name=55784 AND p.last_name=117302 and (( age >= 22 and age <= 27) or (age is null or age = 0)) and sex = 'm' and links > -1 /* /var/www/LIVE0A0A/search.class.php 1752 75.77.23.162 build_query */ ORDER BY links DESC LIMIT 0,1000 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1238083904 MySQL thread id 1021850, query id 28567891 10.1.0.200 Opening tables SELECT id FROM last_names2 WHERE name = BINARY LOWER('Nvjv') ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1192290624 MySQL thread id 1021835, query id 28567814 10.1.0.202 Opening tables SELECT COUNT(first_name) AS cnt FROM profiles AS p force index (first_last_middle_links_sex_age_id) WHERE first_name=31495 AND last_name=102705 and p.links >= 0 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1222641984 MySQL thread id 1021833, query id 28567808 10.1.0.200 Opening tables SELECT profile_id from search_country_222 as sloc where sloc.first_name=813981 limit 1 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1194154304 MySQL thread id 1021813, query id 28567680 10.1.0.200 Opening tables select p.*, fm.name as first_name, ln.name as last_name, mn.name as middle_name from profiles as p inner join first_names2 as fm on fm.id = p.first_name inner join last_names2 as ln on ln.id = p.last_name left join middle_names2 as mn on mn.id = p.middle_name where p.id = 51947694 and p.links >= 0 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1182439744 MySQL thread id 1021812, query id 28567694 10.1.0.200 Opening tables select p.*, fm.name as first_name, ln.name as last_name, mn.name as middle_name from profiles as p inner join first_names2 as fm on fm.id = p.first_name inner join last_names2 as ln on ln.id = p.last_name left join middle_names2 as mn on mn.id = p.middle_name where p.id = 150305660 and p.links >= 0 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1213323584 MySQL thread id 1021811, query id 28567688 10.1.0.201 Opening tables select p.*, fm.name as first_name, ln.name as last_name, mn.name as middle_name from profiles as p inner join first_names2 as fm on fm.id = p.first_name inner join last_names2 as ln on ln.id = p.last_name left join middle_names2 as mn on mn.id = p.middle_name where p.id = 53713686 and p.links >= 0 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1185634624 MySQL thread id 1021810, query id 28567638 10.1.0.201 Opening tables Select co.name as country, c.id as city_id, c.name as city, r.name as region, r.id as region_id from citys as c inner join regions as r on r.id = c.region_id inner join countrys as co on co.id = r.country_id where c.name like 'ultar pr%' and r.country_id = 98 order by c.name ASC limit 5 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1237018944 MySQL thread id 1021800, query id 28567582 10.1.0.202 Opening tables SELECT profile_id FROM search_country_222 AS p JOIN username_profiles2 AS up USING(profile_id) WHERE up.username_id=13108073 /*/var/www/LIVE0A0A/search.class.php 1750 198.45.18.48 build_query*/ ORDER BY links DESC LIMIT 0,20 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1192024384 MySQL thread id 1021796, query id 28567554 10.1.0.202 Opening tables select id from last_names2 where name = binary lower('WINTERS') ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1210927424 MySQL thread id 1021793, query id 28567542 10.1.0.200 Opening tables SELECT id, results FROM employers WHERE (name LIKE "Equitable Recovery Systems Inc %" || name = "Equitable Recovery Systems Inc") order by results desc limit 50 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1097500992 MySQL thread id 1021792, query id 28567538 10.1.0.201 Opening tables SELECT first_name_else from multifname where first_name = 12536 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1211992384 MySQL thread id 1021788, query id 28567522 10.1.0.202 Opening tables select p.*, fm.name as first_name, ln.name as last_name, mn.name as middle_name from profiles as p inner join first_names2 as fm on fm.id = p.first_name inner join last_names2 as ln on ln.id = p.last_name left join middle_names2 as mn on mn.id = p.middle_name where p.id = 104540061 and p.links >= 0 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1092200768 MySQL thread id 1021779, query id 28567463 10.1.0.202 Opening tables SELECT id FROM usernames WHERE name="vicwillzx" ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1196816704 MySQL thread id 1021778, query id 28567461 10.1.0.201 Opening tables select p.*, fm.name as first_name, ln.name as last_name, mn.name as middle_name from profiles as p inner join first_names2 as fm on fm.id = p.first_name inner join last_names2 as ln on ln.id = p.last_name left join middle_names2 as mn on mn.id = p.middle_name where p.id = 157142039 and p.links >= 0 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1096706368 MySQL thread id 1021772, query id 28567426 10.1.0.202 Opening tables select id from last_names2 where name = binary lower('Lewis') ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1202673984 MySQL thread id 1021765, query id 28567379 10.1.0.200 Opening tables SELECT c.id,c.name from countrys as c force index (id_name) WHERE id in (SELECT DISTINCT country_id from search_country as sloc where sloc.first_name=51321 AND sloc.last_name=502388 && sloc.country_id < 236) ORDER BY c.name ASC /*/var/www/LIVE0A0A/search.class.php 828 66.169.249.0 query_toolbar*/ ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1234889024 MySQL thread id 1021761, query id 28567360 10.1.0.200 Opening tables SELECT id FROM usernames WHERE name="jrbeezy" ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1204271424 MySQL thread id 1021760, query id 28567358 10.1.0.201 Opening tables select p.*, fm.name as first_name, ln.name as last_name, mn.name as middle_name from profiles as p inner join first_names2 as fm on fm.id = p.first_name inner join last_names2 as ln on ln.id = p.last_name left join middle_names2 as mn on mn.id = p.middle_name where p.id = 33291716 and p.links >= 0 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1218914624 MySQL thread id 1021755, query id 28567331 10.1.0.200 Opening tables select p.*, fm.name as first_name, ln.name as last_name, mn.name as middle_name from profiles as p inner join first_names2 as fm on fm.id = p.first_name inner join last_names2 as ln on ln.id = p.last_name left join middle_names2 as mn on mn.id = p.middle_name where p.id = 166407074 and p.links >= 0 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1203738944 MySQL thread id 1021753, query id 28567318 10.1.0.202 Opening tables SELECT COUNT(first_name) AS cnt FROM profiles AS p force index (first_last_middle_links_sex_age_id) WHERE first_name=31495 AND last_name=102705 and p.links >= 0 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1087486272 MySQL thread id 1021742, query id 28567251 10.1.0.201 Opening tables select id from citys where name = 'Southern Specialties' and region_id = '' ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1214122304 MySQL thread id 1021740, query id 28567205 10.1.0.201 Opening tables select p.*, fm.name as first_name, ln.name as last_name, mn.name as middle_name from profiles as p inner join first_names2 as fm on fm.id = p.first_name inner join last_names2 as ln on ln.id = p.last_name left join middle_names2 as mn on mn.id = p.middle_name where p.id = 166406694 and p.links >= 0 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1248467264 MySQL thread id 1021739, query id 28567197 10.1.0.202 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1198946624 MySQL thread id 1021730, query id 28567176 10.1.0.200 Opening tables select p.*, fm.name as first_name, ln.name as last_name, mn.name as middle_name from profiles as p inner join first_names2 as fm on fm.id = p.first_name inner join last_names2 as ln on ln.id = p.last_name left join middle_names2 as mn on mn.id = p.middle_name where p.id = 52308707 and p.links >= 0 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1245006144 MySQL thread id 1021729, query id 28567163 10.1.0.200 Opening tables SELECT id, results FROM schools WHERE (name LIKE "Miami University %" || name = "Miami University" ) order by results desc limit 50 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1255389504 MySQL thread id 1021721, query id 28567107 10.1.0.202 Opening tables select id from first_names2 where name = binary lower('LESTER') ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1233824064 MySQL thread id 1021717, query id 28567076 10.1.0.202 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1230096704 MySQL thread id 1021713, query id 28567060 10.1.0.202 Opening tables select id from first_names2 where name = binary lower('IOLE') ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1221843264 MySQL thread id 1021711, query id 28567059 10.1.0.202 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1231960384 MySQL thread id 1021707, query id 28567027 10.1.0.200 Opening tables SELECT p.id as profile_id FROM profiles AS p force index (first_last_middle_links_sex_age_id) WHERE first_name=9820 AND last_name=292946 and p.links >= 0 /* /var/www/LIVE0A0A/search.class.php 1658 208.49.196.146 build_query */ ORDER BY links DESC LIMIT 0,1000 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1242077504 MySQL thread id 1021705, query id 28567037 10.1.0.202 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1193355584 MySQL thread id 1021704, query id 28567047 10.1.0.202 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1219979584 MySQL thread id 1021695, query id 28566961 10.1.0.201 Opening tables SELECT profile_id from search_country_222 as sloc where sloc.first_name=45855 AND sloc.last_name=327821 limit 1 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1207732544 MySQL thread id 1021682, query id 28566882 10.1.0.202 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1241012544 MySQL thread id 1021676, query id 28566860 10.1.0.200 Opening tables select p.*, fm.name as first_name, ln.name as last_name, mn.name as middle_name from profiles as p inner join first_names2 as fm on fm.id = p.first_name inner join last_names2 as ln on ln.id = p.last_name left join middle_names2 as mn on mn.id = p.middle_name where p.id = 158643824 and p.links >= 0 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1203206464 MySQL thread id 1021677, query id 28566864 10.1.0.202 Opening tables SELECT * FROM countrys WHERE name='Lee Perfect' OR code='Lee_Perfect' ---TRANSACTION 1 4021546067, not started, process no 20665, OS thread id 1204537664 MySQL thread id 1021666, query id 28566820 10.1.0.201 p_php closing tables select p.id as id, age, sex from profiles as p inner join search_city_3870 as pl on pl.profile_id = p.id where pl.city_id = 2012226 and p.first_name = 3467 and p.last_name = 451499 and pl.first_name = 3467 and pl.last_name = 451499 ---TRANSACTION 1 4021546058, not started, process no 20665, OS thread id 1189894464 MySQL thread id 1021671, query id 28566826 10.1.0.200 p_php Opening tables select p.id from profiles as p inner join profile_locations as pl force index (profile_country_region_city) on pl.profile_id = p.id where p.first_name = 40425 and p.last_name =541919 and pl.city_id in (1910928,1910187,1910765,1910333,1910024,1909569,1911020,1909753,1909570,1911017,1910487,1910049,1909474,1909473,1909652,1910448,1909997,1909871,1910618,1910901,1910079,1910973,1910496,1909820,1910093,1910708,1909970,1909513,1909730,1910576,1910951,1910069) and pl.region_id in (3839, 1910928) and pl.country_id = 222 ---TRANSACTION 1 4021546053, not started, process no 20665, OS thread id 1211459904 MySQL thread id 1021672, query id 28566827 10.1.0.201 Opening tables select max(id) from profiles ---TRANSACTION 1 4021546068, not started, process no 20665, OS thread id 1183770944 MySQL thread id 1021668, query id 28566811 10.1.0.202 closing tables SELECT COUNT(first_name) AS cnt FROM profiles AS p force index (first_last_middle_links_sex_age_id) WHERE first_name=40233 AND last_name=160920 and p.links >= 0 ---TRANSACTION 1 4021546054, not started, process no 20665, OS thread id 1240213824 MySQL thread id 1021665, query id 28566812 10.1.0.200 ---TRANSACTION 1 4021546055, not started, process no 20665, OS thread id 1217583424 MySQL thread id 1021664, query id 28566813 10.1.0.201 ---TRANSACTION 1 4021545868, not started, process no 20665, OS thread id 1243408704 MySQL thread id 1021660, query id 28566428 10.1.0.201 p_php closing tables select p.id as id, age, sex from profiles as p inner join search_city_3870 as pl on pl.profile_id = p.id where pl.city_id = 2012226 and p.first_name = 3467 and p.last_name = 770843 and pl.first_name = 3467 and pl.last_name = 770843 ---TRANSACTION 1 4021545946, not started, process no 20665, OS thread id 1249265984 MySQL thread id 1021662, query id 28566742 10.1.0.200 _all ---TRANSACTION 1 4021545949, not started, process no 20665, OS thread id 1185102144 MySQL thread id 1021644, query id 28566563 10.1.0.202 p_php ---TRANSACTION 1 4021546062, not started, process no 20665, OS thread id 1243142464 MySQL thread id 1021649, query id 28566805 10.1.0.200 closing tables select p.*, fm.name as first_name, ln.name as last_name, mn.name as middle_name from profiles as p inner join first_names2 as fm on fm.id = p.first_name inner join last_names2 as ln on ln.id = p.last_name left join middle_names2 as mn on mn.id = p.middle_name where p.id = 32577519 and p.links >= 0 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1189095744 MySQL thread id 1021647, query id 28565903 10.1.0.201 ---TRANSACTION 1 4021545841, not started, process no 20665, OS thread id 1242343744 MySQL thread id 1021646, query id 28566328 10.1.0.202 _all ---TRANSACTION 1 4021546044, not started, process no 20665, OS thread id 1219713344 MySQL thread id 1021634, query id 28566768 10.1.0.200 freeing items select t.name as name, status from tags as t inner join profile_global_tags on profile_global_tags.global_tag_id = t.id where profile_global_tags.profile_id = 136536650 and global_tag_type='tag' ---TRANSACTION 1 4021546064, not started, process no 20665, OS thread id 1199212864 MySQL thread id 1021635, query id 28566810 10.1.0.201 closing tables select thumbnail from profile_thumbs where profile_id = 20216216 ---TRANSACTION 1 4021545569, not started, process no 20665, OS thread id 1241545024 MySQL thread id 1021631, query id 28565794 10.1.0.202 p_php ---TRANSACTION 1 4021546041, not started, process no 20665, OS thread id 1233025344 MySQL thread id 1021627, query id 28566734 10.1.0.202 freeing items select t.name as name from schools as t inner join profile_global_tags on profile_global_tags.global_tag_id = t.id where status <> 0 and profile_global_tags.profile_id = 131834648 and global_tag_type='school' ---TRANSACTION 1 4021546065, not started, process no 20665, OS thread id 1240480064 MySQL thread id 1021619, query id 28566814 10.1.0.200 p_php closing tables select p.id from profiles as p inner join profile_locations as pl force index (profile_country_region_city) on pl.profile_id = p.id where p.first_name = 40425 and p.last_name =541919 and pl.city_id in (1910928,1910187,1910765,1910333,1910024,1909569,1911020,1909753,1909570,1911017,1910487,1910049,1909474,1909473,1909652,1910448,1909997,1909871,1910618,1910901,1910079,1910973,1910496,1909820,1910093,1910708,1909970,1909513,1909730,1910576,1910951,1910069) and pl.region_id in (3839, 1910928) and pl.country_id = 222 ---TRANSACTION 1 4021545797, not started, process no 20665, OS thread id 1252194624 MySQL thread id 1021615, query id 28566281 10.1.0.200 p_php ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1253259584 MySQL thread id 1021621, query id 28567054 10.1.0.200 Opening tables Select cry.id as country_id, cry.name as country_name, r.id as region_id, r.name as region_name, r.region_code as region_abbrev,c.id as city_id, c.name as city_name from regions as r inner join citys as c on r.id = c.region_id join countrys as cry on r.country_id = cry.id where (r.region_code = '' or r.name='') AND c.name = '' ---TRANSACTION 1 4021545334, not started, process no 20665, OS thread id 1193621824 MySQL thread id 1021599, query id 28565149 10.1.0.200 p_php closing tables select p.id from profiles as p inner join profile_locations as pl force index (profile_country_region_city) on pl.profile_id = p.id where p.first_name = 29786 and p.last_name =515183 and pl.city_id in (1993363,1996538,1994529,1993820,1996549,1996055,1994025,1994469,1997511,1994655,1994033,1998063,1994656,1998557,1996247,1994798,1996359) and pl.region_id in (3866, 1993363) and pl.country_id = 222 ---TRANSACTION 1 4021546018, not started, process no 20665, OS thread id 1187232064 MySQL thread id 1021612, query id 28566762 10.1.0.200 closing tables Select profile_id_who, profile_id_whom from profile_track where profile_id_whom = 128640031 ---TRANSACTION 1 4021545453, not started, process no 20665, OS thread id 1186965824 MySQL thread id 1021611, query id 28565526 10.1.0.201 _all ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1207200064 MySQL thread id 1021608, query id 28566847 10.1.0.200 Opening tables Select profile_id_who, profile_id_whom from profile_track where profile_id_whom = 62972363 ---TRANSACTION 1 4021545457, not started, process no 20665, OS thread id 1090042176 MySQL thread id 1021607, query id 28565505 10.1.0.202 _all ---TRANSACTION 1 4021545243, not started, process no 20665, OS thread id 1190959424 MySQL thread id 1021601, query id 28564852 10.1.0.200 p_php ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1098033472 MySQL thread id 1021596, query id 28564344 10.1.0.200 ---TRANSACTION 1 4021546028, not started, process no 20665, OS thread id 1220512064 MySQL thread id 1021587, query id 28566680 10.1.0.201 freeing items select id, profile_id, city_id, region_id, country_id, city, region, country from profile_locations where profile_id = 2853419 order by is_primary desc ---TRANSACTION 1 4021545955, not started, process no 20665, OS thread id 1238616384 MySQL thread id 1021586, query id 28566645 10.1.0.200 ---TRANSACTION 1 4021546038, not started, process no 20665, OS thread id 1228765504 MySQL thread id 1021584, query id 28566748 10.1.0.200 closing tables select t.name as name, status from tags as t inner join profile_global_tags on profile_global_tags.global_tag_id = t.id where profile_global_tags.profile_id = 82628736 and global_tag_type='tag' ---TRANSACTION 1 4021545198, not started, process no 20665, OS thread id 1223440704 MySQL thread id 1021577, query id 28566868 10.1.0.200 Opening tables select * from profiles where id = 59725794 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1250064704 MySQL thread id 1021571, query id 28563939 10.1.0.200 ---TRANSACTION 1 4021544860, not started, process no 20665, OS thread id 1209329984 MySQL thread id 1021564, query id 28566907 10.1.0.202 p_php Opening tables select pl.id from profile_locations as pl inner join regions as r on r.id = pl.region_id where profile_id = 166407106 and pl.city = "Great Lakes" and (r.name = "Illinois" or r.region_code= "Illinois") ---TRANSACTION 1 4021545384, not started, process no 20665, OS thread id 1220245824 MySQL thread id 1021550, query id 28565295 10.1.0.202 ---TRANSACTION 1 4021546061, not started, process no 20665, OS thread id 1216252224 MySQL thread id 1021548, query id 28566808 10.1.0.200 closing tables select thumbnail from profile_thumbs where profile_id = 28037340 ---TRANSACTION 1 4021546023, not started, process no 20665, OS thread id 1248201024 MySQL thread id 1021545, query id 28566695 10.1.0.201 closing tables select id, profile_id, city_id, region_id, country_id, city, region, country from profile_locations where profile_id = 3006929 order by is_primary desc ---TRANSACTION 1 4021546060, not started, process no 20665, OS thread id 1198680384 MySQL thread id 1021544, query id 28566763 10.1.0.201 freeing items select id, profile_id, city_id, region_id, country_id, city, region, country from profile_locations where profile_id = 128361371 order by is_primary desc ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1182972224 MySQL thread id 1021531, query id 28562788 10.1.0.202 ---TRANSACTION 1 4021544374, not started, process no 20665, OS thread id 1194686784 MySQL thread id 1021497, query id 28562510 10.1.0.202 p_php ---TRANSACTION 1 4021546037, not started, process no 20665, OS thread id 1210128704 MySQL thread id 1021508, query id 28566767 10.1.0.201 freeing items select p.*, fm.name as first_name, ln.name as last_name, mn.name as middle_name from profiles as p inner join first_names2 as fm on fm.id = p.first_name inner join last_names2 as ln on ln.id = p.last_name left join middle_names2 as mn on mn.id = p.middle_name where p.id = 15075106 and p.links >= 0 ---TRANSACTION 1 4021546059, not started, process no 20665, OS thread id 1206135104 MySQL thread id 1021506, query id 28566819 10.1.0.200 closing tables select id, profile_id, city_id, region_id, country_id, city, region, country from profile_locations where profile_id = 608724 order by is_primary desc ---TRANSACTION 1 4021545135, not started, process no 20665, OS thread id 1196017984 MySQL thread id 1021493, query id 28566935 10.1.0.201 p_php Opening tables select pl.id from profile_locations as pl inner join regions as r on r.id = pl.region_id where profile_id = 166407108 and pl.city = "Winter Park" and (r.name = "Florida" or r.region_code= "Florida") ---TRANSACTION 1 4021545406, not started, process no 20665, OS thread id 1184037184 MySQL thread id 1021491, query id 28565317 10.1.0.201 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1206401344 MySQL thread id 1021484, query id 28561588 10.1.0.201 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1215187264 MySQL thread id 1021479, query id 28561437 10.1.0.202 ---TRANSACTION 1 4021546043, not started, process no 20665, OS thread id 1097767232 MySQL thread id 1021449, query id 28566755 10.1.0.202 freeing items select t.name as name, status from tags as t inner join profile_global_tags on profile_global_tags.global_tag_id = t.id where profile_global_tags.profile_id = 39567542 and global_tag_type='tag' ---TRANSACTION 1 4021543605, not started, process no 20665, OS thread id 1184835904 MySQL thread id 1021401, query id 28560320 10.1.0.201 p_php ---TRANSACTION 1 4021546033, not started, process no 20665, OS thread id 1201342784 MySQL thread id 1021398, query id 28566758 10.1.0.201 freeing items select * from profiles where id = 106663837 ---TRANSACTION 1 4021546042, not started, process no 20665, OS thread id 1187764544 MySQL thread id 1021322, query id 28566752 10.1.0.202 freeing items select id, profile_id, city_id, region_id, country_id, city, region, country from profile_locations where profile_id = 779 order by is_primary desc ---TRANSACTION 1 4021546050, not started, process no 20665, OS thread id 1087818048 MySQL thread id 1021276, query id 28566821 10.1.0.201 closing tables select id, phone, type from profile_phones where status > 0 and profile_id = 125371628 group by phone ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1190426944 MySQL thread id 1021209, query id 28555027 10.1.0.202 ---TRANSACTION 1 4021545460, not started, process no 20665, OS thread id 1210394944 MySQL thread id 1021002, query id 28566938 10.1.0.202 _all Opening tables INSERT INTO changes_links_add (actor_id, profile_id, object_id,description) VALUES (1, 166407107, 155658390,'http://www.peoplefinders.com/summary.asp?input=name&fn=Lisa&ln=Lafrance&state=MA&utm_source=pq&utm_medium=results&utm_campaign=tzr:6') ---TRANSACTION 1 4021545508, not started, process no 20665, OS thread id 1089775936 MySQL thread id 1020867, query id 28565621 10.1.0.202 p_php ---TRANSACTION 1 4021545379, not started, process no 20665, OS thread id 1205868864 MySQL thread id 1020861, query id 28566936 10.1.0.202 ---TRANSACTION 1 4021545978, not started, process no 20665, OS thread id 1205602624 MySQL thread id 1020615, query id 28575040 10.1.0.202 _all User lock SELECT COALESCE(GET_LOCK('lock_insert_locations', 5), 0) ---TRANSACTION 1 4021545939, not started, process no 20665, OS thread id 1190160704 MySQL thread id 1020576, query id 28566527 10.1.0.202 p_php ---TRANSACTION 1 4021538352, not started, process no 20665, OS thread id 1095051584 MySQL thread id 1020324, query id 28546680 10.1.0.201 p_php ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1080584512 MySQL thread id 1020255, query id 28532385 10.1.0.202 ---TRANSACTION 1 4021532284, not started, process no 20665, OS thread id 1214921024 MySQL thread id 1020150, query id 28530729 10.1.0.202 closing tables SELECT profile_id FROM search_city AS p WHERE region_id=14 and links > -1 /* /var/www/LIVE0A0A/search.class.php 1752 142.12.33.5 build_query */ ORDER BY links DESC LIMIT 0,20 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1231694144 MySQL thread id 1020046, query id 28528131 10.1.0.202 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1239415104 MySQL thread id 1019674, query id 28518606 10.1.0.202 ---TRANSACTION 1 4021545303, not started, process no 20665, OS thread id 1201076544 MySQL thread id 1019547, query id 28564986 10.1.0.202 _all ---TRANSACTION 1 4021545510, not started, process no 20665, OS thread id 1233557824 MySQL thread id 1019515, query id 28566845 10.1.0.202 p_php Opening tables select p.id from profiles as p inner join profile_locations as pl force index (profile_country_region_city) on pl.profile_id = p.id left join middle_names2 as mn force index (id_name) on mn.id = p.middle_name where p.first_name = 28070 and (mn.name = 'E' or mn.name = 'E' or SUBSTR(mn.name, 0, 1) = 'E' or mn.name is null) and p.last_name =100477 and pl.city_id in (1897615,1897616,1893764,1895704,1895460,1897453,1893204,1893349,1892373,1895143,1892989,1986099,1897678,1893584,1895209,1983435,1897591,1898052,1894766,1985280,1892694,1986007,1986091,1893219,1892221,1985513,1894172,1896820,1892963,1 ---TRANSACTION 1 4021545999, not started, process no 20665, OS thread id 1237551424 MySQL thread id 1019231, query id 28566696 10.1.0.202 _all ---TRANSACTION 1 4021545073, not started, process no 20665, OS thread id 1223706944 MySQL thread id 1019166, query id 28564257 10.1.0.202 p_php ---TRANSACTION 1 4021546063, not started, process no 20665, OS thread id 1229031744 MySQL thread id 1019164, query id 28566806 10.1.0.202 closing tables select id, age, sex from profiles as pp join (select p.id from profiles as p force index (first_last_middle_links_sex_age_id) inner join profile_locations as pl force index (country_region_city_profile) on pl.profile_id = p.id where p.first_name = 58635 and p.last_name = 244285 and pl.country_id = 222 and pl.region_id = 3858 and pl.city_id = 1964450 and (middle_name = '' or middle_name != '') and (links = 0 or links !=0) and (age != 0 or age = 0) ) as x using(id) ---TRANSACTION 1 4021544452, not started, process no 20665, OS thread id 1091934528 MySQL thread id 1019034, query id 28566823 10.1.0.202 p_php Opening tables select p.id as id, age, sex from profiles as p inner join search_city_3858 as pl on pl.profile_id = p.id where pl.city_id = 1967970 and p.first_name = 58635 and p.last_name = 244285 and pl.first_name = 58635 and pl.last_name = 244285 ---TRANSACTION 1 4021543010, not started, process no 20665, OS thread id 1195751744 MySQL thread id 1018256, query id 28558747 10.1.0.202 _all ---TRANSACTION 1 4021545090, not started, process no 20665, OS thread id 1221577024 MySQL thread id 1018226, query id 28566829 10.1.0.202 p_php Opening tables select profile_id from profile_peoplefinders where peoplefinders_id = 1234923283 ---TRANSACTION 1 4021546066, not started, process no 20665, OS thread id 1236486464 MySQL thread id 1018055, query id 28566800 10.1.0.202 p_php closing tables select p.id as id, age, sex from profiles as p inner join search_city_3858 as pl on pl.profile_id = p.id where pl.city_id = 1964339 and p.first_name = 58635 and p.last_name = 244285 and pl.first_name = 58635 and pl.last_name = 244285 ---TRANSACTION 1 4021509380, not started, process no 20665, OS thread id 1184569664 MySQL thread id 1017922, query id 28471048 10.1.0.202 _all ---TRANSACTION 1 4021545056, not started, process no 20665, OS thread id 1227168064 MySQL thread id 1017341, query id 28564200 10.1.0.202 p_php ---TRANSACTION 1 4021546006, not started, process no 20665, OS thread id 1230629184 MySQL thread id 1017326, query id 28566652 10.1.0.202 closing tables select id, age, sex from profiles as pp join (select p.id from profiles as p force index (first_last_middle_links_sex_age_id) inner join profile_locations as pl force index (country_region_city_profile) on pl.profile_id = p.id where p.first_name = 58635 and p.last_name = 244285 and pl.country_id = 222 and pl.region_id = 3858 and pl.city_id = 1965696 and (middle_name = '' or middle_name != '') and (age != 0 or age = 0) and (links = 0 or links !=0)) as x using(id) ---TRANSACTION 1 4021545921, not started, process no 20665, OS thread id 1090308416 MySQL thread id 1017229, query id 28566492 10.1.0.202 _all ---TRANSACTION 1 4021545754, not started, process no 20665, OS thread id 1088350528 MySQL thread id 1017041, query id 28566215 10.1.0.202 p_php ---TRANSACTION 1 4021545800, not started, process no 20665, OS thread id 1207998784 MySQL thread id 1017035, query id 28566559 10.1.0.202 freeing items Select profile_id_who, profile_id_whom from profile_track where profile_id_whom = 166407073 ---TRANSACTION 1 4021545054, not started, process no 20665, OS thread id 1225570624 MySQL thread id 1016595, query id 28564208 10.1.0.202 p_php ---TRANSACTION 1 4021545954, not started, process no 20665, OS thread id 1088084288 MySQL thread id 1016591, query id 28566581 10.1.0.202 closing tables select id, age, sex from profiles as pp join (select p.id from profiles as p force index (first_last_middle_links_sex_age_id) inner join profile_locations as pl force index (country_region_city_profile) on pl.profile_id = p.id where p.first_name = 58635 and p.last_name = 244285 and pl.country_id = 222 and pl.region_id = 3858 and pl.city_id = 1965696 and (middle_name = '' or middle_name != '') and (age != 0 or age = 0) and (links = 0 or links !=0)) as x using(id) ---TRANSACTION 1 4021545078, not started, process no 20665, OS thread id 1232226624 MySQL thread id 1015375, query id 28564267 10.1.0.202 p_php ---TRANSACTION 1 4021545897, not started, process no 20665, OS thread id 1192823104 MySQL thread id 1015370, query id 28566539 10.1.0.202 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1252460864 MySQL thread id 1014976, query id 28381657 10.1.0.202 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1222375744 MySQL thread id 1014495, query id 28369438 10.1.0.202 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1193089344 MySQL thread id 981305, query id 27562174 10.1.0.200 ---TRANSACTION 0 0, not started, process no 20665, OS thread id 1199745344 MySQL thread id 477406, query id 14240127 10.1.0.201 _all ---TRANSACTION 1 4021546051, ACTIVE 115 sec, process no 20665, OS thread id 1217050944, thread declared inside InnoDB 500 mysql tables in use 10, locked 10 2 lock struct(s), heap size 368, 0 row lock(s), undo log entries 1 MySQL thread id 1021670, query id 28566801 10.1.0.202 _all end UPDATE profilesInCountry as s SET s.counter=s.counter+1 where s.country_id = NEW.country_id ---TRANSACTION 1 4021546047, ACTIVE 115 sec, process no 20665, OS thread id 1200544064, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 1 lock struct(s), heap size 368, 0 row lock(s), undo log entries 1 MySQL thread id 1021614, query id 28566774 10.1.0.200 _all update INSERT INTO changes_links_add (actor_id, profile_id, object_id,description) VALUES (1, 7728693, 155658389,'http://www.active.com/rankings/index.cfm?active=do.eventdetails2&event_id=1513238&distid=13:6') ---TRANSACTION 1 4021546039, ACTIVE 115 sec, process no 20665, OS thread id 1213057344, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 1 lock struct(s), heap size 368, 0 row lock(s), undo log entries 1 MySQL thread id 1015461, query id 28566749 10.1.0.202 _all update INSERT INTO search_city_3870 set profile_id = 166407109 , city_id = 2010559,first_name = 40233,last_name = 212040,links = 0 ---TRANSACTION 1 4021546010, ACTIVE 115 sec, process no 20665, OS thread id 1249798464, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 1 lock struct(s), heap size 368, 0 row lock(s), undo log entries 1 MySQL thread id 1020522, query id 28566713 10.1.0.201 _all update INSERT INTO tag_country2 (global_tag_id,global_tag_type,country_id) VALUES (1310872,'tag',37) -------- 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: waiting for i/o request (write thread) Pending normal aio reads: 0, aio writes: 0, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 3679755 OS file reads, 613451 OS file writes, 142761 OS fsyncs 57.44 reads/s, 17781 avg bytes/read, 280.77 writes/s, 66.20 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 2887, free list len 333139, seg size 336027, 772078 inserts, 317103 merged recs, 133322 merges Hash table size 20751823, node heap has 4233 buffer(s) 0.00 hash searches/s, 327.09 non-hash searches/s --- LOG --- Log sequence number 804 3800364216 Log flushed up to 804 3800357006 Last checkpoint at 804 3699205753 0 pending log writes, 0 pending chkp writes 21631 log i/o's done, 6.16 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 11588885704; in additional pool allocated 28866816 Dictionary memory allocated 1924720 Buffer pool size 640000 Free buffers 0 Database pages 635767 Modified db pages 76169 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages read 3856046, created 11805, written 612780 62.34 reads/s, 0.00 creates/s, 308.73 writes/s Buffer pool hit rate 969 / 1000 -------------- ROW OPERATIONS -------------- 4 queries inside InnoDB, 0 queries in queue 1 read views open inside InnoDB Main thread process no. 20665, id 1182173504, state: doing insert buffer merge Number of rows inserted 769692, updated 173341, deleted 3844, read 276238175 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================