*************************** 1. row *************************** Type: InnoDB Name: Status: ===================================== 120529 11:27:55 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 22 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 2459877 1_second, 2456094 sleeps, 230417 10_second, 378836 background, 378831 flush srv_master_thread log flush and writes: 2497717 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 1076256, signal count 3516314 Mutex spin waits 64500291, rounds 46686033, OS waits 135023 RW-shared spins 1539072, rounds 27803549, OS waits 876408 RW-excl spins 1013452, rounds 6558602, OS waits 43312 Spin rounds per wait: 0.72 mutex, 18.07 RW-shared, 6.47 RW-excl ------------ TRANSACTIONS ------------ Trx id counter 14A8981B5 Purge done for trx's n:o < 14A898159 undo n:o < 0 History list length 875 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0, not started MySQL thread id 255278, query id 49599620 10.1.106.11 root show engine innodb status ---TRANSACTION 14A898042, not started MySQL thread id 255258, query id 49598557 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A897E32, not started MySQL thread id 255257, query id 49598251 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A8981AD, not started MySQL thread id 255250, query id 49599533 10.1.25.11 ra-0000-0a01190b ---TRANSACTION 14A897B92, not started MySQL thread id 255251, query id 49586693 10.1.25.11 ra-0000-0a01190b ---TRANSACTION 14A898176, not started MySQL thread id 255239, query id 49599433 10.1.25.12 ra-0000-0a01190c ---TRANSACTION 14A8981AE, not started MySQL thread id 255241, query id 49599611 10.1.25.12 ra-0000-0a01190c ---TRANSACTION 14A8981B4, not started MySQL thread id 255240, query id 49599618 10.1.25.12 ra-0000-0a01190c ---TRANSACTION 14A89694E, not started MySQL thread id 255137, query id 49559603 10.1.25.12 ra-0000-0a01190c ---TRANSACTION 14A896B5B, not started MySQL thread id 255138, query id 49561170 10.1.25.12 ra-0000-0a01190c ---TRANSACTION 14A896C9E, not started MySQL thread id 255139, query id 49561795 10.1.25.12 ra-0000-0a01190c ---TRANSACTION 14A895034, not started MySQL thread id 255094, query id 49536207 10.1.25.12 ra-0000-0a01190c ---TRANSACTION 14A8952ED, not started MySQL thread id 255095, query id 49538352 10.1.25.12 ra-0000-0a01190c ---TRANSACTION 14A896F30, not started MySQL thread id 255107, query id 49571005 10.1.25.11 ra-0000-0a01190b ---TRANSACTION 14A896D78, not started MySQL thread id 255108, query id 49569772 10.1.25.11 ra-0000-0a01190b ---TRANSACTION 14A896546, not started MySQL thread id 255109, query id 49553012 10.1.25.11 ra-0000-0a01190b ---TRANSACTION 0, not started MySQL thread id 255104, query id 49526415 10.1.250.92 gkemnitz_ro ---TRANSACTION 14A8952F7, not started MySQL thread id 255097, query id 49538372 10.1.25.12 ra-0000-0a01190c ---TRANSACTION 14A895246, not started MySQL thread id 255096, query id 49537275 10.1.25.12 ra-0000-0a01190c ---TRANSACTION 14A897AF2, not started MySQL thread id 255061, query id 49586256 10.1.250.129 bevans_ro ---TRANSACTION 14A896FE6, not started MySQL thread id 254954, query id 49571315 10.1.25.11 ra-0000-0a01190b ---TRANSACTION 14A741CE5, not started MySQL thread id 222506, query id 49598573 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A73CD68, not started MySQL thread id 222369, query id 49598575 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A730052, not started MySQL thread id 221962, query id 49598564 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A72EF10, not started MySQL thread id 221917, query id 49598576 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A72DAA5, not started MySQL thread id 221884, query id 49598572 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A729C95, not started MySQL thread id 216942, query id 49598574 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A7209A6, not started MySQL thread id 216649, query id 49598569 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A720D4D, not started MySQL thread id 216648, query id 49598567 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A7204FC, not started MySQL thread id 216637, query id 49598566 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A71FC1C, not started MySQL thread id 216633, query id 49598565 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A89741C, not started MySQL thread id 216632, query id 49598707 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A89741B, not started MySQL thread id 216631, query id 49598706 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A89741A, not started MySQL thread id 216630, query id 49598705 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A897419, not started MySQL thread id 216629, query id 49598704 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A897418, not started MySQL thread id 216628, query id 49598703 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A897417, not started MySQL thread id 216627, query id 49598702 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A897416, not started MySQL thread id 216626, query id 49598701 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A897415, not started MySQL thread id 216625, query id 49598700 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A8865B4, not started MySQL thread id 216624, query id 49598699 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A897414, not started MySQL thread id 216623, query id 49598698 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A897413, not started MySQL thread id 216622, query id 49598696 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A8865B3, not started MySQL thread id 216621, query id 49598695 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A897E81, not started MySQL thread id 216620, query id 49598694 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A897E80, not started MySQL thread id 216619, query id 49598693 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A897E7F, not started MySQL thread id 216618, query id 49598692 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A897E7E, not started MySQL thread id 216617, query id 49598691 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A897E7D, not started MySQL thread id 216616, query id 49598690 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A897E7C, not started MySQL thread id 216615, query id 49598689 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A897E7B, not started MySQL thread id 216614, query id 49598688 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A897A98, not started MySQL thread id 216613, query id 49598687 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A897A97, not started MySQL thread id 216612, query id 49598686 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A897A96, not started MySQL thread id 216611, query id 49598685 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A897A95, not started MySQL thread id 216610, query id 49598684 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A898053, not started MySQL thread id 216609, query id 49598683 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A897A93, not started MySQL thread id 216608, query id 49598682 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A898052, not started MySQL thread id 216607, query id 49598681 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A897A91, not started MySQL thread id 216606, query id 49598680 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A898051, not started MySQL thread id 216605, query id 49598679 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A897A8F, not started MySQL thread id 216604, query id 49598678 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A8973FF, not started MySQL thread id 216603, query id 49598677 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A898050, not started MySQL thread id 216602, query id 49598676 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A897A8D, not started MySQL thread id 216601, query id 49598675 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A89804F, not started MySQL thread id 216600, query id 49598674 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A896984, not started MySQL thread id 216599, query id 49598673 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A897A8B, not started MySQL thread id 216598, query id 49598672 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A89804E, not started MySQL thread id 216597, query id 49598671 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A897A89, not started MySQL thread id 216596, query id 49598670 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A89804D, not started MySQL thread id 216595, query id 49598669 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A896D1C, not started MySQL thread id 216594, query id 49598668 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A896D1B, not started MySQL thread id 216593, query id 49598667 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A896D1A, not started MySQL thread id 216592, query id 49598666 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A896D19, not started MySQL thread id 216591, query id 49598665 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A896D18, not started MySQL thread id 216590, query id 49598664 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A897A87, not started MySQL thread id 216589, query id 49598663 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A896D17, not started MySQL thread id 216588, query id 49598662 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A897A86, not started MySQL thread id 216587, query id 49598661 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A896D16, not started MySQL thread id 216586, query id 49598660 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A896D15, not started MySQL thread id 216585, query id 49598659 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A896D14, not started MySQL thread id 216584, query id 49598658 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A896D13, not started MySQL thread id 216583, query id 49598657 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A896D12, not started MySQL thread id 216582, query id 49598656 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A8973F6, not started MySQL thread id 216581, query id 49598655 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A8973F5, not started MySQL thread id 216580, query id 49598654 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A8973F4, not started MySQL thread id 216579, query id 49598653 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A8973F3, not started MySQL thread id 216578, query id 49598652 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A8973F2, not started MySQL thread id 216577, query id 49598651 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A8973F1, not started MySQL thread id 216576, query id 49598650 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A8973F0, not started MySQL thread id 216575, query id 49598649 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A89627E, not started MySQL thread id 216574, query id 49598648 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A89627D, not started MySQL thread id 216573, query id 49598647 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A8973EF, not started MySQL thread id 216572, query id 49598646 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A8973EE, not started MySQL thread id 216571, query id 49598645 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A8973ED, not started MySQL thread id 216570, query id 49598644 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A8973EC, not started MySQL thread id 216569, query id 49598643 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A8973EB, not started MySQL thread id 216568, query id 49598642 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A8973EA, not started MySQL thread id 216567, query id 49598641 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A8973E9, not started MySQL thread id 216566, query id 49598640 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A8973E8, not started MySQL thread id 216565, query id 49598639 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A8973E7, not started MySQL thread id 216564, query id 49598638 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A8973E6, not started MySQL thread id 216563, query id 49598637 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A897A85, not started MySQL thread id 216562, query id 49598636 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A897A84, not started MySQL thread id 216561, query id 49598635 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A897A83, not started MySQL thread id 216560, query id 49598634 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A897A82, not started MySQL thread id 216559, query id 49598633 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A897A81, not started MySQL thread id 216558, query id 49598632 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A897A80, not started MySQL thread id 216557, query id 49598631 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A897A7F, not started MySQL thread id 216556, query id 49598630 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A897A7E, not started MySQL thread id 216555, query id 49598629 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A897A7D, not started MySQL thread id 216554, query id 49598628 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A8973DC, not started MySQL thread id 216553, query id 49598627 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A896977, not started MySQL thread id 216552, query id 49598626 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A896976, not started MySQL thread id 216551, query id 49598625 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A896975, not started MySQL thread id 216550, query id 49598624 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A89804B, not started MySQL thread id 216549, query id 49598623 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A896974, not started MySQL thread id 216548, query id 49598622 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A896973, not started MySQL thread id 216547, query id 49598621 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A896972, not started MySQL thread id 216546, query id 49598620 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A896971, not started MySQL thread id 216545, query id 49598619 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A8973DA, not started MySQL thread id 216544, query id 49598618 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A8973D9, not started MySQL thread id 216543, query id 49598617 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A896970, not started MySQL thread id 216542, query id 49598616 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A897A7B, not started MySQL thread id 216541, query id 49598615 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A89696F, not started MySQL thread id 216540, query id 49598614 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A8973D8, not started MySQL thread id 216539, query id 49598613 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A897A7A, not started MySQL thread id 216538, query id 49598612 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A897A79, not started MySQL thread id 216537, query id 49598611 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A897A78, not started MySQL thread id 216536, query id 49598610 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A897A77, not started MySQL thread id 216535, query id 49598609 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A897A76, not started MySQL thread id 216534, query id 49598608 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A897A75, not started MySQL thread id 216533, query id 49598607 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A897A74, not started MySQL thread id 216532, query id 49598606 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A897A73, not started MySQL thread id 216531, query id 49598605 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A8973D7, not started MySQL thread id 216530, query id 49598604 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A8973D6, not started MySQL thread id 216529, query id 49598603 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A8973D5, not started MySQL thread id 216528, query id 49598602 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A8973D4, not started MySQL thread id 216527, query id 49598601 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A89626C, not started MySQL thread id 216526, query id 49598600 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A8973D3, not started MySQL thread id 216525, query id 49598599 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A89626A, not started MySQL thread id 216524, query id 49598598 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A8973D2, not started MySQL thread id 216523, query id 49598597 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A896268, not started MySQL thread id 216522, query id 49598596 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A8973D1, not started MySQL thread id 216521, query id 49598595 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A896266, not started MySQL thread id 216520, query id 49598594 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A8973D0, not started MySQL thread id 216519, query id 49598593 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A896264, not started MySQL thread id 216518, query id 49598592 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A896263, not started MySQL thread id 216517, query id 49598591 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A88658A, not started MySQL thread id 216516, query id 49598590 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A896262, not started MySQL thread id 216515, query id 49598589 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A886589, not started MySQL thread id 216514, query id 49598588 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A896261, not started MySQL thread id 216513, query id 49598587 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A886588, not started MySQL thread id 216512, query id 49598586 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A896260, not started MySQL thread id 216511, query id 49598585 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A886587, not started MySQL thread id 216509, query id 49598584 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A89625F, not started MySQL thread id 216508, query id 49598583 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A886586, not started MySQL thread id 216507, query id 49598582 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A886585, not started MySQL thread id 216506, query id 49598581 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A886584, not started MySQL thread id 216496, query id 49598580 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A886583, not started MySQL thread id 216494, query id 49598579 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A886582, not started MySQL thread id 216492, query id 49598578 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A886581, not started MySQL thread id 216491, query id 49598577 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A898048, not started MySQL thread id 216487, query id 49598562 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A898047, not started MySQL thread id 216488, query id 49598563 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A898046, not started MySQL thread id 216486, query id 49598561 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A898045, not started MySQL thread id 216485, query id 49598560 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A898044, not started MySQL thread id 216484, query id 49598559 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 14A898043, not started MySQL thread id 216483, query id 49598558 10.1.40.12 rf-0000-0a01280c ---TRANSACTION 0, not started MySQL thread id 143457, query id 49599008 10.1.108.11 root_ro ---TRANSACTION 14A8981A3, ACTIVE 3 sec starting index read mysql tables in use 1, locked 1 LOCK WAIT 3 lock struct(s), heap size 1248, 2 row lock(s) MySQL thread id 255247, query id 49599523 10.1.106.11 root Updating update ga_ra_user set preferences = NULL where user_name = 'ealvizurez' ------- TRX HAS BEEN WAITING 3 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 0 page no 29250241 n bits 88 index `PRIMARY` of table `radb00`.`ga_ra_user` trx id 14A8981A3 lock_mode X locks rec but not gap waiting Record lock, heap no 4 PHYSICAL RECORD: n_fields 25; compact format; info bits 0 0: len 8; hex 8000000000000209; asc ;; 1: len 6; hex 00014a882b1d; asc J + ;; 2: len 7; hex 6e03f6c01731f8; asc n 1 ;; 3: len 10; hex 65616c76697a7572657a; asc ealvizurez;; 4: len 30; hex 376664663465376163626237646365653131393734643236663136633534; asc 7fdf4e7acbb7dcee11974d26f16c54; (total 40 bytes); 5: len 8; hex 8000124a820322fc; asc J " ;; 6: len 6; hex 676970353031; asc gip501;; 7: len 8; hex 80000000000f42ba; asc B ;; 8: len 8; hex 80000000003d097a; asc = z;; 9: len 6; hex 4576656c796e; asc Evelyn;; 10: len 9; hex 416c76697a7572657a; asc Alvizurez;; 11: len 29; hex 65616c76697a7572657a406772616e64706f696e7462616e6b2e636f6d; asc ealvizurez@grandpointbank.com;; 12: len 12; hex 3231332d3534322d32373632; asc 213-542-2762;; 13: len 27; hex 68747470733a2f2f6769703530312e66726175646d61702e6e6574; asc https://gip501.fraudmap.net;; 14: len 30; hex 626131653135303535613063613139383033356164366664656235366234; asc ba1e15055a0ca198035ad6fdeb56b4; (total 204 bytes); 15: len 8; hex 8000124ca6ca4df5; asc L M ;; 16: len 6; hex 676970353031; asc gip501;; 17: len 4; hex 53484131; asc SHA1;; 18: SQL NULL; 19: len 4; hex 80000000; asc ;; 20: len 30; hex aced000573720023636f6d2e67612e7269736b6170702e757365726d676d; asc sr #com.ga.riskapp.usermgm; (total 1272 bytes); 21: len 1; hex 81; asc ;; 22: SQL NULL; 23: len 8; hex 8000124cacfcf6a7; asc L ;; 24: len 1; hex 81; asc ;; ------------------ ---TRANSACTION 14A89819F, ACTIVE 5 sec starting index read, thread declared inside InnoDB 28 mysql tables in use 610, locked 0 102 lock struct(s), heap size 14776, 2 row lock(s), holds adaptive hash latch MySQL thread id 254592, query id 49599517 10.1.25.11 ra-0000-0a01190b Copying to tmp table select straight_join sf.session_id AS alias0,sf.count_obsrvd AS alias1,sf.risk_session AS alias2,sf.utc_starttime AS alias3,sf.CLIENT_TZ AS alias4,sf.usermodel_id AS alias5,sf.SOURCE_DYN_ENUM AS alias6,sf.IP_ADDRESS AS alias7,sf.TIME_SINCE_LAST AS alias8,sf.DISTANCE_SINCE_LAST AS alias9,sf.LOGIN_RATE_RISK_0 AS alias10,sf.FRAUD_RISK_0 AS alias11,sf.modified_date AS alias12,sf.created_date AS alias13,um.external_user_hash AS alias14,um.external_user_id AS alias15,sf.STYPE AS alias16,sf.NO_SUMMARY_ACT_COUNT AS alias17,ums.last_obsrvd_k AS alias18,sf.cond_risk_1 AS crisk1,sf.marg_risk_1 AS mrisk1 Trx read view will not see trx with id >= 14A8981A0, sees < 14A882B1D ---TRANSACTION 14A89819E, ACTIVE 5 sec MySQL thread id 255252, query id 49599510 10.1.25.11 ra-0000-0a01190b ---TRANSACTION 14A898188, ACTIVE 15 sec starting index read mysql tables in use 1, locked 1 LOCK WAIT 2 lock struct(s), heap size 376, 1 row lock(s) MySQL thread id 255253, query id 49599469 10.1.25.11 ra-0000-0a01190b Updating update ga_ra_user set USER_NAME='ealvizurez', USER_PASSWORD='7fdf4e7acbb7dcee11974d26f16c54e436a915ed', USER_CREATION_DATE='2011-12-18 12:35:16', FIRST_NAME='Evelyn', LAST_NAME='Alvizurez', EMAIL='ealvizurez@grandpointbank.com', PHONE_NUMBER='213-542-2762', FRAUDMAP_URL='https://gip501.fraudmap.net', LAST_PASSWORDS='ba1e15055a0ca198035ad6fdeb56b49cf9f10fee,eebca4eb8a2c65a62427fc179d88ec681cd8d50b,64466806af6bf24c240f99ae554127a66bf14ded,4ce7ff9fd31335e027c8a52ec10e9c6e06508f25,7fdf4e7acbb7dcee11974d26f16c54e436a915ed', LAST_PASSWORD_CHANGE='2012-04-25 09:05:49', LAST_SUB_DOMAIN_NAME='gip501', ------- TRX HAS BEEN WAITING 15 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 0 page no 29250241 n bits 88 index `PRIMARY` of table `radb00`.`ga_ra_user` trx id 14A898188 lock_mode X locks rec but not gap waiting Record lock, heap no 4 PHYSICAL RECORD: n_fields 25; compact format; info bits 0 0: len 8; hex 8000000000000209; asc ;; 1: len 6; hex 00014a882b1d; asc J + ;; 2: len 7; hex 6e03f6c01731f8; asc n 1 ;; 3: len 10; hex 65616c76697a7572657a; asc ealvizurez;; 4: len 30; hex 376664663465376163626237646365653131393734643236663136633534; asc 7fdf4e7acbb7dcee11974d26f16c54; (total 40 bytes); 5: len 8; hex 8000124a820322fc; asc J " ;; 6: len 6; hex 676970353031; asc gip501;; 7: len 8; hex 80000000000f42ba; asc B ;; 8: len 8; hex 80000000003d097a; asc = z;; 9: len 6; hex 4576656c796e; asc Evelyn;; 10: len 9; hex 416c76697a7572657a; asc Alvizurez;; 11: len 29; hex 65616c76697a7572657a406772616e64706f696e7462616e6b2e636f6d; asc ealvizurez@grandpointbank.com;; 12: len 12; hex 3231332d3534322d32373632; asc 213-542-2762;; 13: len 27; hex 68747470733a2f2f6769703530312e66726175646d61702e6e6574; asc https://gip501.fraudmap.net;; 14: len 30; hex 626131653135303535613063613139383033356164366664656235366234; asc ba1e15055a0ca198035ad6fdeb56b4; (total 204 bytes); 15: len 8; hex 8000124ca6ca4df5; asc L M ;; 16: len 6; hex 676970353031; asc gip501;; 17: len 4; hex 53484131; asc SHA1;; 18: SQL NULL; 19: len 4; hex 80000000; asc ;; 20: len 30; hex aced000573720023636f6d2e67612e7269736b6170702e757365726d676d; asc sr #com.ga.riskapp.usermgm; (total 1272 bytes); 21: len 1; hex 81; asc ;; 22: SQL NULL; 23: len 8; hex 8000124cacfcf6a7; asc L ;; 24: len 1; hex 81; asc ;; ------------------ ---TRANSACTION 14A882B1D, ACTIVE 13678 sec 2 lock struct(s), heap size 376, 2 row lock(s), undo log entries 2 MySQL thread id 254593, query id 49152632 10.1.25.11 ra-0000-0a01190b -------- 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 21462835 OS file reads, 33469635 OS file writes, 1518770 OS fsyncs 1 pending preads, 0 pending pwrites 24.41 reads/s, 16384 avg bytes/read, 2.82 writes/s, 0.45 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 5, seg size 7, 115342 merges merged operations: insert 349409, delete mark 6, delete 0 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 254997277, node heap has 79189 buffer(s) 58.09 hash searches/s, 1303.08 non-hash searches/s --- LOG --- Log sequence number 9901219478055 Log flushed up to 9901219477723 Last checkpoint at 9901219475906 0 pending log writes, 0 pending chkp writes 2056541 log i/o's done, 0.91 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 131868917760; in additional pool allocated 0 Dictionary memory allocated 75108878 Buffer pool size 7864320 Free buffers 0 Database pages 7785131 Old database pages 2873788 Modified db pages 18 Pending reads 1 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 25836252, not young 31763148 15.36 youngs/s, 26.18 non-youngs/s Pages read 21629309, created 6453929, written 63891195 24.41 reads/s, 0.00 creates/s, 2.00 writes/s Buffer pool hit rate 995 / 1000, young-making rate 3 / 1000 not 5 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s LRU len: 7785131, unzip_LRU len: 0 I/O sum[837]:cur[32], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 1 queries inside InnoDB, 0 queries in queue 2 read views open inside InnoDB Main thread id 16, state: sleeping Number of rows inserted 655178617, updated 29545386, deleted 5391621, read 85184280255 0.55 inserts/s, 0.05 updates/s, 0.00 deletes/s, 862.78 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================