*************************** 1. row *************************** Type: InnoDB Name: Status: ===================================== 120316 10:30:01 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 28 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 450 1_second, 449 sleeps, 44 10_second, 1 background, 1 flush srv_master_thread log flush and writes: 454 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 21459, signal count 578 --Thread 66 has waited at trx0trx.c line 1110 for 0.00 seconds the semaphore: Mutex at 1a9bfe8 created file srv0srv.c line 1018, lock var 0 waiters flag 0 --Thread 96 has waited at trx0trx.c line 1110 for 0.00 seconds the semaphore: Mutex at 1a9bfe8 created file srv0srv.c line 1018, lock var 0 waiters flag 0 --Thread 72 has waited at trx0trx.c line 1110 for 0.00 seconds the semaphore: Mutex at 1a9bfe8 created file srv0srv.c line 1018, lock var 0 waiters flag 0 --Thread 52 has waited at trx0trx.c line 1110 for 0.00 seconds the semaphore: Mutex at 1a9bfe8 created file srv0srv.c line 1018, lock var 0 waiters flag 0 --Thread 39 has waited at trx0trx.c line 1110 for 0.00 seconds the semaphore: Mutex at 1a9bfe8 created file srv0srv.c line 1018, lock var 0 waiters flag 0 Mutex spin waits 28265, rounds 903657, OS waits 21454 RW-shared spins 3, rounds 90, OS waits 3 RW-excl spins 1, rounds 30, OS waits 1 Spin rounds per wait: 31.97 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 106, OS thread handle 0x76, query id 1125606 localhost root show engine innodb status ---TRANSACTION 1463, ACTIVE 476 sec MySQL thread id 102, OS thread handle 0x74, query id 1125660 10.118.237.202 cmd ---TRANSACTION 1462, ACTIVE 476 sec MySQL thread id 103, OS thread handle 0x75, query id 1125705 10.118.237.202 cmd ---TRANSACTION 1461, ACTIVE 476 sec MySQL thread id 101, OS thread handle 0x73, query id 1125675 10.118.237.202 cmd ---TRANSACTION 1460, ACTIVE 476 sec MySQL thread id 92, OS thread handle 0x6a, query id 1125709 10.118.237.202 cmd ---TRANSACTION 145F, ACTIVE 476 sec MySQL thread id 99, OS thread handle 0x71, query id 1125683 10.118.237.202 cmd ---TRANSACTION 145E, ACTIVE 476 sec MySQL thread id 98, OS thread handle 0x70, query id 1125519 10.118.237.202 cmd ---TRANSACTION 145D, ACTIVE 476 sec MySQL thread id 94, OS thread handle 0x6c, query id 1125603 10.118.237.202 cmd ---TRANSACTION 145C, ACTIVE 476 sec MySQL thread id 93, OS thread handle 0x6b, query id 1125642 10.118.237.202 cmd ---TRANSACTION 145B, ACTIVE 476 sec MySQL thread id 96, OS thread handle 0x6e, query id 1125640 10.118.237.202 cmd ---TRANSACTION 145A, ACTIVE 476 sec MySQL thread id 95, OS thread handle 0x6d, query id 1125704 10.118.237.202 cmd ---TRANSACTION 1459, ACTIVE 476 sec MySQL thread id 100, OS thread handle 0x72, query id 1125708 10.118.237.202 cmd ---TRANSACTION 1458, ACTIVE 476 sec MySQL thread id 97, OS thread handle 0x6f, query id 1125647 10.118.237.202 cmd ---TRANSACTION 1457, ACTIVE 476 sec sleeping before joining InnoDB queue mysql tables in use 3, locked 0 MySQL thread id 91, OS thread handle 0x69, query id 1125607 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 = '9647806942624' and FIND_IN_SET('INTERNET', a.apn) and ---TRANSACTION 1456, ACTIVE 476 sec MySQL thread id 90, OS thread handle 0x68, query id 1125680 10.118.237.202 cmd ---TRANSACTION 1455, ACTIVE 477 sec MySQL thread id 89, OS thread handle 0x67, query id 1125638 10.118.237.202 cmd ---TRANSACTION 1454, ACTIVE 477 sec MySQL thread id 81, OS thread handle 0x5f, query id 1125655 10.118.237.202 cmd ---TRANSACTION 1453, ACTIVE 477 sec MySQL thread id 84, OS thread handle 0x62, query id 1125591 10.118.237.202 cmd ---TRANSACTION 1452, ACTIVE 477 sec starting index read, thread declared inside InnoDB 500 mysql tables in use 3, locked 0 MySQL thread id 82, OS thread handle 0x60, query id 1125530 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 = '9647808097385' and FIND_IN_SET('INTERNET', a.apn) and ---TRANSACTION 1451, ACTIVE 477 sec sleeping before joining InnoDB queue mysql tables in use 3, locked 0 MySQL thread id 80, OS thread handle 0x5e, query id 1125166 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 = '9647800161366' and FIND_IN_SET('INTERNET', a.apn) and ---TRANSACTION 1450, ACTIVE 477 sec, thread declared inside InnoDB 500 mysql tables in use 3, locked 0 MySQL thread id 86, OS thread handle 0x64, query id 1125579 10.118.237.202 cmd statistics 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 = '9647808924940' and FIND_IN_SET('INTERNET', a.apn) and Trx read view will not see trx with id >= 1464, sees < 1400 ---TRANSACTION 144F, ACTIVE 477 sec MySQL thread id 85, OS thread handle 0x63, query id 1125601 10.118.237.202 cmd ---TRANSACTION 144E, ACTIVE 477 sec MySQL thread id 83, OS thread handle 0x61, query id 1125674 10.118.237.202 cmd ---TRANSACTION 144D, ACTIVE 477 sec MySQL thread id 88, OS thread handle 0x66, query id 1125599 10.118.237.202 cmd ---TRANSACTION 144C, ACTIVE 477 sec MySQL thread id 87, OS thread handle 0x65, query id 1125639 10.118.237.202 cmd ---TRANSACTION 144B, ACTIVE 477 sec MySQL thread id 79, OS thread handle 0x5d, query id 1125600 10.118.237.202 cmd ---TRANSACTION 144A, ACTIVE 477 sec starting index read, thread declared inside InnoDB 500 mysql tables in use 3, locked 0 MySQL thread id 78, OS thread handle 0x5c, query id 1125716 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 = '9647806918062' and FIND_IN_SET('INTERNET', a.apn) and ---TRANSACTION 1449, ACTIVE 479 sec MySQL thread id 77, OS thread handle 0x5b, query id 1125652 10.118.237.202 cmd ---TRANSACTION 1448, ACTIVE 479 sec MySQL thread id 76, OS thread handle 0x5a, query id 1125648 10.118.237.202 cmd ---TRANSACTION 1447, ACTIVE 479 sec MySQL thread id 75, OS thread handle 0x59, query id 1125602 10.118.237.202 cmd ---TRANSACTION 1446, ACTIVE 479 sec MySQL thread id 74, OS thread handle 0x58, query id 1125697 10.118.237.202 cmd ---TRANSACTION 1445, ACTIVE 479 sec MySQL thread id 70, OS thread handle 0x54, query id 1125710 10.118.237.202 cmd ---TRANSACTION 1444, ACTIVE 479 sec MySQL thread id 73, OS thread handle 0x57, query id 1125684 10.118.237.202 cmd ---TRANSACTION 1443, ACTIVE 479 sec MySQL thread id 72, OS thread handle 0x56, query id 1125673 10.118.237.202 cmd ---TRANSACTION 1442, ACTIVE 479 sec sleeping before joining InnoDB queue mysql tables in use 3, locked 0 MySQL thread id 71, OS thread handle 0x55, query id 1125352 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 = '9647813565393' and FIND_IN_SET('INTERNET', a.apn) and ---TRANSACTION 1441, ACTIVE 479 sec MySQL thread id 68, OS thread handle 0x52, query id 1125653 10.118.237.202 cmd ---TRANSACTION 1440, ACTIVE 479 sec starting index read, thread declared inside InnoDB 500 mysql tables in use 3, locked 0 MySQL thread id 69, OS thread handle 0x53, query id 1125717 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 = '9647801039560' and FIND_IN_SET('INTERNET', a.apn) and ---TRANSACTION 143F, ACTIVE 479 sec MySQL thread id 67, OS thread handle 0x51, query id 1125718 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 = '9647801936653' and FIND_IN_SET('INTERNET', a.apn) and ---TRANSACTION 143E, ACTIVE 479 sec sleeping before joining InnoDB queue mysql tables in use 3, locked 0 MySQL thread id 66, OS thread handle 0x50, query id 1125212 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 = '9647800193511' and FIND_IN_SET('INTERNET', a.apn) and ---TRANSACTION 143D, ACTIVE 479 sec MySQL thread id 54, OS thread handle 0x44, query id 1125662 10.118.237.202 cmd ---TRANSACTION 143C, ACTIVE 479 sec mysql tables in use 3, locked 0 MySQL thread id 56, OS thread handle 0x46, query id 1125447 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 = '9647801893400' and FIND_IN_SET('INTERNET', a.apn) and Trx read view will not see trx with id >= 1464, sees < 1400 ---TRANSACTION 143B, ACTIVE 479 sec starting index read, thread declared inside InnoDB 500 mysql tables in use 3, locked 0 MySQL thread id 58, OS thread handle 0x48, query id 1125531 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 = '9647800678190' and FIND_IN_SET('INTERNET', a.apn) and ---TRANSACTION 143A, ACTIVE 479 sec MySQL thread id 57, OS thread handle 0x47, query id 1125671 10.118.237.202 cmd ---TRANSACTION 1439, ACTIVE 479 sec sleeping before joining InnoDB queue mysql tables in use 3, locked 0 MySQL thread id 65, OS thread handle 0x4f, query id 1124954 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 = '9647804921899' and FIND_IN_SET('INTERNET', a.apn) and ---TRANSACTION 1438, ACTIVE 479 sec MySQL thread id 64, OS thread handle 0x4e, query id 1125707 10.118.237.202 cmd ---TRANSACTION 1437, ACTIVE 479 sec MySQL thread id 63, OS thread handle 0x4d, query id 1125645 10.118.237.202 cmd ---TRANSACTION 1436, ACTIVE 479 sec MySQL thread id 60, OS thread handle 0x4a, query id 1125590 10.118.237.202 cmd ---TRANSACTION 1435, ACTIVE 479 sec MySQL thread id 62, OS thread handle 0x4c, query id 1125657 10.118.237.202 cmd ---TRANSACTION 1434, ACTIVE 479 sec MySQL thread id 61, OS thread handle 0x4b, query id 1125650 10.118.237.202 cmd ---TRANSACTION 1433, ACTIVE 479 sec mysql tables in use 3, locked 0 MySQL thread id 59, OS thread handle 0x49, query id 1125494 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 = '9647814185378' and FIND_IN_SET('INTERNET', a.apn) and Trx read view will not see trx with id >= 1464, sees < 1400 ---TRANSACTION 1432, ACTIVE 479 sec MySQL thread id 55, OS thread handle 0x45, query id 1125676 10.118.237.202 cmd ---TRANSACTION 1431, ACTIVE 480 sec MySQL thread id 53, OS thread handle 0x43, query id 1125651 10.118.237.202 cmd ---TRANSACTION 1430, ACTIVE 481 sec MySQL thread id 43, OS thread handle 0x39, query id 1125659 10.118.237.202 cmd ---TRANSACTION 142F, ACTIVE 481 sec starting index read, thread declared inside InnoDB 500 mysql tables in use 3, locked 0 MySQL thread id 52, OS thread handle 0x42, query id 1125525 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 = '9647906958035' and FIND_IN_SET('INTERNET', a.apn) and ---TRANSACTION 142E, ACTIVE 481 sec MySQL thread id 44, OS thread handle 0x3a, query id 1125598 10.118.237.202 cmd ---TRANSACTION 142D, ACTIVE 481 sec MySQL thread id 47, OS thread handle 0x3d, query id 1125681 10.118.237.202 cmd ---TRANSACTION 142C, ACTIVE 481 sec MySQL thread id 46, OS thread handle 0x3c, query id 1125686 10.118.237.202 cmd ---TRANSACTION 142B, ACTIVE 481 sec mysql tables in use 3, locked 0 MySQL thread id 45, OS thread handle 0x3b, query id 1125626 10.118.237.202 cmd preparing 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 = '9647814181234' and FIND_IN_SET('INTERNET', a.apn) and ---TRANSACTION 142A, ACTIVE 481 sec MySQL thread id 48, OS thread handle 0x3e, query id 1125641 10.118.237.202 cmd ---TRANSACTION 1429, ACTIVE 481 sec MySQL thread id 42, OS thread handle 0x38, query id 1125672 10.118.237.202 cmd ---TRANSACTION 1428, ACTIVE 481 sec MySQL thread id 51, OS thread handle 0x41, query id 1125588 10.118.237.202 cmd ---TRANSACTION 1427, ACTIVE 481 sec MySQL thread id 50, OS thread handle 0x40, query id 1125678 10.118.237.202 cmd ---TRANSACTION 1426, ACTIVE 481 sec MySQL thread id 49, OS thread handle 0x3f, query id 1125661 10.118.237.202 cmd ---TRANSACTION 1425, ACTIVE 481 sec MySQL thread id 40, OS thread handle 0x36, query id 1125587 10.118.237.202 cmd ---TRANSACTION 1424, ACTIVE 481 sec MySQL thread id 39, OS thread handle 0x35, query id 1125594 10.118.237.202 cmd ---TRANSACTION 1423, ACTIVE 481 sec starting index read, thread declared inside InnoDB 500 mysql tables in use 3, locked 0 MySQL thread id 38, OS thread handle 0x34, query id 1125532 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 = '9647812128772' and FIND_IN_SET('INTERNET', a.apn) and ---TRANSACTION 1422, ACTIVE 481 sec MySQL thread id 37, OS thread handle 0x33, query id 1125670 10.118.237.202 cmd ---TRANSACTION 1421, ACTIVE 481 sec MySQL thread id 35, OS thread handle 0x31, query id 1125701 10.118.237.202 cmd ---TRANSACTION 1420, ACTIVE 481 sec MySQL thread id 41, OS thread handle 0x37, query id 1125703 10.118.237.202 cmd ---TRANSACTION 141F, ACTIVE 481 sec MySQL thread id 36, OS thread handle 0x32, query id 1125643 10.118.237.202 cmd ---TRANSACTION 141E, ACTIVE 481 sec starting index read, thread declared inside InnoDB 500 mysql tables in use 3, locked 0 MySQL thread id 31, OS thread handle 0x2d, query id 1125518 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 = '9647809088002' and FIND_IN_SET('INTERNET', a.apn) and Trx read view will not see trx with id >= 1464, sees < 1400 ---TRANSACTION 141D, ACTIVE 481 sec mysql tables in use 3, locked 0 MySQL thread id 34, OS thread handle 0x30, query id 1125235 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 = '9647806941692' and FIND_IN_SET('INTERNET', a.apn) and Trx read view will not see trx with id >= 1464, sees < 1400 ---TRANSACTION 141C, ACTIVE 481 sec sleeping before joining InnoDB queue mysql tables in use 3, locked 0 MySQL thread id 33, OS thread handle 0x2f, query id 1125471 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 = '9647808318307' and FIND_IN_SET('INTERNET', a.apn) and ---TRANSACTION 141B, ACTIVE 481 sec MySQL thread id 32, OS thread handle 0x2e, query id 1125597 10.118.237.202 cmd ---TRANSACTION 141A, ACTIVE 481 sec MySQL thread id 30, OS thread handle 0x2c, query id 1125679 10.118.237.202 cmd ---TRANSACTION 1419, ACTIVE 482 sec MySQL thread id 29, OS thread handle 0x2b, query id 1125592 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 = '9647818960697' and FIND_IN_SET('INTERNET', a.apn) and ---TRANSACTION 1418, ACTIVE 483 sec MySQL thread id 28, OS thread handle 0x2a, query id 1125644 10.118.237.202 cmd ---TRANSACTION 1417, ACTIVE 483 sec sleeping before joining InnoDB queue mysql tables in use 3, locked 0 MySQL thread id 27, OS thread handle 0x29, query id 1124978 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 = '9647806910376' and FIND_IN_SET('INTERNET', a.apn) and ---TRANSACTION 1416, ACTIVE 483 sec MySQL thread id 26, OS thread handle 0x28, query id 1125699 10.118.237.202 cmd ---TRANSACTION 1415, ACTIVE 483 sec MySQL thread id 21, OS thread handle 0x23, query id 1125595 10.118.237.202 cmd ---TRANSACTION 1414, ACTIVE 483 sec MySQL thread id 24, OS thread handle 0x26, query id 1125700 10.118.237.202 cmd ---TRANSACTION 1413, ACTIVE 483 sec MySQL thread id 19, OS thread handle 0x21, query id 1125649 10.118.237.202 cmd ---TRANSACTION 1412, ACTIVE 483 sec starting index read, thread declared inside InnoDB 500 mysql tables in use 3, locked 0 MySQL thread id 25, OS thread handle 0x27, query id 1125533 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 = '9647813909868' and FIND_IN_SET('INTERNET', a.apn) and ---TRANSACTION 1411, ACTIVE 483 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 1125715 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 = '9647806944434' and FIND_IN_SET('INTERNET', a.apn) and ---TRANSACTION 1410, ACTIVE 483 sec mysql tables in use 3, locked 0 MySQL thread id 18, OS thread handle 0x20, query id 1125307 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 = '9647804873974' and FIND_IN_SET('INTERNET', a.apn) and Trx read view will not see trx with id >= 1464, sees < 1400 ---TRANSACTION 140F, ACTIVE 483 sec MySQL thread id 23, OS thread handle 0x25, query id 1125698 10.118.237.202 cmd ---TRANSACTION 140E, ACTIVE 483 sec MySQL thread id 22, OS thread handle 0x24, query id 1125702 10.118.237.202 cmd ---TRANSACTION 140D, ACTIVE 483 sec MySQL thread id 17, OS thread handle 0x1f, query id 1125646 10.118.237.202 cmd ---TRANSACTION 140C, ACTIVE 483 sec MySQL thread id 16, OS thread handle 0x1e, query id 1125656 10.118.237.202 cmd ---TRANSACTION 140B, ACTIVE 484 sec MySQL thread id 12, OS thread handle 0x1a, query id 1125685 10.118.237.202 cmd ---TRANSACTION 140A, ACTIVE 484 sec MySQL thread id 11, OS thread handle 0x19, query id 1125696 10.118.237.202 cmd ---TRANSACTION 1409, ACTIVE 484 sec MySQL thread id 9, OS thread handle 0x17, query id 1125682 10.118.237.202 cmd ---TRANSACTION 1408, ACTIVE 484 sec MySQL thread id 13, OS thread handle 0x1b, query id 1125654 10.118.237.202 cmd ---TRANSACTION 1407, ACTIVE 484 sec MySQL thread id 14, OS thread handle 0x1c, query id 1125589 10.118.237.202 cmd ---TRANSACTION 1406, ACTIVE 484 sec MySQL thread id 15, OS thread handle 0x1d, query id 1125677 10.118.237.202 cmd ---TRANSACTION 1405, ACTIVE 484 sec MySQL thread id 10, OS thread handle 0x18, query id 1125596 10.118.237.202 cmd ---TRANSACTION 1404, ACTIVE 484 sec MySQL thread id 8, OS thread handle 0x16, query id 1125706 10.118.237.202 cmd ---TRANSACTION 1403, ACTIVE 484 sec starting index read, thread declared inside InnoDB 500 mysql tables in use 3, locked 0 MySQL thread id 5, OS thread handle 0x13, query id 1125714 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 = '9647806930179' and FIND_IN_SET('INTERNET', a.apn) and ---TRANSACTION 1402, ACTIVE 484 sec MySQL thread id 7, OS thread handle 0x15, query id 1125658 10.118.237.202 cmd ---TRANSACTION 1401, ACTIVE 484 sec MySQL thread id 6, OS thread handle 0x14, query id 1125593 10.118.237.202 cmd ---TRANSACTION 1400, ACTIVE 485 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) 2244.06 hash searches/s, 31417.66 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 -------------- 12 queries inside InnoDB, 7 queries in queue 7 read views open inside InnoDB Main thread id 16, state: sleeping Number of rows inserted 0, updated 0, deleted 0, read 3441288 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 6732.30 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================