*************************** 1. row *************************** Type: InnoDB Name: Status: ===================================== 120316 10:23:27 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 47 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 86 1_second, 85 sleeps, 8 10_second, 1 background, 1 flush srv_master_thread log flush and writes: 88 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 3726, signal count 101 Mutex spin waits 4902, rounds 157650, OS waits 3722 RW-shared spins 3, rounds 90, OS waits 3 RW-excl spins 1, rounds 30, OS waits 1 Spin rounds per wait: 32.16 mutex, 30.00 RW-shared, 30.00 RW-excl ------------ TRANSACTIONS ------------ Trx id counter 1464 Purge done for trx's n:o < 6B2 undo n:o < 0 History list length 60 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0, not started MySQL thread id 104, OS thread handle 0x76, query id 199432 localhost root show engine innodb status ---TRANSACTION 1463, ACTIVE 82 sec MySQL thread id 102, OS thread handle 0x74, query id 199405 10.118.237.202 cmd ---TRANSACTION 1462, ACTIVE 82 sec MySQL thread id 103, OS thread handle 0x75, query id 199427 10.118.237.202 cmd ---TRANSACTION 1461, ACTIVE 82 sec MySQL thread id 101, OS thread handle 0x73, query id 199415 10.118.237.202 cmd ---TRANSACTION 1460, ACTIVE 82 sec MySQL thread id 92, OS thread handle 0x6a, query id 199373 10.118.237.202 cmd ---TRANSACTION 145F, ACTIVE 82 sec mysql tables in use 3, locked 0 MySQL thread id 99, OS thread handle 0x71, query id 198686 10.118.237.202 cmd Sending data select a.campaign_id, offer_for_blackberry, type, duration, vuc_value, vuc_low_value, vuc_qos_change, vuc_notification, vuc_low_notification, redirect_url, active_on_days, active_from_hour, active_to_hour, service_mapping_in, service_mapping_out, rating_mapping, free_daily_quota, language, DATE_FORMAT(activation_date, '%Y-%m-%d %H:%i:%s'), DATE_FORMAT(end_date, '%Y-%m-%d %H:%i:%s'), activation_code, short_code, tabs_service, a.apn apn from user_campaign a, campaign b where msisdn = '9647805146628' and FIND_IN_SET('INTERNET', a.apn) and ---TRANSACTION 145E, ACTIVE 82 sec mysql tables in use 3, locked 0 MySQL thread id 98, OS thread handle 0x70, query id 198693 10.118.237.202 cmd Sending data select a.campaign_id, offer_for_blackberry, type, duration, vuc_value, vuc_low_value, vuc_qos_change, vuc_notification, vuc_low_notification, redirect_url, active_on_days, active_from_hour, active_to_hour, service_mapping_in, service_mapping_out, rating_mapping, free_daily_quota, language, DATE_FORMAT(activation_date, '%Y-%m-%d %H:%i:%s'), DATE_FORMAT(end_date, '%Y-%m-%d %H:%i:%s'), activation_code, short_code, tabs_service, a.apn apn from user_campaign a, campaign b where msisdn = '9647808086189' and FIND_IN_SET('INTERNET', a.apn) and Trx read view will not see trx with id >= 1464, sees < 1400 ---TRANSACTION 145D, ACTIVE 82 sec MySQL thread id 94, OS thread handle 0x6c, query id 199379 10.118.237.202 cmd ---TRANSACTION 145C, ACTIVE 82 sec MySQL thread id 93, OS thread handle 0x6b, query id 198551 10.118.237.202 cmd ---TRANSACTION 145B, ACTIVE 82 sec MySQL thread id 96, OS thread handle 0x6e, query id 199371 10.118.237.202 cmd ---TRANSACTION 145A, ACTIVE 82 sec MySQL thread id 95, OS thread handle 0x6d, query id 199384 10.118.237.202 cmd ---TRANSACTION 1459, ACTIVE 82 sec MySQL thread id 100, OS thread handle 0x72, query id 199383 10.118.237.202 cmd ---TRANSACTION 1458, ACTIVE 82 sec mysql tables in use 3, locked 0 MySQL thread id 97, OS thread handle 0x6f, query id 198687 10.118.237.202 cmd Sending data select a.campaign_id, offer_for_blackberry, type, duration, vuc_value, vuc_low_value, vuc_qos_change, vuc_notification, vuc_low_notification, redirect_url, active_on_days, active_from_hour, active_to_hour, service_mapping_in, service_mapping_out, rating_mapping, free_daily_quota, language, DATE_FORMAT(activation_date, '%Y-%m-%d %H:%i:%s'), DATE_FORMAT(end_date, '%Y-%m-%d %H:%i:%s'), activation_code, short_code, tabs_service, a.apn apn from user_campaign a, campaign b where msisdn = '9647803579844' and FIND_IN_SET('INTERNET', a.apn) and ---TRANSACTION 1457, ACTIVE 82 sec starting index read, thread declared inside InnoDB 497 mysql tables in use 3, locked 0 MySQL thread id 91, OS thread handle 0x69, query id 199300 10.118.237.202 cmd Sending data select a.campaign_id, offer_for_blackberry, type, duration, vuc_value, vuc_low_value, vuc_qos_change, vuc_notification, vuc_low_notification, redirect_url, active_on_days, active_from_hour, active_to_hour, service_mapping_in, service_mapping_out, rating_mapping, free_daily_quota, language, DATE_FORMAT(activation_date, '%Y-%m-%d %H:%i:%s'), DATE_FORMAT(end_date, '%Y-%m-%d %H:%i:%s'), activation_code, short_code, tabs_service, a.apn apn from user_campaign a, campaign b where msisdn = '9647800050333' and FIND_IN_SET('INTERNET', a.apn) and Trx read view will not see trx with id >= 1464, sees < 1400 ---TRANSACTION 1456, ACTIVE 82 sec MySQL thread id 90, OS thread handle 0x68, query id 198617 10.118.237.202 cmd ---TRANSACTION 1455, ACTIVE 83 sec MySQL thread id 89, OS thread handle 0x67, query id 199395 10.118.237.202 cmd ---TRANSACTION 1454, ACTIVE 83 sec MySQL thread id 81, OS thread handle 0x5f, query id 199389 10.118.237.202 cmd ---TRANSACTION 1453, ACTIVE 83 sec MySQL thread id 84, OS thread handle 0x62, query id 199388 10.118.237.202 cmd ---TRANSACTION 1452, ACTIVE 83 sec MySQL thread id 82, OS thread handle 0x60, query id 199409 10.118.237.202 cmd ---TRANSACTION 1451, ACTIVE 83 sec MySQL thread id 80, OS thread handle 0x5e, query id 199374 10.118.237.202 cmd freeing items select a.campaign_id, offer_for_blackberry, type, duration, vuc_value, vuc_low_value, vuc_qos_change, vuc_notification, vuc_low_notification, redirect_url, active_on_days, active_from_hour, active_to_hour, service_mapping_in, service_mapping_out, rating_mapping, free_daily_quota, language, DATE_FORMAT(activation_date, '%Y-%m-%d %H:%i:%s'), DATE_FORMAT(end_date, '%Y-%m-%d %H:%i:%s'), activation_code, short_code, tabs_service, a.apn apn from user_campaign a, campaign b where msisdn = '9647813919954' and FIND_IN_SET('INTERNET', a.apn) and ---TRANSACTION 1450, ACTIVE 83 sec MySQL thread id 86, OS thread handle 0x64, query id 199025 10.118.237.202 cmd checking query cache for query select a.campaign_id, offer_for_blackberry, type, duration, vuc_value, vuc_low_value, vuc_qos_change, vuc_notification, vuc_low_notification, redirect_url, active_on_days, active_from_hour, active_to_hour, service_mapping_in, service_mapping_out, rating_mapping, free_daily_quota, language, DATE_FORMAT(activation_date, '%Y-%m-%d %H:%i:%s'), DATE_FORMAT(end_date, '%Y-%m-%d %H:%i:%s'), activation_code, short_code, tabs_service, a.apn apn from user_campaign a, campaign b where msisdn = '9647801035335' and FIND_IN_SET('INTERNET', a.apn) and ---TRANSACTION 144F, ACTIVE 83 sec MySQL thread id 85, OS thread handle 0x63, query id 199401 10.118.237.202 cmd ---TRANSACTION 144E, ACTIVE 83 sec MySQL thread id 83, OS thread handle 0x61, query id 199380 10.118.237.202 cmd ---TRANSACTION 144D, ACTIVE 83 sec MySQL thread id 88, OS thread handle 0x66, query id 199392 10.118.237.202 cmd ---TRANSACTION 144C, ACTIVE 83 sec MySQL thread id 87, OS thread handle 0x65, query id 199385 10.118.237.202 cmd ---TRANSACTION 144B, ACTIVE 83 sec MySQL thread id 79, OS thread handle 0x5d, query id 199366 10.118.237.202 cmd ---TRANSACTION 144A, ACTIVE 83 sec MySQL thread id 78, OS thread handle 0x5c, query id 199368 10.118.237.202 cmd ---TRANSACTION 1449, ACTIVE 85 sec MySQL thread id 77, OS thread handle 0x5b, query id 198694 10.118.237.202 cmd ---TRANSACTION 1448, ACTIVE 85 sec MySQL thread id 76, OS thread handle 0x5a, query id 199396 10.118.237.202 cmd ---TRANSACTION 1447, ACTIVE 85 sec MySQL thread id 75, OS thread handle 0x59, query id 199428 10.118.237.202 cmd ---TRANSACTION 1446, ACTIVE 85 sec MySQL thread id 74, OS thread handle 0x58, query id 198695 10.118.237.202 cmd ---TRANSACTION 1445, ACTIVE 85 sec MySQL thread id 70, OS thread handle 0x54, query id 199422 10.118.237.202 cmd ---TRANSACTION 1444, ACTIVE 85 sec MySQL thread id 73, OS thread handle 0x57, query id 199393 10.118.237.202 cmd ---TRANSACTION 1443, ACTIVE 85 sec starting index read, thread declared inside InnoDB 500 mysql tables in use 3, locked 0 MySQL thread id 72, OS thread handle 0x56, query id 198852 10.118.237.202 cmd Sending data select a.campaign_id, offer_for_blackberry, type, duration, vuc_value, vuc_low_value, vuc_qos_change, vuc_notification, vuc_low_notification, redirect_url, active_on_days, active_from_hour, active_to_hour, service_mapping_in, service_mapping_out, rating_mapping, free_daily_quota, language, DATE_FORMAT(activation_date, '%Y-%m-%d %H:%i:%s'), DATE_FORMAT(end_date, '%Y-%m-%d %H:%i:%s'), activation_code, short_code, tabs_service, a.apn apn from user_campaign a, campaign b where msisdn = '9647813236180' and FIND_IN_SET('INTERNET', a.apn) and ---TRANSACTION 1442, ACTIVE 85 sec MySQL thread id 71, OS thread handle 0x55, query id 199420 10.118.237.202 cmd ---TRANSACTION 1441, ACTIVE 85 sec MySQL thread id 68, OS thread handle 0x52, query id 199381 10.118.237.202 cmd ---TRANSACTION 1440, ACTIVE 85 sec MySQL thread id 69, OS thread handle 0x53, query id 199369 10.118.237.202 cmd ---TRANSACTION 143F, ACTIVE 85 sec MySQL thread id 67, OS thread handle 0x51, query id 199397 10.118.237.202 cmd ---TRANSACTION 143E, ACTIVE 85 sec MySQL thread id 66, OS thread handle 0x50, query id 199406 10.118.237.202 cmd ---TRANSACTION 143D, ACTIVE 85 sec sleeping before joining InnoDB queue mysql tables in use 3, locked 0 MySQL thread id 54, OS thread handle 0x44, query id 199127 10.118.237.202 cmd Sending data select a.campaign_id, offer_for_blackberry, type, duration, vuc_value, vuc_low_value, vuc_qos_change, vuc_notification, vuc_low_notification, redirect_url, active_on_days, active_from_hour, active_to_hour, service_mapping_in, service_mapping_out, rating_mapping, free_daily_quota, language, DATE_FORMAT(activation_date, '%Y-%m-%d %H:%i:%s'), DATE_FORMAT(end_date, '%Y-%m-%d %H:%i:%s'), activation_code, short_code, tabs_service, a.apn apn from user_campaign a, campaign b where msisdn = '9647816678006' and FIND_IN_SET('INTERNET', a.apn) and ---TRANSACTION 143C, ACTIVE 85 sec MySQL thread id 56, OS thread handle 0x46, query id 199426 10.118.237.202 cmd ---TRANSACTION 143B, ACTIVE 85 sec MySQL thread id 58, OS thread handle 0x48, query id 199376 10.118.237.202 cmd ---TRANSACTION 143A, ACTIVE 85 sec MySQL thread id 57, OS thread handle 0x47, query id 199417 10.118.237.202 cmd ---TRANSACTION 1439, ACTIVE 85 sec MySQL thread id 65, OS thread handle 0x4f, query id 199408 10.118.237.202 cmd ---TRANSACTION 1438, ACTIVE 85 sec starting index read, thread declared inside InnoDB 500 mysql tables in use 3, locked 0 MySQL thread id 64, OS thread handle 0x4e, query id 198492 10.118.237.202 cmd Sending data select a.campaign_id, offer_for_blackberry, type, duration, vuc_value, vuc_low_value, vuc_qos_change, vuc_notification, vuc_low_notification, redirect_url, active_on_days, active_from_hour, active_to_hour, service_mapping_in, service_mapping_out, rating_mapping, free_daily_quota, language, DATE_FORMAT(activation_date, '%Y-%m-%d %H:%i:%s'), DATE_FORMAT(end_date, '%Y-%m-%d %H:%i:%s'), activation_code, short_code, tabs_service, a.apn apn from user_campaign a, campaign b where msisdn = '9647817320800' and FIND_IN_SET('INTERNET', a.apn) and ---TRANSACTION 1437, ACTIVE 85 sec MySQL thread id 63, OS thread handle 0x4d, query id 199419 10.118.237.202 cmd ---TRANSACTION 1436, ACTIVE 85 sec MySQL thread id 60, OS thread handle 0x4a, query id 198950 10.118.237.202 cmd Sending data select a.campaign_id, offer_for_blackberry, type, duration, vuc_value, vuc_low_value, vuc_qos_change, vuc_notification, vuc_low_notification, redirect_url, active_on_days, active_from_hour, active_to_hour, service_mapping_in, service_mapping_out, rating_mapping, free_daily_quota, language, DATE_FORMAT(activation_date, '%Y-%m-%d %H:%i:%s'), DATE_FORMAT(end_date, '%Y-%m-%d %H:%i:%s'), activation_code, short_code, tabs_service, a.apn apn from user_campaign a, campaign b where msisdn = '9647811533873' and FIND_IN_SET('INTERNET', a.apn) and Trx read view will not see trx with id >= 1464, sees < 1400 ---TRANSACTION 1435, ACTIVE 85 sec MySQL thread id 62, OS thread handle 0x4c, query id 199201 10.118.237.202 cmd Sending data select a.campaign_id, offer_for_blackberry, type, duration, vuc_value, vuc_low_value, vuc_qos_change, vuc_notification, vuc_low_notification, redirect_url, active_on_days, active_from_hour, active_to_hour, service_mapping_in, service_mapping_out, rating_mapping, free_daily_quota, language, DATE_FORMAT(activation_date, '%Y-%m-%d %H:%i:%s'), DATE_FORMAT(end_date, '%Y-%m-%d %H:%i:%s'), activation_code, short_code, tabs_service, a.apn apn from user_campaign a, campaign b where msisdn = '9647808097869' and FIND_IN_SET('INTERNET', a.apn) and Trx read view will not see trx with id >= 1464, sees < 1400 ---TRANSACTION 1434, ACTIVE 85 sec MySQL thread id 61, OS thread handle 0x4b, query id 199394 10.118.237.202 cmd ---TRANSACTION 1433, ACTIVE 85 sec MySQL thread id 59, OS thread handle 0x49, query id 199407 10.118.237.202 cmd ---TRANSACTION 1432, ACTIVE 85 sec MySQL thread id 55, OS thread handle 0x45, query id 199400 10.118.237.202 cmd ---TRANSACTION 1431, ACTIVE 86 sec starting index read, thread declared inside InnoDB 500 mysql tables in use 3, locked 0 MySQL thread id 53, OS thread handle 0x43, query id 198697 10.118.237.202 cmd Sending data select a.campaign_id, offer_for_blackberry, type, duration, vuc_value, vuc_low_value, vuc_qos_change, vuc_notification, vuc_low_notification, redirect_url, active_on_days, active_from_hour, active_to_hour, service_mapping_in, service_mapping_out, rating_mapping, free_daily_quota, language, DATE_FORMAT(activation_date, '%Y-%m-%d %H:%i:%s'), DATE_FORMAT(end_date, '%Y-%m-%d %H:%i:%s'), activation_code, short_code, tabs_service, a.apn apn from user_campaign a, campaign b where msisdn = '9647807384916' and FIND_IN_SET('INTERNET', a.apn) and ---TRANSACTION 1430, ACTIVE 87 sec MySQL thread id 43, OS thread handle 0x39, query id 199418 10.118.237.202 cmd ---TRANSACTION 142F, ACTIVE 87 sec MySQL thread id 52, OS thread handle 0x42, query id 198699 10.118.237.202 cmd ---TRANSACTION 142E, ACTIVE 87 sec MySQL thread id 44, OS thread handle 0x3a, query id 199410 10.118.237.202 cmd ---TRANSACTION 142D, ACTIVE 87 sec starting index read, thread declared inside InnoDB 500 mysql tables in use 3, locked 0 MySQL thread id 47, OS thread handle 0x3d, query id 198688 10.118.237.202 cmd Sending data select a.campaign_id, offer_for_blackberry, type, duration, vuc_value, vuc_low_value, vuc_qos_change, vuc_notification, vuc_low_notification, redirect_url, active_on_days, active_from_hour, active_to_hour, service_mapping_in, service_mapping_out, rating_mapping, free_daily_quota, language, DATE_FORMAT(activation_date, '%Y-%m-%d %H:%i:%s'), DATE_FORMAT(end_date, '%Y-%m-%d %H:%i:%s'), activation_code, short_code, tabs_service, a.apn apn from user_campaign a, campaign b where msisdn = '9647905083905' and FIND_IN_SET('INTERNET', a.apn) and ---TRANSACTION 142C, ACTIVE 87 sec MySQL thread id 46, OS thread handle 0x3c, query id 199390 10.118.237.202 cmd ---TRANSACTION 142B, ACTIVE 87 sec MySQL thread id 45, OS thread handle 0x3b, query id 199411 10.118.237.202 cmd ---TRANSACTION 142A, ACTIVE 87 sec MySQL thread id 48, OS thread handle 0x3e, query id 199375 10.118.237.202 cmd ---TRANSACTION 1429, ACTIVE 87 sec starting index read, thread declared inside InnoDB 500 mysql tables in use 3, locked 0 MySQL thread id 42, OS thread handle 0x38, query id 199433 10.118.237.202 cmd Sending data select a.campaign_id, offer_for_blackberry, type, duration, vuc_value, vuc_low_value, vuc_qos_change, vuc_notification, vuc_low_notification, redirect_url, active_on_days, active_from_hour, active_to_hour, service_mapping_in, service_mapping_out, rating_mapping, free_daily_quota, language, DATE_FORMAT(activation_date, '%Y-%m-%d %H:%i:%s'), DATE_FORMAT(end_date, '%Y-%m-%d %H:%i:%s'), activation_code, short_code, tabs_service, a.apn apn from user_campaign a, campaign b where msisdn = '9647807477755' and FIND_IN_SET('INTERNET', a.apn) and ---TRANSACTION 1428, ACTIVE 87 sec MySQL thread id 51, OS thread handle 0x41, query id 199421 10.118.237.202 cmd ---TRANSACTION 1427, ACTIVE 87 sec starting index read, thread declared inside InnoDB 500 mysql tables in use 3, locked 0 MySQL thread id 50, OS thread handle 0x40, query id 198689 10.118.237.202 cmd Sending data select a.campaign_id, offer_for_blackberry, type, duration, vuc_value, vuc_low_value, vuc_qos_change, vuc_notification, vuc_low_notification, redirect_url, active_on_days, active_from_hour, active_to_hour, service_mapping_in, service_mapping_out, rating_mapping, free_daily_quota, language, DATE_FORMAT(activation_date, '%Y-%m-%d %H:%i:%s'), DATE_FORMAT(end_date, '%Y-%m-%d %H:%i:%s'), activation_code, short_code, tabs_service, a.apn apn from user_campaign a, campaign b where msisdn = '9647807988968' and FIND_IN_SET('INTERNET', a.apn) and ---TRANSACTION 1426, ACTIVE 87 sec MySQL thread id 49, OS thread handle 0x3f, query id 198703 10.118.237.202 cmd ---TRANSACTION 1425, ACTIVE 87 sec MySQL thread id 40, OS thread handle 0x36, query id 199382 10.118.237.202 cmd ---TRANSACTION 1424, ACTIVE 87 sec MySQL thread id 39, OS thread handle 0x35, query id 199412 10.118.237.202 cmd ---TRANSACTION 1423, ACTIVE 87 sec MySQL thread id 38, OS thread handle 0x34, query id 199424 10.118.237.202 cmd ---TRANSACTION 1422, ACTIVE 87 sec starting index read, thread declared inside InnoDB 500 mysql tables in use 3, locked 0 MySQL thread id 37, OS thread handle 0x33, query id 198691 10.118.237.202 cmd Sending data select a.campaign_id, offer_for_blackberry, type, duration, vuc_value, vuc_low_value, vuc_qos_change, vuc_notification, vuc_low_notification, redirect_url, active_on_days, active_from_hour, active_to_hour, service_mapping_in, service_mapping_out, rating_mapping, free_daily_quota, language, DATE_FORMAT(activation_date, '%Y-%m-%d %H:%i:%s'), DATE_FORMAT(end_date, '%Y-%m-%d %H:%i:%s'), activation_code, short_code, tabs_service, a.apn apn from user_campaign a, campaign b where msisdn = '9647814262140' and FIND_IN_SET('INTERNET', a.apn) and ---TRANSACTION 1421, ACTIVE 87 sec MySQL thread id 35, OS thread handle 0x31, query id 199378 10.118.237.202 cmd ---TRANSACTION 1420, ACTIVE 87 sec MySQL thread id 41, OS thread handle 0x37, query id 199399 10.118.237.202 cmd ---TRANSACTION 141F, ACTIVE 87 sec MySQL thread id 36, OS thread handle 0x32, query id 198700 10.118.237.202 cmd ---TRANSACTION 141E, ACTIVE 87 sec MySQL thread id 31, OS thread handle 0x2d, query id 199414 10.118.237.202 cmd ---TRANSACTION 141D, ACTIVE 87 sec MySQL thread id 34, OS thread handle 0x30, query id 199398 10.118.237.202 cmd ---TRANSACTION 141C, ACTIVE 87 sec starting index read, thread declared inside InnoDB 500 mysql tables in use 3, locked 0 MySQL thread id 33, OS thread handle 0x2f, query id 198752 10.118.237.202 cmd Sending data select a.campaign_id, offer_for_blackberry, type, duration, vuc_value, vuc_low_value, vuc_qos_change, vuc_notification, vuc_low_notification, redirect_url, active_on_days, active_from_hour, active_to_hour, service_mapping_in, service_mapping_out, rating_mapping, free_daily_quota, language, DATE_FORMAT(activation_date, '%Y-%m-%d %H:%i:%s'), DATE_FORMAT(end_date, '%Y-%m-%d %H:%i:%s'), activation_code, short_code, tabs_service, a.apn apn from user_campaign a, campaign b where msisdn = '9647811520208' and FIND_IN_SET('INTERNET', a.apn) and ---TRANSACTION 141B, ACTIVE 87 sec MySQL thread id 32, OS thread handle 0x2e, query id 199402 10.118.237.202 cmd ---TRANSACTION 141A, ACTIVE 87 sec starting index read, thread declared inside InnoDB 500 mysql tables in use 3, locked 0 MySQL thread id 30, OS thread handle 0x2c, query id 199251 10.118.237.202 cmd Sending data select a.campaign_id, offer_for_blackberry, type, duration, vuc_value, vuc_low_value, vuc_qos_change, vuc_notification, vuc_low_notification, redirect_url, active_on_days, active_from_hour, active_to_hour, service_mapping_in, service_mapping_out, rating_mapping, free_daily_quota, language, DATE_FORMAT(activation_date, '%Y-%m-%d %H:%i:%s'), DATE_FORMAT(end_date, '%Y-%m-%d %H:%i:%s'), activation_code, short_code, tabs_service, a.apn apn from user_campaign a, campaign b where msisdn = '9647806031338' and FIND_IN_SET('INTERNET', a.apn) and ---TRANSACTION 1419, ACTIVE 88 sec MySQL thread id 29, OS thread handle 0x2b, query id 199377 10.118.237.202 cmd ---TRANSACTION 1418, ACTIVE 89 sec MySQL thread id 28, OS thread handle 0x2a, query id 198698 10.118.237.202 cmd ---TRANSACTION 1417, ACTIVE 89 sec MySQL thread id 27, OS thread handle 0x29, query id 199413 10.118.237.202 cmd ---TRANSACTION 1416, ACTIVE 89 sec MySQL thread id 26, OS thread handle 0x28, query id 199000 10.118.237.202 cmd Sending data select a.campaign_id, offer_for_blackberry, type, duration, vuc_value, vuc_low_value, vuc_qos_change, vuc_notification, vuc_low_notification, redirect_url, active_on_days, active_from_hour, active_to_hour, service_mapping_in, service_mapping_out, rating_mapping, free_daily_quota, language, DATE_FORMAT(activation_date, '%Y-%m-%d %H:%i:%s'), DATE_FORMAT(end_date, '%Y-%m-%d %H:%i:%s'), activation_code, short_code, tabs_service, a.apn apn from user_campaign a, campaign b where msisdn = '9647808192034' and FIND_IN_SET('INTERNET', a.apn) and Trx read view will not see trx with id >= 1464, sees < 1400 ---TRANSACTION 1415, ACTIVE 89 sec MySQL thread id 21, OS thread handle 0x23, query id 199423 10.118.237.202 cmd ---TRANSACTION 1414, ACTIVE 89 sec starting index read, thread declared inside InnoDB 500 mysql tables in use 3, locked 0 MySQL thread id 24, OS thread handle 0x26, query id 198733 10.118.237.202 cmd Sending data select a.campaign_id, offer_for_blackberry, type, duration, vuc_value, vuc_low_value, vuc_qos_change, vuc_notification, vuc_low_notification, redirect_url, active_on_days, active_from_hour, active_to_hour, service_mapping_in, service_mapping_out, rating_mapping, free_daily_quota, language, DATE_FORMAT(activation_date, '%Y-%m-%d %H:%i:%s'), DATE_FORMAT(end_date, '%Y-%m-%d %H:%i:%s'), activation_code, short_code, tabs_service, a.apn apn from user_campaign a, campaign b where msisdn = '9647800151863' and FIND_IN_SET('INTERNET', a.apn) and ---TRANSACTION 1413, ACTIVE 89 sec MySQL thread id 19, OS thread handle 0x21, query id 198567 10.118.237.202 cmd ---TRANSACTION 1412, ACTIVE 89 sec MySQL thread id 25, OS thread handle 0x27, query id 198702 10.118.237.202 cmd ---TRANSACTION 1411, ACTIVE 89 sec starting index read, thread declared inside InnoDB 500 mysql tables in use 3, locked 0 MySQL thread id 20, OS thread handle 0x22, query id 199050 10.118.237.202 cmd Sending data select a.campaign_id, offer_for_blackberry, type, duration, vuc_value, vuc_low_value, vuc_qos_change, vuc_notification, vuc_low_notification, redirect_url, active_on_days, active_from_hour, active_to_hour, service_mapping_in, service_mapping_out, rating_mapping, free_daily_quota, language, DATE_FORMAT(activation_date, '%Y-%m-%d %H:%i:%s'), DATE_FORMAT(end_date, '%Y-%m-%d %H:%i:%s'), activation_code, short_code, tabs_service, a.apn apn from user_campaign a, campaign b where msisdn = '9647813359146' and FIND_IN_SET('INTERNET', a.apn) and ---TRANSACTION 1410, ACTIVE 89 sec MySQL thread id 18, OS thread handle 0x20, query id 199370 10.118.237.202 cmd ---TRANSACTION 140F, ACTIVE 89 sec MySQL thread id 23, OS thread handle 0x25, query id 199391 10.118.237.202 cmd ---TRANSACTION 140E, ACTIVE 89 sec MySQL thread id 22, OS thread handle 0x24, query id 199430 10.118.237.202 cmd ---TRANSACTION 140D, ACTIVE 89 sec MySQL thread id 17, OS thread handle 0x1f, query id 199416 10.118.237.202 cmd ---TRANSACTION 140C, ACTIVE 89 sec MySQL thread id 16, OS thread handle 0x1e, query id 199425 10.118.237.202 cmd ---TRANSACTION 140B, ACTIVE 90 sec sleeping before joining InnoDB queue mysql tables in use 3, locked 0 MySQL thread id 12, OS thread handle 0x1a, query id 199434 10.118.237.202 cmd Sending data select a.campaign_id, offer_for_blackberry, type, duration, vuc_value, vuc_low_value, vuc_qos_change, vuc_notification, vuc_low_notification, redirect_url, active_on_days, active_from_hour, active_to_hour, service_mapping_in, service_mapping_out, rating_mapping, free_daily_quota, language, DATE_FORMAT(activation_date, '%Y-%m-%d %H:%i:%s'), DATE_FORMAT(end_date, '%Y-%m-%d %H:%i:%s'), activation_code, short_code, tabs_service, a.apn apn from user_campaign a, campaign b where msisdn = '9647808457060' and FIND_IN_SET('INTERNET', a.apn) and ---TRANSACTION 140A, ACTIVE 90 sec MySQL thread id 11, OS thread handle 0x19, query id 198592 10.118.237.202 cmd ---TRANSACTION 1409, ACTIVE 90 sec starting index read, thread declared inside InnoDB 500 mysql tables in use 3, locked 0 MySQL thread id 9, OS thread handle 0x17, query id 198827 10.118.237.202 cmd Sending data select a.campaign_id, offer_for_blackberry, type, duration, vuc_value, vuc_low_value, vuc_qos_change, vuc_notification, vuc_low_notification, redirect_url, active_on_days, active_from_hour, active_to_hour, service_mapping_in, service_mapping_out, rating_mapping, free_daily_quota, language, DATE_FORMAT(activation_date, '%Y-%m-%d %H:%i:%s'), DATE_FORMAT(end_date, '%Y-%m-%d %H:%i:%s'), activation_code, short_code, tabs_service, a.apn apn from user_campaign a, campaign b where msisdn = '9647807252220' and FIND_IN_SET('INTERNET', a.apn) and ---TRANSACTION 1408, ACTIVE 90 sec MySQL thread id 13, OS thread handle 0x1b, query id 199386 10.118.237.202 cmd ---TRANSACTION 1407, ACTIVE 90 sec sleeping before joining InnoDB queue mysql tables in use 3, locked 0 MySQL thread id 14, OS thread handle 0x1c, query id 199076 10.118.237.202 cmd Sending data select a.campaign_id, offer_for_blackberry, type, duration, vuc_value, vuc_low_value, vuc_qos_change, vuc_notification, vuc_low_notification, redirect_url, active_on_days, active_from_hour, active_to_hour, service_mapping_in, service_mapping_out, rating_mapping, free_daily_quota, language, DATE_FORMAT(activation_date, '%Y-%m-%d %H:%i:%s'), DATE_FORMAT(end_date, '%Y-%m-%d %H:%i:%s'), activation_code, short_code, tabs_service, a.apn apn from user_campaign a, campaign b where msisdn = '9647806933678' and FIND_IN_SET('INTERNET', a.apn) and ---TRANSACTION 1406, ACTIVE 90 sec starting index read, thread declared inside InnoDB 500 mysql tables in use 3, locked 0 MySQL thread id 15, OS thread handle 0x1d, query id 198690 10.118.237.202 cmd Sending data select a.campaign_id, offer_for_blackberry, type, duration, vuc_value, vuc_low_value, vuc_qos_change, vuc_notification, vuc_low_notification, redirect_url, active_on_days, active_from_hour, active_to_hour, service_mapping_in, service_mapping_out, rating_mapping, free_daily_quota, language, DATE_FORMAT(activation_date, '%Y-%m-%d %H:%i:%s'), DATE_FORMAT(end_date, '%Y-%m-%d %H:%i:%s'), activation_code, short_code, tabs_service, a.apn apn from user_campaign a, campaign b where msisdn = '9647801442207' and FIND_IN_SET('INTERNET', a.apn) and ---TRANSACTION 1405, ACTIVE 90 sec MySQL thread id 10, OS thread handle 0x18, query id 199403 10.118.237.202 cmd ---TRANSACTION 1404, ACTIVE 90 sec MySQL thread id 8, OS thread handle 0x16, query id 199429 10.118.237.202 cmd ---TRANSACTION 1403, ACTIVE 90 sec MySQL thread id 5, OS thread handle 0x13, query id 199387 10.118.237.202 cmd ---TRANSACTION 1402, ACTIVE 90 sec MySQL thread id 7, OS thread handle 0x15, query id 199404 10.118.237.202 cmd ---TRANSACTION 1401, ACTIVE 90 sec MySQL thread id 6, OS thread handle 0x14, query id 199367 10.118.237.202 cmd ---TRANSACTION 1400, ACTIVE 91 sec MySQL thread id 4, OS thread handle 0x12, query id 11 10.118.237.202 cmd -------- 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 (read thread) I/O thread 4 state: waiting for i/o request (read thread) I/O thread 5 state: waiting for i/o request (read thread) I/O thread 6 state: waiting for i/o request (write thread) I/O thread 7 state: waiting for i/o request (write thread) I/O thread 8 state: waiting for i/o request (write thread) I/O thread 9 state: waiting for i/o request (write thread) Pending normal aio reads: 0 [0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0] , ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 768 OS file reads, 7 OS file writes, 7 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 0, seg size 2, 0 merges merged operations: insert 0, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 207619, node heap has 1 buffer(s) 2385.80 hash searches/s, 33398.23 non-hash searches/s --- LOG --- Log sequence number 257514754 Log flushed up to 257514754 Last checkpoint at 257514754 0 pending log writes, 0 pending chkp writes 10 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 107315200; in additional pool allocated 0 Dictionary memory allocated 120231 Buffer pool size 6400 Free buffers 5644 Database pages 755 Old database pages 298 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 755, created 0, written 1 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 755, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 16 queries inside InnoDB, 4 queries in queue 6 read views open inside InnoDB Main thread id 16, state: sleeping Number of rows inserted 0, updated 0, deleted 0, read 662407 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 7157.49 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================