170705 14:36:13 [Note] Plugin 'FEDERATED' is disabled. 170705 14:36:14 InnoDB: The InnoDB memory heap is disabled 170705 14:36:14 InnoDB: Mutexes and rw_locks use Windows interlocked functions 170705 14:36:14 InnoDB: Compressed tables use zlib 1.2.3 170705 14:36:14 InnoDB: Initializing buffer pool, size = 512.0M 170705 14:36:14 InnoDB: Completed initialization of buffer pool 170705 14:36:15 InnoDB: Log file C:\AppDynamics\Controller\db\data\ib_logfile0 did not exist: new to be created InnoDB: Setting log file C:\AppDynamics\Controller\db\data\ib_logfile0 size to 512 MB InnoDB: Database physically writes the file full: wait... InnoDB: Progress in MB: 100 200 300 400 500 170705 14:37:05 InnoDB: Log file C:\AppDynamics\Controller\db\data\ib_logfile1 did not exist: new to be created InnoDB: Setting log file C:\AppDynamics\Controller\db\data\ib_logfile1 size to 512 MB InnoDB: Database physically writes the file full: wait... InnoDB: Progress in MB: 100 200 300 400 500 170705 14:37:24 InnoDB: highest supported file format is Barracuda. InnoDB: The log sequence number in ibdata files does not match InnoDB: the log sequence number in the ib_logfiles! 170705 14:37:24 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 170705 14:38:01 InnoDB: Waiting for the background threads to start 170705 14:38:02 InnoDB: 5.5.54 started; log sequence number 17427468 170705 14:38:02 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3388 170705 14:38:02 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 170705 14:38:02 [Note] Server socket created on IP: '0.0.0.0'. 170705 14:38:02 [Note] Event Scheduler: Loaded 0 events 170705 14:38:02 [Note] C:\AppDynamics\Controller\db\bin\mysqld.exe: ready for connections. Version: '5.5.54-enterprise-commercial-advanced-log' socket: '' port: 3388 MySQL Enterprise Server - Advanced Edition (Commercial) 170705 15:28:57 [Note] C:\AppDynamics\Controller\db\bin\mysqld.exe: Normal shutdown 170705 15:29:03 [Note] Event Scheduler: Purging the queue. 0 events 170705 15:29:05 [Warning] C:\AppDynamics\Controller\db\bin\mysqld.exe: Forcing close of thread 38 user: 'controller' 170705 15:29:05 [Warning] C:\AppDynamics\Controller\db\bin\mysqld.exe: Forcing close of thread 11 user: 'root' 170705 15:29:17 InnoDB: Starting shutdown... 170705 15:29:51 InnoDB: Shutdown completed; log sequence number 34862928 170705 15:29:54 [Note] C:\AppDynamics\Controller\db\bin\mysqld.exe: Shutdown complete 170705 15:31:24 [Note] Plugin 'FEDERATED' is disabled. 170705 15:31:24 InnoDB: The InnoDB memory heap is disabled 170705 15:31:24 InnoDB: Mutexes and rw_locks use Windows interlocked functions 170705 15:31:24 InnoDB: Compressed tables use zlib 1.2.3 170705 15:31:24 InnoDB: Initializing buffer pool, size = 512.0M 170705 15:31:24 InnoDB: Completed initialization of buffer pool 170705 15:31:25 InnoDB: highest supported file format is Barracuda. 170705 15:31:27 InnoDB: Waiting for the background threads to start 170705 15:31:28 InnoDB: 5.5.54 started; log sequence number 34862928 170705 15:31:28 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3388 170705 15:31:28 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 170705 15:31:28 [Note] Server socket created on IP: '0.0.0.0'. 170705 15:31:29 [Note] Event Scheduler: Loaded 0 events 170705 15:31:29 [Note] C:\AppDynamics\Controller\db\bin\mysqld.exe: ready for connections. Version: '5.5.54-enterprise-commercial-advanced-log' socket: '' port: 3388 MySQL Enterprise Server - Advanced Edition (Commercial) InnoDB: Warning: a long semaphore wait: --Thread 8016 has waited at dict0dict.c line 777 for 31316.00 seconds the semaphore: Mutex at 0000000005E4CAE8 created file dict0dict.c line 731, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 11752 has waited at dict0dict.c line 777 for 31317.00 seconds the semaphore: Mutex at 0000000005E4CAE8 created file dict0dict.c line 731, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 10204 has waited at dict0dict.c line 357 for 31315.00 seconds the semaphore: Mutex at 0000000005E4CAE8 created file dict0dict.c line 731, lock var 1 waiters flag 1 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 ===================================== 170706 10:41:15 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 4 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 17548 1_second, 17545 sleeps, 1621 10_second, 1347 background, 1347 flush srv_master_thread log flush and writes: 17657 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 3276, signal count 2499 --Thread 8016 has waited at dict0dict.c line 777 for 31318.00 seconds the semaphore: Mutex at 0000000005E4CAE8 created file dict0dict.c line 731, lock var 1 waiters flag 1 --Thread 11752 has waited at dict0dict.c line 777 for 31318.00 seconds the semaphore: Mutex at 0000000005E4CAE8 created file dict0dict.c line 731, lock var 1 waiters flag 1 --Thread 10204 has waited at dict0dict.c line 357 for 31316.00 seconds the semaphore: Mutex at 0000000005E4CAE8 created file dict0dict.c line 731, lock var 1 waiters flag 1 --Thread 13704 has waited at buf0buf.c line 2272 for 0.00 seconds the semaphore: Mutex at 0000000006098C28 created file buf0buf.c line 1188, lock var 1 waiters flag 1 --Thread 10236 has waited at dict0dict.c line 777 for 1.00 seconds the semaphore: Mutex at 0000000005E4CAE8 created file dict0dict.c line 731, lock var 1 waiters flag 1 --Thread 13732 has waited at dict0dict.c line 777 for 1.00 seconds the semaphore: Mutex at 0000000005E4CAE8 created file dict0dict.c line 731, lock var 1 waiters flag 1 --Thread 5716 has waited at dict0dict.c line 777 for 1.00 seconds the semaphore: Mutex at 0000000005E4CAE8 created file dict0dict.c line 731, lock var 1 waiters flag 1 --Thread 11372 has waited at dict0dict.c line 777 for 1.00 seconds the semaphore: Mutex at 0000000005E4CAE8 created file dict0dict.c line 731, lock var 1 waiters flag 1 --Thread 5580 has waited at ha_innodb.cc line 7258 for 1.00 seconds the semaphore: X-lock on RW-latch at 00007FF7CC38B460 created in file dict0dict.c line 744 a writer (thread id 13704) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row0purge.c line 691 Last time write locked in file ..\..\..\mysqlcom-pro-5.5.54\storage\innobase\handler\ha_innodb.cc line 7258 Mutex spin waits 12925, rounds 86353, OS waits 2202 RW-shared spins 606, rounds 18124, OS waits 599 RW-excl spins 272, rounds 14268, OS waits 461 Spin rounds per wait: 6.68 mutex, 29.91 RW-shared, 52.46 RW-excl ------------ TRANSACTIONS ------------ Trx id counter 100C8 Purge done for trx's n:o < FE54 undo n:o < 0 History list length 1225 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0, not started MySQL thread id 376, OS thread handle 0x15cc, query id 243490 localhost 127.0.0.1 controller setup ALTER TABLE metricdata_ten_min REORGANIZE PARTITION PARTMAX INTO ( PARTITION PART208244 VALUES LESS THAN (24989280), PARTITION PARTMAX VALUES LESS THAN MAXVALUE) ---TRANSACTION 10024, not started MySQL thread id 383, OS thread handle 0x11c0, query id 243474 localhost 127.0.0.1 controller ---TRANSACTION 10023, not started MySQL thread id 382, OS thread handle 0x2f98, query id 243465 localhost 127.0.0.1 controller ---TRANSACTION 1003E, not started MySQL thread id 381, OS thread handle 0x2830, query id 243532 localhost 127.0.0.1 controller ---TRANSACTION 1003B, not started MySQL thread id 380, OS thread handle 0x36b8, query id 243560 localhost 127.0.0.1 controller ---TRANSACTION 10046, not started MySQL thread id 379, OS thread handle 0x2544, query id 243563 localhost 127.0.0.1 controller ---TRANSACTION 1006F, not started MySQL thread id 378, OS thread handle 0x27c0, query id 243670 localhost 127.0.0.1 controller ---TRANSACTION 1008A, not started MySQL thread id 377, OS thread handle 0x225c, query id 243827 localhost 127.0.0.1 controller ---TRANSACTION 1002A, not started mysql tables in use 120, locked 120 MySQL thread id 376, OS thread handle 0x15cc, query id 243490 localhost 127.0.0.1 controller setup ALTER TABLE metricdata_ten_min REORGANIZE PARTITION PARTMAX INTO ( PARTITION PART208244 VALUES LESS THAN (24989280), PARTITION PARTMAX VALUES LESS THAN MAXVALUE) ---TRANSACTION 100C5, not started MySQL thread id 375, OS thread handle 0x35a4, query id 244251 localhost 127.0.0.1 controller Opening tables select accountent0_.id as id133_0_, accountent0_.version as version133_0_, accountent0_.name as name133_0_, accountent0_.access_key as access4_133_0_, accountent0_.account_key as account5_133_0_, accountent0_.controller_url as controller6_133_0_, accountent0_.coradiant_integration_enabled as coradiant7_133_0_, accountent0_.coradiant_integration_url as coradiant8_133_0_, accountent0_.created_on as created9_133_0_, accountent0_.deleted as deleted133_0_, accountent0_.display_name as display11_133_0_, accountent0_.edition as edition133_0_, accountent0_.encryption_scheme as encryption13_133_0_, acc ---TRANSACTION 10044, not started mysql tables in use 19, locked 19 MySQL thread id 373, OS thread handle 0x27dc, query id 243553 localhost 127.0.0.1 controller setup ALTER TABLE top_summary_stats DROP PARTITION PART416459 ---TRANSACTION 100C4, not started MySQL thread id 372, OS thread handle 0x27fc, query id 244250 localhost 127.0.0.1 controller Opening tables select accountent0_.id as id133_0_, accountent0_.version as version133_0_, accountent0_.name as name133_0_, accountent0_.access_key as access4_133_0_, accountent0_.account_key as account5_133_0_, accountent0_.controller_url as controller6_133_0_, accountent0_.coradiant_integration_enabled as coradiant7_133_0_, accountent0_.coradiant_integration_url as coradiant8_133_0_, accountent0_.created_on as created9_133_0_, accountent0_.deleted as deleted133_0_, accountent0_.display_name as display11_133_0_, accountent0_.edition as edition133_0_, accountent0_.encryption_scheme as encryption13_133_0_, acc ---TRANSACTION 10078, not started mysql tables in use 152, locked 152 MySQL thread id 365, OS thread handle 0x2de8, query id 243701 localhost 127.0.0.1 controller setup ALTER TABLE metricdata_min DROP PARTITION PART2498765 ---TRANSACTION 100BD, not started MySQL thread id 363, OS thread handle 0x350, query id 244257 localhost 127.0.0.1 controller ---TRANSACTION 100BE, not started MySQL thread id 362, OS thread handle 0x634, query id 244258 localhost 127.0.0.1 controller ---TRANSACTION FFF3, not started mysql tables in use 60, locked 60 MySQL thread id 313, OS thread handle 0x3588, query id 243367 localhost 127.0.0.1 controller setup ALTER TABLE requestdata_summary REORGANIZE PARTITION PARTMAX INTO ( PARTITION PART416477 VALUES LESS THAN (1499317200000), PARTITION PARTMAX VALUES LESS THAN MAXVALUE) ---TRANSACTION 100B0, not started mysql tables in use 1, locked 0 MySQL thread id 312, OS thread handle 0x1f50, query id 244141 localhost 127.0.0.1 controller select attributes0_.rule_id as rule11_206_1_, attributes0_.id as id1_, attributes0_.id as id145_0_, attributes0_.version as version145_0_, attributes0_.field_name as field3_145_0_, attributes0_.getter_chain as getter4_145_0_, attributes0_.mbean_attribute_name as mbean5_145_0_, attributes0_.metric_aggregator_type as metric6_145_0_, attributes0_.metric_cluster_rollup_type as metric7_145_0_, attributes0_.metric_hole_handling_type as metric8_145_0_, attributes0_.metric_name as metric9_145_0_, attributes0_.metric_time_rollup_type as metric10_145_0_, attributes0_.rule_id as rule11_145_0_ from jmx_at ---TRANSACTION FFDA, not started MySQL thread id 37, OS thread handle 0x20a8, query id 243125 localhost 127.0.0.1 controller ---TRANSACTION 1009C, not started MySQL thread id 48, OS thread handle 0xd74, query id 243898 localhost 127.0.0.1 controller ---TRANSACTION 1009D, not started MySQL thread id 38, OS thread handle 0x1160, query id 243901 localhost 127.0.0.1 controller ---TRANSACTION 100C7, ACTIVE 2 sec MySQL thread id 374, OS thread handle 0x1654, query id 244254 localhost 127.0.0.1 controller Opening tables select userentity0_.id as id186_, userentity0_.version as version186_, userentity0_.name as name186_, userentity0_.account_id as account14_186_, userentity0_.created_by as created15_186_, userentity0_.created_on as created4_186_, userentity0_.modified_by as modified16_186_, userentity0_.modified_on as modified5_186_, userentity0_.deleted as deleted186_, userentity0_.display_name as display7_186_, userentity0_.email as email186_, userentity0_.encrypted_password as encrypted9_186_, userentity0_.preferences as prefere10_186_, userentity0_.provider_unique_name as provider11_186_, userentity0_.prov ---TRANSACTION 100C3, ACTIVE 3 sec MySQL thread id 366, OS thread handle 0x2c6c, query id 244256 localhost 127.0.0.1 controller Opening tables select distinct roleentity4_.id as id2_, roleentity4_.version as version2_, roleentity4_.name as name2_, roleentity4_.description as descript4_2_, roleentity4_.display_name as display5_2_ from user userentity0_ inner join user_account_role_mapping accountrol1_ on userentity0_.id=accountrol1_.user_id inner join account_role accountrol2_ on accountrol1_.account_role_id=accountrol2_.id inner join account_role_role_mapping roles3_ on accountrol2_.id=roles3_.account_role_id inner join role roleentity4_ on roles3_.role_id=roleentity4_.id where userentity0_.id=1 ---TRANSACTION 100BC, ACTIVE 31318 sec creating index 4 lock struct(s), heap size 1248, 0 row lock(s), undo log entries 41 MySQL thread id 313, OS thread handle 0x3588, query id 243367 localhost 127.0.0.1 controller setup ALTER TABLE requestdata_summary REORGANIZE PARTITION PARTMAX INTO ( PARTITION PART416477 VALUES LESS THAN (1499317200000), PARTITION PARTMAX VALUES LESS THAN MAXVALUE) ---TRANSACTION 10084, ACTIVE 31321 sec MySQL thread id 364, OS thread handle 0x23d4, query id 244111 localhost 127.0.0.1 controller Waiting for query cache lock select agentconfi0_.agent_configuration_id as agent1_98_1_, agentconfi0_.property_id as property2_1_, propertyen1_.id as id36_0_, propertyen1_.version as version36_0_, propertyen1_.property_definition_id as property4_36_0_, propertyen1_.file_id as file5_36_0_, propertyen1_.property_value as property3_36_0_ from agent_configuration_property_mapping agentconfi0_ inner join property propertyen1_ on agentconfi0_.property_id=propertyen1_.id where agentconfi0_.agent_configuration_id in (40, 51, 43, 48, 44, 46, 52, 42, 41, 45) ---TRANSACTION FFF8, ACTIVE 31331 sec MySQL thread id 340, OS thread handle 0x27f4, query id 243300 localhost 127.0.0.1 controller -------- FILE I/O -------- I/O thread 0 state: wait Windows aio (insert buffer thread) I/O thread 1 state: wait Windows aio (log thread) I/O thread 2 state: wait Windows aio (read thread) I/O thread 3 state: wait Windows aio (read thread) I/O thread 4 state: wait Windows aio (read thread) I/O thread 5 state: wait Windows aio (read thread) I/O thread 6 state: wait Windows aio (read thread) I/O thread 7 state: wait Windows aio (read thread) I/O thread 8 state: wait Windows aio (read thread) I/O thread 9 state: wait Windows aio (read thread) I/O thread 10 state: complete io for buf page (write thread) I/O thread 11 state: wait Windows aio (write thread) I/O thread 12 state: wait Windows aio (write thread) I/O thread 13 state: wait Windows aio (write thread) I/O thread 14 state: wait Windows aio (write thread) I/O thread 15 state: wait Windows aio (write thread) I/O thread 16 state: wait Windows aio (write thread) I/O thread 17 state: wait Windows aio (write thread) Pending normal aio reads: 0 [0, 0, 0, 0, 0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0, 0, 0, 0, 0] , ibuf aio reads: 0, log i/o's: 0, sync i/o's: 1 Pending flushes (fsync) log: 0; buffer pool: 1 6456 OS file reads, 21142 OS file writes, 10304 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 5.89 writes/s, 1.22 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 1106407, node heap has 15 buffer(s) 8.50 hash searches/s, 12.75 non-hash searches/s --- LOG --- Log sequence number 44044637 Log flushed up to 44041567 Last checkpoint at 44013807 0 pending log writes, 0 pending chkp writes 3691 log i/o's done, 0.10 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 549453824; in additional pool allocated 0 Dictionary memory allocated 12979107 Buffer pool size 32768 Free buffers 22450 Database pages 10303 Old database pages 3783 Modified db pages 9 Pending reads 0 Pending writes: LRU 0, flush list 1, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 5557, created 5210, written 12571 0.00 reads/s, 0.30 creates/s, 4.80 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: 10303, unzip_LRU len: 0 I/O sum[38]:cur[48], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 1 read views open inside InnoDB Main thread id 2208, state: flushing buffer pool pages Number of rows inserted 471, updated 44, deleted 4, read 361462 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 16.75 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ ===================================== 170706 10:41:31 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 16 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 17551 1_second, 17547 sleeps, 1621 10_second, 1348 background, 1348 flush srv_master_thread log flush and writes: 17662 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 3302, signal count 2519 --Thread 9172 has waited at dict0dict.c line 777 for 2.00 seconds the semaphore: Mutex at 0000000005E4CAE8 created file dict0dict.c line 731, lock var 1 waiters flag 1 --Thread 5716 has waited at dict0dict.c line 777 for 2.00 seconds the semaphore: Mutex at 0000000005E4CAE8 created file dict0dict.c line 731, lock var 1 waiters flag 1 --Thread 10236 has waited at dict0dict.c line 777 for 2.00 seconds the semaphore: Mutex at 0000000005E4CAE8 created file dict0dict.c line 731, lock var 1 waiters flag 1 --Thread 11372 has waited at ha_innodb.cc line 3592 for 2.00 seconds the semaphore: Mutex at 0000000005E4CAE8 created file dict0dict.c line 731, lock var 1 waiters flag 1 --Thread 11752 has waited at dict0dict.c line 777 for 2.00 seconds the semaphore: Mutex at 0000000005E4CAE8 created file dict0dict.c line 731, lock var 1 waiters flag 1 --Thread 13704 has waited at dict0dict.c line 777 for 2.00 seconds the semaphore: Mutex at 0000000005E4CAE8 created file dict0dict.c line 731, lock var 1 waiters flag 1 --Thread 10204 has waited at row0mysql.c line 3154 for 1.00 seconds the semaphore: X-lock on RW-latch at 00007FF7CC38B460 created in file dict0dict.c line 744 a writer (thread id 5580) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file row0purge.c line 691 Last time write locked in file ..\..\..\mysqlcom-pro-5.5.54\storage\innobase\handler\ha_innodb.cc line 7258 --Thread 13732 has waited at dict0dict.c line 777 for 1.00 seconds the semaphore: Mutex at 0000000005E4CAE8 created file dict0dict.c line 731, lock var 1 waiters flag 1 Mutex spin waits 12963, rounds 86864, OS waits 2218 RW-shared spins 608, rounds 18184, OS waits 601 RW-excl spins 273, rounds 14508, OS waits 468 Spin rounds per wait: 6.70 mutex, 29.91 RW-shared, 53.14 RW-excl ------------ TRANSACTIONS ------------ Trx id counter 100E2 Purge done for trx's n:o < FE54 undo n:o < 0 History list length 1225 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 100BC, not started MySQL thread id 313, OS thread handle 0x3588, query id 243367 localhost 127.0.0.1 controller setup ALTER TABLE requestdata_summary REORGANIZE PARTITION PARTMAX INTO ( PARTITION PART416477 VALUES LESS THAN (1499317200000), PARTITION PARTMAX VALUES LESS THAN MAXVALUE) ---TRANSACTION 10024, not started MySQL thread id 383, OS thread handle 0x11c0, query id 243474 localhost 127.0.0.1 controller ---TRANSACTION 10023, not started MySQL thread id 382, OS thread handle 0x2f98, query id 243465 localhost 127.0.0.1 controller ---TRANSACTION 1003E, not started MySQL thread id 381, OS thread handle 0x2830, query id 243532 localhost 127.0.0.1 controller ---TRANSACTION 1003B, not started MySQL thread id 380, OS thread handle 0x36b8, query id 243560 localhost 127.0.0.1 controller ---TRANSACTION 10046, not started MySQL thread id 379, OS thread handle 0x2544, query id 243563 localhost 127.0.0.1 controller ---TRANSACTION 1006F, not started MySQL thread id 378, OS thread handle 0x27c0, query id 243670 localhost 127.0.0.1 controller ---TRANSACTION 100D7, not started MySQL thread id 377, OS thread handle 0x225c, query id 244334 localhost 127.0.0.1 controller ---TRANSACTION 1002A, not started mysql tables in use 120, locked 120 MySQL thread id 376, OS thread handle 0x15cc, query id 243490 localhost 127.0.0.1 controller setup ALTER TABLE metricdata_ten_min REORGANIZE PARTITION PARTMAX INTO ( PARTITION PART208244 VALUES LESS THAN (24989280), PARTITION PARTMAX VALUES LESS THAN MAXVALUE) ---TRANSACTION 10044, not started MySQL thread id 373, OS thread handle 0x27dc, query id 243553 localhost 127.0.0.1 controller setup ALTER TABLE top_summary_stats DROP PARTITION PART416459 ---TRANSACTION 10078, not started mysql tables in use 152, locked 152 MySQL thread id 365, OS thread handle 0x2de8, query id 243701 localhost 127.0.0.1 controller setup ALTER TABLE metricdata_min DROP PARTITION PART2498765 ---TRANSACTION FFF3, not started mysql tables in use 60, locked 60 MySQL thread id 313, OS thread handle 0x3588, query id 243367 localhost 127.0.0.1 controller setup ALTER TABLE requestdata_summary REORGANIZE PARTITION PARTMAX INTO ( PARTITION PART416477 VALUES LESS THAN (1499317200000), PARTITION PARTMAX VALUES LESS THAN MAXVALUE) ---TRANSACTION FFDA, not started MySQL thread id 37, OS thread handle 0x20a8, query id 244272 localhost 127.0.0.1 controller ---TRANSACTION 1009C, not started MySQL thread id 48, OS thread handle 0xd74, query id 244279 localhost 127.0.0.1 controller ---TRANSACTION 1009D, not started MySQL thread id 38, OS thread handle 0x1160, query id 244269 localhost 127.0.0.1 controller ---TRANSACTION 100E1, ACTIVE 1 sec starting index read mysql tables in use 1, locked 0 MySQL thread id 362, OS thread handle 0x634, query id 244350 localhost 127.0.0.1 controller Sending data select attributes0_.rule_id as rule11_206_1_, attributes0_.id as id1_, attributes0_.id as id145_0_, attributes0_.version as version145_0_, attributes0_.field_name as field3_145_0_, attributes0_.getter_chain as getter4_145_0_, attributes0_.mbean_attribute_name as mbean5_145_0_, attributes0_.metric_aggregator_type as metric6_145_0_, attributes0_.metric_cluster_rollup_type as metric7_145_0_, attributes0_.metric_hole_handling_type as metric8_145_0_, attributes0_.metric_name as metric9_145_0_, attributes0_.metric_time_rollup_type as metric10_145_0_, attributes0_.rule_id as rule11_145_0_ from jmx_at Trx read view will not see trx with id >= 100E2, sees < FFF8 ---TRANSACTION 100DE, ACTIVE 1 sec dropping table MySQL thread id 373, OS thread handle 0x27dc, query id 243553 localhost 127.0.0.1 controller setup ALTER TABLE top_summary_stats DROP PARTITION PART416459 ---TRANSACTION 100DC, ACTIVE 1 sec MySQL thread id 375, OS thread handle 0x35a4, query id 244349 localhost 127.0.0.1 controller Opening tables SELECT db_server.id AS id,db_server.name AS dbServerName,db_server.application_component_node_id AS nodeId,db_server.db_monitor_config_id AS configId,db_server.role AS role,db_monitor_config.type AS type,application_component_node.name AS nodeName,db_monitor_config.name AS configName,db_monitor_config.created_by AS createdBy,db_server_backend_mapping.backend_id AS backendId FROM db_monitor_config,application_component_node,db_server LEFT JOIN db_server_backend_mapping on (id = db_server_backend_mapping.db_server_id) WHERE db_server.db_monitor_config_id = db_monitor_config.id AND db_monitor_con ---TRANSACTION 100DA, ACTIVE 1 sec starting index read mysql tables in use 1, locked 0 MySQL thread id 363, OS thread handle 0x350, query id 244336 localhost 127.0.0.1 controller Sending data select attributes0_.rule_id as rule11_206_1_, attributes0_.id as id1_, attributes0_.id as id145_0_, attributes0_.version as version145_0_, attributes0_.field_name as field3_145_0_, attributes0_.getter_chain as getter4_145_0_, attributes0_.mbean_attribute_name as mbean5_145_0_, attributes0_.metric_aggregator_type as metric6_145_0_, attributes0_.metric_cluster_rollup_type as metric7_145_0_, attributes0_.metric_hole_handling_type as metric8_145_0_, attributes0_.metric_name as metric9_145_0_, attributes0_.metric_time_rollup_type as metric10_145_0_, attributes0_.rule_id as rule11_145_0_ from jmx_at Trx read view will not see trx with id >= 100DB, sees < FFF8 ---TRANSACTION 100D0, ACTIVE 2 sec creating index 4 lock struct(s), heap size 1248, 0 row lock(s), undo log entries 19 MySQL thread id 376, OS thread handle 0x15cc, query id 243490 localhost 127.0.0.1 controller setup ALTER TABLE metricdata_ten_min REORGANIZE PARTITION PARTMAX INTO ( PARTITION PART208244 VALUES LESS THAN (24989280), PARTITION PARTMAX VALUES LESS THAN MAXVALUE) ---TRANSACTION 100CF, ACTIVE 2 sec MySQL thread id 372, OS thread handle 0x27fc, query id 244313 localhost 127.0.0.1 controller Opening tables select identityen0_.id as id114_, identityen0_.deleted as deleted114_, identityen0_.mapped_entity_id as mapped3_114_, identityen0_.name as name114_, identityen0_.type as type114_ from identity identityen0_ where identityen0_.mapped_entity_id='1' ---TRANSACTION 100CB, ACTIVE 2 sec starting index read mysql tables in use 1, locked 0 MySQL thread id 312, OS thread handle 0x1f50, query id 244141 localhost 127.0.0.1 controller Sending data select attributes0_.rule_id as rule11_206_1_, attributes0_.id as id1_, attributes0_.id as id145_0_, attributes0_.version as version145_0_, attributes0_.field_name as field3_145_0_, attributes0_.getter_chain as getter4_145_0_, attributes0_.mbean_attribute_name as mbean5_145_0_, attributes0_.metric_aggregator_type as metric6_145_0_, attributes0_.metric_cluster_rollup_type as metric7_145_0_, attributes0_.metric_hole_handling_type as metric8_145_0_, attributes0_.metric_name as metric9_145_0_, attributes0_.metric_time_rollup_type as metric10_145_0_, attributes0_.rule_id as rule11_145_0_ from jmx_at Trx read view will not see trx with id >= 100CC, sees < FFF8 ---TRANSACTION 100C7, ACTIVE 18 sec MySQL thread id 374, OS thread handle 0x1654, query id 244314 localhost 127.0.0.1 controller Opening tables select identityen0_.id as id114_, identityen0_.deleted as deleted114_, identityen0_.mapped_entity_id as mapped3_114_, identityen0_.name as name114_, identityen0_.type as type114_ from identity identityen0_ where identityen0_.mapped_entity_id='1' ---TRANSACTION 100C3, ACTIVE 19 sec MySQL thread id 366, OS thread handle 0x2c6c, query id 244256 localhost 127.0.0.1 controller Opening tables select distinct roleentity4_.id as id2_, roleentity4_.version as version2_, roleentity4_.name as name2_, roleentity4_.description as descript4_2_, roleentity4_.display_name as display5_2_ from user userentity0_ inner join user_account_role_mapping accountrol1_ on userentity0_.id=accountrol1_.user_id inner join account_role accountrol2_ on accountrol1_.account_role_id=accountrol2_.id inner join account_role_role_mapping roles3_ on accountrol2_.id=roles3_.account_role_id inner join role roleentity4_ on roles3_.role_id=roleentity4_.id where userentity0_.id=1 ---TRANSACTION 10084, ACTIVE 31337 sec MySQL thread id 364, OS thread handle 0x23d4, query id 244312 localhost 127.0.0.1 controller checking permissions select propertyde0_.id as id99_0_, propertyde0_.version as version99_0_, propertyde0_.allowed_string_values as allowed3_99_0_, propertyde0_.file_id as file12_99_0_, propertyde0_.default_value as default4_99_0_, propertyde0_.description as descript5_99_0_, propertyde0_.lower_numeric_bound as lower6_99_0_, propertyde0_.name as name99_0_, propertyde0_.required as required99_0_, propertyde0_.string_max_len as string9_99_0_, propertyde0_.type as type99_0_, propertyde0_.upper_numeric_bound as upper11_99_0_ from property_definition propertyde0_ where propertyde0_.id in (2146, 2147, 2148, 2149, 2150, ---TRANSACTION FFF8, ACTIVE 31347 sec MySQL thread id 340, OS thread handle 0x27f4, query id 243300 localhost 127.0.0.1 controller -------- FILE I/O -------- I/O thread 0 state: wait Windows aio (insert buffer thread) I/O thread 1 state: wait Windows aio (log thread) I/O thread 2 state: wait Windows aio (read thread) I/O thread 3 state: wait Windows aio (read thread) I/O thread 4 state: wait Windows aio (read thread) I/O thread 5 state: wait Windows aio (read thread) I/O thread 6 state: wait Windows aio (read thread) I/O thread 7 state: wait Windows aio (read thread) I/O thread 8 state: wait Windows aio (read thread) I/O thread 9 state: wait Windows aio (read thread) I/O thread 10 state: wait Windows aio (write thread) I/O thread 11 state: wait Windows aio (write thread) I/O thread 12 state: wait Windows aio (write thread) I/O thread 13 state: wait Windows aio (write thread) I/O thread 14 state: wait Windows aio (write thread) I/O thread 15 state: wait Windows aio (write thread) I/O thread 16 state: wait Windows aio (write thread) I/O thread 17 state: wait Windows aio (write thread) Pending normal aio reads: 0 [0, 0, 0, 0, 0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 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 6456 OS file reads, 21198 OS file writes, 10338 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 5.09 writes/s, 2.91 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 1106407, node heap has 15 buffer(s) 7.31 hash searches/s, 31.06 non-hash searches/s --- LOG --- Log sequence number 44068285 Log flushed up to 44065640 Last checkpoint at 44062619 0 pending log writes, 0 pending chkp writes 3702 log i/o's done, 1.10 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 549453824; in additional pool allocated 0 Dictionary memory allocated 13010476 Buffer pool size 32768 Free buffers 22435 Database pages 10318 Old database pages 3788 Modified db pages 15 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 5557, created 5225, written 12599 0.00 reads/s, 1.50 creates/s, 2.80 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: 10318, unzip_LRU len: 0 I/O sum[38]:cur[76], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 4 read views open inside InnoDB Main thread id 2208, state: sleeping Number of rows inserted 471, updated 44, deleted 4, read 362579 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 69.81 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ InnoDB: ###### Diagnostic info printed to the standard error stream 170706 15:11:20 [Note] C:\AppDynamics\Controller\db\bin\mysqld.exe: Normal shutdown 170706 15:11:20 [Note] Event Scheduler: Purging the queue. 0 events 170706 15:11:21 InnoDB: Starting shutdown... 170706 15:11:33 InnoDB: Shutdown completed; log sequence number 58742508 170706 15:11:33 [Note] C:\AppDynamics\Controller\db\bin\mysqld.exe: Shutdown complete 170706 15:11:34 [Note] Plugin 'FEDERATED' is disabled. 170706 15:11:34 InnoDB: The InnoDB memory heap is disabled 170706 15:11:34 InnoDB: Mutexes and rw_locks use Windows interlocked functions 170706 15:11:34 InnoDB: Compressed tables use zlib 1.2.3 170706 15:11:34 InnoDB: Initializing buffer pool, size = 512.0M 170706 15:11:34 InnoDB: Completed initialization of buffer pool 170706 15:11:35 InnoDB: highest supported file format is Barracuda. 170706 15:11:37 InnoDB: Waiting for the background threads to start 170706 15:11:38 InnoDB: 5.5.54 started; log sequence number 58742508 170706 15:11:38 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3388 170706 15:11:38 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 170706 15:11:38 [Note] Server socket created on IP: '0.0.0.0'. 170706 15:11:38 [Note] Event Scheduler: Loaded 0 events 170706 15:11:38 [Note] C:\AppDynamics\Controller\db\bin\mysqld.exe: ready for connections. Version: '5.5.54-enterprise-commercial-advanced-log' socket: '' port: 3388 MySQL Enterprise Server - Advanced Edition (Commercial)