*************************** 1. row *************************** Type: InnoDB Name: Status: ===================================== 100816 22:13:02 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 3 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 356874338, signal count 251813791 --Thread 652259 has waited at buf/buf0flu.c line 413 for 1.00 seconds the semaphore: Mutex at 17508a8 created file trx/trx0sys.c line 105, lock var 1 waiters flag 1 Mutex spin waits 0, rounds 16194703480, OS waits 135724255 RW-shared spins 60923019, OS waits 26827411; RW-excl spins 342912796, OS waits 164580571 ------------ TRANSACTIONS ------------ Trx id counter 0 2415564401 Purge done for trx's n:o < 0 2415559250 undo n:o < 0 0 History list length 2409 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 0, not started, OS thread id 652298 MySQL thread id 1205070, query id 1261102751 localhost 127.0.0.1 service_manager show engine innodb status ---TRANSACTION 0 2415564384, not started, OS thread id 652208 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 1205063, query id 1261102724 localhost 127.0.0.1 service_manager Updating update inventory_instance_attributes set supported=1, frequency=1000, insert_count=0, latest_save_time=1281989581415, latest_string_value='true', latest_double_value=null, latest_long_value=null where instance_attribute_id=260298 ---TRANSACTION 0 2415564373, not started, OS thread id 652265 waiting in InnoDB queue mysql tables in use 132, locked 66 MySQL thread id 1205061, query id 1261102710 localhost 127.0.0.1 service_manager optimizing CALL dc_string_insert(235005, 1281989581245, 'true') ---TRANSACTION 0 2415564319, not started, OS thread id 652279 waiting in InnoDB queue mysql tables in use 7, locked 0 MySQL thread id 1205050, query id 1261102644 localhost 127.0.0.1 service_manager statistics select this_.instance_id as instance1_5_2_, this_.instance_name as instance2_5_2_, this_.type_id as type3_5_2_, this_.parent_id as parent4_5_2_, this_.insert_count as insert5_5_2_, (select concat(inv_ns.namespace, '.', t.type_name) from inventory_namespaces inv_ns join inventory_types t on (inv_ns.namespace_id=t.namespace_id) where t.type_id=this_.type_id) as clazz_2_, hibtype2_.type_id as type1_3_0_, hibtype2_.type_name as type2_3_0_, hibtype2_.namespace_id as namespace3_3_0_, hibtype2_.insert_count as insert4_3_0_, ---TRANSACTION 0 2415564299, not started, OS thread id 652269 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 1205047, query id 1261102646 localhost 127.0.0.1 service_manager Updating update inventory_instance_attributes set supported=1, frequency=300000, insert_count=0, latest_save_time=1281989581408, latest_string_value=null, latest_double_value=null, latest_long_value=3347 where instance_attribute_id=247746 ---TRANSACTION 0 2415564333, not started, OS thread id 652282 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 1205046, query id 1261102620 localhost 127.0.0.1 service_manager Updating update inventory_instance_attributes set supported=1, frequency=1000, insert_count=0, latest_save_time=1281989581666, latest_string_value='true', latest_double_value=null, latest_long_value=null where instance_attribute_id=234470 ---TRANSACTION 0 2415564358, not started, OS thread id 652150 waiting in InnoDB queue mysql tables in use 66, locked 66 MySQL thread id 1205045, query id 1261102742 localhost 127.0.0.1 service_manager update INSERT IGNORE INTO dc_p_long (instance_attribute_id, end_time, value) VALUES (2566681,1281989168713,0) ---TRANSACTION 0 2415564370, not started, OS thread id 652276 waiting in InnoDB queue mysql tables in use 132, locked 66 MySQL thread id 1205043, query id 1261102702 localhost 127.0.0.1 service_manager optimizing CALL dc_string_insert(260251, 1281989581188, 'true') ---TRANSACTION 0 2415564356, not started, OS thread id 652268 waiting in InnoDB queue mysql tables in use 7, locked 0 MySQL thread id 1205036, query id 1261102610 localhost 127.0.0.1 service_manager statistics select hibinvento0_.instance_id as instance1_5_2_, hibinvento0_.instance_name as instance2_5_2_, hibinvento0_.type_id as type3_5_2_, hibinvento0_.parent_id as parent4_5_2_, hibinvento0_.insert_count as insert5_5_2_, (select concat(inv_ns.namespace, '.', t.type_name) from inventory_namespaces inv_ns join inventory_types t on (inv_ns.namespace_id=t.namespace_id) where t.type_id=hibinvento0_.type_id) as clazz_2_, hibtype1_.type_id as type1_3_0_, hibtype1_.type_name as type2_3_0_, hibtype1_.namespace_id as namespace3_3_0_, hibty ---TRANSACTION 0 2415564383, not started, OS thread id 652216 waiting in InnoDB queue mysql tables in use 132, locked 66 MySQL thread id 1205023, query id 1261102741 localhost 127.0.0.1 service_manager optimizing CALL dc_string_insert(256739, 1281989581376, 'true') ---TRANSACTION 0 2415564255, not started, OS thread id 652159 waiting in InnoDB queue mysql tables in use 66, locked 66 MySQL thread id 1205022, query id 1261102617 localhost 127.0.0.1 service_manager update INSERT IGNORE INTO dc_p_long (instance_attribute_id, end_time, value) VALUES (604630,1281989052896,3696934912) ---TRANSACTION 0 2415564380, not started, OS thread id 652146 waiting in InnoDB queue mysql tables in use 132, locked 66 MySQL thread id 1205020, query id 1261102722 localhost 127.0.0.1 service_manager optimizing CALL dc_string_insert(230317, 1281989581434, 'true') ---TRANSACTION 0 2415564170, not started, OS thread id 652199 waiting in InnoDB queue mysql tables in use 66, locked 66 MySQL thread id 1204994, query id 1261102619 localhost 127.0.0.1 service_manager update INSERT IGNORE INTO dc_p_long (instance_attribute_id, end_time, value) VALUES (2615886,1281989356771,0) ---TRANSACTION 0 2415564033, not started, OS thread id 652238 waiting in InnoDB queue mysql tables in use 66, locked 66 MySQL thread id 1204991, query id 1261102625 localhost 127.0.0.1 service_manager update INSERT IGNORE INTO dc_p_double (instance_attribute_id, end_time, value) VALUES (590155,1281989298350,1.949) ---TRANSACTION 0 2415564290, not started, OS thread id 652285 waiting in InnoDB queue mysql tables in use 132, locked 66 MySQL thread id 1204992, query id 1261102616 localhost 127.0.0.1 service_manager optimizing CALL dc_string_insert(2678960, 1281989409888, '\\\\\n* \'msandbox\'') ---TRANSACTION 0 2415564289, not started, OS thread id 652274 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 1204983, query id 1261102621 localhost 127.0.0.1 service_manager Updating update inventory_instance_attributes set supported=1, frequency=1000, insert_count=0, latest_save_time=1281989581691, latest_string_value='true', latest_double_value=null, latest_long_value=null where instance_attribute_id=235515 ---TRANSACTION 0 2415564357, not started, OS thread id 652267 waiting in InnoDB queue mysql tables in use 66, locked 66 MySQL thread id 1204978, query id 1261102723 localhost 127.0.0.1 service_manager update INSERT IGNORE INTO dc_p_long (instance_attribute_id, end_time, value) VALUES (547151,1281989528817,3694051328) ---TRANSACTION 0 2415564381, not started, OS thread id 652227 waiting in InnoDB queue mysql tables in use 7, locked 0 MySQL thread id 1204974, query id 1261102725 localhost 127.0.0.1 service_manager statistics select hibinvento0_.instance_id as instance1_5_2_, hibinvento0_.instance_name as instance2_5_2_, hibinvento0_.type_id as type3_5_2_, hibinvento0_.parent_id as parent4_5_2_, hibinvento0_.insert_count as insert5_5_2_, (select concat(inv_ns.namespace, '.', t.type_name) from inventory_namespaces inv_ns join inventory_types t on (inv_ns.namespace_id=t.namespace_id) where t.type_id=hibinvento0_.type_id) as clazz_2_, hibtype1_.type_id as type1_3_0_, hibtype1_.type_name as type2_3_0_, hibtype1_.namespace_id as namespace3_3_0_, hibty ---TRANSACTION 0 2415564272, not started, OS thread id 652294 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 1204969, query id 1261102635 localhost 127.0.0.1 service_manager Updating update inventory_instance_attributes set supported=1, frequency=300000, insert_count=0, latest_save_time=1281989413248, latest_string_value=null, latest_double_value=null, latest_long_value=null where instance_attribute_id=2644062 ---TRANSACTION 0 2415564376, not started, OS thread id 652258 waiting in InnoDB queue mysql tables in use 132, locked 66 MySQL thread id 1204938, query id 1261102732 localhost 127.0.0.1 service_manager optimizing CALL dc_string_insert(256109, 1281989581534, 'true') ---TRANSACTION 0 2415564372, not started, OS thread id 652200 waiting in InnoDB queue mysql tables in use 66, locked 66 MySQL thread id 1204920, query id 1261102726 localhost 127.0.0.1 service_manager update INSERT IGNORE INTO dc_p_long (instance_attribute_id, end_time, value) VALUES (301914,1281989522054,253509) ---TRANSACTION 0 2415564377, not started, OS thread id 652195 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 1204917, query id 1261102749 localhost 127.0.0.1 service_manager Updating update inventory_instance_attributes set supported=1, frequency=1000, insert_count=0, latest_save_time=1281989582039, latest_string_value='true', latest_double_value=null, latest_long_value=null where instance_attribute_id=2949154 ---TRANSACTION 0 2415564375, not started, OS thread id 652286 waiting in InnoDB queue mysql tables in use 132, locked 66 MySQL thread id 1204905, query id 1261102716 localhost 127.0.0.1 service_manager optimizing CALL dc_string_insert(238200, 1281989581495, 'true') ---TRANSACTION 0 2415564345, not started, OS thread id 652287 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 1204896, query id 1261102627 localhost 127.0.0.1 service_manager Updating update inventory_instance_attributes set supported=1, frequency=1000, insert_count=0, latest_save_time=1281989581685, latest_string_value='true', latest_double_value=null, latest_long_value=null where instance_attribute_id=259895 ---TRANSACTION 0 2415564387, not started, OS thread id 652253 waiting in InnoDB queue mysql tables in use 7, locked 0 MySQL thread id 1204892, query id 1261102748 localhost 127.0.0.1 service_manager statistics select this_.instance_id as instance1_5_2_, this_.instance_name as instance2_5_2_, this_.type_id as type3_5_2_, this_.parent_id as parent4_5_2_, this_.insert_count as insert5_5_2_, (select concat(inv_ns.namespace, '.', t.type_name) from inventory_namespaces inv_ns join inventory_types t on (inv_ns.namespace_id=t.namespace_id) where t.type_id=this_.type_id) as clazz_2_, hibtype2_.type_id as type1_3_0_, hibtype2_.type_name as type2_3_0_, hibtype2_.namespace_id as namespace3_3_0_, hibtype2_.insert_count as insert4_3_0_, ---TRANSACTION 0 2415564340, not started, OS thread id 652283 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 1204869, query id 1261102639 localhost 127.0.0.1 service_manager Updating update inventory_instance_attributes set supported=1, frequency=1000, insert_count=0, latest_save_time=1281989581659, latest_string_value='true', latest_double_value=null, latest_long_value=null where instance_attribute_id=260206 ---TRANSACTION 0 2415564378, not started, OS thread id 652275 waiting in InnoDB queue mysql tables in use 66, locked 66 MySQL thread id 1204855, query id 1261102735 localhost 127.0.0.1 service_manager update INSERT IGNORE INTO dc_p_long (instance_attribute_id, end_time, value) VALUES (406067,1281989400259,237873) ---TRANSACTION 0 2415564330, not started, OS thread id 652247 waiting in InnoDB queue mysql tables in use 66, locked 66 MySQL thread id 1204760, query id 1261102640 localhost 127.0.0.1 service_manager update INSERT IGNORE INTO dc_p_double (instance_attribute_id, end_time, value) VALUES (610424,1281989532581,1.953) ---TRANSACTION 0 2415564253, not started, OS thread id 652168 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 1204736, query id 1261102643 localhost 127.0.0.1 service_manager Updating update inventory_instance_attributes set supported=1, frequency=1000, insert_count=0, latest_save_time=1281989581436, latest_string_value='true', latest_double_value=null, latest_long_value=null where instance_attribute_id=252766 ---TRANSACTION 0 0, not started, OS thread id 651185 updating table statistics MySQL thread id 1201410, query id 1261095288 localhost 127.0.0.1 service_manager SELECT COUNT(*) AS partitions_count FROM information_schema.PARTITIONS WHERE table_schema like "mem" and table_name like 'dc_p_long' ---TRANSACTION 0 2415564390, ACTIVE 0 sec, OS thread id 652288 inserting, thread declared inside InnoDB 500 mysql tables in use 66, locked 66 1 lock struct(s), heap size 368, 0 row lock(s) MySQL thread id 1204941, query id 1261102595 localhost 127.0.0.1 service_manager update INSERT IGNORE INTO dc_p_long (instance_attribute_id, end_time, value) VALUES (2646077,1281988926265,0) ---TRANSACTION 0 2415564389, ACTIVE 0 sec, OS thread id 652203 waiting in InnoDB queue mysql tables in use 4, locked 0 MySQL thread id 1205037, query id 1261102605 localhost 127.0.0.1 service_manager statistics select this_.instance_id as instance1_5_2_, this_.instance_name as instance2_5_2_, this_.type_id as type3_5_2_, this_.parent_id as parent4_5_2_, this_.insert_count as insert5_5_2_, (select concat(inv_ns.namespace, '.', t.type_name) from inventory_namespaces inv_ns join inventory_types t on (inv_ns.namespace_id=t.namespace_id) where t.type_id=this_.type_id) as clazz_2_, hibtype2_.type_id as type1_3_0_, hibtype2_.type_name as type2_3_0_, hibtype2_.namespace_id as namespace3_3_0_, hibtype2_.insert_count as insert4_3_0_, Trx read view will not see trx with id >= 0 2415564390, sees < 0 2415563146 ---TRANSACTION 0 2415564388, ACTIVE 0 sec, OS thread id 652293 inserting, thread declared inside InnoDB 500 mysql tables in use 66, locked 66 1 lock struct(s), heap size 368, 0 row lock(s) MySQL thread id 1204970, query id 1261102588 localhost 127.0.0.1 service_manager update INSERT IGNORE INTO dc_p_long (instance_attribute_id, end_time, value) VALUES (1023479,1281989411749,15207104512) ---TRANSACTION 0 2415564386, ACTIVE 0 sec, OS thread id 652297 waiting in InnoDB queue 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 1205054, query id 1261102693 localhost 127.0.0.1 service_manager Updating update inventory_instance_attributes set supported=1, frequency=60000, insert_count=0, latest_save_time=1281989530736, latest_string_value=null, latest_double_value=null, latest_long_value=0 where instance_attribute_id=2571653 ---TRANSACTION 0 2415564385, ACTIVE 0 sec, OS thread id 651935 waiting in InnoDB queue mysql tables in use 1, locked 1 2 lock struct(s), heap size 368, 1 row lock(s), undo log entries 1 MySQL thread id 1204575, query id 1261102692 localhost 127.0.0.1 service_manager Updating update inventory_instance_attributes set supported=1, frequency=60000, insert_count=0, latest_save_time=1281988933230, latest_string_value=null, latest_double_value=1.957, latest_long_value=null where instance_attribute_id=264649 ---TRANSACTION 0 2415564382, ACTIVE 0 sec, OS thread id 652271 waiting in InnoDB queue mysql tables in use 1, locked 1 2 lock struct(s), heap size 368, 1 row lock(s), undo log entries 1 MySQL thread id 1204895, query id 1261102689 localhost 127.0.0.1 service_manager Updating update inventory_instance_attributes set supported=1, frequency=60000, insert_count=0, latest_save_time=1281989344450, latest_string_value=null, latest_double_value=null, latest_long_value=106 where instance_attribute_id=2634478 ---TRANSACTION 0 2415564379, ACTIVE 0 sec, OS thread id 652233 waiting in InnoDB queue mysql tables in use 66, locked 66 2 lock struct(s), heap size 368, 1 row lock(s) MySQL thread id 1204988, query id 1261102663 localhost 127.0.0.1 service_manager Searching rows for update UPDATE dc_p_string SET end_time = NAME_CONST('ins_end_time',1281989581362), value_count = ( NAME_CONST('last_value_count',1802) + 1) WHERE instance_attribute_id = NAME_CONST('ins_instance_attribute_id',230753) AND end_time = NAME_CONST('last_endtime',1281989578157) Trx read view will not see trx with id >= 0 2415564380, sees < 0 2415563146 ---TRANSACTION 0 2415564374, ACTIVE 0 sec, OS thread id 652166 waiting in InnoDB queue 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 1204971, query id 1261102683 localhost 127.0.0.1 service_manager Updating update inventory_instance_attributes set supported=1, frequency=60000, insert_count=0, latest_save_time=1281989286797, latest_string_value=null, latest_double_value=null, latest_long_value=0 where instance_attribute_id=403625 ---TRANSACTION 0 2415564371, ACTIVE 0 sec, OS thread id 652255 waiting in InnoDB queue mysql tables in use 66, locked 66 2 lock struct(s), heap size 368, 1 row lock(s) MySQL thread id 1205062, query id 1261102655 localhost 127.0.0.1 service_manager Searching rows for update UPDATE dc_p_string SET end_time = NAME_CONST('ins_end_time',1281989581453), value_count = ( NAME_CONST('last_value_count',1658) + 1) WHERE instance_attribute_id = NAME_CONST('ins_instance_attribute_id',259967) AND end_time = NAME_CONST('last_endtime',1281989574045) Trx read view will not see trx with id >= 0 2415564372, sees < 0 2415563146 ---TRANSACTION 0 2415564369, ACTIVE 0 sec, OS thread id 652260 waiting in InnoDB queue mysql tables in use 66, locked 66 2 lock struct(s), heap size 368, 1 row lock(s), undo log entries 1 MySQL thread id 1204639, query id 1261102676 localhost 127.0.0.1 service_manager update INSERT IGNORE INTO dc_p_long (instance_attribute_id, end_time, value) VALUES (2676930,1281989538926,0) ---TRANSACTION 0 2415564368, ACTIVE 0 sec, OS thread id 652107 inserting, thread declared inside InnoDB 500 mysql tables in use 66, locked 66 1 lock struct(s), heap size 368, 0 row lock(s) MySQL thread id 1205040, query id 1261102509 localhost 127.0.0.1 service_manager update INSERT IGNORE INTO dc_p_long (instance_attribute_id, end_time, value) VALUES (2631999,1281989422014,1) ---TRANSACTION 0 2415564359, ACTIVE 1 sec, OS thread id 652147 waiting in InnoDB queue mysql tables in use 1, locked 1 2 lock struct(s), heap size 368, 2 row lock(s), undo log entries 2 MySQL thread id 1204990, query id 1261102675 localhost 127.0.0.1 service_manager Updating update inventory_instance_attributes set supported=1, frequency=60000, insert_count=0, latest_save_time=1281989537004, latest_string_value='', latest_double_value=null, latest_long_value=null where instance_attribute_id=2658792 ---TRANSACTION 0 2415564354, ACTIVE 1 sec, OS thread id 652262 inserting, thread declared inside InnoDB 500 mysql tables in use 66, locked 66 1 lock struct(s), heap size 368, 0 row lock(s) MySQL thread id 1204916, query id 1261102497 localhost 127.0.0.1 service_manager update INSERT IGNORE INTO dc_p_long (instance_attribute_id, end_time, value) VALUES (327038,1281988927767,8699650048) ---TRANSACTION 0 2415564343, ACTIVE 1 sec, OS thread id 652259 inserting, thread declared inside InnoDB 500 mysql tables in use 66, locked 66 1 lock struct(s), heap size 368, 0 row lock(s) MySQL thread id 1205042, query id 1261102457 localhost 127.0.0.1 service_manager update INSERT IGNORE INTO dc_p_long (instance_attribute_id, end_time, value) VALUES (602648,1281989111867,0) ---TRANSACTION 0 2415564341, ACTIVE 1 sec, OS thread id 652201 waiting in InnoDB queue mysql tables in use 132, locked 66 MySQL thread id 1204719, query id 1261102565 localhost 127.0.0.1 service_manager optimizing CALL dc_string_insert(388913, 1281989113457, '129.159.117.160') Trx read view will not see trx with id >= 0 2415564342, sees < 0 2415563146 ---TRANSACTION 0 2415564337, ACTIVE 1 sec, OS thread id 652296 inserting, thread declared inside InnoDB 500 mysql tables in use 66, locked 66 1 lock struct(s), heap size 368, 0 row lock(s) MySQL thread id 1205053, query id 1261102525 localhost 127.0.0.1 service_manager update INSERT IGNORE INTO dc_p_long (instance_attribute_id, end_time, value) VALUES (673202,1281989418885,4966965248) Trx read view will not see trx with id >= 0 2415564338, sees < 0 2415563146 ---TRANSACTION 0 2415564312, ACTIVE 1 sec, OS thread id 652290 waiting in InnoDB queue mysql tables in use 1, locked 0 2 lock struct(s), heap size 368, 4 row lock(s), undo log entries 4 MySQL thread id 1204954, query id 1261102656 localhost 127.0.0.1 service_manager statistics select this_.instance_attribute_id as instance1_6_0_, this_.instance_id as instance2_6_0_, this_.attribute_id as attribute3_6_0_, this_.supported as supported6_0_, this_.frequency as frequency6_0_, this_.insert_count as insert6_6_0_, this_.latest_save_time as latest7_6_0_, this_.latest_string_value as latest8_6_0_, this_.latest_double_value as latest9_6_0_, this_.latest_long_value as latest10_6_0_ from inventory_instance_attributes this_ where (this_.instance_id=657727 and this_.attribute_id=272) ---TRANSACTION 0 2415564256, ACTIVE 1 sec, OS thread id 652065 waiting in InnoDB queue mysql tables in use 1, locked 1 3 lock struct(s), heap size 1216, 8 row lock(s), undo log entries 8 MySQL thread id 1204979, query id 1261102673 localhost 127.0.0.1 service_manager Updating update inventory_instance_attributes set supported=1, frequency=300000, insert_count=0, latest_save_time=1281989406014, latest_string_value=null, latest_double_value=null, latest_long_value=755 where instance_attribute_id=2660098 ---TRANSACTION 0 2415564236, ACTIVE 1 sec, OS thread id 652295 waiting in InnoDB queue mysql tables in use 1, locked 1 2 lock struct(s), heap size 368, 9 row lock(s), undo log entries 9 MySQL thread id 1205051, query id 1261102674 localhost 127.0.0.1 service_manager Updating update inventory_instance_attributes set supported=1, frequency=60000, insert_count=0, latest_save_time=1281989413339, latest_string_value=null, latest_double_value=null, latest_long_value=0 where instance_attribute_id=2587213 ---TRANSACTION 0 2415564214, ACTIVE 1 sec, OS thread id 652292 waiting in InnoDB queue mysql tables in use 1, locked 1 3 lock struct(s), heap size 1216, 10 row lock(s), undo log entries 10 MySQL thread id 1204956, query id 1261102661 localhost 127.0.0.1 service_manager Updating update inventory_instance_attributes set supported=1, frequency=300000, insert_count=0, latest_save_time=1281989422815, latest_string_value='ON', latest_double_value=null, latest_long_value=null where instance_attribute_id=2698211 ---TRANSACTION 0 2415564211, ACTIVE 1 sec, OS thread id 652211 waiting in InnoDB queue mysql tables in use 1, locked 1 2 lock struct(s), heap size 368, 10 row lock(s), undo log entries 10 MySQL thread id 1204989, query id 1261102659 localhost 127.0.0.1 service_manager Updating update inventory_instance_attributes set supported=1, frequency=60000, insert_count=0, latest_save_time=1281989530826, latest_string_value=null, latest_double_value=0.0, latest_long_value=null where instance_attribute_id=2684586 ---TRANSACTION 0 2415564205, ACTIVE 1 sec, OS thread id 652206 waiting in InnoDB queue mysql tables in use 66, locked 66 3 lock struct(s), heap size 1216, 1 row lock(s), undo log entries 2 MySQL thread id 1204939, query id 1261102648 localhost 127.0.0.1 service_manager update INSERT IGNORE INTO dc_p_double (instance_attribute_id, end_time, value) VALUES (2655989,1281989533427,10.0) ---TRANSACTION 0 2415564203, ACTIVE 1 sec, OS thread id 652249 waiting in InnoDB queue mysql tables in use 1, locked 1 2 lock struct(s), heap size 368, 10 row lock(s), undo log entries 10 MySQL thread id 1204888, query id 1261102649 localhost 127.0.0.1 service_manager Updating update inventory_instance_attributes set supported=1, frequency=60000, insert_count=0, latest_save_time=1281988873301, latest_string_value=null, latest_double_value=null, latest_long_value=5434 where instance_attribute_id=2581614 ---TRANSACTION 0 2415564105, ACTIVE 1 sec, OS thread id 652280 waiting in InnoDB queue mysql tables in use 66, locked 66 2 lock struct(s), heap size 368, 16 row lock(s), undo log entries 16 MySQL thread id 1205052, query id 1261102657 localhost 127.0.0.1 service_manager update INSERT IGNORE INTO dc_p_double (instance_attribute_id, end_time, value) VALUES (2569457,1281989473029,0.0),(2569486,1281989473029,0.0) ---TRANSACTION 0 2415564096, ACTIVE 1 sec, OS thread id 652242 waiting in InnoDB queue mysql tables in use 1, locked 1 3 lock struct(s), heap size 1216, 14 row lock(s), undo log entries 14 MySQL thread id 1204731, query id 1261102650 localhost 127.0.0.1 service_manager Updating update inventory_instance_attributes set supported=1, frequency=600000, insert_count=0, latest_save_time=1281989420034, latest_string_value=null, latest_double_value=null, latest_long_value=0 where instance_attribute_id=2594847 Trx read view will not see trx with id >= 0 2415564097, sees < 0 2415562456 ---TRANSACTION 0 2415564045, ACTIVE 1 sec, OS thread id 651986 inserting, thread declared inside InnoDB 492 mysql tables in use 66, locked 66 5 lock struct(s), heap size 1216, 16 row lock(s), undo log entries 26 MySQL thread id 1204673, query id 1261102462 localhost 127.0.0.1 service_manager update INSERT IGNORE INTO dc_p_long (instance_attribute_id, end_time, value) VALUES (2633831,1281989472018,17393),(2633819,1281989472018,512),(2633793,1281989472018,19),(2633897,1281989472018,0),(2633799,1281989472018,0),(2633851,1281989472018,3),(2633891,1281989472018,0),(2633853,1281989472018,41),(2633827,1281989472018,0),(2633893,1281989472018,0),(2633900,1281989472018,5567),(2633899,1281989472018,273),(2633901,1281989472018,0),(2633895,1281989472018,0),(2633855,1281989472018,3) ---TRANSACTION 0 2415564012, ACTIVE 1 sec, OS thread id 652229 waiting in InnoDB queue mysql tables in use 1, locked 1 3 lock struct(s), heap size 1216, 21 row lock(s), undo log entries 21 MySQL thread id 1204927, query id 1261102660 localhost 127.0.0.1 service_manager Updating update inventory_instance_attributes set supported=1, frequency=60000, insert_count=0, latest_save_time=1281989231408, latest_string_value=null, latest_double_value=null, latest_long_value=64255 where instance_attribute_id=2596887 ---TRANSACTION 0 2415563902, ACTIVE 1 sec, OS thread id 652291 waiting in InnoDB queue mysql tables in use 1, locked 1 2 lock struct(s), heap size 368, 26 row lock(s), undo log entries 26 MySQL thread id 1204984, query id 1261102651 localhost 127.0.0.1 service_manager Updating update inventory_instance_attributes set supported=1, frequency=60000, insert_count=0, latest_save_time=1281989344329, latest_string_value=null, latest_double_value=null, latest_long_value=0 where instance_attribute_id=2603423 ---TRANSACTION 0 2415563856, ACTIVE 1 sec, OS thread id 652170 waiting in InnoDB queue mysql tables in use 1, locked 1 3 lock struct(s), heap size 1216, 29 row lock(s), undo log entries 29 MySQL thread id 1205067, query id 1261102658 localhost 127.0.0.1 service_manager Updating update inventory_instance_attributes set supported=1, frequency=60000, insert_count=0, latest_save_time=1281989347210, latest_string_value=null, latest_double_value=null, latest_long_value=0 where instance_attribute_id=2621882 ---TRANSACTION 0 2415563851, ACTIVE 1 sec, OS thread id 652248 waiting in InnoDB queue mysql tables in use 1, locked 1 4 lock struct(s), heap size 1216, 29 row lock(s), undo log entries 29 MySQL thread id 1204763, query id 1261102652 localhost 127.0.0.1 service_manager Updating update inventory_instance_attributes set supported=1, frequency=60000, insert_count=0, latest_save_time=1281989185681, latest_string_value=null, latest_double_value=null, latest_long_value=1088337 where instance_attribute_id=2611109 ---TRANSACTION 0 2415563814, ACTIVE 1 sec, OS thread id 652272 waiting in InnoDB queue mysql tables in use 1, locked 1 3 lock struct(s), heap size 1216, 32 row lock(s), undo log entries 32 MySQL thread id 1204909, query id 1261102665 localhost 127.0.0.1 service_manager Updating update inventory_instance_attributes set supported=1, frequency=60000, insert_count=0, latest_save_time=1281989478332, latest_string_value=null, latest_double_value=null, latest_long_value=2 where instance_attribute_id=2584788 ---TRANSACTION 0 2415563763, ACTIVE 1 sec, OS thread id 652278 waiting in InnoDB queue mysql tables in use 1, locked 1 3 lock struct(s), heap size 1216, 35 row lock(s), undo log entries 35 MySQL thread id 1205049, query id 1261102669 localhost 127.0.0.1 service_manager Updating update inventory_instance_attributes set supported=1, frequency=60000, insert_count=0, latest_save_time=1281989345373, latest_string_value=null, latest_double_value=null, latest_long_value=0 where instance_attribute_id=2645518 ---TRANSACTION 0 2415563749, ACTIVE 1 sec, OS thread id 652179 waiting in InnoDB queue mysql tables in use 1, locked 1 3 lock struct(s), heap size 1216, 35 row lock(s), undo log entries 35 MySQL thread id 1205060, query id 1261102653 localhost 127.0.0.1 service_manager Updating update inventory_instance_attributes set supported=1, frequency=60000, insert_count=0, latest_save_time=1281989536382, latest_string_value=null, latest_double_value=null, latest_long_value=0 where instance_attribute_id=2577474 ---TRANSACTION 0 2415563644, ACTIVE 1 sec, OS thread id 652264 waiting in InnoDB queue mysql tables in use 1, locked 1 3 lock struct(s), heap size 1216, 40 row lock(s), undo log entries 40 MySQL thread id 1204945, query id 1261102668 localhost 127.0.0.1 service_manager Updating update inventory_instance_attributes set supported=1, frequency=60000, insert_count=0, latest_save_time=1281989286619, latest_string_value=null, latest_double_value=null, latest_long_value=0 where instance_attribute_id=2661042 ---TRANSACTION 0 2415563640, ACTIVE 1 sec, OS thread id 652213 waiting in InnoDB queue mysql tables in use 1, locked 1 3 lock struct(s), heap size 1216, 40 row lock(s), undo log entries 40 MySQL thread id 1204891, query id 1261102666 localhost 127.0.0.1 service_manager Updating update inventory_instance_attributes set supported=1, frequency=60000, insert_count=0, latest_save_time=1281989473712, latest_string_value=null, latest_double_value=null, latest_long_value=0 where instance_attribute_id=2685721 ---TRANSACTION 0 2415563559, ACTIVE 2 sec, OS thread id 652239 waiting in InnoDB queue mysql tables in use 1, locked 1 3 lock struct(s), heap size 1216, 43 row lock(s), undo log entries 43 MySQL thread id 1204946, query id 1261102671 localhost 127.0.0.1 service_manager Updating update inventory_instance_attributes set supported=1, frequency=60000, insert_count=0, latest_save_time=1281989411338, latest_string_value=null, latest_double_value=null, latest_long_value=6692 where instance_attribute_id=2598597 ---TRANSACTION 0 2415563534, ACTIVE 2 sec, OS thread id 652257 waiting in InnoDB queue mysql tables in use 1, locked 1 4 lock struct(s), heap size 1216, 16 row lock(s), undo log entries 33 MySQL thread id 1204928, query id 1261102647 localhost 127.0.0.1 service_manager Updating update inventory_instance_attributes set supported=1, frequency=60000, insert_count=0, latest_save_time=1281989355920, latest_string_value=null, latest_double_value=null, latest_long_value=3 where instance_attribute_id=2559953 ---TRANSACTION 0 2415563447, ACTIVE 2 sec, OS thread id 652284 waiting in InnoDB queue mysql tables in use 1, locked 1 4 lock struct(s), heap size 1216, 41 row lock(s), undo log entries 83 MySQL thread id 1204870, query id 1261102678 localhost 127.0.0.1 service_manager Updating update inventory_instance_attributes set supported=1, frequency=60000, insert_count=0, latest_save_time=1281989063565, latest_string_value=null, latest_double_value=null, latest_long_value=14 where instance_attribute_id=2610020 ---TRANSACTION 0 2415563389, ACTIVE 2 sec, OS thread id 652277 waiting in InnoDB queue mysql tables in use 1, locked 1 4 lock struct(s), heap size 1216, 52 row lock(s), undo log entries 52 MySQL thread id 1204987, query id 1261102667 localhost 127.0.0.1 service_manager Updating update inventory_instance_attributes set supported=1, frequency=60000, insert_count=0, latest_save_time=1281989228417, latest_string_value=null, latest_double_value=null, latest_long_value=0 where instance_attribute_id=2657123 ---TRANSACTION 0 2415563338, ACTIVE 2 sec, OS thread id 652266 waiting in InnoDB queue mysql tables in use 1, locked 1 4 lock struct(s), heap size 1216, 54 row lock(s), undo log entries 54 MySQL thread id 1205039, query id 1261102670 localhost 127.0.0.1 service_manager Updating update inventory_instance_attributes set supported=1, frequency=300000, insert_count=0, latest_save_time=1281989124078, latest_string_value=null, latest_double_value=null, latest_long_value=0 where instance_attribute_id=2594094 ---TRANSACTION 0 2415563268, ACTIVE 2 sec, OS thread id 652234 inserting, thread declared inside InnoDB 459 mysql tables in use 66, locked 66 4 lock struct(s), heap size 1216, 53 row lock(s), undo log entries 94 MySQL thread id 1204943, query id 1261102343 localhost 127.0.0.1 service_manager update INSERT IGNORE INTO dc_p_long (instance_attribute_id, end_time, value) VALUES (2575417,1281989232709,124307),(2575434,1281989232709,77),(2575253,1281989232709,0),(2575539,1281989232709,0),(2575313,1281989232709,0),(2575395,1281989232709,0),(2575540,1281989232709,1),(2575312,1281989232709,0),(2575329,1281989232709,0),(2575435,1281989232709,12),(2575257,1281989232709,93481037),(2575543,1281989232709,8233837),(2575419,1281989232709,0),(2575542,1281989232709,1),(2575534,1281989232709,189874),(2575292,1281989232709,0),(2575491,1281989232709,0),(2575415,1281989232709,91281),(2575510,1281989232709,0), ---TRANSACTION 0 2415563146, ACTIVE 3 sec, OS thread id 652240 waiting in InnoDB queue mysql tables in use 1, locked 1 3 lock struct(s), heap size 1216, 55 row lock(s), undo log entries 55 MySQL thread id 1205048, query id 1261102664 localhost 127.0.0.1 service_manager Updating update inventory_instance_attributes set supported=1, frequency=60000, insert_count=0, latest_save_time=1281989416433, latest_string_value=null, latest_double_value=null, latest_long_value=0 where instance_attribute_id=2688250 Trx read view will not see trx with id >= 0 2415563147, sees < 0 2415561375 -------- 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: 1 62551247 OS file reads, 233214721 OS file writes, 4511345 OS fsyncs 176.61 reads/s, 16384 avg bytes/read, 332.56 writes/s, 5.66 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 74, seg size 76, 673745 inserts, 673605 merged recs, 62218 merges Hash table size 1106407, node heap has 449 buffer(s) 827.06 hash searches/s, 6173.28 non-hash searches/s --- LOG --- Log sequence number 158 3252974835 Log flushed up to 158 3252723452 Last checkpoint at 158 3232659991 0 pending log writes, 0 pending chkp writes 185863219 log i/o's done, 231.92 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 633838842; in additional pool allocated 1048576 Dictionary memory allocated 2070848 Buffer pool size 32768 Free buffers 0 Database pages 32319 Modified db pages 21571 Pending reads 0 Pending writes: LRU 2, flush list 1, single page 0 Pages read 66895732, created 2574771, written 107470543 176.61 reads/s, 2.33 creates/s, 203.60 writes/s Buffer pool hit rate 993 / 1000 -------------- ROW OPERATIONS -------------- 8 queries inside InnoDB, 62 queries in queue 8 read views open inside InnoDB Main thread id 10, state: making checkpoint Number of rows inserted 249664825, updated 363188836, deleted 2870005, read 4166475343 403.53 inserts/s, 655.45 updates/s, 0.00 deletes/s, 3177.27 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================