mysql> show innodb status\G
*************************** 1. row ***************************
Type: InnoDB
Name:
Status:
=====================================
120322 18:22:17 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 20 seconds
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 320191567, signal count 279186400
Mutex spin waits 0, rounds 183400391575, OS waits 195985638
RW-shared spins 283520, OS waits 84441; RW-excl spins 213679, OS waits 38802
------------
TRANSACTIONS
------------
Trx id counter 0 2310741495
Purge done for trx's n:o < 0 2310676540 undo n:o < 0 0
History list length 20436
... truncated...
query id 96488194 15.185.140.21 nova Sending data
SELECT anon_1.fixed_ips_created_at AS anon_1_fixed_ips_created_at, anon_1.fixed_ips_updated_at AS anon_1_fixed_ips_updated_at, anon_1.fixed_ips_deleted_at AS anon_1_fixed_ips_deleted_at, anon_1.fixed_ips_deleted AS anon_1_fixed_ips_deleted, anon_1.fixed_ips_id AS anon_1_fixed_ips_id, anon_1.fixed_ips_address AS anon_1_fixed_ips_address, anon_1.fixed_ips_network_id AS anon_1_fixed_ips_network_id, anon_1.fixed_ips_virtual_interface_id AS anon_1_fixed_ips_virtual_interface_id, anon_1.fixed_ips_instance_id AS anon_1_fixed_ips_instance_id, anon_1.fixed_ips_allocated AS anon_1_fixed_ips_allocated, a
Trx read view will not see trx with id >= 0 2310741238, sees < 0 2310676535
---TRANSACTION 0 2310741222, ACTIVE 0 sec, process no 23489, OS thread id 140305447769856 waiting in InnoDB queue
mysql tables in use 7, locked 0
MySQL thread id 33458, query id 96488152 15.185.141.91 nova Sending data
SELECT anon_1.fixed_ips_created_at AS anon_1_fixed_ips_created_at, anon_1.fixed_ips_updated_at AS anon_1_fixed_ips_updated_at, anon_1.fixed_ips_deleted_at AS anon_1_fixed_ips_deleted_at, anon_1.fixed_ips_deleted AS anon_1_fixed_ips_deleted, anon_1.fixed_ips_id AS anon_1_fixed_ips_id, anon_1.fixed_ips_address AS anon_1_fixed_ips_address, anon_1.fixed_ips_network_id AS anon_1_fixed_ips_network_id, anon_1.fixed_ips_virtual_interface_id AS anon_1_fixed_ips_virtual_interface_id, anon_1.fixed_ips_instance_id AS anon_1_fixed_ips_instance_id, anon_1.fixed_ips_allocated AS anon_1_fixed_ips_allocated, a
Trx read view will not see trx with id >= 0 2310741223, sees < 0 2310676535
---TRANSACTION 0 2310741200, ACTIVE 1 sec, process no 23489, OS thread id 140305494402816 sleeping before joining InnoDB queue
mysql tables in use 7, locked 0
MySQL thread id 34220, query id 96488105 15.185.140.9 nova statistics
SELECT anon_1.fixed_ips_created_at AS anon_1_fixed_ips_created_at, anon_1.fixed_ips_updated_at AS anon_1_fixed_ips_updated_at, anon_1.fixed_ips_deleted_at AS anon_1_fixed_ips_deleted_at, anon_1.fixed_ips_deleted AS anon_1_fixed_ips_deleted, anon_1.fixed_ips_id AS anon_1_fixed_ips_id, anon_1.fixed_ips_address AS anon_1_fixed_ips_address, anon_1.fixed_ips_network_id AS anon_1_fixed_ips_network_id, anon_1.fixed_ips_virtual_interface_id AS anon_1_fixed_ips_virtual_interface_id, anon_1.fixed_ips_instance_id AS anon_1_fixed_ips_instance_id, anon_1.fixed_ips_allocated AS anon_1_fixed_ips_allocated, a
Trx read view will not see trx with id >= 0 2310741201, sees < 0 2310676535
---TRANSACTION 0 2310741173, ACTIVE 1 sec, process no 23489, OS thread id 140305583625984 waiting in InnoDB queue
mysql tables in use 7, locked 0
MySQL thread id 33324, query id 96488048 15.185.141.58 nova statistics
SELECT anon_1.fixed_ips_created_at AS anon_1_fixed_ips_created_at, anon_1.fixed_ips_updated_at AS anon_1_fixed_ips_updated_at, anon_1.fixed_ips_deleted_at AS anon_1_fixed_ips_deleted_at, anon_1.fixed_ips_deleted AS anon_1_fixed_ips_deleted, anon_1.fixed_ips_id AS anon_1_fixed_ips_id, anon_1.fixed_ips_address AS anon_1_fixed_ips_address, anon_1.fixed_ips_network_id AS anon_1_fixed_ips_network_id, anon_1.fixed_ips_virtual_interface_id AS anon_1_fixed_ips_virtual_interface_id, anon_1.fixed_ips_instance_id AS anon_1_fixed_ips_instance_id, anon_1.fixed_ips_allocated AS anon_1_fixed_ips_allocated, a
Trx read view will not see trx with id >= 0 2310741174, sees < 0 2310676535
---TRANSACTION 0 2310741161, ACTIVE 1 sec, process no 23489, OS thread id 140305483454208 waiting in InnoDB queue
mysql tables in use 12, locked 0
MySQL thread id 34143, query id 96488067 15.185.141.188 nova Sending data
SELECT instances.created_at AS instances_created_at, instances.updated_at AS instances_updated_at, instances.deleted_at AS instances_deleted_at, instances.deleted AS instances_deleted, instances.id AS instances_id, instances.user_id AS instances_user_id, instances.project_id AS instances_project_id, instances.image_ref AS instances_image_ref, instances.kernel_id AS instances_kernel_id, instances.ramdisk_id AS instances_ramdisk_id, instances.server_name AS instances_server_name, instances.launch_index AS instances_launch_index, instances.key_name AS instances_key_name, instances.key_data AS ins
Trx read view will not see trx with id >= 0 2310741162, sees < 0 2310676535
---TRANSACTION 0 2310741153, ACTIVE 1 sec, process no 23489, OS thread id 140305285371648 waiting in InnoDB queue
mysql tables in use 2, locked 0
MySQL thread id 33407, query id 96488007 15.185.140.216 nova Sending data
SELECT anon_1.fixed_ips_created_at AS anon_1_fixed_ips_created_at, anon_1.fixed_ips_updated_at AS anon_1_fixed_ips_updated_at, anon_1.fixed_ips_deleted_at AS anon_1_fixed_ips_deleted_at, anon_1.fixed_ips_deleted AS anon_1_fixed_ips_deleted, anon_1.fixed_ips_id AS anon_1_fixed_ips_id, anon_1.fixed_ips_address AS anon_1_fixed_ips_address, anon_1.fixed_ips_network_id AS anon_1_fixed_ips_network_id, anon_1.fixed_ips_virtual_interface_id AS anon_1_fixed_ips_virtual_interface_id, anon_1.fixed_ips_instance_id AS anon_1_fixed_ips_instance_id, anon_1.fixed_ips_allocated AS anon_1_fixed_ips_allocated, a
Trx read view will not see trx with id >= 0 2310741154, sees < 0 2310676535
---TRANSACTION 0 2310741076, ACTIVE 1 sec, process no 23489, OS thread id 140305169131264 sleeping before joining InnoDB queue
mysql tables in use 12, locked 0
MySQL thread id 33309, query id 96487886 15.185.140.125 nova Sending data
SELECT instances.created_at AS instances_created_at, instances.updated_at AS instances_updated_at, instances.deleted_at AS instances_deleted_at, instances.deleted AS instances_deleted, instances.id AS instances_id, instances.user_id AS instances_user_id, instances.project_id AS instances_project_id, instances.image_ref AS instances_image_ref, instances.kernel_id AS instances_kernel_id, instances.ramdisk_id AS instances_ramdisk_id, instances.server_name AS instances_server_name, instances.launch_index AS instances_launch_index, instances.key_name AS instances_key_name, instances.key_data AS ins
Trx read view will not see trx with id >= 0 2310741077, sees < 0 2310676535
---TRANSACTION 0 2310741056, ACTIVE 1 sec, process no 23489, OS thread id 140305670903552 waiting in InnoDB queue
mysql tables in use 12, locked 0
MySQL thread id 33228, query id 96487845 15.185.140.45 nova Sending data
SELECT instances.created_at AS instances_created_at, instances.updated_at AS instances_updated_at, instances.deleted_at AS instances_deleted_at, instances.deleted AS instances_deleted, instances.id AS instances_id, instances.user_id AS instances_user_id, instances.project_id AS instances_project_id, instances.image_ref AS instances_image_ref, instances.kernel_id AS instances_kernel_id, instances.ramdisk_id AS instances_ramdisk_id, instances.server_name AS instances_server_name, instances.launch_index AS instances_launch_index, instances.key_name AS instances_key_name, instances.key_data AS ins
Trx read view will not see trx with id >= 0 2310741057, sees < 0 2310676535
---TRANSACTION 0 2310740967, ACTIVE 1 sec, process no 23489, OS thread id 140305494673152 waiting in InnoDB queue
mysql tables in use 12, locked 0
MySQL thread id 33939, query id 96487684 15.185.141.146 nova Sending data
SELECT instances.created_at AS instances_created_at, instances.updated_at AS instances_updated_at, instances.deleted_at AS instances_deleted_at, instances.deleted AS instances_deleted, instances.id AS instances_id, instances.user_id AS instances_user_id, instances.project_id AS instances_project_id, instances.image_ref AS instances_image_ref, instances.kernel_id AS instances_kernel_id, instances.ramdisk_id AS instances_ramdisk_id, instances.server_name AS instances_server_name, instances.launch_index AS instances_launch_index, instances.key_name AS instances_key_name, instances.key_data AS ins
Trx read view will not see trx with id >= 0 2310740968, sees < 0 2310676535
---TRANSACTION 0 2310740953, ACTIVE 1 sec, process no 23489, OS thread id 140305487644416 waiting in InnoDB queue
mysql tables in use 12, locked 0
MySQL thread id 34103, query id 96487664 15.185.141.52 nova Sending data
SELECT instances.created_at AS instances_created_at, instances.updated_at AS instances_updated_at, instances.deleted_at AS instances_deleted_at, instances.deleted AS instances_deleted, instances.id AS instances_id, instances.user_id AS instances_user_id, instances.project_id AS instances_project_id, instances.image_ref AS instances_image_ref, instances.kernel_id AS instances_kernel_id, instances.ramdisk_id AS instances_ramdisk_id, instances.server_name AS instances_server_name, instances.launch_index AS instances_launch_index, instances.key_name AS instances_key_name, instances.key_data AS ins
Trx read view will not see trx with id >= 0 2310740954, sees < 0 2310676535
---TRANSACTION 0 2310740947, ACTIVE 1 sec, process no 23489, OS thread id 140305460205312 waiting in InnoDB queue
mysql tables in use 12, locked 0
MySQL thread id 34150, query id 96487652 15.185.141.235 nova Sending data
SELECT instances.created_at AS instances_created_at, instances.updated_at AS instances_updated_at, instances.deleted_at AS instances_deleted_at, instances.deleted AS instances_deleted, instances.id AS instances_id, instances.user_id AS instances_user_id, instances.project_id AS instances_project_id, instances.image_ref AS instances_image_ref, instances.kernel_id AS instances_kernel_id, instances.ramdisk_id AS instances_ramdisk_id, instances.server_name AS instances_server_name, instances.launch_index AS instances_launch_index, instances.key_name AS instances_key_name, instances.key_data AS ins
Trx read view will not see trx with id >= 0 2310740948, sees < 0 2310676535
---TRANSACTION 0 2310740934, ACTIVE 1 sec, process no 23489, OS thread id 140305472235264 waiting in InnoDB queue
mysql tables in use 12, locked 0
MySQL thread id 33878, query id 96487614 15.185.141.230 nova Sending data
SELECT instances.created_at AS instances_created_at, instances.updated_at AS instances_updated_at, instances.deleted_at AS instances_deleted_at, instances.deleted AS instances_deleted, instances.id AS instances_id, instances.user_id AS instances_user_id, instances.project_id AS instances_project_id, instances.image_ref AS instances_image_ref, instances.kernel_id AS instances_kernel_id, instances.ramdisk_id AS instances_ramdisk_id, instances.server_name AS instances_server_name, instances.launch_index AS instances_launch_index, instances.key_name AS instances_key_name, instances.key_data AS ins
Trx read view will not see trx with id >= 0 2310740935, sees < 0 2310676535
---TRANSACTION 0 2310740930, ACTIVE 1 sec, process no 23489, OS thread id 140305261852416 fetching rows, thread declared inside InnoDB 495
mysql tables in use 12, locked 0
MySQL thread id 34334, query id 96487601 15.185.141.206 nova Sending data
SELECT instances.created_at AS instances_created_at, instances.updated_at AS instances_updated_at, instances.deleted_at AS instances_deleted_at, instances.deleted AS instances_deleted, instances.id AS instances_id, instances.user_id AS instances_user_id, instances.project_id AS instances_project_id, instances.image_ref AS instances_image_ref, instances.kernel_id AS instances_kernel_id, instances.ramdisk_id AS instances_ramdisk_id, instances.server_name AS instances_server_name, instances.launch_index AS instances_launch_index, instances.key_name AS instances_key_name, instances.key_data AS ins
Trx read view will not see trx with id >= 0 2310740931, sees < 0 2310676535
---TRANSACTION 0 2310740891, ACTIVE 1 sec, process no 23489, OS thread id 140305487103744 waiting in InnoDB queue
mysql tables in use 12, locked 0
MySQL thread id 34033, query id 96487524 15.185.141.245 nova Sending data
SELECT instances.created_at AS instances_created_at, instances.updated_at AS instances_updated_at, instances.deleted_at AS instances_deleted_at, instances.deleted AS instances_deleted, instances.id AS instances_id, instances.user_id AS instances_user_id, instances.project_id AS instances_project_id, instances.image_ref AS instances_image_ref, instances.kernel_id AS instances_kernel_id, instances.ramdisk_id AS instances_ramdisk_id, instances.server_name AS instances_server_name, instances.launch_index AS instances_launch_index, instances.key_name AS instances_key_name, instances.key_data AS ins
Trx read view will not see trx with id >= 0 2310740892, sees < 0 2310676535
---TRANSACTION 0 2310740890, ACTIVE 1 sec, process no 23489, OS thread id 140305496835840 waiting in InnoDB queue
mysql tables in use 12, locked 0
MySQL thread id 33900, query id 96487523 15.185.140.219 nova Sending data
SELECT instances.created_at AS instances_created_at, instances.updated_at AS instances_updated_at, instances.deleted_at AS instances_deleted_at, instances.deleted AS instances_deleted, instances.id AS instances_id, instances.user_id AS instances_user_id, instances.project_id AS instances_project_id, instances.image_ref AS instances_image_ref, instances.kernel_id AS instances_kernel_id, instances.ramdisk_id AS instances_ramdisk_id, instances.server_name AS instances_server_name, instances.launch_index AS instances_launch_index, instances.key_name AS instances_key_name, instances.key_data AS ins
Trx read view will not see trx with id >= 0 2310740891, sees < 0 2310676535
---TRANSACTION 0 2310740883, ACTIVE 1 sec, process no 23489, OS thread id 140305594304256 waiting in InnoDB queue
mysql tables in use 12, locked 0
MySQL thread id 33723, query id 96487510 15.185.142.9 nova Sending data
SELECT instances.created_at AS instances_created_at, instances.updated_at AS instances_updated_at, instances.deleted_at AS instances_deleted_at, instances.deleted AS instances_deleted, instances.id AS instances_id, instances.user_id AS instances_user_id, instances.project_id AS instances_project_id, instances.image_ref AS instances_image_ref, instances.kernel_id AS instances_kernel_id, instances.ramdisk_id AS instances_ramdisk_id, instances.server_name AS instances_server_name, instances.launch_index AS instances_launch_index, instances.key_name AS instances_key_name, instances.key_data AS ins
Trx read view will not see trx with id >= 0 2310740884, sees < 0 2310676535
---TRANSACTION 0 2310740874, ACTIVE 1 sec, process no 23489, OS thread id 140305249146624 waiting in InnoDB queue
mysql tables in use 12, locked 0
MySQL thread id 33060, query id 96487496 15.185.140.86 nova Sending data
SELECT instances.created_at AS instances_created_at, instances.updated_at AS instances_updated_at, instances.deleted_at AS instances_deleted_at, instances.deleted AS instances_deleted, instances.id AS instances_id, instances.user_id AS instances_user_id, instances.project_id AS instances_project_id, instances.image_ref AS instances_image_ref, instances.kernel_id AS instances_kernel_id, instances.ramdisk_id AS instances_ramdisk_id, instances.server_name AS instances_server_name, instances.launch_index AS instances_launch_index, instances.key_name AS instances_key_name, instances.key_data AS ins
Trx read view will not see trx with id >= 0 2310740875, sees < 0 2310676535
---TRANSACTION 0 2310740857, ACTIVE 1 sec, process no 23489, OS thread id 140305483183872 waiting in InnoDB queue
mysql tables in use 12, locked 0
MySQL thread id 33035, query id 96487457 15.185.141.49 nova Sending data
SELECT instances.created_at AS instances_created_at, instances.updated_at AS instances_updated_at, instances.deleted_at AS instances_deleted_at, instances.deleted AS instances_deleted, instances.id AS instances_id, instances.user_id AS instances_user_id, instances.project_id AS instances_project_id, instances.image_ref AS instances_image_ref, instances.kernel_id AS instances_kernel_id, instances.ramdisk_id AS instances_ramdisk_id, instances.server_name AS instances_server_name, instances.launch_index AS instances_launch_index, instances.key_name AS instances_key_name, instances.key_data AS ins
Trx read view will not see trx with id >= 0 2310740858, sees < 0 2310676535
---TRANSACTION 0 2310740832, ACTIVE 2 sec, process no 23489, OS thread id 140305468045056 sleeping before joining InnoDB queue
mysql tables in use 12, locked 0
MySQL thread id 34044, query id 96487396 15.185.141.217 nova Sending data
SELECT instances.created_at AS instances_created_at, instances.updated_at AS instances_updated_at, instances.deleted_at AS instances_deleted_at, instances.deleted AS instances_deleted, instances.id AS instances_id, instances.user_id AS instances_user_id, instances.project_id AS instances_project_id, instances.image_ref AS instances_image_ref, instances.kernel_id AS instances_kernel_id, instances.ramdisk_id AS instances_ramdisk_id, instances.server_name AS instances_server_name, instances.launch_index AS instances_launch_index, instances.key_name AS instances_key_name, instances.key_data AS ins
Trx read view will not see trx with id >= 0 2310740833, sees < 0 2310676535
---TRANSACTION 0 2310740816, ACTIVE 2 sec, process no 23489, OS thread id 140305447905024 fetching rows, thread declared inside InnoDB 178
mysql tables in use 12, locked 0
MySQL thread id 33953, query id 96487368 15.185.142.11 nova Sending data
SELECT instances.created_at AS instances_created_at, instances.updated_at AS instances_updated_at, instances.deleted_at AS instances_deleted_at, instances.deleted AS instances_deleted, instances.id AS instances_id, instances.user_id AS instances_user_id, instances.project_id AS instances_project_id, instances.image_ref AS instances_image_ref, instances.kernel_id AS instances_kernel_id, instances.ramdisk_id AS instances_ramdisk_id, instances.server_name AS instances_server_name, instances.launch_index AS instances_launch_index, instances.key_name AS instances_key_name, instances.key_data AS ins
Trx read view will not see trx with id >= 0 2310740817, sees < 0 2310676535
---TRANSACTION 0 2310740794, ACTIVE 2 sec, process no 23489, OS thread id 140305598088960 fetching rows, thread declared inside InnoDB 201
mysql tables in use 12, locked 0
MySQL thread id 33753, query id 96487337 15.185.140.166 nova Sending data
SELECT instances.created_at AS instances_created_at, instances.updated_at AS instances_updated_at, instances.deleted_at AS instances_deleted_at, instances.deleted AS instances_deleted, instances.id AS instances_id, instances.user_id AS instances_user_id, instances.project_id AS instances_project_id, instances.image_ref AS instances_image_ref, instances.kernel_id AS instances_kernel_id, instances.ramdisk_id AS instances_ramdisk_id, instances.server_name AS instances_server_name, instances.launch_index AS instances_launch_index, instances.key_name AS instances_key_name, instances.key_data AS ins
Trx read view will not see trx with id >= 0 2310740795, sees < 0 2310676535
---TRANSACTION 0 2310740783, ACTIVE 2 sec, process no 23489, OS thread id 140305443174144 waiting in InnoDB queue
mysql tables in use 12, locked 0
MySQL thread id 33039, query id 96487313 15.185.140.11 nova Sending data
SELECT instances.created_at AS instances_created_at, instances.updated_at AS instances_updated_at, instances.deleted_at AS instances_deleted_at, instances.deleted AS instances_deleted, instances.id AS instances_id, instances.user_id AS instances_user_id, instances.project_id AS instances_project_id, instances.image_ref AS instances_image_ref, instances.kernel_id AS instances_kernel_id, instances.ramdisk_id AS instances_ramdisk_id, instances.server_name AS instances_server_name, instances.launch_index AS instances_launch_index, instances.key_name AS instances_key_name, instances.key_data AS ins
Trx read view will not see trx with id >= 0 2310740784, sees < 0 2310676535
---TRANSACTION 0 2310740760, ACTIVE 2 sec, process no 23489, OS thread id 140305255229184 waiting in InnoDB queue
mysql tables in use 12, locked 0
MySQL thread id 33997, query id 96487254 15.185.140.9 nova Sending data
SELECT instances.created_at AS instances_created_at, instances.updated_at AS instances_updated_at, instances.deleted_at AS instances_deleted_at, instances.deleted AS instances_deleted, instances.id AS instances_id, instances.user_id AS instances_user_id, instances.project_id AS instances_project_id, instances.image_ref AS instances_image_ref, instances.kernel_id AS instances_kernel_id, instances.ramdisk_id AS instances_ramdisk_id, instances.server_name AS instances_server_name, instances.launch_index AS instances_launch_index, instances.key_name AS instances_key_name, instances.key_data AS ins
Trx read view will not see trx with id >= 0 2310740761, sees < 0 2310676535
---TRANSACTION 0 2310740730, ACTIVE 2 sec, process no 23489, OS thread id 140305456826112 waiting in InnoDB queue
mysql tables in use 12, locked 0
MySQL thread id 34016, query id 96487204 15.185.141.172 nova Sending data
SELECT instances.created_at AS instances_created_at, instances.updated_at AS instances_updated_at, instances.deleted_at AS instances_deleted_at, instances.deleted AS instances_deleted, instances.id AS instances_id, instances.user_id AS instances_user_id, instances.project_id AS instances_project_id, instances.image_ref AS instances_image_ref, instances.kernel_id AS instances_kernel_id, instances.ramdisk_id AS instances_ramdisk_id, instances.server_name AS instances_server_name, instances.launch_index AS instances_launch_index, instances.key_name AS instances_key_name, instances.key_data AS ins
Trx read view will not see trx with id >= 0 2310740731, sees < 0 2310676535
---TRANSACTION 0 2310740687, ACTIVE 2 sec, process no 23489, OS thread id 140305457501952 waiting in InnoDB queue
mysql tables in use 12, locked 0
MySQL thread id 33275, query id 96487111 15.185.141.60 nova Sending data
SELECT instances.created_at AS instances_created_at, instances.updated_at AS instances_updated_at, instances.deleted_at AS instances_deleted_at, instances.deleted AS instances_deleted, instances.id AS instances_id, instances.user_id AS instances_user_id, instances.project_id AS instances_project_id, instances.image_ref AS instances_image_ref, instances.kernel_id AS instances_kernel_id, instances.ramdisk_id AS instances_ramdisk_id, instances.server_name AS instances_server_name, instances.launch_index AS instances_launch_index, instances.key_name AS instances_key_name, instances.key_data AS ins
Trx read view will not see trx with id >= 0 2310740688, sees < 0 2310676535
---TRANSACTION 0 2310740671, ACTIVE 2 sec, process no 23489, OS thread id 140305602955008 waiting in InnoDB queue
mysql tables in use 12, locked 0
MySQL thread id 33643, query id 96487081 15.185.140.26 nova Sending data
SELECT instances.created_at AS instances_created_at, instances.updated_at AS instances_updated_at, instances.deleted_at AS instances_deleted_at, instances.deleted AS instances_deleted, instances.id AS instances_id, instances.user_id AS instances_user_id, instances.project_id AS instances_project_id, instances.image_ref AS instances_image_ref, instances.kernel_id AS instances_kernel_id, instances.ramdisk_id AS instances_ramdisk_id, instances.server_name AS instances_server_name, instances.launch_index AS instances_launch_index, instances.key_name AS instances_key_name, instances.key_data AS ins
Trx read view will not see trx with id >= 0 2310740672, sees < 0 2310676535
---TRANSACTION 0 2310740564, ACTIVE 2 sec, process no 23489, OS thread id 140305495619328 sleeping before joining InnoDB queue
mysql tables in use 12, locked 0
MySQL thread id 33859, query id 96486878 15.185.140.32 nova Sending data
SELECT instances.created_at AS instances_created_at, instances.updated_at AS instances_updated_at, instances.deleted_at AS instances_deleted_at, instances.deleted AS instances_deleted, instances.id AS instances_id, instances.user_id AS instances_user_id, instances.project_id AS instances_project_id, instances.image_ref AS instances_image_ref, instances.kernel_id AS instances_kernel_id, instances.ramdisk_id AS instances_ramdisk_id, instances.server_name AS instances_server_name, instances.launch_index AS instances_launch_index, instances.key_name AS instances_key_name, instances.key_data AS ins
Trx read view will not see trx with id >= 0 2310740565, sees < 0 2310676535
---TRANSACTION 0 2310740546, ACTIVE 2 sec, process no 23489, OS thread id 140305596872448 sleeping before joining InnoDB queue
mysql tables in use 12, locked 0
MySQL thread id 33630, query id 96486831 15.185.140.215 nova Sending data
SELECT instances.created_at AS instances_created_at, instances.updated_at AS instances_updated_at, instances.deleted_at AS instances_deleted_at, instances.deleted AS instances_deleted, instances.id AS instances_id, instances.user_id AS instances_user_id, instances.project_id AS instances_project_id, instances.image_ref AS instances_image_ref, instances.kernel_id AS instances_kernel_id, instances.ramdisk_id AS instances_ramdisk_id, instances.server_name AS instances_server_name, instances.launch_index AS instances_launch_index, instances.key_name AS instances_key_name, instances.key_data AS ins
Trx read view will not see trx with id >= 0 2310740547, sees < 0 2310676535
---TRANSACTION 0 2310740527, ACTIVE 2 sec, process no 23489, OS thread id 140305462368000 fetching rows, thread declared inside InnoDB 153
mysql tables in use 12, locked 0
MySQL thread id 33993, query id 96486802 15.185.141.104 nova Sending data
SELECT instances.created_at AS instances_created_at, instances.updated_at AS instances_updated_at, instances.deleted_at AS instances_deleted_at, instances.deleted AS instances_deleted, instances.id AS instances_id, instances.user_id AS instances_user_id, instances.project_id AS instances_project_id, instances.image_ref AS instances_image_ref, instances.kernel_id AS instances_kernel_id, instances.ramdisk_id AS instances_ramdisk_id, instances.server_name AS instances_server_name, instances.launch_index AS instances_launch_index, instances.key_name AS instances_key_name, instances.key_data AS ins
Trx read view will not see trx with id >= 0 2310740528, sees < 0 2310676535
---TRANSACTION 0 2310740476, ACTIVE 2 sec, process no 23489, OS thread id 140305587275520 waiting in InnoDB queue
mysql tables in use 12, locked 0
MySQL thread id 33897, query id 96486702 15.185.141.62 nova Sending data
SELECT instances.created_at AS instances_created_at, instances.updated_at AS instances_updated_at, instances.deleted_at AS instances_deleted_at, instances.deleted AS instances_deleted, instances.id AS instances_id, instances.user_id AS instances_user_id, instances.project_id AS instances_project_id, instances.image_ref AS instances_image_ref, instances.kernel_id AS instances_kernel_id, instances.ramdisk_id AS instances_ramdisk_id, instances.server_name AS instances_server_name, instances.launch_index AS instances_launch_index, instances.key_name AS instances_key_name, instances.key_data AS ins
Trx read view will not see trx with id >= 0 2310740477, sees < 0 2310676535
---TRANSACTION 0 2310740454, ACTIVE 2 sec, process no 23489, OS thread id 140305503729408 waiting in InnoDB queue
mysql tables in use 16, locked 0
MySQL thread id 33105, query id 96486652 15.185.140.240 nova Sorting result
SELECT instances.created_at AS instances_created_at, instances.updated_at AS instances_updated_at, instances.deleted_at AS instances_deleted_at, instances.deleted AS instances_deleted, instances.id AS instances_id, instances.user_id AS instances_user_id, instances.project_id AS instances_project_id, instances.image_ref AS instances_image_ref, instances.kernel_id AS instances_kernel_id, instances.ramdisk_id AS instances_ramdisk_id, instances.server_name AS instances_server_name, instances.launch_index AS instances_launch_index, instances.key_name AS instances_key_name, instances.key_data AS ins
Trx read view will not see trx with id >= 0 2310740455, sees < 0 2310676535
---TRANSACTION 0 2310740379, ACTIVE 2 sec, process no 23489, OS thread id 140305594574592 waiting in InnoDB queue
mysql tables in use 12, locked 0
MySQL thread id 34054, query id 96486504 15.185.140.245 nova Sending data
SELECT instances.created_at AS instances_created_at, instances.updated_at AS instances_updated_at, instances.deleted_at AS instances_deleted_at, instances.deleted AS instances_deleted, instances.id AS instances_id, instances.user_id AS instances_user_id, instances.project_id AS instances_project_id, instances.image_ref AS instances_image_ref, instances.kernel_id AS instances_kernel_id, instances.ramdisk_id AS instances_ramdisk_id, instances.server_name AS instances_server_name, instances.launch_index AS instances_launch_index, instances.key_name AS instances_key_name, instances.key_data AS ins
Trx read view will not see trx with id >= 0 2310740380, sees < 0 2310676535
---TRANSACTION 0 2310740363, ACTIVE 2 sec, process no 23489, OS thread id 140305292265216 waiting in InnoDB queue
mysql tables in use 12, locked 0
MySQL thread id 33162, query id 96486482 15.185.141.80 nova Sending data
SELECT instances.created_at AS instances_created_at, instances.updated_at AS instances_updated_at, instances.deleted_at AS instances_deleted_at, instances.deleted AS instances_deleted, instances.id AS instances_id, instances.user_id AS instances_user_id, instances.project_id AS instances_project_id, instances.image_ref AS instances_image_ref, instances.kernel_id AS instances_kernel_id, instances.ramdisk_id AS instances_ramdisk_id, instances.server_name AS instances_server_name, instances.launch_index AS instances_launch_index, instances.key_name AS instances_key_name, instances.key_data AS ins
Trx read view will not see trx with id >= 0 2310740364, sees < 0 2310676535
---TRANSACTION 0 2310740360, ACTIVE 2 sec, process no 23489, OS thread id 140305451013888 sleeping before joining InnoDB queue
mysql tables in use 12, locked 0
MySQL thread id 34354, query id 96486479 15.185.140.174 nova Sending data
SELECT instances.created_at AS instances_created_at, instances.updated_at AS instances_updated_at, instances.deleted_at AS instances_deleted_at, instances.deleted AS instances_deleted, instances.id AS instances_id, instances.user_id AS instances_user_id, instances.project_id AS instances_project_id, instances.image_ref AS instances_image_ref, instances.kernel_id AS instances_kernel_id, instances.ramdisk_id AS instances_ramdisk_id, instances.server_name AS instances_server_name, instances.launch_index AS instances_launch_index, instances.key_name AS instances_key_name, instances.key_data AS ins
Trx read view will not see trx with id >= 0 2310740361, sees < 0 2310676535
---TRANSACTION 0 2310740359, ACTIVE 2 sec, process no 23489, OS thread id 140305158723328 waiting in InnoDB queue
mysql tables in use 12, locked 0
MySQL thread id 33692, query id 96486476 15.185.142.2 nova Sending data
SELECT instances.created_at AS instances_created_at, instances.updated_at AS instances_updated_at, instances.deleted_at AS instances_deleted_at, instances.deleted AS instances_deleted, instances.id AS instances_id, instances.user_id AS instances_user_id, instances.project_id AS instances_project_id, instances.image_ref AS instances_image_ref, instances.kernel_id AS instances_kernel_id, instances.ramdisk_id AS instances_ramdisk_id, instances.server_name AS instances_server_name, instances.launch_index AS instances_launch_index, instances.key_name AS instances_key_name, instances.key_data AS ins
Trx read view will not see trx with id >= 0 2310740360, sees < 0 2310676535
---TRANSACTION 0 2310740358, ACTIVE 2 sec, process no 23489, OS thread id 140305305376512 waiting in InnoDB queue
mysql tables in use 12, locked 0
MySQL thread id 34136, query id 96486477 15.185.140.132 nova Sending data
SELECT instances.created_at AS instances_created_at, instances.updated_at AS instances_updated_at, instances.deleted_at AS instances_deleted_at, instances.deleted AS instances_deleted, instances.id AS instances_id, instances.user_id AS instances_user_id, instances.project_id AS instances_project_id, instances.image_ref AS instances_image_ref, instances.kernel_id AS instances_kernel_id, instances.ramdisk_id AS instances_ramdisk_id, instances.server_name AS instances_server_name, instances.launch_index AS instances_launch_index, instances.key_name AS instances_key_name, instances.key_data AS ins
Trx read view will not see trx with id >= 0 2310740359, sees < 0 2310676535
---TRANSACTION 0 2310740349, ACTIVE 2 sec, process no 23489, OS thread id 140305506162432 sleeping before joining InnoDB queue
mysql tables in use 12, locked 0
MySQL thread id 34206, query id 96486453 15.185.141.56 nova Sending data
SELECT instances.created_at AS instances_created_at, instances.updated_at AS instances_updated_at, instances.deleted_at AS instances_deleted_at, instances.deleted AS instances_deleted, instances.id AS instances_id, instances.user_id AS instances_user_id, instances.project_id AS instances_project_id, instances.image_ref AS instances_image_ref, instances.kernel_id AS instances_kernel_id, instances.ramdisk_id AS instances_ramdisk_id, instances.server_name AS instances_server_name, instances.launch_index AS instances_launch_index, instances.key_name AS instances_key_name, instances.key_data AS ins
Trx read view will not see trx with id >= 0 2310740350, sees < 0 2310676535
---TRANSACTION 0 2310740336, ACTIVE 2 sec, process no 23489, OS thread id 140305261717248 waiting in InnoDB queue
mysql tables in use 12, locked 0
MySQL thread id 33658, query id 96486411 15.185.141.216 nova Sending data
SELECT instances.created_at AS instances_created_at, instances.updated_at AS instances_updated_at, instances.deleted_at AS instances_deleted_at, instances.deleted AS instances_deleted, instances.id AS instances_id, instances.user_id AS instances_user_id, instances.project_id AS instances_project_id, instances.image_ref AS instances_image_ref, instances.kernel_id AS instances_kernel_id, instances.ramdisk_id AS instances_ramdisk_id, instances.server_name AS instances_server_name, instances.launch_index AS instances_launch_index, instances.key_name AS instances_key_name, instances.key_data AS ins
Trx read view will not see trx with id >= 0 2310740337, sees < 0 2310676535
---TRANSACTION 0 2310740325, ACTIVE 3 sec, process no 23489, OS thread id 140305604036352 waiting in InnoDB queue
mysql tables in use 12, locked 0
MySQL thread id 33783, query id 96486387 15.185.141.189 nova Sending data
SELECT instances.created_at AS instances_created_at, instances.updated_at AS instances_updated_at, instances.deleted_at AS instances_deleted_at, instances.deleted AS instances_deleted, instances.id AS instances_id, instances.user_id AS instances_user_id, instances.project_id AS instances_project_id, instances.image_ref AS instances_image_ref, instances.kernel_id AS instances_kernel_id, instances.ramdisk_id AS instances_ramdisk_id, instances.server_name AS instances_server_name, instances.launch_index AS instances_launch_index, instances.key_name AS instances_key_name, instances.key_data AS ins
Trx read view will not see trx with id >= 0 2310740326, sees < 0 2310676535
---TRANSACTION 0 2310740297, ACTIVE 3 sec, process no 23489, OS thread id 140305584842496 waiting in InnoDB queue
mysql tables in use 12, locked 0
MySQL thread id 33966, query id 96486341 15.185.140.51 nova Sending data
SELECT instances.created_at AS instances_created_at, instances.updated_at AS instances_updated_at, instances.deleted_at AS instances_deleted_at, instances.deleted AS instances_deleted, instances.id AS instances_id, instances.user_id AS instances_user_id, instances.project_id AS instances_project_id, instances.image_ref AS instances_image_ref, instances.kernel_id AS instances_kernel_id, instances.ramdisk_id AS instances_ramdisk_id, instances.server_name AS instances_server_name, instances.launch_index AS instances_launch_index, instances.key_name AS instances_key_name, instances.key_data AS ins
Trx read view will not see trx with id >= 0 2310740298, sees < 0 2310676535
---TRANSACTION 0 2310740204, ACTIVE 3 sec, process no 23489, OS thread id 140305470883584 sleeping before joining InnoDB queue
mysql tables in use 12, locked 0
MySQL thread id 33055, query id 96486151 15.185.140.155 nova Sending data
SELECT instances.created_at AS instances_created_at, instances.updated_at AS instances_updated_at, instances.deleted_at AS instances_deleted_at, instances.deleted AS instances_deleted, instances.id AS instances_id, instances.user_id AS instances_user_id, instances.project_id AS instances_project_id, instances.image_ref AS instances_image_ref, instances.kernel_id AS instances_kernel_id, instances.ramdisk_id AS instances_ramdisk_id, instances.server_name AS instances_server_name, instances.launch_index AS instances_launch_index, instances.key_name AS instances_key_name, instances.key_data AS ins
Trx read view will not see trx with id >= 0 2310740205, sees < 0 2310676535
---TRANSACTION 0 2310740186, ACTIVE 3 sec, process no 23489, OS thread id 140305468180224 waiting in InnoDB queue
mysql tables in use 12, locked 0
MySQL thread id 33216, query id 96486120 15.185.141.46 nova Sending data
SELECT instances.created_at AS instances_created_at, instances.updated_at AS instances_updated_at, instances.deleted_at AS instances_deleted_at, instances.deleted AS instances_deleted, instances.id AS instances_id, instances.user_id AS instances_user_id, instances.project_id AS instances_project_id, instances.image_ref AS instances_image_ref, instances.kernel_id AS instances_kernel_id, instances.ramdisk_id AS instances_ramdisk_id, instances.server_name AS instances_server_name, instances.launch_index AS instances_launch_index, instances.key_name AS instances_key_name, instances.key_data AS ins
Trx read view will not see trx with id >= 0 2310740187, sees < 0 2310676535
---TRANSACTION 0 2310740181, ACTIVE 3 sec, process no 23489, OS thread id 140305590925056 fetching rows, thread declared inside InnoDB 343
mysql tables in use 12, locked 0
MySQL thread id 34152, query id 96486104 15.185.140.162 nova Sending data
SELECT instances.created_at AS instances_created_at, instances.updated_at AS instances_updated_at, instances.deleted_at AS instances_deleted_at, instances.deleted AS instances_deleted, instances.id AS instances_id, instances.user_id AS instances_user_id, instances.project_id AS instances_project_id, instances.image_ref AS instances_image_ref, instances.kernel_id AS instances_kernel_id, instances.ramdisk_id AS instances_ramdisk_id, instances.server_name AS instances_server_name, instances.launch_index AS instances_launch_index, instances.key_name AS instances_key_name, instances.key_data AS ins
Trx read view will not see trx with id >= 0 2310740182, sees < 0 2310676535
---TRANSACTION 0 2310740072, ACTIVE 3 sec, process no 23489, OS thread id 140305492375296 sleeping before joining InnoDB queue
mysql tables in use 12, locked 0
MySQL thread id 34088, query id 96485886 15.185.140.229 nova Sending data
SELECT instances.created_at AS instances_created_at, instances.updated_at AS instances_updated_at, instances.deleted_at AS instances_deleted_at, instances.deleted AS instances_deleted, instances.id AS instances_id, instances.user_id AS instances_user_id, instances.project_id AS instances_project_id, instances.image_ref AS instances_image_ref, instances.kernel_id AS instances_kernel_id, instances.ramdisk_id AS instances_ramdisk_id, instances.server_name AS instances_server_name, instances.launch_index AS instances_launch_index, instances.key_name AS instances_key_name, instances.key_data AS ins
Trx read view will not see trx with id >= 0 2310740073, sees < 0 2310676535
---TRANSACTION 0 2310737792, ACTIVE 8 sec, process no 23489, OS thread id 140305619851008 waiting in InnoDB queue
mysql tables in use 6, locked 0
MySQL thread id 33521, query id 96481340 15.185.140.116 nova Sending data
SELECT fixed_ips.created_at AS fixed_ips_created_at, fixed_ips.updated_at AS fixed_ips_updated_at, fixed_ips.deleted_at AS fixed_ips_deleted_at, fixed_ips.deleted AS fixed_ips_deleted, fixed_ips.id AS fixed_ips_id, fixed_ips.address AS fixed_ips_address, fixed_ips.network_id AS fixed_ips_network_id, fixed_ips.virtual_interface_id AS fixed_ips_virtual_interface_id, fixed_ips.instance_id AS fixed_ips_instance_id, fixed_ips.allocated AS fixed_ips_allocated, fixed_ips.leased AS fixed_ips_leased, fixed_ips.reserved AS fixed_ips_reserved, fixed_ips.host AS fixed_ips_host, networks_1.created_at AS ne
Trx read view will not see trx with id >= 0 2310737793, sees < 0 2310676535
---TRANSACTION 0 2310737744, ACTIVE 8 sec, process no 23489, OS thread id 140305608767232 waiting in InnoDB queue
mysql tables in use 2, locked 0
MySQL thread id 33610, query id 96481199 15.185.140.34 nova Sending data
SELECT anon_1.instance_types_created_at AS anon_1_instance_types_created_at, anon_1.instance_types_updated_at AS anon_1_instance_types_updated_at, anon_1.instance_types_deleted_at AS anon_1_instance_types_deleted_at, anon_1.instance_types_deleted AS anon_1_instance_types_deleted, anon_1.instance_types_id AS anon_1_instance_types_id, anon_1.instance_types_name AS anon_1_instance_types_name, anon_1.instance_types_memory_mb AS anon_1_instance_types_memory_mb, anon_1.instance_types_vcpus AS anon_1_instance_types_vcpus, anon_1.instance_types_local_gb AS anon_1_instance_types_local_gb, anon_1.instan
Trx read view will not see trx with id >= 0 2310737745, sees < 0 2310676535
---TRANSACTION 0 2310737716, ACTIVE 8 sec, process no 23489, OS thread id 140305158047488 sleeping before joining InnoDB queue
mysql tables in use 6, locked 0
MySQL thread id 33379, query id 96481190 15.185.140.48 nova Sending data
SELECT fixed_ips.created_at AS fixed_ips_created_at, fixed_ips.updated_at AS fixed_ips_updated_at, fixed_ips.deleted_at AS fixed_ips_deleted_at, fixed_ips.deleted AS fixed_ips_deleted, fixed_ips.id AS fixed_ips_id, fixed_ips.address AS fixed_ips_address, fixed_ips.network_id AS fixed_ips_network_id, fixed_ips.virtual_interface_id AS fixed_ips_virtual_interface_id, fixed_ips.instance_id AS fixed_ips_instance_id, fixed_ips.allocated AS fixed_ips_allocated, fixed_ips.leased AS fixed_ips_leased, fixed_ips.reserved AS fixed_ips_reserved, fixed_ips.host AS fixed_ips_host, networks_1.created_at AS ne
Trx read view will not see trx with id >= 0 2310737717, sees < 0 2310676535
---TRANSACTION 0 2310737303, ACTIVE 9 sec, process no 23489, OS thread id 140305301862144 waiting in InnoDB queue
mysql tables in use 2, locked 0
MySQL thread id 34276, query id 96480326 15.185.140.118 nova Sending data
SELECT anon_1.instance_types_created_at AS anon_1_instance_types_created_at, anon_1.instance_types_updated_at AS anon_1_instance_types_updated_at, anon_1.instance_types_deleted_at AS anon_1_instance_types_deleted_at, anon_1.instance_types_deleted AS anon_1_instance_types_deleted, anon_1.instance_types_id AS anon_1_instance_types_id, anon_1.instance_types_name AS anon_1_instance_types_name, anon_1.instance_types_memory_mb AS anon_1_instance_types_memory_mb, anon_1.instance_types_vcpus AS anon_1_instance_types_vcpus, anon_1.instance_types_local_gb AS anon_1_instance_types_local_gb, anon_1.instan
Trx read view will not see trx with id >= 0 2310737304, sees < 0 2310676535
---TRANSACTION 0 2310736945, ACTIVE 9 sec, process no 23489, OS thread id 140305451554560 waiting in InnoDB queue
mysql tables in use 6, locked 0
MySQL thread id 34230, query id 96479633 15.185.140.53 nova Sending data
SELECT fixed_ips.created_at AS fixed_ips_created_at, fixed_ips.updated_at AS fixed_ips_updated_at, fixed_ips.deleted_at AS fixed_ips_deleted_at, fixed_ips.deleted AS fixed_ips_deleted, fixed_ips.id AS fixed_ips_id, fixed_ips.address AS fixed_ips_address, fixed_ips.network_id AS fixed_ips_network_id, fixed_ips.virtual_interface_id AS fixed_ips_virtual_interface_id, fixed_ips.instance_id AS fixed_ips_instance_id, fixed_ips.allocated AS fixed_ips_allocated, fixed_ips.leased AS fixed_ips_leased, fixed_ips.reserved AS fixed_ips_reserved, fixed_ips.host AS fixed_ips_host, networks_1.created_at AS ne
Trx read view will not see trx with id >= 0 2310736946, sees < 0 2310676535
---TRANSACTION 0 2310736878, ACTIVE 10 sec, process no 23489, OS thread id 140305448716032 waiting in InnoDB queue
mysql tables in use 6, locked 0
MySQL thread id 34241, query id 96479509 15.185.140.81 nova Sending data
SELECT fixed_ips.created_at AS fixed_ips_created_at, fixed_ips.updated_at AS fixed_ips_updated_at, fixed_ips.deleted_at AS fixed_ips_deleted_at, fixed_ips.deleted AS fixed_ips_deleted, fixed_ips.id AS fixed_ips_id, fixed_ips.address AS fixed_ips_address, fixed_ips.network_id AS fixed_ips_network_id, fixed_ips.virtual_interface_id AS fixed_ips_virtual_interface_id, fixed_ips.instance_id AS fixed_ips_instance_id, fixed_ips.allocated AS fixed_ips_allocated, fixed_ips.leased AS fixed_ips_leased, fixed_ips.reserved AS fixed_ips_reserved, fixed_ips.host AS fixed_ips_host, networks_1.created_at AS ne
Trx read view will not see trx with id >= 0 2310736879, sees < 0 2310676535
---TRANSACTION 0 2310736809, ACTIVE 10 sec, process no 23489, OS thread id 140305158858496 waiting in InnoDB queue
mysql tables in use 6, locked 0
MySQL thread id 33448, query id 96479374 15.185.140.206 nova Sending data
SELECT fixed_ips.created_at AS fixed_ips_created_at, fixed_ips.updated_at AS fixed_ips_updated_at, fixed_ips.deleted_at AS fixed_ips_deleted_at, fixed_ips.deleted AS fixed_ips_deleted, fixed_ips.id AS fixed_ips_id, fixed_ips.address AS fixed_ips_address, fixed_ips.network_id AS fixed_ips_network_id, fixed_ips.virtual_interface_id AS fixed_ips_virtual_interface_id, fixed_ips.instance_id AS fixed_ips_instance_id, fixed_ips.allocated AS fixed_ips_allocated, fixed_ips.leased AS fixed_ips_leased, fixed_ips.reserved AS fixed_ips_reserved, fixed_ips.host AS fixed_ips_host, networks_1.created_at AS ne
Trx read view will not see trx with id >= 0 2310736827, sees < 0 2310676535
---TRANSACTION 0 2310736280, ACTIVE 11 sec, process no 23489, OS thread id 140305161967360 waiting in InnoDB queue
mysql tables in use 6, locked 0
MySQL thread id 33330, query id 96478320 15.185.140.232 nova Sending data
SELECT fixed_ips.created_at AS fixed_ips_created_at, fixed_ips.updated_at AS fixed_ips_updated_at, fixed_ips.deleted_at AS fixed_ips_deleted_at, fixed_ips.deleted AS fixed_ips_deleted, fixed_ips.id AS fixed_ips_id, fixed_ips.address AS fixed_ips_address, fixed_ips.network_id AS fixed_ips_network_id, fixed_ips.virtual_interface_id AS fixed_ips_virtual_interface_id, fixed_ips.instance_id AS fixed_ips_instance_id, fixed_ips.allocated AS fixed_ips_allocated, fixed_ips.leased AS fixed_ips_leased, fixed_ips.reserved AS fixed_ips_reserved, fixed_ips.host AS fixed_ips_host, networks_1.created_at AS ne
Trx read view will not see trx with id >= 0 2310736281, sees < 0 2310676535
---TRANSACTION 0 2310736060, ACTIVE 11 sec, process no 23489, OS thread id 140305498052352 fetching rows, thread declared inside InnoDB 135
mysql tables in use 2, locked 0
MySQL thread id 33106, query id 96477870 15.185.140.240 nova Copying to tmp table
SELECT instance_types.created_at AS instance_types_created_at, instance_types.updated_at AS instance_types_updated_at, instance_types.deleted_at AS instance_types_deleted_at, instance_types.deleted AS instance_types_deleted, instance_types.id AS instance_types_id, instance_types.name AS instance_types_name, instance_types.memory_mb AS instance_types_memory_mb, instance_types.vcpus AS instance_types_vcpus, instance_types.local_gb AS instance_types_local_gb, instance_types.flavorid AS instance_types_flavorid, instance_types.swap AS instance_types_swap, instance_types.rxtx_quota AS instance_types
Trx read view will not see trx with id >= 0 2310736061, sees < 0 2310676535
---TRANSACTION 0 2310736033, ACTIVE 11 sec, process no 23489, OS thread id 140305615255296 waiting in InnoDB queue
mysql tables in use 6, locked 0
MySQL thread id 33480, query id 96477823 15.185.140.141 nova Sending data
SELECT fixed_ips.created_at AS fixed_ips_created_at, fixed_ips.updated_at AS fixed_ips_updated_at, fixed_ips.deleted_at AS fixed_ips_deleted_at, fixed_ips.deleted AS fixed_ips_deleted, fixed_ips.id AS fixed_ips_id, fixed_ips.address AS fixed_ips_address, fixed_ips.network_id AS fixed_ips_network_id, fixed_ips.virtual_interface_id AS fixed_ips_virtual_interface_id, fixed_ips.instance_id AS fixed_ips_instance_id, fixed_ips.allocated AS fixed_ips_allocated, fixed_ips.leased AS fixed_ips_leased, fixed_ips.reserved AS fixed_ips_reserved, fixed_ips.host AS fixed_ips_host, networks_1.created_at AS ne
Trx read view will not see trx with id >= 0 2310736057, sees < 0 2310676535
---TRANSACTION 0 2310735849, ACTIVE 12 sec, process no 23489, OS thread id 140305498322688 sleeping before joining InnoDB queue
mysql tables in use 6, locked 0
MySQL thread id 34155, query id 96477459 15.185.140.131 nova Sending data
SELECT fixed_ips.created_at AS fixed_ips_created_at, fixed_ips.updated_at AS fixed_ips_updated_at, fixed_ips.deleted_at AS fixed_ips_deleted_at, fixed_ips.deleted AS fixed_ips_deleted, fixed_ips.id AS fixed_ips_id, fixed_ips.address AS fixed_ips_address, fixed_ips.network_id AS fixed_ips_network_id, fixed_ips.virtual_interface_id AS fixed_ips_virtual_interface_id, fixed_ips.instance_id AS fixed_ips_instance_id, fixed_ips.allocated AS fixed_ips_allocated, fixed_ips.leased AS fixed_ips_leased, fixed_ips.reserved AS fixed_ips_reserved, fixed_ips.host AS fixed_ips_host, networks_1.created_at AS ne
Trx read view will not see trx with id >= 0 2310735850, sees < 0 2310676535
---TRANSACTION 0 2310735069, ACTIVE 13 sec, process no 23489, OS thread id 140305273206528 waiting in InnoDB queue
mysql tables in use 6, locked 0
MySQL thread id 33507, query id 96475879 15.185.140.176 nova Sending data
SELECT fixed_ips.created_at AS fixed_ips_created_at, fixed_ips.updated_at AS fixed_ips_updated_at, fixed_ips.deleted_at AS fixed_ips_deleted_at, fixed_ips.deleted AS fixed_ips_deleted, fixed_ips.id AS fixed_ips_id, fixed_ips.address AS fixed_ips_address, fixed_ips.network_id AS fixed_ips_network_id, fixed_ips.virtual_interface_id AS fixed_ips_virtual_interface_id, fixed_ips.instance_id AS fixed_ips_instance_id, fixed_ips.allocated AS fixed_ips_allocated, fixed_ips.leased AS fixed_ips_leased, fixed_ips.reserved AS fixed_ips_reserved, fixed_ips.host AS fixed_ips_host, networks_1.created_at AS ne
Trx read view will not see trx with id >= 0 2310735070, sees < 0 2310676535
---TRANSACTION 0 2310734170, ACTIVE 15 sec, process no 23489, OS thread id 140305492645632 waiting in InnoDB queue
mysql tables in use 2, locked 0
MySQL thread id 33588, query id 96474022 15.185.140.248 nova Sending data
SELECT anon_1.instance_types_created_at AS anon_1_instance_types_created_at, anon_1.instance_types_updated_at AS anon_1_instance_types_updated_at, anon_1.instance_types_deleted_at AS anon_1_instance_types_deleted_at, anon_1.instance_types_deleted AS anon_1_instance_types_deleted, anon_1.instance_types_id AS anon_1_instance_types_id, anon_1.instance_types_name AS anon_1_instance_types_name, anon_1.instance_types_memory_mb AS anon_1_instance_types_memory_mb, anon_1.instance_types_vcpus AS anon_1_instance_types_vcpus, anon_1.instance_types_local_gb AS anon_1_instance_types_local_gb, anon_1.instan
Trx read view will not see trx with id >= 0 2310734171, sees < 0 2310676535
---TRANSACTION 0 2310733198, ACTIVE 17 sec, process no 23489, OS thread id 140305269827328 waiting in InnoDB queue
mysql tables in use 6, locked 0
MySQL thread id 33342, query id 96472103 15.185.141.1 nova Sending data
SELECT fixed_ips.created_at AS fixed_ips_created_at, fixed_ips.updated_at AS fixed_ips_updated_at, fixed_ips.deleted_at AS fixed_ips_deleted_at, fixed_ips.deleted AS fixed_ips_deleted, fixed_ips.id AS fixed_ips_id, fixed_ips.address AS fixed_ips_address, fixed_ips.network_id AS fixed_ips_network_id, fixed_ips.virtual_interface_id AS fixed_ips_virtual_interface_id, fixed_ips.instance_id AS fixed_ips_instance_id, fixed_ips.allocated AS fixed_ips_allocated, fixed_ips.leased AS fixed_ips_leased, fixed_ips.reserved AS fixed_ips_reserved, fixed_ips.host AS fixed_ips_host, networks_1.created_at AS ne
Trx read view will not see trx with id >= 0 2310733199, sees < 0 2310676535
---TRANSACTION 0 2310733070, ACTIVE 17 sec, process no 23489, OS thread id 140305276991232 sleeping before joining InnoDB queue
mysql tables in use 6, locked 0
MySQL thread id 33524, query id 96471849 15.185.140.191 nova Sending data
SELECT fixed_ips.created_at AS fixed_ips_created_at, fixed_ips.updated_at AS fixed_ips_updated_at, fixed_ips.deleted_at AS fixed_ips_deleted_at, fixed_ips.deleted AS fixed_ips_deleted, fixed_ips.id AS fixed_ips_id, fixed_ips.address AS fixed_ips_address, fixed_ips.network_id AS fixed_ips_network_id, fixed_ips.virtual_interface_id AS fixed_ips_virtual_interface_id, fixed_ips.instance_id AS fixed_ips_instance_id, fixed_ips.allocated AS fixed_ips_allocated, fixed_ips.leased AS fixed_ips_leased, fixed_ips.reserved AS fixed_ips_reserved, fixed_ips.host AS fixed_ips_host, networks_1.created_at AS ne
Trx read view will not see trx with id >= 0 2310733100, sees < 0 2310676535
---TRANSACTION 0 2310732710, ACTIVE 17 sec, process no 23489, OS thread id 140305594709760 waiting in InnoDB queue
mysql tables in use 6, locked 0
MySQL thread id 33609, query id 96471110 15.185.140.231 nova Sending data
SELECT fixed_ips.created_at AS fixed_ips_created_at, fixed_ips.updated_at AS fixed_ips_updated_at, fixed_ips.deleted_at AS fixed_ips_deleted_at, fixed_ips.deleted AS fixed_ips_deleted, fixed_ips.id AS fixed_ips_id, fixed_ips.address AS fixed_ips_address, fixed_ips.network_id AS fixed_ips_network_id, fixed_ips.virtual_interface_id AS fixed_ips_virtual_interface_id, fixed_ips.instance_id AS fixed_ips_instance_id, fixed_ips.allocated AS fixed_ips_allocated, fixed_ips.leased AS fixed_ips_leased, fixed_ips.reserved AS fixed_ips_reserved, fixed_ips.host AS fixed_ips_host, networks_1.created_at AS ne
Trx read view will not see trx with id >= 0 2310732711, sees < 0 2310676535
---TRANSACTION 0 2310731772, ACTIVE 19 sec, process no 23489, OS thread id 140305669281536 waiting in InnoDB queue
mysql tables in use 6, locked 0
MySQL thread id 34082, query id 96469261 15.185.140.17 nova Sending data
SELECT fixed_ips.created_at AS fixed_ips_created_at, fixed_ips.updated_at AS fixed_ips_updated_at, fixed_ips.deleted_at AS fixed_ips_deleted_at, fixed_ips.deleted AS fixed_ips_deleted, fixed_ips.id AS fixed_ips_id, fixed_ips.address AS fixed_ips_address, fixed_ips.network_id AS fixed_ips_network_id, fixed_ips.virtual_interface_id AS fixed_ips_virtual_interface_id, fixed_ips.instance_id AS fixed_ips_instance_id, fixed_ips.allocated AS fixed_ips_allocated, fixed_ips.leased AS fixed_ips_leased, fixed_ips.reserved AS fixed_ips_reserved, fixed_ips.host AS fixed_ips_host, networks_1.created_at AS ne
Trx read view will not see trx with id >= 0 2310731804, sees < 0 2310676535
---TRANSACTION 0 2310731728, ACTIVE 19 sec, process no 23489, OS thread id 140305240901376 waiting in InnoDB queue
mysql tables in use 16, locked 0
MySQL thread id 33186, query id 96469151 15.185.142.5 nova Sending data
SELECT instances.created_at AS instances_created_at, instances.updated_at AS instances_updated_at, instances.deleted_at AS instances_deleted_at, instances.deleted AS instances_deleted, instances.id AS instances_id, instances.user_id AS instances_user_id, instances.project_id AS instances_project_id, instances.image_ref AS instances_image_ref, instances.kernel_id AS instances_kernel_id, instances.ramdisk_id AS instances_ramdisk_id, instances.server_name AS instances_server_name, instances.launch_index AS instances_launch_index, instances.key_name AS instances_key_name, instances.key_data AS ins
Trx read view will not see trx with id >= 0 2310731729, sees < 0 2310676535
---TRANSACTION 0 2310729303, ACTIVE 24 sec, process no 23489, OS thread id 140305281316608 waiting in InnoDB queue
mysql tables in use 6, locked 0
MySQL thread id 33378, query id 96464322 15.185.140.38 nova Sending data
SELECT fixed_ips.created_at AS fixed_ips_created_at, fixed_ips.updated_at AS fixed_ips_updated_at, fixed_ips.deleted_at AS fixed_ips_deleted_at, fixed_ips.deleted AS fixed_ips_deleted, fixed_ips.id AS fixed_ips_id, fixed_ips.address AS fixed_ips_address, fixed_ips.network_id AS fixed_ips_network_id, fixed_ips.virtual_interface_id AS fixed_ips_virtual_interface_id, fixed_ips.instance_id AS fixed_ips_instance_id, fixed_ips.allocated AS fixed_ips_allocated, fixed_ips.leased AS fixed_ips_leased, fixed_ips.reserved AS fixed_ips_reserved, fixed_ips.host AS fixed_ips_host, networks_1.created_at AS ne
Trx read view will not see trx with id >= 0 2310729304, sees < 0 2310619474
---TRANSACTION 0 2310727125, ACTIVE 29 sec, process no 23489, OS thread id 140305444931328 sleeping before joining InnoDB queue
mysql tables in use 6, locked 0
MySQL thread id 34188, query id 96459998 15.185.141.174 nova Sending data
SELECT fixed_ips.created_at AS fixed_ips_created_at, fixed_ips.updated_at AS fixed_ips_updated_at, fixed_ips.deleted_at AS fixed_ips_deleted_at, fixed_ips.deleted AS fixed_ips_deleted, fixed_ips.id AS fixed_ips_id, fixed_ips.address AS fixed_ips_address, fixed_ips.network_id AS fixed_ips_network_id, fixed_ips.virtual_interface_id AS fixed_ips_virtual_interface_id, fixed_ips.instance_id AS fixed_ips_instance_id, fixed_ips.allocated AS fixed_ips_allocated, fixed_ips.leased AS fixed_ips_leased, fixed_ips.reserved AS fixed_ips_reserved, fixed_ips.host AS fixed_ips_host, networks_1.created_at AS ne
Trx read view will not see trx with id >= 0 2310727126, sees < 0 2310370337
---TRANSACTION 0 2310724421, ACTIVE 34 sec, process no 23489, OS thread id 140305470342912 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 34355, query id 96454558 localhost nova Sending data
select * from services
Trx read view will not see trx with id >= 0 2310724432, sees < 0 2310370337
---TRANSACTION 0 2310720487, ACTIVE 42 sec, process no 23489, OS thread id 140305272936192 waiting in InnoDB queue
mysql tables in use 2, locked 0
MySQL thread id 33112, query id 96446666 15.185.140.96 nova Sending data
SELECT anon_1.instance_types_created_at AS anon_1_instance_types_created_at, anon_1.instance_types_updated_at AS anon_1_instance_types_updated_at, anon_1.instance_types_deleted_at AS anon_1_instance_types_deleted_at, anon_1.instance_types_deleted AS anon_1_instance_types_deleted, anon_1.instance_types_id AS anon_1_instance_types_id, anon_1.instance_types_name AS anon_1_instance_types_name, anon_1.instance_types_memory_mb AS anon_1_instance_types_memory_mb, anon_1.instance_types_vcpus AS anon_1_instance_types_vcpus, anon_1.instance_types_local_gb AS anon_1_instance_types_local_gb, anon_1.instan
Trx read view will not see trx with id >= 0 2310720488, sees < 0 2310370337
---TRANSACTION 0 2310709578, ACTIVE 64 sec, process no 23489, OS thread id 140305458042624 waiting in InnoDB queue
mysql tables in use 2, locked 0
MySQL thread id 33103, query id 96424865 15.185.140.240 nova Sending data
SELECT anon_1.instance_types_created_at AS anon_1_instance_types_created_at, anon_1.instance_types_updated_at AS anon_1_instance_types_updated_at, anon_1.instance_types_deleted_at AS anon_1_instance_types_deleted_at, anon_1.instance_types_deleted AS anon_1_instance_types_deleted, anon_1.instance_types_id AS anon_1_instance_types_id, anon_1.instance_types_name AS anon_1_instance_types_name, anon_1.instance_types_memory_mb AS anon_1_instance_types_memory_mb, anon_1.instance_types_vcpus AS anon_1_instance_types_vcpus, anon_1.instance_types_local_gb AS anon_1_instance_types_local_gb, anon_1.instan
Trx read view will not see trx with id >= 0 2310709579, sees < 0 2310370337
---TRANSACTION 0 2310704340, ACTIVE 74 sec, process no 23489, OS thread id 140305249416960 waiting in InnoDB queue
mysql tables in use 2, locked 0
MySQL thread id 33667, query id 96414358 15.185.141.237 nova Sending data
SELECT anon_1.instance_types_created_at AS anon_1_instance_types_created_at, anon_1.instance_types_updated_at AS anon_1_instance_types_updated_at, anon_1.instance_types_deleted_at AS anon_1_instance_types_deleted_at, anon_1.instance_types_deleted AS anon_1_instance_types_deleted, anon_1.instance_types_id AS anon_1_instance_types_id, anon_1.instance_types_name AS anon_1_instance_types_name, anon_1.instance_types_memory_mb AS anon_1_instance_types_memory_mb, anon_1.instance_types_vcpus AS anon_1_instance_types_vcpus, anon_1.instance_types_local_gb AS anon_1_instance_types_local_gb, anon_1.instan
Trx read view will not see trx with id >= 0 2310704341, sees < 0 2310370337
---TRANSACTION 0 2310676535, ACTIVE 130 sec, process no 23489, OS thread id 140305670362880 waiting in InnoDB queue
mysql tables in use 2, locked 0
MySQL thread id 33098, query id 96358736 15.185.140.96 nova Sending data
SELECT anon_1.instance_types_created_at AS anon_1_instance_types_created_at, anon_1.instance_types_updated_at AS anon_1_instance_types_updated_at, anon_1.instance_types_deleted_at AS anon_1_instance_types_deleted_at, anon_1.instance_types_deleted AS anon_1_instance_types_deleted, anon_1.instance_types_id AS anon_1_instance_types_id, anon_1.instance_types_name AS anon_1_instance_types_name, anon_1.instance_types_memory_mb AS anon_1_instance_types_memory_mb, anon_1.instance_types_vcpus AS anon_1_instance_types_vcpus, anon_1.instance_types_local_gb AS anon_1_instance_types_local_gb, anon_1.instan
Trx read view will not see trx with id >= 0 2310676536, sees < 0 2310305961
--------
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: 0
4361 OS file reads, 30174657 OS file writes, 30085807 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 319.63 writes/s, 318.93 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 0, seg size 2,
23 inserts, 23 merged recs, 22 merges
Hash table size 553253, node heap has 282 buffer(s)
5246.94 hash searches/s, 982.00 non-hash searches/s
---
LOG
---
Log sequence number 45 1054941053
Log flushed up to 45 1054941053
Last checkpoint at 45 1049734850
0 pending log writes, 0 pending chkp writes
30061426 log i/o's done, 318.73 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 333923338; in additional pool allocated 1047808
Dictionary memory allocated 222056
Buffer pool size 16384
Free buffers 1
Database pages 16101
Modified db pages 1934
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages read 8182, created 102798, written 581185
0.00 reads/s, 1.20 creates/s, 2.30 writes/s
Buffer pool hit rate 1000 / 1000
--------------
ROW OPERATIONS
--------------
8 queries inside InnoDB, 160 queries in queue
152 read views open inside InnoDB
Main thread process no. 23489, id 140305628919552, state: sleeping
Number of rows inserted 2355, updated 15015762, deleted 493, read 108778620197
0.45 inserts/s, 158.79 updates/s, 0.00 deletes/s, 1160556.57 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================
1 row in set, 1 warning (0.01 sec)
mysql>