MariaDB [(none)]> SHOW GLOBAL VARIABLES; +--------------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Variable_name | Value | +--------------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | aria_block_size | 8192 | | aria_checkpoint_interval | 30 | | aria_checkpoint_log_activity | 1048576 | | aria_force_start_after_recovery_failures | 0 | | aria_group_commit | none | | aria_group_commit_interval | 0 | | aria_log_file_size | 1073741824 | | aria_log_purge_type | immediate | | aria_max_sort_file_size | 9223372036853727232 | | aria_page_checksum | ON | | aria_pagecache_age_threshold | 300 | | aria_pagecache_buffer_size | 134217728 | | aria_pagecache_division_limit | 100 | | aria_pagecache_file_hash_size | 512 | | aria_recover | NORMAL | | aria_repair_threads | 1 | | aria_sort_buffer_size | 268434432 | | aria_stats_method | nulls_unequal | | aria_sync_log_dir | NEWFILE | | aria_used_for_temp_tables | ON | | auto_increment_increment | 1 | | auto_increment_offset | 1 | | autocommit | ON | | automatic_sp_privileges | ON | | back_log | 150 | | basedir | /usr | | big_tables | OFF | | binlog_annotate_row_events | OFF | | binlog_cache_size | 32768 | | binlog_checksum | NONE | | binlog_commit_wait_count | 0 | | binlog_commit_wait_usec | 100000 | | binlog_direct_non_transactional_updates | OFF | | binlog_format | ROW | | binlog_optimize_thread_scheduling | ON | | binlog_stmt_cache_size | 32768 | | bulk_insert_buffer_size | 8388608 | | character_set_client | latin1 | | character_set_connection | latin1 | | character_set_database | latin1 | | character_set_filesystem | binary | | character_set_results | latin1 | | character_set_server | latin1 | | character_set_system | utf8 | | character_sets_dir | /usr/share/mysql/charsets/ | | collation_connection | latin1_bin | | collation_database | latin1_bin | | collation_server | latin1_bin | | completion_type | NO_CHAIN | | concurrent_insert | AUTO | | connect_timeout | 10 | | datadir | /data/lib/mysql/ | | date_format | %Y-%m-%d | | datetime_format | %Y-%m-%d %H:%i:%s | | deadlock_search_depth_long | 15 | | deadlock_search_depth_short | 4 | | deadlock_timeout_long | 50000000 | | deadlock_timeout_short | 10000 | | debug_no_thread_alarm | OFF | | default_regex_flags | | | default_storage_engine | InnoDB | | default_week_format | 0 | | delay_key_write | ON | | delayed_insert_limit | 100 | | delayed_insert_timeout | 300 | | delayed_queue_size | 1000 | | div_precision_increment | 4 | | event_scheduler | OFF | | expensive_subquery_limit | 100 | | expire_logs_days | 0 | | extra_max_connections | 1 | | extra_port | 0 | | flush | OFF | | flush_time | 0 | | foreign_key_checks | ON | | ft_boolean_syntax | + -><()~*:""&| | | ft_max_word_len | 84 | | ft_min_word_len | 4 | | ft_query_expansion_limit | 20 | | ft_stopword_file | (built-in) | | general_log | OFF | | general_log_file | SESAMMALSQL01.log | | group_concat_max_len | 1024 | | gtid_binlog_pos | 0-10-17145597 | | gtid_binlog_state | 0-10-17145597 | | gtid_current_pos | 0-10-17145597 | | gtid_domain_id | 0 | | gtid_ignore_duplicates | OFF | | gtid_slave_pos | | | gtid_strict_mode | OFF | | have_compress | YES | | have_crypt | YES | | have_dynamic_loading | YES | | have_geometry | YES | | have_openssl | YES | | have_profiling | YES | | have_query_cache | YES | | have_rtree_keys | YES | | have_ssl | DISABLED | | have_symlink | YES | | histogram_size | 0 | | histogram_type | SINGLE_PREC_HB | | host_cache_size | 128 | | hostname | SESAMMALSQL01 | | ignore_builtin_innodb | OFF | | ignore_db_dirs | | | init_connect | | | init_file | | | init_slave | | | innodb_adaptive_flushing | ON | | innodb_adaptive_flushing_lwm | 10 | | innodb_adaptive_hash_index | ON | | innodb_adaptive_hash_index_partitions | 1 | | innodb_adaptive_max_sleep_delay | 150000 | | innodb_additional_mem_pool_size | 33554432 | | innodb_api_bk_commit_interval | 5 | | innodb_api_disable_rowlock | OFF | | innodb_api_enable_binlog | OFF | | innodb_api_enable_mdl | OFF | | innodb_api_trx_level | 0 | | innodb_autoextend_increment | 64 | | innodb_autoinc_lock_mode | 2 | | innodb_buffer_pool_dump_at_shutdown | OFF | | innodb_buffer_pool_dump_now | OFF | | innodb_buffer_pool_filename | ib_buffer_pool | | innodb_buffer_pool_instances | 8 | | innodb_buffer_pool_load_abort | OFF | | innodb_buffer_pool_load_at_startup | OFF | | innodb_buffer_pool_load_now | OFF | | innodb_buffer_pool_populate | OFF | | innodb_buffer_pool_size | 21474836480 | | innodb_change_buffer_max_size | 25 | | innodb_change_buffering | all | | innodb_checksum_algorithm | innodb | | innodb_checksums | ON | | innodb_cleaner_lsn_age_factor | high_checkpoint | | innodb_cmp_per_index_enabled | OFF | | innodb_commit_concurrency | 0 | | innodb_compression_failure_threshold_pct | 5 | | innodb_compression_level | 6 | | innodb_compression_pad_pct_max | 50 | | innodb_concurrency_tickets | 5000 | | innodb_corrupt_table_action | assert | | innodb_data_file_path | ibdata1:12M:autoextend | | innodb_data_home_dir | | | innodb_disable_sort_file_cache | OFF | | innodb_disallow_writes | OFF | | innodb_doublewrite | ON | | innodb_empty_free_list_algorithm | backoff | | innodb_fake_changes | OFF | | innodb_fast_shutdown | 1 | | innodb_file_format | Antelope | | innodb_file_format_check | ON | | innodb_file_format_max | Antelope | | innodb_file_per_table | ON | | innodb_flush_log_at_timeout | 1 | | innodb_flush_log_at_trx_commit | 1 | | innodb_flush_method | | | innodb_flush_neighbors | 1 | | innodb_flushing_avg_loops | 30 | | innodb_force_load_corrupted | OFF | | innodb_force_recovery | 0 | | innodb_foreground_preflush | exponential_backoff | | innodb_ft_aux_table | | | innodb_ft_cache_size | 8000000 | | innodb_ft_enable_diag_print | OFF | | innodb_ft_enable_stopword | ON | | innodb_ft_max_token_size | 84 | | innodb_ft_min_token_size | 3 | | innodb_ft_num_word_optimize | 2000 | | innodb_ft_result_cache_limit | 2000000000 | | innodb_ft_server_stopword_table | | | innodb_ft_sort_pll_degree | 2 | | innodb_ft_total_cache_size | 640000000 | | innodb_ft_user_stopword_table | | | innodb_io_capacity | 200 | | innodb_io_capacity_max | 2000 | | innodb_kill_idle_transaction | 0 | | innodb_large_prefix | OFF | | innodb_lock_wait_timeout | 50 | | innodb_locking_fake_changes | ON | | innodb_locks_unsafe_for_binlog | OFF | | innodb_log_arch_dir | ./ | | innodb_log_arch_expire_sec | 0 | | innodb_log_archive | OFF | | innodb_log_block_size | 512 | | innodb_log_buffer_size | 67108864 | | innodb_log_checksum_algorithm | innodb | | innodb_log_compressed_pages | ON | | innodb_log_file_size | 536870912 | | innodb_log_files_in_group | 2 | | innodb_log_group_home_dir | ./ | | innodb_lru_scan_depth | 1024 | | innodb_max_bitmap_file_size | 104857600 | | innodb_max_changed_pages | 1000000 | | innodb_max_dirty_pages_pct | 75 | | innodb_max_dirty_pages_pct_lwm | 0 | | innodb_max_purge_lag | 0 | | innodb_max_purge_lag_delay | 0 | | innodb_mirrored_log_groups | 1 | | innodb_monitor_disable | | | innodb_monitor_enable | | | innodb_monitor_reset | | | innodb_monitor_reset_all | | | innodb_old_blocks_pct | 37 | | innodb_old_blocks_time | 1000 | | innodb_online_alter_log_max_size | 134217728 | | innodb_open_files | 2048 | | innodb_optimize_fulltext_only | OFF | | innodb_page_size | 16384 | | innodb_print_all_deadlocks | OFF | | innodb_purge_batch_size | 300 | | innodb_purge_threads | 1 | | innodb_random_read_ahead | OFF | | innodb_read_ahead_threshold | 56 | | innodb_read_io_threads | 4 | | innodb_read_only | OFF | | innodb_replication_delay | 0 | | innodb_rollback_on_timeout | OFF | | innodb_rollback_segments | 128 | | innodb_sched_priority_cleaner | 19 | | innodb_show_locks_held | 10 | | innodb_show_verbose_locks | 0 | | innodb_simulate_comp_failures | 0 | | innodb_sort_buffer_size | 1048576 | | innodb_spin_wait_delay | 6 | | innodb_stats_auto_recalc | ON | | innodb_stats_method | nulls_equal | | innodb_stats_on_metadata | OFF | | innodb_stats_persistent | ON | | innodb_stats_persistent_sample_pages | 20 | | innodb_stats_sample_pages | 8 | | innodb_stats_transient_sample_pages | 8 | | innodb_status_output | OFF | | innodb_status_output_locks | OFF | | innodb_strict_mode | OFF | | innodb_support_xa | ON | | innodb_sync_array_size | 1 | | innodb_sync_spin_loops | 30 | | innodb_table_locks | ON | | innodb_thread_concurrency | 64 | | innodb_thread_sleep_delay | 0 | | innodb_track_changed_pages | OFF | | innodb_undo_directory | . | | innodb_undo_logs | 128 | | innodb_undo_tablespaces | 0 | | innodb_use_atomic_writes | OFF | | innodb_use_fallocate | OFF | | innodb_use_global_flush_log_at_trx_commit | ON | | innodb_use_native_aio | ON | | innodb_use_stacktrace | OFF | | innodb_use_sys_malloc | ON | | innodb_version | 5.6.20-68.0 | | innodb_write_io_threads | 4 | | interactive_timeout | 28800 | | join_buffer_size | 131072 | | join_buffer_space_limit | 2097152 | | join_cache_level | 2 | | keep_files_on_create | OFF | | key_buffer_size | 57671680 | | key_cache_age_threshold | 300 | | key_cache_block_size | 1024 | | key_cache_division_limit | 100 | | key_cache_file_hash_size | 512 | | key_cache_segments | 0 | | large_files_support | ON | | large_page_size | 0 | | large_pages | OFF | | lc_messages | en_US | | lc_messages_dir | | | lc_time_names | en_US | | license | GPL | | local_infile | OFF | | lock_wait_timeout | 31536000 | | locked_in_memory | OFF | | log_bin | ON | | log_bin_trust_function_creators | OFF | | log_error | /var/log/mysql.log | | log_output | FILE | | log_queries_not_using_indexes | OFF | | log_slave_updates | ON | | log_slow_filter | admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk | | log_slow_rate_limit | 1 | | log_slow_verbosity | | | log_warnings | 1 | | long_query_time | 10.000000 | | low_priority_updates | OFF | | lower_case_file_system | OFF | | lower_case_table_names | 0 | | master_verify_checksum | OFF | | max_allowed_packet | 104857600 | | max_binlog_cache_size | 18446744073709547520 | | max_binlog_size | 1073741824 | | max_binlog_stmt_cache_size | 18446744073709547520 | | max_connect_errors | 100 | | max_connections | 1024 | | max_delayed_threads | 20 | | max_error_count | 64 | | max_heap_table_size | 16777216 | | max_insert_delayed_threads | 20 | | max_join_size | 18446744073709551615 | | max_length_for_sort_data | 1024 | | max_long_data_size | 104857600 | | max_prepared_stmt_count | 16382 | | max_relay_log_size | 1073741824 | | max_seeks_for_key | 4294967295 | | max_sort_length | 1024 | | max_sp_recursion_depth | 0 | | max_tmp_tables | 32 | | max_user_connections | 0 | | max_write_lock_count | 4294967295 | | metadata_locks_cache_size | 1024 | | metadata_locks_hash_instances | 8 | | min_examined_row_limit | 0 | | mrr_buffer_size | 262144 | | multi_range_count | 256 | | myisam_block_size | 1024 | | myisam_data_pointer_size | 6 | | myisam_max_sort_file_size | 107374182400 | | myisam_mmap_size | 18446744073709551615 | | myisam_recover_options | DEFAULT | | myisam_repair_threads | 1 | | myisam_sort_buffer_size | 131072000 | | myisam_stats_method | nulls_unequal | | myisam_use_mmap | OFF | | net_buffer_length | 16384 | | net_read_timeout | 30 | | net_retry_count | 10 | | net_write_timeout | 60 | | old | OFF | | old_alter_table | OFF | | old_mode | | | old_passwords | OFF | | open_files_limit | 5131 | | optimizer_prune_level | 1 | | optimizer_search_depth | 62 | | optimizer_selectivity_sampling_limit | 100 | | optimizer_switch | index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on | | optimizer_use_condition_selectivity | 1 | | performance_schema | OFF | | performance_schema_accounts_size | -1 | | performance_schema_digests_size | -1 | | performance_schema_events_stages_history_long_size | -1 | | performance_schema_events_stages_history_size | -1 | | performance_schema_events_statements_history_long_size | -1 | | performance_schema_events_statements_history_size | -1 | | performance_schema_events_waits_history_long_size | -1 | | performance_schema_events_waits_history_size | -1 | | performance_schema_hosts_size | -1 | | performance_schema_max_cond_classes | 80 | | performance_schema_max_cond_instances | -1 | | performance_schema_max_file_classes | 50 | | performance_schema_max_file_handles | 32768 | | performance_schema_max_file_instances | -1 | | performance_schema_max_mutex_classes | 200 | | performance_schema_max_mutex_instances | -1 | | performance_schema_max_rwlock_classes | 40 | | performance_schema_max_rwlock_instances | -1 | | performance_schema_max_socket_classes | 10 | | performance_schema_max_socket_instances | -1 | | performance_schema_max_stage_classes | 150 | | performance_schema_max_statement_classes | 180 | | performance_schema_max_table_handles | -1 | | performance_schema_max_table_instances | -1 | | performance_schema_max_thread_classes | 50 | | performance_schema_max_thread_instances | -1 | | performance_schema_session_connect_attrs_size | -1 | | performance_schema_setup_actors_size | 100 | | performance_schema_setup_objects_size | 100 | | performance_schema_users_size | -1 | | pid_file | /data/lib/mysql/SESAMMALSQL01.pid | | plugin_dir | /usr/lib64/mysql/plugin/ | | plugin_maturity | unknown | | port | 3306 | | preload_buffer_size | 32768 | | profiling | OFF | | profiling_history_size | 15 | | progress_report_time | 5 | | protocol_version | 10 | | query_alloc_block_size | 8192 | | query_cache_limit | 1048576 | | query_cache_min_res_unit | 4096 | | query_cache_size | 0 | | query_cache_strip_comments | OFF | | query_cache_type | OFF | | query_cache_wlock_invalidate | OFF | | query_prealloc_size | 8192 | | range_alloc_block_size | 4096 | | read_buffer_size | 65536 | | read_only | OFF | | read_rnd_buffer_size | 262144 | | relay_log | | | relay_log_index | | | relay_log_info_file | relay-log.info | | relay_log_purge | ON | | relay_log_recovery | OFF | | relay_log_space_limit | 0 | | replicate_annotate_row_events | OFF | | replicate_do_db | | | replicate_do_table | | | replicate_events_marked_for_skip | replicate | | replicate_ignore_db | | | replicate_ignore_table | | | replicate_wild_do_table | | | replicate_wild_ignore_table | | | report_host | | | report_password | | | report_port | 3306 | | report_user | | | rowid_merge_buff_size | 8388608 | | rpl_recovery_rank | 0 | | secure_auth | OFF | | secure_file_priv | | | server_id | 10 | | skip_external_locking | ON | | skip_name_resolve | ON | | skip_networking | OFF | | skip_show_database | OFF | | slave_compressed_protocol | OFF | | slave_ddl_exec_mode | IDEMPOTENT | | slave_domain_parallel_threads | 0 | | slave_exec_mode | STRICT | | slave_load_tmpdir | /tmp | | slave_max_allowed_packet | 1073741824 | | slave_net_timeout | 3600 | | slave_parallel_max_queued | 131072 | | slave_parallel_threads | 0 | | slave_skip_errors | OFF | | slave_sql_verify_checksum | ON | | slave_transaction_retries | 10 | | slave_type_conversions | | | slow_launch_time | 2 | | slow_query_log | OFF | | slow_query_log_file | SESAMMALSQL01-slow.log | | socket | /var/lib/mysql/mysql.sock | | sort_buffer_size | 262144 | | sql_auto_is_null | OFF | | sql_big_selects | ON | | sql_buffer_result | OFF | | sql_log_bin | ON | | sql_log_off | OFF | | sql_mode | STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION | | sql_notes | ON | | sql_quote_show_create | ON | | sql_safe_updates | OFF | | sql_select_limit | 18446744073709551615 | | sql_slave_skip_counter | 0 | | sql_warnings | OFF | | ssl_ca | | | ssl_capath | | | ssl_cert | | | ssl_cipher | | | ssl_crl | | | ssl_crlpath | | | ssl_key | | | storage_engine | InnoDB | | stored_program_cache | 256 | | sync_binlog | 1 | | sync_frm | ON | | sync_master_info | 0 | | sync_relay_log | 0 | | sync_relay_log_info | 0 | | system_time_zone | CET | | table_definition_cache | 400 | | table_open_cache | 2048 | | thread_cache_size | 32 | | thread_concurrency | 10 | | thread_handling | pool-of-threads | | thread_pool_idle_timeout | 60 | | thread_pool_max_threads | 500 | | thread_pool_oversubscribe | 3 | | thread_pool_size | 24 | | thread_pool_stall_limit | 500 | | thread_stack | 294912 | | time_format | %H:%i:%s | | time_zone | SYSTEM | | timed_mutexes | OFF | | tmp_table_size | 134217728 | | tmpdir | /tmp | | transaction_alloc_block_size | 8192 | | transaction_prealloc_size | 4096 | | tx_isolation | REPEATABLE-READ | | tx_read_only | OFF | | unique_checks | ON | | updatable_views_with_limit | YES | | use_stat_tables | NEVER | | userstat | OFF | | version | 10.0.14-MariaDB-wsrep-log | | version_comment | MariaDB Server, wsrep_25.10.r4144 | | version_compile_machine | x86_64 | | version_compile_os | Linux | | version_malloc_library | bundled jemalloc | | wait_timeout | 28800 | | wsrep_auto_increment_control | ON | | wsrep_causal_reads | OFF | | wsrep_certify_nonpk | ON | | wsrep_cluster_address | gcomm:// | | wsrep_cluster_name | samport_galera_cluster | | wsrep_convert_lock_to_trx | OFF | | wsrep_data_home_dir | /data/lib/mysql/ | | wsrep_dbug_option | | | wsrep_debug | OFF | | wsrep_desync | OFF | | wsrep_drupal_282555_workaround | OFF | | wsrep_forced_binlog_format | NONE | | wsrep_load_data_splitting | ON | | wsrep_log_conflicts | OFF | | wsrep_max_ws_rows | 131072 | | wsrep_max_ws_size | 1073741824 | | wsrep_mysql_replication_bundle | 0 | | wsrep_node_address | | | wsrep_node_incoming_address | AUTO | | wsrep_node_name | SESAMMALSQL01 | | wsrep_notify_cmd | | | wsrep_on | ON | | wsrep_osu_method | TOI | | wsrep_provider | /usr/lib64/galera/libgalera_smm.so | | wsrep_provider_options | base_host = 10.20.20.61; base_port = 4567; cert.log_conflicts = no; debug = no; evs.causal_keepalive_period = PT1S; evs.debug_log_mask = 0x1; evs.inactive_check_period = PT0.5S; evs.inactive_timeout = PT15S; evs.info_log_mask = 0; evs.install_timeout = PT15S; evs.join_retrans_period = PT1S; evs.keepalive_period = PT1S; evs.max_install_timeouts = 1; evs.send_window = 4; evs.stats_report_period = PT1M; evs.suspect_timeout = PT5S; evs.use_aggregate = true; evs.user_send_window = 2; evs.version = 0; evs.view_forget_timeout = P1D; gcache.dir = /data/lib/mysql/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /data/lib/mysql//galera.cache; gcache.page_size = 128M; gcache.size = 2G; gcs.fc_debug = 0; gcs.fc_factor = 1.0; gcs.fc_limit = 16; gcs.fc_master_slave = no; gcs.max_packet_size = 64500; gcs.max_throttle = 0.25; gcs.recv_q_hard_limit = 9223372036854775807; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor = no; gmcast.listen_addr = tcp://0.0.0.0:4567; gmcast.mcast_addr = ; gmcast.mcast_ttl = 1; gmcast.peer_timeout = PT3S; gmcast.segment = 0; gmcast.time_wait = PT5S; gmcast.version = 0; ist.recv_addr = 10.20.20.61; pc.announce_timeout = PT3S; pc.checksum = false; pc.ignore_quorum = false; pc.ignore_sb = false; pc.linger = PT20S; pc.npvo = false; pc.version = 0; pc.wait_prim = true; pc.wait_prim_timeout = P30S; pc.weight = 1; protonet.backend = asio; protonet.version = 0; repl.causal_read_timeout = PT30S; repl.commit_order = 3; repl.key_format = FLAT8; repl.max_ws_size = 2147483647; repl.proto_max = 5; socket.checksum = 2; | | wsrep_recover | OFF | | wsrep_replicate_myisam | OFF | | wsrep_restart_slave | OFF | | wsrep_retry_autocommit | 3 | | wsrep_slave_fk_checks | ON | | wsrep_slave_threads | 3 | | wsrep_slave_uk_checks | OFF | | wsrep_sst_auth | | | wsrep_sst_donor | | | wsrep_sst_donor_rejects_queries | OFF | | wsrep_sst_method | rsync | | wsrep_sst_receive_address | AUTO | | wsrep_start_position | e6dbea68-8a86-11e3-bc05-07a1b0b715b7:407891495 | | wsrep_sync_wait | 0 | +--------------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 532 rows in set (0.01 sec) MariaDB [(none)]> show global status; +-----------------------------------------------+--------------------------------------+ | Variable_name | Value | +-----------------------------------------------+--------------------------------------+ | Aborted_clients | 0 | | Aborted_connects | 1 | | Access_denied_errors | 2 | | Aria_pagecache_blocks_not_flushed | 0 | | Aria_pagecache_blocks_unused | 15736 | | Aria_pagecache_blocks_used | 17 | | Aria_pagecache_read_requests | 5314 | | Aria_pagecache_reads | 9 | | Aria_pagecache_write_requests | 1679 | | Aria_pagecache_writes | 0 | | Aria_transaction_log_syncs | 0 | | Binlog_commits | 196594 | | Binlog_group_commits | 196594 | | Binlog_snapshot_file | mariadb-bin.000992 | | Binlog_snapshot_position | 464971009 | | Binlog_bytes_written | 464970719 | | Binlog_cache_disk_use | 124 | | Binlog_cache_use | 196594 | | Binlog_stmt_cache_disk_use | 0 | | Binlog_stmt_cache_use | 0 | | Busy_time | 0.000000 | | Bytes_received | 1120146991 | | Bytes_sent | 2905952489 | | Com_admin_commands | 708391 | | Com_alter_db | 0 | | Com_alter_db_upgrade | 0 | | Com_alter_event | 0 | | Com_alter_function | 0 | | Com_alter_procedure | 0 | | Com_alter_server | 0 | | Com_alter_table | 0 | | Com_alter_tablespace | 0 | | Com_analyze | 0 | | Com_assign_to_keycache | 0 | | Com_begin | 180513 | | Com_binlog | 0 | | Com_call_procedure | 0 | | Com_change_db | 658349 | | Com_change_master | 0 | | Com_check | 0 | | Com_checksum | 0 | | Com_commit | 180510 | | Com_create_db | 0 | | Com_create_event | 0 | | Com_create_function | 0 | | Com_create_index | 0 | | Com_create_procedure | 0 | | Com_create_role | 0 | | Com_create_server | 0 | | Com_create_table | 0 | | Com_create_trigger | 0 | | Com_create_udf | 0 | | Com_create_user | 0 | | Com_create_view | 0 | | Com_dealloc_sql | 0 | | Com_delete | 3900 | | Com_delete_multi | 0 | | Com_do | 0 | | Com_drop_db | 0 | | Com_drop_event | 0 | | Com_drop_function | 0 | | Com_drop_index | 0 | | Com_drop_procedure | 0 | | Com_drop_role | 0 | | Com_drop_server | 0 | | Com_drop_table | 0 | | Com_drop_trigger | 0 | | Com_drop_user | 0 | | Com_drop_view | 0 | | Com_empty_query | 0 | | Com_execute_sql | 0 | | Com_flush | 0 | | Com_get_diagnostics | 0 | | Com_grant | 0 | | Com_grant_role | 0 | | Com_ha_close | 0 | | Com_ha_open | 0 | | Com_ha_read | 0 | | Com_help | 0 | | Com_insert | 368870 | | Com_insert_select | 7 | | Com_install_plugin | 0 | | Com_kill | 0 | | Com_load | 0 | | Com_lock_tables | 0 | | Com_optimize | 0 | | Com_preload_keys | 0 | | Com_prepare_sql | 0 | | Com_purge | 0 | | Com_purge_before_date | 0 | | Com_release_savepoint | 0 | | Com_rename_table | 0 | | Com_rename_user | 0 | | Com_repair | 0 | | Com_replace | 0 | | Com_replace_select | 0 | | Com_reset | 0 | | Com_resignal | 0 | | Com_revoke | 0 | | Com_revoke_all | 0 | | Com_revoke_role | 0 | | Com_rollback | 3 | | Com_rollback_to_savepoint | 0 | | Com_savepoint | 0 | | Com_select | 1323466 | | Com_set_option | 291810 | | Com_show_authors | 0 | | Com_show_binlog_events | 0 | | Com_show_binlogs | 0 | | Com_show_charsets | 0 | | Com_show_client_statistics | 0 | | Com_show_collations | 526 | | Com_show_contributors | 0 | | Com_show_create_db | 0 | | Com_show_create_event | 0 | | Com_show_create_func | 0 | | Com_show_create_proc | 0 | | Com_show_create_table | 0 | | Com_show_create_trigger | 0 | | Com_show_databases | 39 | | Com_show_engine_logs | 0 | | Com_show_engine_mutex | 0 | | Com_show_engine_status | 39 | | Com_show_errors | 0 | | Com_show_events | 0 | | Com_show_explain | 0 | | Com_show_fields | 0 | | Com_show_function_status | 0 | | Com_show_grants | 0 | | Com_show_index_statistics | 0 | | Com_show_keys | 0 | | Com_show_master_status | 41 | | Com_show_open_tables | 0 | | Com_show_plugins | 0 | | Com_show_privileges | 0 | | Com_show_procedure_status | 0 | | Com_show_processlist | 0 | | Com_show_profile | 0 | | Com_show_profiles | 0 | | Com_show_relaylog_events | 0 | | Com_show_slave_hosts | 0 | | Com_show_slave_status | 0 | | Com_show_status | 40 | | Com_show_storage_engines | 3 | | Com_show_table_statistics | 0 | | Com_show_table_status | 0 | | Com_show_tables | 0 | | Com_show_triggers | 0 | | Com_show_user_statistics | 0 | | Com_show_variables | 565 | | Com_show_warnings | 4 | | Com_shutdown | 0 | | Com_signal | 0 | | Com_start_all_slaves | 0 | | Com_start_slave | 0 | | Com_stmt_close | 0 | | Com_stmt_execute | 0 | | Com_stmt_fetch | 0 | | Com_stmt_prepare | 0 | | Com_stmt_reprepare | 0 | | Com_stmt_reset | 0 | | Com_stmt_send_long_data | 0 | | Com_stop_all_slaves | 0 | | Com_stop_slave | 0 | | Com_truncate | 0 | | Com_uninstall_plugin | 0 | | Com_unlock_tables | 0 | | Com_update | 147250 | | Com_update_multi | 0 | | Com_xa_commit | 0 | | Com_xa_end | 0 | | Com_xa_prepare | 0 | | Com_xa_recover | 0 | | Com_xa_rollback | 0 | | Com_xa_start | 0 | | Compression | OFF | | Connection_errors_accept | 0 | | Connection_errors_internal | 0 | | Connection_errors_max_connections | 0 | | Connection_errors_peer_address | 0 | | Connection_errors_select | 0 | | Connection_errors_tcpwrap | 0 | | Connections | 542 | | Cpu_time | 0.000000 | | Created_tmp_disk_tables | 22 | | Created_tmp_files | 69 | | Created_tmp_tables | 92022 | | Delayed_errors | 0 | | Delayed_insert_threads | 0 | | Delayed_writes | 0 | | Empty_queries | 192005 | | Executed_events | 0 | | Executed_triggers | 0 | | Feature_delay_key_write | 0 | | Feature_dynamic_columns | 0 | | Feature_fulltext | 0 | | Feature_gis | 0 | | Feature_locale | 0 | | Feature_subquery | 44760 | | Feature_timezone | 0 | | Feature_trigger | 0 | | Feature_xml | 0 | | Flush_commands | 1 | | Handler_commit | 4426094 | | Handler_delete | 110070 | | Handler_discover | 0 | | Handler_external_lock | 0 | | Handler_icp_attempts | 215214334 | | Handler_icp_match | 209632228 | | Handler_mrr_init | 0 | | Handler_mrr_key_refills | 0 | | Handler_mrr_rowid_refills | 0 | | Handler_prepare | 2038180 | | Handler_read_first | 564 | | Handler_read_key | 10147925 | | Handler_read_last | 195 | | Handler_read_next | 221063654 | | Handler_read_prev | 495958 | | Handler_read_rnd | 3707104 | | Handler_read_rnd_deleted | 38 | | Handler_read_rnd_next | 370610520 | | Handler_rollback | 10 | | Handler_savepoint | 0 | | Handler_savepoint_rollback | 0 | | Handler_tmp_update | 0 | | Handler_tmp_write | 843106 | | Handler_update | 189753 | | Handler_write | 12680867 | | Innodb_available_undo_logs | 128 | | Innodb_background_log_sync | 11614 | | Innodb_buffer_pool_bytes_data | 2618359808 | | Innodb_buffer_pool_bytes_dirty | 294109184 | | Innodb_buffer_pool_dump_status | not started | | Innodb_buffer_pool_load_status | not started | | Innodb_buffer_pool_pages_data | 159812 | | Innodb_buffer_pool_pages_dirty | 17951 | | Innodb_buffer_pool_pages_flushed | 295288 | | Innodb_buffer_pool_pages_free | 1141725 | | Innodb_buffer_pool_pages_lru_flushed | 0 | | Innodb_buffer_pool_pages_made_not_young | 0 | | Innodb_buffer_pool_pages_made_young | 1283 | | Innodb_buffer_pool_pages_misc | 9175 | | Innodb_buffer_pool_pages_old | 58849 | | Innodb_buffer_pool_pages_total | 1310712 | | Innodb_buffer_pool_read_ahead | 1518 | | Innodb_buffer_pool_read_ahead_evicted | 0 | | Innodb_buffer_pool_read_ahead_rnd | 0 | | Innodb_buffer_pool_read_requests | 809341067 | | Innodb_buffer_pool_reads | 87360 | | Innodb_buffer_pool_wait_free | 0 | | Innodb_buffer_pool_write_requests | 20862122 | | Innodb_checkpoint_age | 99064150 | | Innodb_checkpoint_max_age | 865244898 | | Innodb_data_fsyncs | 491109 | | Innodb_data_pending_fsyncs | 0 | | Innodb_data_pending_reads | 0 | | Innodb_data_pending_writes | 0 | | Innodb_data_read | 1604112384 | | Innodb_data_reads | 98014 | | Innodb_data_writes | 637875 | | Innodb_data_written | 11452026880 | | Innodb_dblwr_pages_written | 295288 | | Innodb_dblwr_writes | 114406 | | Innodb_deadlocks | 0 | | Innodb_have_atomic_builtins | ON | | Innodb_history_list_length | 1905 | | Innodb_ibuf_discarded_delete_marks | 0 | | Innodb_ibuf_discarded_deletes | 0 | | Innodb_ibuf_discarded_inserts | 0 | | Innodb_ibuf_free_list | 591 | | Innodb_ibuf_merged_delete_marks | 12067 | | Innodb_ibuf_merged_deletes | 3588 | | Innodb_ibuf_merged_inserts | 12861 | | Innodb_ibuf_merges | 10780 | | Innodb_ibuf_segment_size | 593 | | Innodb_ibuf_size | 1 | | Innodb_log_waits | 0 | | Innodb_log_write_requests | 4109805 | | Innodb_log_writes | 226579 | | Innodb_lsn_current | 6680502331838 | | Innodb_lsn_flushed | 6680502331558 | | Innodb_lsn_last_checkpoint | 6680403267688 | | Innodb_master_thread_active_loops | 11588 | | Innodb_master_thread_idle_loops | 26 | | Innodb_max_trx_id | 1840269391 | | Innodb_mem_adaptive_hash | 490322448 | | Innodb_mem_dictionary | 85726975 | | Innodb_mem_total | 21978152960 | | Innodb_mutex_os_waits | 82654 | | Innodb_mutex_spin_rounds | 2660502 | | Innodb_mutex_spin_waits | 169666 | | Innodb_oldest_view_low_limit_trx_id | 0 | | Innodb_os_log_fsyncs | 228209 | | Innodb_os_log_pending_fsyncs | 0 | | Innodb_os_log_pending_writes | 0 | | Innodb_os_log_written | 1775209984 | | Innodb_page_size | 16384 | | Innodb_pages_created | 61908 | | Innodb_pages_read | 97904 | | Innodb_pages_written | 295288 | | Innodb_purge_trx_id | 1840269390 | | Innodb_purge_undo_no | 0 | | Innodb_read_views_memory | 23488 | | Innodb_row_lock_current_waits | 0 | | Innodb_row_lock_time | 165 | | Innodb_row_lock_time_avg | 55 | | Innodb_row_lock_time_max | 162 | | Innodb_row_lock_waits | 3 | | Innodb_rows_deleted | 110070 | | Innodb_rows_inserted | 8087052 | | Innodb_rows_read | 565190120 | | Innodb_rows_updated | 189752 | | Innodb_s_lock_os_waits | 3893 | | Innodb_s_lock_spin_rounds | 197135 | | Innodb_s_lock_spin_waits | 18917 | | Innodb_truncated_status_writes | 0 | | Innodb_x_lock_os_waits | 2286 | | Innodb_x_lock_spin_rounds | 275828 | | Innodb_x_lock_spin_waits | 38015 | | Key_blocks_not_flushed | 0 | | Key_blocks_unused | 45907 | | Key_blocks_used | 6 | | Key_blocks_warm | 0 | | Key_read_requests | 10 | | Key_reads | 6 | | Key_write_requests | 0 | | Key_writes | 0 | | Last_query_cost | 0.000000 | | Max_used_connections | 242 | | Memory_used | 226700984 | | Not_flushed_delayed_rows | 0 | | Open_files | 87 | | Open_streams | 0 | | Open_table_definitions | 188 | | Open_tables | 285 | | Opened_files | 413 | | Opened_plugin_libraries | 0 | | Opened_table_definitions | 118 | | Opened_tables | 456 | | Opened_views | 0 | | Performance_schema_accounts_lost | 0 | | Performance_schema_cond_classes_lost | 0 | | Performance_schema_cond_instances_lost | 0 | | Performance_schema_digest_lost | 0 | | Performance_schema_file_classes_lost | 0 | | Performance_schema_file_handles_lost | 0 | | Performance_schema_file_instances_lost | 0 | | Performance_schema_hosts_lost | 0 | | Performance_schema_locker_lost | 0 | | Performance_schema_mutex_classes_lost | 0 | | Performance_schema_mutex_instances_lost | 0 | | Performance_schema_rwlock_classes_lost | 0 | | Performance_schema_rwlock_instances_lost | 0 | | Performance_schema_session_connect_attrs_lost | 0 | | Performance_schema_socket_classes_lost | 0 | | Performance_schema_socket_instances_lost | 0 | | Performance_schema_stage_classes_lost | 0 | | Performance_schema_statement_classes_lost | 0 | | Performance_schema_table_handles_lost | 0 | | Performance_schema_table_instances_lost | 0 | | Performance_schema_thread_classes_lost | 0 | | Performance_schema_thread_instances_lost | 0 | | Performance_schema_users_lost | 0 | | Prepared_stmt_count | 0 | | Qcache_free_blocks | 0 | | Qcache_free_memory | 0 | | Qcache_hits | 0 | | Qcache_inserts | 0 | | Qcache_lowmem_prunes | 0 | | Qcache_not_cached | 0 | | Qcache_queries_in_cache | 0 | | Qcache_total_blocks | 0 | | Queries | 3156263 | | Questions | 3156264 | | Rows_read | 564879735 | | Rows_sent | 10922046 | | Rows_tmp_read | 34048797 | | Rpl_status | AUTH_MASTER | | Select_full_join | 1888 | | Select_full_range_join | 0 | | Select_range | 122148 | | Select_range_check | 0 | | Select_scan | 122790 | | Slave_heartbeat_period | 0.000 | | Slave_open_temp_tables | 0 | | Slave_received_heartbeats | 0 | | Slave_retried_transactions | 0 | | Slave_running | OFF | | Slow_launch_threads | 0 | | Slow_queries | 1 | | Sort_merge_passes | 3 | | Sort_priority_queue_sorts | 107560 | | Sort_range | 63025 | | Sort_rows | 4153511 | | Sort_scan | 59639 | | Ssl_accept_renegotiates | 0 | | Ssl_accepts | 0 | | Ssl_callback_cache_hits | 0 | | Ssl_cipher | | | Ssl_cipher_list | | | Ssl_client_connects | 0 | | Ssl_connect_renegotiates | 0 | | Ssl_ctx_verify_depth | 0 | | Ssl_ctx_verify_mode | 0 | | Ssl_default_timeout | 0 | | Ssl_finished_accepts | 0 | | Ssl_finished_connects | 0 | | Ssl_server_not_after | | | Ssl_server_not_before | | | Ssl_session_cache_hits | 0 | | Ssl_session_cache_misses | 0 | | Ssl_session_cache_mode | NONE | | Ssl_session_cache_overflows | 0 | | Ssl_session_cache_size | 0 | | Ssl_session_cache_timeouts | 0 | | Ssl_sessions_reused | 0 | | Ssl_used_session_cache_entries | 0 | | Ssl_verify_depth | 0 | | Ssl_verify_mode | 0 | | Ssl_version | | | Subquery_cache_hit | 3549 | | Subquery_cache_miss | 33800 | | Syncs | 196601 | | Table_locks_immediate | 2488292 | | Table_locks_waited | 0 | | Tc_log_max_pages_used | 0 | | Tc_log_page_size | 0 | | Tc_log_page_waits | 0 | | Threadpool_idle_threads | 52 | | Threadpool_threads | 56 | | Threads_cached | 0 | | Threads_connected | 211 | | Threads_created | 2223 | | Threads_running | 4 | | Uptime | 11637 | | Uptime_since_flush_status | 11637 | | wsrep_local_state_uuid | e6dbea68-8a86-11e3-bc05-07a1b0b715b7 | | wsrep_protocol_version | 5 | | wsrep_last_committed | 408088090 | | wsrep_replicated | 196595 | | wsrep_replicated_bytes | 545455893 | | wsrep_repl_keys | 8914559 | | wsrep_repl_keys_bytes | 75963209 | | wsrep_repl_data_bytes | 456910604 | | wsrep_repl_other_bytes | 0 | | wsrep_received | 8443 | | wsrep_received_bytes | 67676 | | wsrep_local_commits | 196594 | | wsrep_local_cert_failures | 0 | | wsrep_local_replays | 0 | | wsrep_local_send_queue | 0 | | wsrep_local_send_queue_avg | 0.001409 | | wsrep_local_recv_queue | 0 | | wsrep_local_recv_queue_avg | 0.000118 | | wsrep_local_cached_downto | 407891496 | | wsrep_flow_control_paused_ns | 0 | | wsrep_flow_control_paused | 0.000000 | | wsrep_flow_control_sent | 0 | | wsrep_flow_control_recv | 0 | | wsrep_cert_deps_distance | 15.866935 | | wsrep_apply_oooe | 0.061441 | | wsrep_apply_oool | 0.000000 | | wsrep_apply_window | 1.088186 | | wsrep_commit_oooe | 0.000000 | | wsrep_commit_oool | 0.000000 | | wsrep_commit_window | 1.026842 | | wsrep_local_state | 4 | | wsrep_local_state_comment | Synced | | wsrep_cert_index_size | 149 | | wsrep_causal_reads | 0 | | wsrep_cert_interval | 0.092785 | | wsrep_incoming_addresses | 10.20.20.61:3306 | | wsrep_cluster_conf_id | 1 | | wsrep_cluster_size | 1 | | wsrep_cluster_state_uuid | e6dbea68-8a86-11e3-bc05-07a1b0b715b7 | | wsrep_cluster_status | Primary | | wsrep_connected | ON | | wsrep_local_bf_aborts | 0 | | wsrep_local_index | 0 | | wsrep_provider_name | Galera | | wsrep_provider_vendor | Codership Oy | | wsrep_provider_version | 25.3.5(rXXXX) | | wsrep_ready | ON | | wsrep_thread_count | 4 | +-----------------------------------------------+--------------------------------------+ 484 rows in set (0.00 sec) MariaDB [(none)]> SHOW ENGINE INNODB STATUS \G *************************** 1. row *************************** Type: InnoDB Name: Status: ===================================== 2014-11-17 16:39:05 7fdf36319700 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 26 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 11617 srv_active, 0 srv_shutdown, 26 srv_idle srv_master_thread log flush and writes: 11643 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 89791 OS WAIT ARRAY INFO: signal count 125293 Mutex spin waits 170003, rounds 2667553, OS waits 82885 RW-shared spins 18930, rounds 197314, OS waits 3897 RW-excl spins 38020, rounds 275907, OS waits 2286 Spin rounds per wait: 15.69 mutex, 10.42 RW-shared, 7.26 RW-excl ------------ TRANSACTIONS ------------ Trx id counter 1840272981 Purge done for trx's n:o < 1840272965 undo n:o < 0 state: running but idle History list length 1845 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0, not started MySQL thread id 541, OS thread handle 0x7fdf36319700, query id 3163738 localhost guru init SHOW ENGINE INNODB STATUS ---TRANSACTION 1840272689, not started MySQL thread id 543, OS thread handle 0x7fdf361f5700, query id 3163168 10.20.10.181 app cleaning up ---TRANSACTION 1840272688, not started MySQL thread id 544, OS thread handle 0x7fdf36088700, query id 3163165 10.20.10.181 app cleaning up ---TRANSACTION 1840271597, not started MySQL thread id 542, OS thread handle 0x7fdf36287700, query id 3160939 10.20.10.181 app cleaning up ---TRANSACTION 1840271859, not started MySQL thread id 540, OS thread handle 0x7fdf1d292700, query id 3161477 10.20.10.121 web cleaning up ---TRANSACTION 1840271866, not started MySQL thread id 538, OS thread handle 0x7fdf36518700, query id 3161540 10.20.10.121 web cleaning up ---TRANSACTION 1840251612, not started MySQL thread id 537, OS thread handle 0x7fdf35d65700, query id 3120848 10.20.10.121 web cleaning up ---TRANSACTION 1840263720, not started MySQL thread id 536, OS thread handle 0x7fdf3623e700, query id 3144944 10.20.10.122 app cleaning up ---TRANSACTION 1840268139, not started MySQL thread id 535, OS thread handle 0x7fdf207ff700, query id 3153586 10.20.10.122 web cleaning up ---TRANSACTION 1840268149, not started MySQL thread id 533, OS thread handle 0x7fdf1d3ff700, query id 3153658 10.20.10.122 web cleaning up ---TRANSACTION 1840243827, not started MySQL thread id 532, OS thread handle 0x7fdf363ab700, query id 3105289 10.20.10.121 web cleaning up ---TRANSACTION 1840266071, not started MySQL thread id 530, OS thread handle 0x7fdf317ff700, query id 3149491 10.20.10.121 app cleaning up ---TRANSACTION 1840269658, not started MySQL thread id 528, OS thread handle 0x7fdf207b6700, query id 3156795 10.20.10.182 app cleaning up ---TRANSACTION 1840256088, not started MySQL thread id 527, OS thread handle 0x7fdf365aa700, query id 3129970 10.20.10.121 app cleaning up ---TRANSACTION 1840268599, not started MySQL thread id 507, OS thread handle 0x7fdf1d3b6700, query id 3154595 10.20.10.122 web cleaning up ---TRANSACTION 1840269534, not started MySQL thread id 503, OS thread handle 0x7fdf365aa700, query id 3156561 10.20.10.182 app cleaning up ---TRANSACTION 1840272690, not started MySQL thread id 494, OS thread handle 0x7fdf36287700, query id 3163170 10.20.10.181 app cleaning up ---TRANSACTION 1840272623, not started MySQL thread id 488, OS thread handle 0x7fdf3623e700, query id 3163032 10.20.10.121 web cleaning up ---TRANSACTION 1840270212, not started MySQL thread id 480, OS thread handle 0x7fdf29bff700, query id 3157941 10.20.10.121 web cleaning up ---TRANSACTION 1840270337, not started MySQL thread id 474, OS thread handle 0x7fdf277ff700, query id 3158173 10.20.10.182 app cleaning up ---TRANSACTION 1840270095, not started MySQL thread id 475, OS thread handle 0x7fdf365f3700, query id 3157659 10.20.10.182 app cleaning up ---TRANSACTION 1840269656, not started MySQL thread id 477, OS thread handle 0x7fdf213ff700, query id 3156792 10.20.10.182 app cleaning up ---TRANSACTION 1840270094, not started MySQL thread id 476, OS thread handle 0x7fdf347ff700, query id 3157653 10.20.10.182 app cleaning up ---TRANSACTION 1840270338, not started MySQL thread id 473, OS thread handle 0x7fdf30bff700, query id 3158179 10.20.10.182 app cleaning up ---TRANSACTION 1840272679, not started MySQL thread id 470, OS thread handle 0x7fdf36287700, query id 3163140 10.20.10.181 app cleaning up ---TRANSACTION 1840270723, not started MySQL thread id 382, OS thread handle 0x7fdf1fbff700, query id 3159002 10.20.10.121 web cleaning up ---TRANSACTION 1840270728, not started MySQL thread id 381, OS thread handle 0x7fdf213ff700, query id 3159050 10.20.10.121 web cleaning up ---TRANSACTION 1839533849, not started MySQL thread id 364, OS thread handle 0x7fdf363ab700, query id 1654595 10.20.10.122 app cleaning up ---TRANSACTION 1840267475, not started MySQL thread id 334, OS thread handle 0x7fdf323ff700, query id 3152272 10.20.20.211 app cleaning up ---TRANSACTION 1840261100, not started MySQL thread id 337, OS thread handle 0x7fdf364cf700, query id 3139800 10.20.20.211 app cleaning up ---TRANSACTION 1840260075, not started MySQL thread id 333, OS thread handle 0x7fdf35ed2700, query id 3137799 10.20.20.211 app cleaning up ---TRANSACTION 1840253594, not started MySQL thread id 330, OS thread handle 0x7fdf277ff700, query id 3124912 10.20.20.211 app cleaning up ---TRANSACTION 1839542050, not started MySQL thread id 294, OS thread handle 0x7fdf30bff700, query id 1671244 10.20.10.122 web cleaning up ---TRANSACTION 1839539675, not started MySQL thread id 231, OS thread handle 0x7fdf35f64700, query id 1666309 10.20.10.122 web cleaning up ---TRANSACTION 1839543078, not started MySQL thread id 208, OS thread handle 0x7fdf2cfff700, query id 1673553 10.20.10.122 web cleaning up ---TRANSACTION 1839542220, not started MySQL thread id 119, OS thread handle 0x7fdf353ff700, query id 1671700 10.20.10.122 web cleaning up ---TRANSACTION 1839542218, not started MySQL thread id 118, OS thread handle 0x7fdf2b7b6700, query id 1671682 10.20.10.122 web cleaning up ---TRANSACTION 1839542894, not started MySQL thread id 234, OS thread handle 0x7fdf277ff700, query id 1673161 10.20.10.122 web cleaning up ---TRANSACTION 1839541493, not started MySQL thread id 141, OS thread handle 0x7fdf213ff700, query id 1670007 10.20.10.122 web cleaning up ---TRANSACTION 1839540720, not started MySQL thread id 128, OS thread handle 0x7fdf317ff700, query id 1668434 10.20.10.122 web cleaning up ---TRANSACTION 1839539680, not started MySQL thread id 122, OS thread handle 0x7fdf2076d700, query id 1666335 10.20.10.122 web cleaning up ---TRANSACTION 1839539668, not started MySQL thread id 121, OS thread handle 0x7fdf364cf700, query id 1666293 10.20.10.122 web cleaning up ---TRANSACTION 1839539681, not started MySQL thread id 117, OS thread handle 0x7fdf213ff700, query id 1666344 10.20.10.122 web cleaning up ---TRANSACTION 1839540384, not started MySQL thread id 227, OS thread handle 0x7fdf360d1700, query id 1667761 10.20.10.122 web cleaning up ---TRANSACTION 1839539661, not started MySQL thread id 224, OS thread handle 0x7fdf317ff700, query id 1666267 10.20.10.122 web cleaning up ---TRANSACTION 1839539679, not started MySQL thread id 221, OS thread handle 0x7fdf32fb6700, query id 1666326 10.20.10.122 web cleaning up ---TRANSACTION 1839539621, not started MySQL thread id 220, OS thread handle 0x7fdf3643d700, query id 1666172 10.20.10.122 web cleaning up ---TRANSACTION 1839538602, not started MySQL thread id 219, OS thread handle 0x7fdf1d3b6700, query id 1664229 10.20.10.122 web cleaning up ---TRANSACTION 1839538601, not started MySQL thread id 218, OS thread handle 0x7fdf2076d700, query id 1664169 10.20.10.122 web cleaning up ---TRANSACTION 1839538414, not started MySQL thread id 217, OS thread handle 0x7fdf364cf700, query id 1663810 10.20.10.122 web cleaning up ---TRANSACTION 1839538413, not started MySQL thread id 216, OS thread handle 0x7fdf29bff700, query id 1663801 10.20.10.122 web cleaning up ---TRANSACTION 1839539620, not started MySQL thread id 215, OS thread handle 0x7fdf365aa700, query id 1666163 10.20.10.122 web cleaning up ---TRANSACTION 1839539663, not started MySQL thread id 214, OS thread handle 0x7fdf1fbff700, query id 1666280 10.20.10.122 web cleaning up ---TRANSACTION 1839543311, not started MySQL thread id 213, OS thread handle 0x7fdf213ff700, query id 1674037 10.20.10.122 web cleaning up ---TRANSACTION 1839543142, not started MySQL thread id 212, OS thread handle 0x7fdf347ff700, query id 1673683 10.20.10.122 web cleaning up ---TRANSACTION 1839543310, not started MySQL thread id 211, OS thread handle 0x7fdf365f3700, query id 1674021 10.20.10.122 web cleaning up ---TRANSACTION 1839543141, not started MySQL thread id 210, OS thread handle 0x7fdf277ff700, query id 1673670 10.20.10.122 web cleaning up ---TRANSACTION 1839543077, not started MySQL thread id 209, OS thread handle 0x7fdf253ff700, query id 1673544 10.20.10.122 web cleaning up ---TRANSACTION 1839538412, not started MySQL thread id 207, OS thread handle 0x7fdf361f5700, query id 1663792 10.20.10.122 web cleaning up ---TRANSACTION 1839542892, not started MySQL thread id 206, OS thread handle 0x7fdf36287700, query id 1673156 10.20.10.122 web cleaning up ---TRANSACTION 1839539660, not started MySQL thread id 205, OS thread handle 0x7fdf36319700, query id 1666258 10.20.10.122 web cleaning up ---TRANSACTION 1839542927, not started MySQL thread id 204, OS thread handle 0x7fdf1d292700, query id 1673240 10.20.10.122 web cleaning up ---TRANSACTION 1839542891, not started MySQL thread id 203, OS thread handle 0x7fe547192700, query id 1673145 10.20.10.122 web cleaning up ---TRANSACTION 1839542898, not started MySQL thread id 202, OS thread handle 0x7fdf1d324700, query id 1673178 10.20.10.122 web cleaning up ---TRANSACTION 1839542888, not started MySQL thread id 201, OS thread handle 0x7fdf32fff700, query id 1673118 10.20.10.122 web cleaning up ---TRANSACTION 1839542890, not started MySQL thread id 200, OS thread handle 0x7fdf3623e700, query id 1673136 10.20.10.122 web cleaning up ---TRANSACTION 1839542885, not started MySQL thread id 199, OS thread handle 0x7fdf366ce700, query id 1673091 10.20.10.122 web cleaning up ---TRANSACTION 1839542889, not started MySQL thread id 198, OS thread handle 0x7fdf323b6700, query id 1673127 10.20.10.122 web cleaning up ---TRANSACTION 1839542887, not started MySQL thread id 197, OS thread handle 0x7fdf32fb6700, query id 1673109 10.20.10.122 web cleaning up ---TRANSACTION 1839542884, not started MySQL thread id 196, OS thread handle 0x7fdf3643d700, query id 1673082 10.20.10.122 web cleaning up ---TRANSACTION 1839542282, not started MySQL thread id 195, OS thread handle 0x7fdf347b6700, query id 1671898 10.20.10.122 web cleaning up ---TRANSACTION 1839542283, not started MySQL thread id 194, OS thread handle 0x7fdf2076d700, query id 1671921 10.20.10.122 web cleaning up ---TRANSACTION 1839542260, not started MySQL thread id 193, OS thread handle 0x7fdf364cf700, query id 1671840 10.20.10.122 web cleaning up ---TRANSACTION 1839542886, not started MySQL thread id 192, OS thread handle 0x7fdf207b6700, query id 1673100 10.20.10.122 web cleaning up ---TRANSACTION 1839542270, not started MySQL thread id 191, OS thread handle 0x7fdf353ff700, query id 1671859 10.20.10.122 web cleaning up ---TRANSACTION 1839542240, not started MySQL thread id 190, OS thread handle 0x7fdf2b7b6700, query id 1671781 10.20.10.122 web cleaning up ---TRANSACTION 1839542928, not started MySQL thread id 189, OS thread handle 0x7fdf35ed2700, query id 1673258 10.20.10.122 web cleaning up ---TRANSACTION 1839542244, not started MySQL thread id 188, OS thread handle 0x7fdf347ff700, query id 1671797 10.20.10.122 web cleaning up ---TRANSACTION 1839542226, not started MySQL thread id 187, OS thread handle 0x7fdf2e7b6700, query id 1671739 10.20.10.122 web cleaning up ---TRANSACTION 1839542230, not started MySQL thread id 186, OS thread handle 0x7fdf30bb6700, query id 1671764 10.20.10.122 web cleaning up ---TRANSACTION 1839542225, not started MySQL thread id 185, OS thread handle 0x7fdf253ff700, query id 1671730 10.20.10.122 web cleaning up ---TRANSACTION 1839542227, not started MySQL thread id 184, OS thread handle 0x7fdf2cfff700, query id 1671748 10.20.10.122 web cleaning up ---TRANSACTION 1839542221, not started MySQL thread id 183, OS thread handle 0x7fdf361f5700, query id 1671709 10.20.10.122 web cleaning up ---TRANSACTION 1839542219, not started MySQL thread id 182, OS thread handle 0x7fdf36287700, query id 1671691 10.20.10.122 web cleaning up ---TRANSACTION 1839542222, not started MySQL thread id 181, OS thread handle 0x7fdf36319700, query id 1671718 10.20.10.122 web cleaning up ---TRANSACTION 1839542256, not started MySQL thread id 180, OS thread handle 0x7fdf1d292700, query id 1671822 10.20.10.122 web cleaning up ---TRANSACTION 1839542217, not started MySQL thread id 179, OS thread handle 0x7fdf360d1700, query id 1671673 10.20.10.122 web cleaning up ---TRANSACTION 1839542216, not started MySQL thread id 178, OS thread handle 0x7fdf36518700, query id 1671664 10.20.10.122 web cleaning up ---TRANSACTION 1839542215, not started MySQL thread id 177, OS thread handle 0x7fdf32fff700, query id 1671655 10.20.10.122 web cleaning up ---TRANSACTION 1839542211, not started MySQL thread id 176, OS thread handle 0x7fdf317ff700, query id 1671619 10.20.10.122 web cleaning up ---TRANSACTION 1839542214, not started MySQL thread id 175, OS thread handle 0x7fdf1d2db700, query id 1671646 10.20.10.122 web cleaning up ---TRANSACTION 1839542210, not started MySQL thread id 174, OS thread handle 0x7fdf323b6700, query id 1671610 10.20.10.122 web cleaning up ---TRANSACTION 1839542213, not started MySQL thread id 173, OS thread handle 0x7fdf1fb6d700, query id 1671637 10.20.10.122 web cleaning up ---TRANSACTION 1839542085, not started MySQL thread id 172, OS thread handle 0x7fdf363ab700, query id 1671357 10.20.10.122 web cleaning up ---TRANSACTION 1839542208, not started MySQL thread id 171, OS thread handle 0x7fdf347b6700, query id 1671592 10.20.10.122 web cleaning up ---TRANSACTION 1839542076, not started MySQL thread id 170, OS thread handle 0x7fdf2076d700, query id 1671328 10.20.10.122 web cleaning up ---TRANSACTION 1839542209, not started MySQL thread id 169, OS thread handle 0x7fdf364cf700, query id 1671601 10.20.10.122 web cleaning up ---TRANSACTION 1839542063, not started MySQL thread id 168, OS thread handle 0x7fdf29bff700, query id 1671306 10.20.10.122 web cleaning up ---TRANSACTION 1839542056, not started MySQL thread id 167, OS thread handle 0x7fdf365aa700, query id 1671261 10.20.10.122 web cleaning up ---TRANSACTION 1839542044, not started MySQL thread id 166, OS thread handle 0x7fdf2b7b6700, query id 1671232 10.20.10.122 web cleaning up ---TRANSACTION 1839542212, not started MySQL thread id 165, OS thread handle 0x7fdf213ff700, query id 1671628 10.20.10.122 web cleaning up ---TRANSACTION 1839542062, not started MySQL thread id 164, OS thread handle 0x7fdf347ff700, query id 1671279 10.20.10.122 web cleaning up ---TRANSACTION 1839542041, not started MySQL thread id 163, OS thread handle 0x7fdf2e7b6700, query id 1671219 10.20.10.122 web cleaning up ---TRANSACTION 1839542040, not started MySQL thread id 162, OS thread handle 0x7fdf30bb6700, query id 1671209 10.20.10.122 web cleaning up ---TRANSACTION 1839542037, not started MySQL thread id 161, OS thread handle 0x7fdf253ff700, query id 1671187 10.20.10.122 web cleaning up ---TRANSACTION 1839542038, not started MySQL thread id 160, OS thread handle 0x7fdf361ac700, query id 1671199 10.20.10.122 web cleaning up ---TRANSACTION 1839542035, not started MySQL thread id 159, OS thread handle 0x7fdf361f5700, query id 1671169 10.20.10.122 web cleaning up ---TRANSACTION 1839542034, not started MySQL thread id 158, OS thread handle 0x7fdf36287700, query id 1671158 10.20.10.122 web cleaning up ---TRANSACTION 1839542031, not started MySQL thread id 157, OS thread handle 0x7fdf36319700, query id 1671143 10.20.10.122 web cleaning up ---TRANSACTION 1839541977, not started MySQL thread id 154, OS thread handle 0x7fdf36518700, query id 1671065 10.20.10.122 web cleaning up ---TRANSACTION 1839541882, not started MySQL thread id 153, OS thread handle 0x7fdf1b76d700, query id 1670844 10.20.10.122 web cleaning up ---TRANSACTION 1839541976, not started MySQL thread id 152, OS thread handle 0x7fdf3623e700, query id 1671033 10.20.10.122 web cleaning up ---TRANSACTION 1839541877, not started MySQL thread id 151, OS thread handle 0x7fdf366ce700, query id 1670799 10.20.10.122 web cleaning up ---TRANSACTION 1839542036, not started MySQL thread id 150, OS thread handle 0x7fdf30bff700, query id 1671178 10.20.10.122 web cleaning up ---TRANSACTION 1839541878, not started MySQL thread id 149, OS thread handle 0x7fdf32fb6700, query id 1670808 10.20.10.122 web cleaning up ---TRANSACTION 1839541881, not started MySQL thread id 148, OS thread handle 0x7fdf363ab700, query id 1670835 10.20.10.122 web cleaning up ---TRANSACTION 1839541875, not started MySQL thread id 147, OS thread handle 0x7fdf1d3b6700, query id 1670781 10.20.10.122 web cleaning up ---TRANSACTION 1839541880, not started MySQL thread id 146, OS thread handle 0x7fdf2076d700, query id 1670826 10.20.10.122 web cleaning up ---TRANSACTION 1839541874, not started MySQL thread id 145, OS thread handle 0x7fdf364cf700, query id 1670772 10.20.10.122 web cleaning up ---TRANSACTION 1839541876, not started MySQL thread id 144, OS thread handle 0x7fdf29bff700, query id 1670790 10.20.10.122 web cleaning up ---TRANSACTION 1839541847, not started MySQL thread id 143, OS thread handle 0x7fdf365aa700, query id 1670734 10.20.10.122 web cleaning up ---TRANSACTION 1839541846, not started MySQL thread id 142, OS thread handle 0x7fdf2b7b6700, query id 1670701 10.20.10.122 web cleaning up ---TRANSACTION 1839541492, not started MySQL thread id 140, OS thread handle 0x7fdf347ff700, query id 1669998 10.20.10.122 web cleaning up ---TRANSACTION 1839541453, not started MySQL thread id 139, OS thread handle 0x7fdf365f3700, query id 1669918 10.20.10.122 web cleaning up ---TRANSACTION 0, not started MySQL thread id 138, OS thread handle 0x7fdf30bb6700, query id 3157063 10.20.20.60 guru cleaning up ---TRANSACTION 1839540721, not started MySQL thread id 134, OS thread handle 0x7fdf36287700, query id 1668443 10.20.10.122 web cleaning up ---TRANSACTION 1839541879, not started MySQL thread id 136, OS thread handle 0x7fdf361ac700, query id 1670817 10.20.10.122 web cleaning up ---TRANSACTION 1839541452, not started MySQL thread id 135, OS thread handle 0x7fdf361f5700, query id 1669909 10.20.10.122 web cleaning up ---TRANSACTION 1839540499, not started MySQL thread id 133, OS thread handle 0x7fdf36319700, query id 1668005 10.20.10.122 web cleaning up ---TRANSACTION 1839541407, not started MySQL thread id 132, OS thread handle 0x7fdf1d292700, query id 1669780 10.20.10.122 web cleaning up ---TRANSACTION 1839542897, not started MySQL thread id 131, OS thread handle 0x7fe547192700, query id 1673169 10.20.10.122 web cleaning up ---TRANSACTION 1839540498, not started MySQL thread id 127, OS thread handle 0x7fdf366ce700, query id 1667987 10.20.10.122 web cleaning up ---TRANSACTION 1839539854, not started MySQL thread id 126, OS thread handle 0x7fdf30bff700, query id 1666731 10.20.10.122 web cleaning up ---TRANSACTION 1839540383, not started MySQL thread id 125, OS thread handle 0x7fdf1fb6d700, query id 1667752 10.20.10.122 web cleaning up ---TRANSACTION 1839539849, not started MySQL thread id 124, OS thread handle 0x7fdf3643d700, query id 1666690 10.20.10.122 web cleaning up ---TRANSACTION 1839539684, not started MySQL thread id 123, OS thread handle 0x7fdf347b6700, query id 1666360 10.20.10.122 web cleaning up ---TRANSACTION 1840272920, not started MySQL thread id 95, OS thread handle 0x7fdf365aa700, query id 3163610 10.20.20.202 app cleaning up ---TRANSACTION 1840272970, not started MySQL thread id 94, OS thread handle 0x7fdf1fbff700, query id 3163720 10.20.20.202 app cleaning up ---TRANSACTION 1840272918, not started MySQL thread id 85, OS thread handle 0x7fdf36319700, query id 3163606 10.20.20.202 app cleaning up ---TRANSACTION 1840272919, not started MySQL thread id 92, OS thread handle 0x7fdf347ff700, query id 3163608 10.20.20.202 app cleaning up ---TRANSACTION 1840272914, not started MySQL thread id 91, OS thread handle 0x7fdf2e7b6700, query id 3163601 10.20.20.202 app cleaning up ---TRANSACTION 1840272960, not started MySQL thread id 90, OS thread handle 0x7fdf277ff700, query id 3163701 10.20.20.202 app cleaning up ---TRANSACTION 1840272941, not started MySQL thread id 84, OS thread handle 0x7fdf1d292700, query id 3163658 10.20.20.202 app cleaning up ---TRANSACTION 1840272913, not started MySQL thread id 86, OS thread handle 0x7fdf36287700, query id 3163595 10.20.20.202 app cleaning up ---TRANSACTION 1840272926, not started MySQL thread id 88, OS thread handle 0x7fdf36088700, query id 3163628 10.20.20.202 app cleaning up ---TRANSACTION 1840272942, not started MySQL thread id 89, OS thread handle 0x7fdf30bff700, query id 3163660 10.20.20.202 app cleaning up ---TRANSACTION 1840272928, not started MySQL thread id 87, OS thread handle 0x7fdf35f64700, query id 3163630 10.20.20.202 app cleaning up ---TRANSACTION 1840272938, not started MySQL thread id 82, OS thread handle 0x7fdf36518700, query id 3163655 10.20.20.202 app cleaning up ---TRANSACTION 1840272924, not started MySQL thread id 83, OS thread handle 0x7fdf360d1700, query id 3163619 10.20.20.202 app cleaning up ---TRANSACTION 1840272921, not started MySQL thread id 80, OS thread handle 0x7fdf3623e700, query id 3163616 10.20.20.202 app cleaning up ---TRANSACTION 1840272962, not started MySQL thread id 81, OS thread handle 0x7fdf35d65700, query id 3163709 10.20.20.202 app cleaning up ---TRANSACTION 1840272937, not started MySQL thread id 77, OS thread handle 0x7fdf1d3ff700, query id 3163649 10.20.20.202 app cleaning up ---TRANSACTION 1840272925, not started MySQL thread id 76, OS thread handle 0x7fdf363ab700, query id 3163621 10.20.20.202 app cleaning up ---TRANSACTION 1840272917, not started MySQL thread id 75, OS thread handle 0x7fdf347b6700, query id 3163604 10.20.20.202 app cleaning up ---TRANSACTION 1840272936, not started MySQL thread id 73, OS thread handle 0x7fdf20724700, query id 3163647 10.20.20.202 app cleaning up ---TRANSACTION 1840272967, not started MySQL thread id 72, OS thread handle 0x7fdf29bff700, query id 3163716 10.20.20.202 app cleaning up ---TRANSACTION 1840272961, not started MySQL thread id 74, OS thread handle 0x7fdf317ff700, query id 3163703 10.20.20.202 app cleaning up ---TRANSACTION 1840272686, not started MySQL thread id 69, OS thread handle 0x7fdf213ff700, query id 3163154 10.20.10.181 app cleaning up ---TRANSACTION 1840272687, not started MySQL thread id 65, OS thread handle 0x7fdf30bff700, query id 3163156 10.20.10.181 app cleaning up ---TRANSACTION 1840269412, not started MySQL thread id 62, OS thread handle 0x7fdf36287700, query id 3156312 10.20.20.211 app cleaning up ---TRANSACTION 1840272853, not started MySQL thread id 61, OS thread handle 0x7fdf36319700, query id 3163480 10.20.20.201 app cleaning up ---TRANSACTION 1840272906, not started MySQL thread id 60, OS thread handle 0x7fdf1d292700, query id 3163580 10.20.20.201 app cleaning up ---TRANSACTION 1840272929, not started MySQL thread id 58, OS thread handle 0x7fdf36518700, query id 3163632 10.20.20.201 app cleaning up ---TRANSACTION 1840272931, not started MySQL thread id 57, OS thread handle 0x7fdf35f1b700, query id 3163640 10.20.20.201 app cleaning up ---TRANSACTION 1840272907, not started MySQL thread id 56, OS thread handle 0x7fdf3623e700, query id 3163586 10.20.20.201 app cleaning up ---TRANSACTION 1840272885, not started MySQL thread id 55, OS thread handle 0x7fdf366ce700, query id 3163542 10.20.20.201 app cleaning up ---TRANSACTION 1840272819, not started MySQL thread id 54, OS thread handle 0x7fdf323b6700, query id 3163421 10.20.20.201 app cleaning up ---TRANSACTION 1840272868, not started MySQL thread id 53, OS thread handle 0x7fdf1b76d700, query id 3163510 10.20.20.201 app cleaning up ---TRANSACTION 1840272903, not started MySQL thread id 52, OS thread handle 0x7fdf363ab700, query id 3163568 10.20.20.201 app cleaning up ---TRANSACTION 1840272963, not started MySQL thread id 51, OS thread handle 0x7fdf347b6700, query id 3163711 10.20.20.201 app cleaning up ---TRANSACTION 1840272910, not started MySQL thread id 50, OS thread handle 0x7fdf317ff700, query id 3163589 10.20.20.201 app cleaning up ---TRANSACTION 1840272838, not started MySQL thread id 49, OS thread handle 0x7fdf20724700, query id 3163449 10.20.20.201 app cleaning up ---TRANSACTION 1840272952, not started MySQL thread id 48, OS thread handle 0x7fdf207b6700, query id 3163685 10.20.20.201 app cleaning up ---TRANSACTION 1840272959, not started MySQL thread id 46, OS thread handle 0x7fdf1fbff700, query id 3163699 10.20.20.201 app cleaning up ---TRANSACTION 1840272955, not started MySQL thread id 45, OS thread handle 0x7fdf213ff700, query id 3163688 10.20.20.201 app cleaning up ---TRANSACTION 1840272887, not started MySQL thread id 44, OS thread handle 0x7fdf347ff700, query id 3163544 10.20.20.201 app cleaning up ---TRANSACTION 1840272839, not started MySQL thread id 43, OS thread handle 0x7fdf365f3700, query id 3163457 10.20.20.201 app cleaning up ---TRANSACTION 1840270727, not started MySQL thread id 42, OS thread handle 0x7fdf277ff700, query id 3159017 10.20.20.211 app cleaning up ---TRANSACTION 1840272980, not started MySQL thread id 41, OS thread handle 0x7fdf253ff700, query id 3163737 10.20.20.201 app cleaning up ---TRANSACTION 1840272945, not started MySQL thread id 40, OS thread handle 0x7fdf361ac700, query id 3163670 10.20.20.201 app cleaning up ---TRANSACTION 1840272870, not started MySQL thread id 39, OS thread handle 0x7fdf35f64700, query id 3163512 10.20.20.201 app cleaning up ---TRANSACTION 1840272930, not started MySQL thread id 37, OS thread handle 0x7fdf36319700, query id 3163634 10.20.20.201 app cleaning up ---TRANSACTION 1840272904, not started MySQL thread id 36, OS thread handle 0x7fdf1d292700, query id 3163576 10.20.20.201 app cleaning up ---TRANSACTION 1840272911, not started MySQL thread id 35, OS thread handle 0x7fdf360d1700, query id 3163591 10.20.20.201 app cleaning up ---TRANSACTION 1840272948, not started MySQL thread id 34, OS thread handle 0x7fdf2ffff700, query id 3163673 10.20.20.201 app cleaning up ---TRANSACTION 1840272956, not started MySQL thread id 33, OS thread handle 0x7fdf35d65700, query id 3163690 10.20.20.201 app cleaning up ---TRANSACTION 1840272891, not started MySQL thread id 32, OS thread handle 0x7fdf3623e700, query id 3163555 10.20.20.201 app cleaning up ---TRANSACTION 1840272944, not started MySQL thread id 31, OS thread handle 0x7fdf207ff700, query id 3163664 10.20.20.201 app cleaning up ---TRANSACTION 1840272949, not started MySQL thread id 30, OS thread handle 0x7fdf323b6700, query id 3163675 10.20.20.201 app cleaning up ---TRANSACTION 1840272817, not started MySQL thread id 29, OS thread handle 0x7fdf1d3ff700, query id 3163417 10.20.20.201 app cleaning up ---TRANSACTION 1840272957, not started MySQL thread id 28, OS thread handle 0x7fdf363ab700, query id 3163697 10.20.20.201 app cleaning up ---TRANSACTION 1840272826, not started MySQL thread id 27, OS thread handle 0x7fdf347b6700, query id 3163436 10.20.20.201 app cleaning up ---TRANSACTION 1840272950, not started MySQL thread id 24, OS thread handle 0x7fdf207b6700, query id 3163677 10.20.20.201 app cleaning up ---TRANSACTION 1840272840, not started MySQL thread id 23, OS thread handle 0x7fdf365aa700, query id 3163459 10.20.20.201 app cleaning up ---TRANSACTION 1840272979, not started MySQL thread id 22, OS thread handle 0x7fdf1fbff700, query id 3163729 10.20.20.201 app cleaning up ---TRANSACTION 1840272852, not started MySQL thread id 21, OS thread handle 0x7fdf213ff700, query id 3163472 10.20.20.201 app cleaning up ---TRANSACTION 1840272934, not started MySQL thread id 19, OS thread handle 0x7fdf365f3700, query id 3163643 10.20.20.201 app cleaning up ---TRANSACTION 1840272905, not started MySQL thread id 18, OS thread handle 0x7fdf277ff700, query id 3163578 10.20.20.201 app cleaning up ---TRANSACTION 1840272814, not started MySQL thread id 17, OS thread handle 0x7fdf253ff700, query id 3163414 10.20.20.201 app cleaning up ---TRANSACTION 1840272951, not started MySQL thread id 16, OS thread handle 0x7fdf36088700, query id 3163679 10.20.20.201 app cleaning up ---TRANSACTION 1840272935, not started MySQL thread id 15, OS thread handle 0x7fdf35f64700, query id 3163645 10.20.20.201 app cleaning up ---TRANSACTION 1840272229, not started MySQL thread id 9, OS thread handle 0x7fdf35d65700, query id 3162228 10.20.20.211 app cleaning up ---TRANSACTION 1840272943, not started MySQL thread id 8, OS thread handle 0x7fdf35ff6700, query id 3163662 10.20.20.201 app cleaning up ---TRANSACTION 1838725379, not started MySQL thread id 3, OS thread handle 0x7fdf371f3700, query id 0 Waiting for background binlog tasks -------- FILE I/O -------- I/O thread 0 state: waiting for completed aio requests (insert buffer thread) I/O thread 1 state: waiting for completed aio requests (log thread) I/O thread 2 state: waiting for completed aio requests (read thread) I/O thread 3 state: waiting for completed aio requests (read thread) I/O thread 4 state: waiting for completed aio requests (read thread) I/O thread 5 state: waiting for completed aio requests (read thread) I/O thread 6 state: waiting for completed aio requests (write thread) I/O thread 7 state: waiting for completed aio requests (write thread) I/O thread 8 state: waiting for completed aio requests (write thread) I/O thread 9 state: waiting for completed aio requests (write thread) Pending normal aio reads: 0 [0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0] , ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 98035 OS file reads, 639344 OS file writes, 492329 OS fsyncs 0.73 reads/s, 16384 avg bytes/read, 50.42 writes/s, 41.88 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 591, seg size 593, 10781 merges merged operations: insert 12862, delete mark 12067, delete 3588 discarded operations: insert 0, delete mark 0, delete 0 18706.90 hash searches/s, 1919.85 non-hash searches/s --- LOG --- Log sequence number 6680506108678 Log flushed up to 6680506108507 Pages flushed up to 6680407905714 Last checkpoint at 6680407489396 Max checkpoint age 865244898 Checkpoint age target 838205995 Modified age 98202964 Checkpoint age 98619282 0 pending log writes, 0 pending chkp writes 228688 log i/o's done, 17.35 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 21978152960; in additional pool allocated 0 Total memory allocated by read views 23752 Internal hash tables (constant factor + variable factor) Adaptive hash index 490551824 (339995048 + 150556776) Page hash 2657176 (buffer pool 0 only) Dictionary cache 85726975 (85000144 + 726831) File system 868360 (812272 + 56088) Lock system 53198696 (53125256 + 73440) Recovery system 0 (0 + 0) Dictionary memory allocated 726831 Buffer pool size 1310712 Buffer pool size, bytes 21474705408 Free buffers 1141556 Database pages 159967 Old database pages 58907 Modified db pages 18017 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1287, not young 0 0.15 youngs/s, 0.00 non-youngs/s Pages read 97925, created 62042, written 295935 0.73 reads/s, 4.65 creates/s, 22.19 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: 159967, unzip_LRU len: 0 I/O sum[0]:cur[40], unzip sum[0]:cur[0] ---------------------- INDIVIDUAL BUFFER POOL INFO ---------------------- ---BUFFER POOL 0 Buffer pool size 163839 Buffer pool size, bytes 2684338176 Free buffers 142852 Database pages 19845 Old database pages 7307 Modified db pages 2243 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 133, not young 0 0.04 youngs/s, 0.00 non-youngs/s Pages read 12253, created 7592, written 34486 0.12 reads/s, 0.23 creates/s, 3.23 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: 19845, unzip_LRU len: 0 I/O sum[0]:cur[5], unzip sum[0]:cur[0] ---BUFFER POOL 1 Buffer pool size 163839 Buffer pool size, bytes 2684338176 Free buffers 143242 Database pages 19443 Old database pages 7157 Modified db pages 2004 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 146, not young 0 0.04 youngs/s, 0.00 non-youngs/s Pages read 11870, created 7573, written 34716 0.00 reads/s, 0.00 creates/s, 4.62 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: 19443, unzip_LRU len: 0 I/O sum[0]:cur[5], unzip sum[0]:cur[0] ---BUFFER POOL 2 Buffer pool size 163839 Buffer pool size, bytes 2684338176 Free buffers 142911 Database pages 19744 Old database pages 7272 Modified db pages 2196 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 158, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 12668, created 7076, written 38064 0.12 reads/s, 0.00 creates/s, 4.35 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: 19744, unzip_LRU len: 0 I/O sum[0]:cur[5], unzip sum[0]:cur[0] ---BUFFER POOL 3 Buffer pool size 163839 Buffer pool size, bytes 2684338176 Free buffers 142014 Database pages 20710 Old database pages 7626 Modified db pages 2244 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 146, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 12026, created 8684, written 35720 0.00 reads/s, 0.00 creates/s, 2.12 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: 20710, unzip_LRU len: 0 I/O sum[0]:cur[5], unzip sum[0]:cur[0] ---BUFFER POOL 4 Buffer pool size 163839 Buffer pool size, bytes 2684338176 Free buffers 142152 Database pages 20568 Old database pages 7582 Modified db pages 2195 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 144, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 12168, created 8400, written 39324 0.31 reads/s, 0.08 creates/s, 2.08 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: 20568, unzip_LRU len: 0 I/O sum[0]:cur[5], unzip sum[0]:cur[0] ---BUFFER POOL 5 Buffer pool size 163839 Buffer pool size, bytes 2684338176 Free buffers 142883 Database pages 19774 Old database pages 7279 Modified db pages 2265 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 201, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 12143, created 7631, written 37915 0.15 reads/s, 1.58 creates/s, 1.69 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: 19774, unzip_LRU len: 0 I/O sum[0]:cur[5], unzip sum[0]:cur[0] ---BUFFER POOL 6 Buffer pool size 163839 Buffer pool size, bytes 2684338176 Free buffers 142893 Database pages 19789 Old database pages 7284 Modified db pages 2545 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 160, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 12075, created 7714, written 37065 0.00 reads/s, 2.50 creates/s, 1.92 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: 19789, unzip_LRU len: 0 I/O sum[0]:cur[5], unzip sum[0]:cur[0] ---BUFFER POOL 7 Buffer pool size 163839 Buffer pool size, bytes 2684338176 Free buffers 142609 Database pages 20094 Old database pages 7400 Modified db pages 2325 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 199, not young 0 0.08 youngs/s, 0.00 non-youngs/s Pages read 12722, created 7372, written 38645 0.04 reads/s, 0.27 creates/s, 2.19 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: 20094, unzip_LRU len: 0 I/O sum[0]:cur[5], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 0 read views open inside InnoDB 0 RW transactions active inside InnoDB 0 RO transactions active inside InnoDB 0 out of 1000 descriptors used Main thread process no. 29777, id 140596752656128, state: sleeping Number of rows inserted 8106235, updated 190051, deleted 110244, read 566218303 649.24 inserts/s, 10.31 updates/s, 6.69 deletes/s, 32508.87 reads/s ------------ TRANSACTIONS ------------ Trx id counter 1840272981 Purge done for trx's n:o < 1840272965 undo n:o < 0 state: running but idle History list length 1845 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0, not started MySQL thread id 541, OS thread handle 0x7fdf36319700, query id 3163738 localhost guru init SHOW ENGINE INNODB STATUS ---TRANSACTION 1840272689, not started MySQL thread id 543, OS thread handle 0x7fdf361f5700, query id 3163168 10.20.10.181 app cleaning up ---TRANSACTION 1840272688, not started MySQL thread id 544, OS thread handle 0x7fdf36088700, query id 3163165 10.20.10.181 app cleaning up ---TRANSACTION 1840271597, not started MySQL thread id 542, OS thread handle 0x7fdf36287700, query id 3160939 10.20.10.181 app cleaning up ---TRANSACTION 1840271859, not started MySQL thread id 540, OS thread handle 0x7fdf1d292700, query id 3161477 10.20.10.121 web cleaning up ---TRANSACTION 1840271866, not started MySQL thread id 538, OS thread handle 0x7fdf36518700, query id 3161540 10.20.10.121 web cleaning up ---TRANSACTION 1840251612, not started MySQL thread id 537, OS thread handle 0x7fdf35d65700, query id 3120848 10.20.10.121 web cleaning up ---TRANSACTION 1840263720, not started MySQL thread id 536, OS thread handle 0x7fdf3623e700, query id 3144944 10.20.10.122 app cleaning up ---TRANSACTION 1840268139, not started MySQL thread id 535, OS thread handle 0x7fdf207ff700, query id 3153586 10.20.10.122 web cleaning up ---TRANSACTION 1840268149, not started MySQL thread id 533, OS thread handle 0x7fdf1d3ff700, query id 3153658 10.20.10.122 web cleaning up ---TRANSACTION 1840243827, not started MySQL thread id 532, OS thread handle 0x7fdf363ab700, query id 3105289 10.20.10.121 web cleaning up ---TRANSACTION 1840266071, not started MySQL thread id 530, OS thread handle 0x7fdf317ff700, query id 3149491 10.20.10.121 app cleaning up ---TRANSACTION 1840269658, not started MySQL thread id 528, OS thread handle 0x7fdf207b6700, query id 3156795 10.20.10.182 app cleaning up ---TRANSACTION 1840256088, not started MySQL thread id 527, OS thread handle 0x7fdf365aa700, query id 3129970 10.20.10.121 app cleaning up ---TRANSACTION 1840268599, not started MySQL thread id 507, OS thread handle 0x7fdf1d3b6700, query id 3154595 10.20.10.122 web cleaning up ---TRANSACTION 1840269534, not started MySQL thread id 503, OS thread handle 0x7fdf365aa700, query id 3156561 10.20.10.182 app cleaning up ---TRANSACTION 1840272690, not started MySQL thread id 494, OS thread handle 0x7fdf36287700, query id 3163170 10.20.10.181 app cleaning up ---TRANSACTION 1840272623, not started MySQL thread id 488, OS thread handle 0x7fdf3623e700, query id 3163032 10.20.10.121 web cleaning up ---TRANSACTION 1840270212, not started MySQL thread id 480, OS thread handle 0x7fdf29bff700, query id 3157941 10.20.10.121 web cleaning up ---TRANSACTION 1840270337, not started MySQL thread id 474, OS thread handle 0x7fdf277ff700, query id 3158173 10.20.10.182 app cleaning up ---TRANSACTION 1840270095, not started MySQL thread id 475, OS thread handle 0x7fdf365f3700, query id 3157659 10.20.10.182 app cleaning up ---TRANSACTION 1840269656, not started MySQL thread id 477, OS thread handle 0x7fdf213ff700, query id 3156792 10.20.10.182 app cleaning up ---TRANSACTION 1840270094, not started MySQL thread id 476, OS thread handle 0x7fdf347ff700, query id 3157653 10.20.10.182 app cleaning up ---TRANSACTION 1840270338, not started MySQL thread id 473, OS thread handle 0x7fdf30bff700, query id 3158179 10.20.10.182 app cleaning up ---TRANSACTION 1840272679, not started MySQL thread id 470, OS thread handle 0x7fdf36287700, query id 3163140 10.20.10.181 app cleaning up ---TRANSACTION 1840270723, not started MySQL thread id 382, OS thread handle 0x7fdf1fbff700, query id 3159002 10.20.10.121 web cleaning up ---TRANSACTION 1840270728, not started MySQL thread id 381, OS thread handle 0x7fdf213ff700, query id 3159050 10.20.10.121 web cleaning up ---TRANSACTION 1839533849, not started MySQL thread id 364, OS thread handle 0x7fdf363ab700, query id 1654595 10.20.10.122 app cleaning up ---TRANSACTION 1840267475, not started MySQL thread id 334, OS thread handle 0x7fdf323ff700, query id 3152272 10.20.20.211 app cleaning up ---TRANSACTION 1840261100, not started MySQL thread id 337, OS thread handle 0x7fdf364cf700, query id 3139800 10.20.20.211 app cleaning up ---TRANSACTION 1840260075, not started MySQL thread id 333, OS thread handle 0x7fdf35ed2700, query id 3137799 10.20.20.211 app cleaning up ---TRANSACTION 1840253594, not started MySQL thread id 330, OS thread handle 0x7fdf277ff700, query id 3124912 10.20.20.211 app cleaning up ---TRANSACTION 1839542050, not started MySQL thread id 294, OS thread handle 0x7fdf30bff700, query id 1671244 10.20.10.122 web cleaning up ---TRANSACTION 1839539675, not started MySQL thread id 231, OS thread handle 0x7fdf35f64700, query id 1666309 10.20.10.122 web cleaning up ---TRANSACTION 1839543078, not started MySQL thread id 208, OS thread handle 0x7fdf2cfff700, query id 1673553 10.20.10.122 web cleaning up ---TRANSACTION 1839542220, not started MySQL thread id 119, OS thread handle 0x7fdf353ff700, query id 1671700 10.20.10.122 web cleaning up ---TRANSACTION 1839542218, not started MySQL thread id 118, OS thread handle 0x7fdf2b7b6700, query id 1671682 10.20.10.122 web cleaning up ---TRANSACTION 1839542894, not started MySQL thread id 234, OS thread handle 0x7fdf277ff700, query id 1673161 10.20.10.122 web cleaning up ---TRANSACTION 1839541493, not started MySQL thread id 141, OS thread handle 0x7fdf213ff700, query id 1670007 10.20.10.122 web cleaning up ---TRANSACTION 1839540720, not started MySQL thread id 128, OS thread handle 0x7fdf317ff700, query id 1668434 10.20.10.122 web cleaning up ---TRANSACTION 1839539680, not started MySQL thread id 122, OS thread handle 0x7fdf2076d700, query id 1666335 10.20.10.122 web cleaning up ---TRANSACTION 1839539668, not started MySQL thread id 121, OS thread handle 0x7fdf364cf700, query id 1666293 10.20.10.122 web cleaning up ---TRANSACTION 1839539681, not started MySQL thread id 117, OS thread handle 0x7fdf213ff700, query id 1666344 10.20.10.122 web cleaning up ---TRANSACTION 1839540384, not started MySQL thread id 227, OS thread handle 0x7fdf360d1700, query id 1667761 10.20.10.122 web cleaning up ---TRANSACTION 1839539661, not started MySQL thread id 224, OS thread handle 0x7fdf317ff700, query id 1666267 10.20.10.122 web cleaning up ---TRANSACTION 1839539679, not started MySQL thread id 221, OS thread handle 0x7fdf32fb6700, query id 1666326 10.20.10.122 web cleaning up ---TRANSACTION 1839539621, not started MySQL thread id 220, OS thread handle 0x7fdf3643d700, query id 1666172 10.20.10.122 web cleaning up ---TRANSACTION 1839538602, not started MySQL thread id 219, OS thread handle 0x7fdf1d3b6700, query id 1664229 10.20.10.122 web cleaning up ---TRANSACTION 1839538601, not started MySQL thread id 218, OS thread handle 0x7fdf2076d700, query id 1664169 10.20.10.122 web cleaning up ---TRANSACTION 1839538414, not started MySQL thread id 217, OS thread handle 0x7fdf364cf700, query id 1663810 10.20.10.122 web cleaning up ---TRANSACTION 1839538413, not started MySQL thread id 216, OS thread handle 0x7fdf29bff700, query id 1663801 10.20.10.122 web cleaning up ---TRANSACTION 1839539620, not started MySQL thread id 215, OS thread handle 0x7fdf365aa700, query id 1666163 10.20.10.122 web cleaning up ---TRANSACTION 1839539663, not started MySQL thread id 214, OS thread handle 0x7fdf1fbff700, query id 1666280 10.20.10.122 web cleaning up ---TRANSACTION 1839543311, not started MySQL thread id 213, OS thread handle 0x7fdf213ff700, query id 1674037 10.20.10.122 web cleaning up ---TRANSACTION 1839543142, not started MySQL thread id 212, OS thread handle 0x7fdf347ff700, query id 1673683 10.20.10.122 web cleaning up ---TRANSACTION 1839543310, not started MySQL thread id 211, OS thread handle 0x7fdf365f3700, query id 1674021 10.20.10.122 web cleaning up ---TRANSACTION 1839543141, not started MySQL thread id 210, OS thread handle 0x7fdf277ff700, query id 1673670 10.20.10.122 web cleaning up ---TRANSACTION 1839543077, not started MySQL thread id 209, OS thread handle 0x7fdf253ff700, query id 1673544 10.20.10.122 web cleaning up ---TRANSACTION 1839538412, not started MySQL thread id 207, OS thread handle 0x7fdf361f5700, query id 1663792 10.20.10.122 web cleaning up ---TRANSACTION 1839542892, not started MySQL thread id 206, OS thread handle 0x7fdf36287700, query id 1673156 10.20.10.122 web cleaning up ---TRANSACTION 1839539660, not started MySQL thread id 205, OS thread handle 0x7fdf36319700, query id 1666258 10.20.10.122 web cleaning up ---TRANSACTION 1839542927, not started MySQL thread id 204, OS thread handle 0x7fdf1d292700, query id 1673240 10.20.10.122 web cleaning up ---TRANSACTION 1839542891, not started MySQL thread id 203, OS thread handle 0x7fe547192700, query id 1673145 10.20.10.122 web cleaning up ---TRANSACTION 1839542898, not started MySQL thread id 202, OS thread handle 0x7fdf1d324700, query id 1673178 10.20.10.122 web cleaning up ---TRANSACTION 1839542888, not started MySQL thread id 201, OS thread handle 0x7fdf32fff700, query id 1673118 10.20.10.122 web cleaning up ---TRANSACTION 1839542890, not started MySQL thread id 200, OS thread handle 0x7fdf3623e700, query id 1673136 10.20.10.122 web cleaning up ---TRANSACTION 1839542885, not started MySQL thread id 199, OS thread handle 0x7fdf366ce700, query id 1673091 10.20.10.122 web cleaning up ---TRANSACTION 1839542889, not started MySQL thread id 198, OS thread handle 0x7fdf323b6700, query id 1673127 10.20.10.122 web cleaning up ---TRANSACTION 1839542887, not started MySQL thread id 197, OS thread handle 0x7fdf32fb6700, query id 1673109 10.20.10.122 web cleaning up ---TRANSACTION 1839542884, not started MySQL thread id 196, OS thread handle 0x7fdf3643d700, query id 1673082 10.20.10.122 web cleaning up ---TRANSACTION 1839542282, not started MySQL thread id 195, OS thread handle 0x7fdf347b6700, query id 1671898 10.20.10.122 web cleaning up ---TRANSACTION 1839542283, not started MySQL thread id 194, OS thread handle 0x7fdf2076d700, query id 1671921 10.20.10.122 web cleaning up ---TRANSACTION 1839542260, not started MySQL thread id 193, OS thread handle 0x7fdf364cf700, query id 1671840 10.20.10.122 web cleaning up ---TRANSACTION 1839542886, not started MySQL thread id 192, OS thread handle 0x7fdf207b6700, query id 1673100 10.20.10.122 web cleaning up ---TRANSACTION 1839542270, not started MySQL thread id 191, OS thread handle 0x7fdf353ff700, query id 1671859 10.20.10.122 web cleaning up ---TRANSACTION 1839542240, not started MySQL thread id 190, OS thread handle 0x7fdf2b7b6700, query id 1671781 10.20.10.122 web cleaning up ---TRANSACTION 1839542928, not started MySQL thread id 189, OS thread handle 0x7fdf35ed2700, query id 1673258 10.20.10.122 web cleaning up ---TRANSACTION 1839542244, not started MySQL thread id 188, OS thread handle 0x7fdf347ff700, query id 1671797 10.20.10.122 web cleaning up ---TRANSACTION 1839542226, not started MySQL thread id 187, OS thread handle 0x7fdf2e7b6700, query id 1671739 10.20.10.122 web cleaning up ---TRANSACTION 1839542230, not started MySQL thread id 186, OS thread handle 0x7fdf30bb6700, query id 1671764 10.20.10.122 web cleaning up ---TRANSACTION 1839542225, not started MySQL thread id 185, OS thread handle 0x7fdf253ff700, query id 1671730 10.20.10.122 web cleaning up ---TRANSACTION 1839542227, not started MySQL thread id 184, OS thread handle 0x7fdf2cfff700, query id 1671748 10.20.10.122 web cleaning up ---TRANSACTION 1839542221, not started MySQL thread id 183, OS thread handle 0x7fdf361f5700, query id 1671709 10.20.10.122 web cleaning up ---TRANSACTION 1839542219, not started MySQL thread id 182, OS thread handle 0x7fdf36287700, query id 1671691 10.20.10.122 web cleaning up ---TRANSACTION 1839542222, not started MySQL thread id 181, OS thread handle 0x7fdf36319700, query id 1671718 10.20.10.122 web cleaning up ---TRANSACTION 1839542256, not started MySQL thread id 180, OS thread handle 0x7fdf1d292700, query id 1671822 10.20.10.122 web cleaning up ---TRANSACTION 1839542217, not started MySQL thread id 179, OS thread handle 0x7fdf360d1700, query id 1671673 10.20.10.122 web cleaning up ---TRANSACTION 1839542216, not started MySQL thread id 178, OS thread handle 0x7fdf36518700, query id 1671664 10.20.10.122 web cleaning up ---TRANSACTION 1839542215, not started MySQL thread id 177, OS thread handle 0x7fdf32fff700, query id 1671655 10.20.10.122 web cleaning up ---TRANSACTION 1839542211, not started MySQL thread id 176, OS thread handle 0x7fdf317ff700, query id 1671619 10.20.10.122 web cleaning up ---TRANSACTION 1839542214, not started MySQL thread id 175, OS thread handle 0x7fdf1d2db700, query id 1671646 10.20.10.122 web cleaning up ---TRANSACTION 1839542210, not started MySQL thread id 174, OS thread handle 0x7fdf323b6700, query id 1671610 10.20.10.122 web cleaning up ---TRANSACTION 1839542213, not started MySQL thread id 173, OS thread handle 0x7fdf1fb6d700, query id 1671637 10.20.10.122 web cleaning up ---TRANSACTION 1839542085, not started MySQL thread id 172, OS thread handle 0x7fdf363ab700, query id 1671357 10.20.10.122 web cleaning up ---TRANSACTION 1839542208, not started MySQL thread id 171, OS thread handle 0x7fdf347b6700, query id 1671592 10.20.10.122 web cleaning up ---TRANSACTION 1839542076, not started MySQL thread id 170, OS thread handle 0x7fdf2076d700, query id 1671328 10.20.10.122 web cleaning up ---TRANSACTION 1839542209, not started MySQL thread id 169, OS thread handle 0x7fdf364cf700, query id 1671601 10.20.10.122 web cleaning up ---TRANSACTION 1839542063, not started MySQL thread id 168, OS thread handle 0x7fdf29bff700, query id 1671306 10.20.10.122 web cleaning up ---TRANSACTION 1839542056, not started MySQL thread id 167, OS thread handle 0x7fdf365aa700, query id 1671261 10.20.10.122 web cleaning up ---TRANSACTION 1839542044, not started MySQL thread id 166, OS thread handle 0x7fdf2b7b6700, query id 1671232 10.20.10.122 web cleaning up ---TRANSACTION 1839542212, not started MySQL thread id 165, OS thread handle 0x7fdf213ff700, query id 1671628 10.20.10.122 web cleaning up ---TRANSACTION 1839542062, not started MySQL thread id 164, OS thread handle 0x7fdf347ff700, query id 1671279 10.20.10.122 web cleaning up ---TRANSACTION 1839542041, not started MySQL thread id 163, OS thread handle 0x7fdf2e7b6700, query id 1671219 10.20.10.122 web cleaning up ---TRANSACTION 1839542040, not started MySQL thread id 162, OS thread handle 0x7fdf30bb6700, query id 1671209 10.20.10.122 web cleaning up ---TRANSACTION 1839542037, not started MySQL thread id 161, OS thread handle 0x7fdf253ff700, query id 1671187 10.20.10.122 web cleaning up ---TRANSACTION 1839542038, not started MySQL thread id 160, OS thread handle 0x7fdf361ac700, query id 1671199 10.20.10.122 web cleaning up ---TRANSACTION 1839542035, not started MySQL thread id 159, OS thread handle 0x7fdf361f5700, query id 1671169 10.20.10.122 web cleaning up ---TRANSACTION 1839542034, not started MySQL thread id 158, OS thread handle 0x7fdf36287700, query id 1671158 10.20.10.122 web cleaning up ---TRANSACTION 1839542031, not started MySQL thread id 157, OS thread handle 0x7fdf36319700, query id 1671143 10.20.10.122 web cleaning up ---TRANSACTION 1839541977, not started MySQL thread id 154, OS thread handle 0x7fdf36518700, query id 1671065 10.20.10.122 web cleaning up ---TRANSACTION 1839541882, not started MySQL thread id 153, OS thread handle 0x7fdf1b76d700, query id 1670844 10.20.10.122 web cleaning up ---TRANSACTION 1839541976, not started MySQL thread id 152, OS thread handle 0x7fdf3623e700, query id 1671033 10.20.10.122 web cleaning up ---TRANSACTION 1839541877, not started MySQL thread id 151, OS thread handle 0x7fdf366ce700, query id 1670799 10.20.10.122 web cleaning up ---TRANSACTION 1839542036, not started MySQL thread id 150, OS thread handle 0x7fdf30bff700, query id 1671178 10.20.10.122 web cleaning up ---TRANSACTION 1839541878, not started MySQL thread id 149, OS thread handle 0x7fdf32fb6700, query id 1670808 10.20.10.122 web cleaning up ---TRANSACTION 1839541881, not started MySQL thread id 148, OS thread handle 0x7fdf363ab700, query id 1670835 10.20.10.122 web cleaning up ---TRANSACTION 1839541875, not started MySQL thread id 147, OS thread handle 0x7fdf1d3b6700, query id 1670781 10.20.10.122 web cleaning up ---TRANSACTION 1839541880, not started MySQL thread id 146, OS thread handle 0x7fdf2076d700, query id 1670826 10.20.10.122 web cleaning up ---TRANSACTION 1839541874, not started MySQL thread id 145, OS thread handle 0x7fdf364cf700, query id 1670772 10.20.10.122 web cleaning up ---TRANSACTION 1839541876, not started MySQL thread id 144, OS thread handle 0x7fdf29bff700, query id 1670790 10.20.10.122 web cleaning up ---TRANSACTION 1839541847, not started MySQL thread id 143, OS thread handle 0x7fdf365aa700, query id 1670734 10.20.10.122 web cleaning up ---TRANSACTION 1839541846, not started MySQL thread id 142, OS thread handle 0x7fdf2b7b6700, query id 1670701 10.20.10.122 web cleaning up ---TRANSACTION 1839541492, not started MySQL thread id 140, OS thread handle 0x7fdf347ff700, query id 1669998 10.20.10.122 web cleaning up ---TRANSACTION 1839541453, not started MySQL thread id 139, OS thread handle 0x7fdf365f3700, query id 1669918 10.20.10.122 web cleaning up ---TRANSACTION 0, not started MySQL thread id 138, OS thread handle 0x7fdf30bb6700, query id 3157063 10.20.20.60 guru cleaning up ---TRANSACTION 1839540721, not started MySQL thread id 134, OS thread handle 0x7fdf36287700, query id 1668443 10.20.10.122 web cleaning up ---TRANSACTION 1839541879, not started MySQL thread id 136, OS thread handle 0x7fdf361ac700, query id 1670817 10.20.10.122 web cleaning up ---TRANSACTION 1839541452, not started MySQL thread id 135, OS thread handle 0x7fdf361f5700, query id 1669909 10.20.10.122 web cleaning up ---TRANSACTION 1839540499, not started MySQL thread id 133, OS thread handle 0x7fdf36319700, query id 1668005 10.20.10.122 web cleaning up ---TRANSACTION 1839541407, not started MySQL thread id 132, OS thread handle 0x7fdf1d292700, query id 1669780 10.20.10.122 web cleaning up ---TRANSACTION 1839542897, not started MySQL thread id 131, OS thread handle 0x7fe547192700, query id 1673169 10.20.10.122 web cleaning up ---TRANSACTION 1839540498, not started MySQL thread id 127, OS thread handle 0x7fdf366ce700, query id 1667987 10.20.10.122 web cleaning up ---TRANSACTION 1839539854, not started MySQL thread id 126, OS thread handle 0x7fdf30bff700, query id 1666731 10.20.10.122 web cleaning up ---TRANSACTION 1839540383, not started MySQL thread id 125, OS thread handle 0x7fdf1fb6d700, query id 1667752 10.20.10.122 web cleaning up ---TRANSACTION 1839539849, not started MySQL thread id 124, OS thread handle 0x7fdf3643d700, query id 1666690 10.20.10.122 web cleaning up ---TRANSACTION 1839539684, not started MySQL thread id 123, OS thread handle 0x7fdf347b6700, query id 1666360 10.20.10.122 web cleaning up ---TRANSACTION 1840272920, not started MySQL thread id 95, OS thread handle 0x7fdf365aa700, query id 3163610 10.20.20.202 app cleaning up ---TRANSACTION 1840272970, not started MySQL thread id 94, OS thread handle 0x7fdf1fbff700, query id 3163720 10.20.20.202 app cleaning up ---TRANSACTION 1840272918, not started MySQL thread id 85, OS thread handle 0x7fdf36319700, query id 3163606 10.20.20.202 app cleaning up ---TRANSACTION 1840272919, not started MySQL thread id 92, OS thread handle 0x7fdf347ff700, query id 3163608 10.20.20.202 app cleaning up ---TRANSACTION 1840272914, not started MySQL thread id 91, OS thread handle 0x7fdf2e7b6700, query id 3163601 10.20.20.202 app cleaning up ---TRANSACTION 1840272960, not started MySQL thread id 90, OS thread handle 0x7fdf277ff700, query id 3163701 10.20.20.202 app cleaning up ---TRANSACTION 1840272941, not started MySQL thread id 84, OS thread handle 0x7fdf1d292700, query id 3163658 10.20.20.202 app cleaning up ---TRANSACTION 1840272913, not started MySQL thread id 86, OS thread handle 0x7fdf36287700, query id 3163595 10.20.20.202 app cleaning up ---TRANSACTION 1840272926, not started MySQL thread id 88, OS thread handle 0x7fdf36088700, query id 3163628 10.20.20.202 app cleaning up ---TRANSACTION 1840272942, not started MySQL thread id 89, OS thread handle 0x7fdf30bff700, query id 3163660 10.20.20.202 app cleaning up ---TRANSACTION 1840272928, not started MySQL thread id 87, OS thread handle 0x7fdf35f64700, query id 3163630 10.20.20.202 app cleaning up ---TRANSACTION 1840272938, not started MySQL thread id 82, OS thread handle 0x7fdf36518700, query id 3163655 10.20.20.202 app cleaning up ---TRANSACTION 1840272924, not started MySQL thread id 83, OS thread handle 0x7fdf360d1700, query id 3163619 10.20.20.202 app cleaning up ---TRANSACTION 1840272921, not started MySQL thread id 80, OS thread handle 0x7fdf3623e700, query id 3163616 10.20.20.202 app cleaning up ---TRANSACTION 1840272962, not started MySQL thread id 81, OS thread handle 0x7fdf35d65700, query id 3163709 10.20.20.202 app cleaning up ---TRANSACTION 1840272937, not started MySQL thread id 77, OS thread handle 0x7fdf1d3ff700, query id 3163649 10.20.20.202 app cleaning up ---TRANSACTION 1840272925, not started MySQL thread id 76, OS thread handle 0x7fdf363ab700, query id 3163621 10.20.20.202 app cleaning up ---TRANSACTION 1840272917, not started MySQL thread id 75, OS thread handle 0x7fdf347b6700, query id 3163604 10.20.20.202 app cleaning up ---TRANSACTION 1840272936, not started MySQL thread id 73, OS thread handle 0x7fdf20724700, query id 3163647 10.20.20.202 app cleaning up ---TRANSACTION 1840272967, not started MySQL thread id 72, OS thread handle 0x7fdf29bff700, query id 3163716 10.20.20.202 app cleaning up ---TRANSACTION 1840272961, not started MySQL thread id 74, OS thread handle 0x7fdf317ff700, query id 3163703 10.20.20.202 app cleaning up ---TRANSACTION 1840272686, not started MySQL thread id 69, OS thread handle 0x7fdf213ff700, query id 3163154 10.20.10.181 app cleaning up ---TRANSACTION 1840272687, not started MySQL thread id 65, OS thread handle 0x7fdf30bff700, query id 3163156 10.20.10.181 app cleaning up ---TRANSACTION 1840269412, not started MySQL thread id 62, OS thread handle 0x7fdf36287700, query id 3156312 10.20.20.211 app cleaning up ---TRANSACTION 1840272853, not started MySQL thread id 61, OS thread handle 0x7fdf36319700, query id 3163480 10.20.20.201 app cleaning up ---TRANSACTION 1840272906, not started MySQL thread id 60, OS thread handle 0x7fdf1d292700, query id 3163580 10.20.20.201 app cleaning up ---TRANSACTION 1840272929, not started MySQL thread id 58, OS thread handle 0x7fdf36518700, query id 3163632 10.20.20.201 app cleaning up ---TRANSACTION 1840272931, not started MySQL thread id 57, OS thread handle 0x7fdf35f1b700, query id 3163640 10.20.20.201 app cleaning up ---TRANSACTION 1840272907, not started MySQL thread id 56, OS thread handle 0x7fdf3623e700, query id 3163586 10.20.20.201 app cleaning up ---TRANSACTION 1840272885, not started MySQL thread id 55, OS thread handle 0x7fdf366ce700, query id 3163542 10.20.20.201 app cleaning up ---TRANSACTION 1840272819, not started MySQL thread id 54, OS thread handle 0x7fdf323b6700, query id 3163421 10.20.20.201 app cleaning up ---TRANSACTION 1840272868, not started MySQL thread id 53, OS thread handle 0x7fdf1b76d700, query id 3163510 10.20.20.201 app cleaning up ---TRANSACTION 1840272903, not started MySQL thread id 52, OS thread handle 0x7fdf363ab700, query id 3163568 10.20.20.201 app cleaning up ---TRANSACTION 1840272963, not started MySQL thread id 51, OS thread handle 0x7fdf347b6700, query id 3163711 10.20.20.201 app cleaning up ---TRANSACTION 1840272910, not started MySQL thread id 50, OS thread handle 0x7fdf317ff700, query id 3163589 10.20.20.201 app cleaning up ---TRANSACTION 1840272838, not started MySQL thread id 49, OS thread handle 0x7fdf20724700, query id 3163449 10.20.20.201 app cleaning up ---TRANSACTION 1840272952, not started MySQL thread id 48, OS thread handle 0x7fdf207b6700, query id 3163685 10.20.20.201 app cleaning up ---TRANSACTION 1840272959, not started MySQL thread id 46, OS thread handle 0x7fdf1fbff700, query id 3163699 10.20.20.201 app cleaning up ---TRANSACTION 1840272955, not started MySQL thread id 45, OS thread handle 0x7fdf213ff700, query id 3163688 10.20.20.201 app cleaning up ---TRANSACTION 1840272887, not started MySQL thread id 44, OS thread handle 0x7fdf347ff700, query id 3163544 10.20.20.201 app cleaning up ---TRANSACTION 1840272839, not started MySQL thread id 43, OS thread handle 0x7fdf365f3700, query id 3163457 10.20.20.201 app cleaning up ---TRANSACTION 1840270727, not started MySQL thread id 42, OS thread handle 0x7fdf277ff700, query id 3159017 10.20.20.211 app cleaning up ---TRANSACTION 1840272980, not started MySQL thread id 41, OS thread handle 0x7fdf253ff700, query id 3163737 10.20.20.201 app cleaning up ---TRANSACTION 1840272945, not started MySQL thread id 40, OS thread handle 0x7fdf361ac700, query id 3163670 10.20.20.201 app cleaning up ---TRANSACTION 1840272870, not started MySQL thread id 39, OS thread handle 0x7fdf35f64700, query id 3163512 10.20.20.201 app cleaning up ---TRANSACTION 1840272930, not started MySQL thread id 37, OS thread handle 0x7fdf36319700, query id 3163634 10.20.20.201 app cleaning up ---TRANSACTION 1840272904, not started MySQL thread id 36, OS thread handle 0x7fdf1d292700, query id 3163576 10.20.20.201 app cleaning up ---TRANSACTION 1840272911, not started MySQL thread id 35, OS thread handle 0x7fdf360d1700, query id 3163591 10.20.20.201 app cleaning up ---TRANSACTION 1840272948, not started MySQL thread id 34, OS thread handle 0x7fdf2ffff700, query id 3163673 10.20.20.201 app cleaning up ---TRANSACTION 1840272956, not started MySQL thread id 33, OS thread handle 0x7fdf35d65700, query id 3163690 10.20.20.201 app cleaning up ---TRANSACTION 1840272891, not started MySQL thread id 32, OS thread handle 0x7fdf3623e700, query id 3163555 10.20.20.201 app cleaning up ---TRANSACTION 1840272944, not started MySQL thread id 31, OS thread handle 0x7fdf207ff700, query id 3163664 10.20.20.201 app cleaning up ---TRANSACTION 1840272949, not started MySQL thread id 30, OS thread handle 0x7fdf323b6700, query id 3163675 10.20.20.201 app cleaning up ---TRANSACTION 1840272817, not started MySQL thread id 29, OS thread handle 0x7fdf1d3ff700, query id 3163417 10.20.20.201 app cleaning up ---TRANSACTION 1840272957, not started MySQL thread id 28, OS thread handle 0x7fdf363ab700, query id 3163697 10.20.20.201 app cleaning up ---TRANSACTION 1840272826, not started MySQL thread id 27, OS thread handle 0x7fdf347b6700, query id 3163436 10.20.20.201 app cleaning up ---TRANSACTION 1840272950, not started MySQL thread id 24, OS thread handle 0x7fdf207b6700, query id 3163677 10.20.20.201 app cleaning up ---TRANSACTION 1840272840, not started MySQL thread id 23, OS thread handle 0x7fdf365aa700, query id 3163459 10.20.20.201 app cleaning up ---TRANSACTION 1840272979, not started MySQL thread id 22, OS thread handle 0x7fdf1fbff700, query id 3163729 10.20.20.201 app cleaning up ---TRANSACTION 1840272852, not started MySQL thread id 21, OS thread handle 0x7fdf213ff700, query id 3163472 10.20.20.201 app cleaning up ---TRANSACTION 1840272934, not started MySQL thread id 19, OS thread handle 0x7fdf365f3700, query id 3163643 10.20.20.201 app cleaning up ---TRANSACTION 1840272905, not started MySQL thread id 18, OS thread handle 0x7fdf277ff700, query id 3163578 10.20.20.201 app cleaning up ---TRANSACTION 1840272814, not started MySQL thread id 17, OS thread handle 0x7fdf253ff700, query id 3163414 10.20.20.201 app cleaning up ---TRANSACTION 1840272951, not started MySQL thread id 16, OS thread handle 0x7fdf36088700, query id 3163679 10.20.20.201 app cleaning up ---TRANSACTION 1840272935, not started MySQL thread id 15, OS thread handle 0x7fdf35f64700, query id 3163645 10.20.20.201 app cleaning up ---TRANSACTION 1840272229, not started MySQL thread id 9, OS thread handle 0x7fdf35d65700, query id 3162228 10.20.20.211 app cleaning up ---TRANSACTION 1840272943, not started MySQL thread id 8, OS thread handle 0x7fdf35ff6700, query id 3163662 10.20.20.201 app cleaning up ---TRANSACTION 1838725379, not started MySQL thread id 3, OS thread handle 0x7fdf371f3700, query id 0 Waiting for background binlog tasks ---------------------------- END OF INNODB MONITOR OUTPUT ============================ 1 row in set (0.00 sec) MariaDB [(none)]> SHOW ENGINE INNODB STATUS \G *************************** 1. row *************************** Type: InnoDB Name: Status: ===================================== 2014-11-17 16:40:12 7fdf36319700 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 6 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 11684 srv_active, 0 srv_shutdown, 26 srv_idle srv_master_thread log flush and writes: 11710 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 90312 OS WAIT ARRAY INFO: signal count 126028 Mutex spin waits 170845, rounds 2682881, OS waits 83383 RW-shared spins 19009, rounds 198068, OS waits 3914 RW-excl spins 38138, rounds 276769, OS waits 2291 Spin rounds per wait: 15.70 mutex, 10.42 RW-shared, 7.26 RW-excl ------------ TRANSACTIONS ------------ Trx id counter 1840281303 Purge done for trx's n:o < 1840281302 undo n:o < 0 state: running but idle History list length 2009 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0, not started MySQL thread id 541, OS thread handle 0x7fdf36319700, query id 3180096 localhost guru init SHOW ENGINE INNODB STATUS ---TRANSACTION 1840272689, not started MySQL thread id 543, OS thread handle 0x7fdf361f5700, query id 3163168 10.20.10.181 app cleaning up ---TRANSACTION 1840272688, not started MySQL thread id 544, OS thread handle 0x7fdf36088700, query id 3163165 10.20.10.181 app cleaning up ---TRANSACTION 1840271597, not started MySQL thread id 542, OS thread handle 0x7fdf36287700, query id 3160939 10.20.10.181 app cleaning up ---TRANSACTION 1840271859, not started MySQL thread id 540, OS thread handle 0x7fdf1d292700, query id 3161477 10.20.10.121 web cleaning up ---TRANSACTION 1840271866, not started MySQL thread id 538, OS thread handle 0x7fdf36518700, query id 3161540 10.20.10.121 web cleaning up ---TRANSACTION 1840251612, not started MySQL thread id 537, OS thread handle 0x7fdf35d65700, query id 3120848 10.20.10.121 web cleaning up ---TRANSACTION 1840263720, not started MySQL thread id 536, OS thread handle 0x7fdf3623e700, query id 3144944 10.20.10.122 app cleaning up ---TRANSACTION 1840268139, not started MySQL thread id 535, OS thread handle 0x7fdf207ff700, query id 3153586 10.20.10.122 web cleaning up ---TRANSACTION 1840268149, not started MySQL thread id 533, OS thread handle 0x7fdf1d3ff700, query id 3153658 10.20.10.122 web cleaning up ---TRANSACTION 1840243827, not started MySQL thread id 532, OS thread handle 0x7fdf363ab700, query id 3105289 10.20.10.121 web cleaning up ---TRANSACTION 1840279909, not started MySQL thread id 530, OS thread handle 0x7fdf317ff700, query id 3177334 10.20.10.121 app cleaning up ---TRANSACTION 1840275906, not started MySQL thread id 528, OS thread handle 0x7fdf207b6700, query id 3169465 10.20.10.182 app cleaning up ---TRANSACTION 1840256088, not started MySQL thread id 527, OS thread handle 0x7fdf365aa700, query id 3129970 10.20.10.121 app cleaning up ---TRANSACTION 1840279616, not started MySQL thread id 507, OS thread handle 0x7fdf1d3b6700, query id 3176771 10.20.10.122 web cleaning up ---TRANSACTION 1840275595, not started MySQL thread id 503, OS thread handle 0x7fdf365aa700, query id 3168851 10.20.10.182 app cleaning up ---TRANSACTION 1840272690, not started MySQL thread id 494, OS thread handle 0x7fdf36287700, query id 3163170 10.20.10.181 app cleaning up ---TRANSACTION 1840280825, not started MySQL thread id 488, OS thread handle 0x7fdf35ff6700, query id 3179149 10.20.10.121 web cleaning up ---TRANSACTION 1840280990, not started MySQL thread id 480, OS thread handle 0x7fdf29bff700, query id 3179478 10.20.10.121 web cleaning up ---TRANSACTION 1840280187, not started MySQL thread id 474, OS thread handle 0x7fdf30bb6700, query id 3177872 10.20.10.182 app cleaning up ---TRANSACTION 1840279622, not started MySQL thread id 475, OS thread handle 0x7fdf2e7b6700, query id 3176785 10.20.10.182 app cleaning up ---TRANSACTION 1840275905, not started MySQL thread id 477, OS thread handle 0x7fdf213ff700, query id 3169459 10.20.10.182 app cleaning up ---TRANSACTION 1840279620, not started MySQL thread id 476, OS thread handle 0x7fdf347ff700, query id 3176782 10.20.10.182 app cleaning up ---TRANSACTION 1840280188, not started MySQL thread id 473, OS thread handle 0x7fdf253ff700, query id 3177878 10.20.10.182 app cleaning up ---TRANSACTION 1840272679, not started MySQL thread id 470, OS thread handle 0x7fdf36287700, query id 3163140 10.20.10.181 app cleaning up ---TRANSACTION 1840280992, not started MySQL thread id 382, OS thread handle 0x7fdf323ff700, query id 3179493 10.20.10.121 web cleaning up ---TRANSACTION 1840278100, not started MySQL thread id 381, OS thread handle 0x7fdf35ed2700, query id 3173767 10.20.10.121 web cleaning up ---TRANSACTION 1839533849, not started MySQL thread id 364, OS thread handle 0x7fdf363ab700, query id 1654595 10.20.10.122 app cleaning up ---TRANSACTION 1840267475, not started MySQL thread id 334, OS thread handle 0x7fdf323ff700, query id 3152272 10.20.20.211 app cleaning up ---TRANSACTION 1840261100, not started MySQL thread id 337, OS thread handle 0x7fdf364cf700, query id 3139800 10.20.20.211 app cleaning up ---TRANSACTION 1840275059, not started MySQL thread id 333, OS thread handle 0x7fdf35ed2700, query id 3167806 10.20.20.211 app cleaning up ---TRANSACTION 1840273933, not started MySQL thread id 330, OS thread handle 0x7fdf277ff700, query id 3165582 10.20.20.211 app cleaning up ---TRANSACTION 1839542050, not started MySQL thread id 294, OS thread handle 0x7fdf30bff700, query id 1671244 10.20.10.122 web cleaning up ---TRANSACTION 1839539675, not started MySQL thread id 231, OS thread handle 0x7fdf35f64700, query id 1666309 10.20.10.122 web cleaning up ---TRANSACTION 1839543078, not started MySQL thread id 208, OS thread handle 0x7fdf2cfff700, query id 1673553 10.20.10.122 web cleaning up ---TRANSACTION 1839542220, not started MySQL thread id 119, OS thread handle 0x7fdf353ff700, query id 1671700 10.20.10.122 web cleaning up ---TRANSACTION 1839542218, not started MySQL thread id 118, OS thread handle 0x7fdf2b7b6700, query id 1671682 10.20.10.122 web cleaning up ---TRANSACTION 1839542894, not started MySQL thread id 234, OS thread handle 0x7fdf277ff700, query id 1673161 10.20.10.122 web cleaning up ---TRANSACTION 1839541493, not started MySQL thread id 141, OS thread handle 0x7fdf213ff700, query id 1670007 10.20.10.122 web cleaning up ---TRANSACTION 1839540720, not started MySQL thread id 128, OS thread handle 0x7fdf317ff700, query id 1668434 10.20.10.122 web cleaning up ---TRANSACTION 1839539680, not started MySQL thread id 122, OS thread handle 0x7fdf2076d700, query id 1666335 10.20.10.122 web cleaning up ---TRANSACTION 1839539668, not started MySQL thread id 121, OS thread handle 0x7fdf364cf700, query id 1666293 10.20.10.122 web cleaning up ---TRANSACTION 1839539681, not started MySQL thread id 117, OS thread handle 0x7fdf213ff700, query id 1666344 10.20.10.122 web cleaning up ---TRANSACTION 1839540384, not started MySQL thread id 227, OS thread handle 0x7fdf360d1700, query id 1667761 10.20.10.122 web cleaning up ---TRANSACTION 1839539661, not started MySQL thread id 224, OS thread handle 0x7fdf317ff700, query id 1666267 10.20.10.122 web cleaning up ---TRANSACTION 1839539679, not started MySQL thread id 221, OS thread handle 0x7fdf32fb6700, query id 1666326 10.20.10.122 web cleaning up ---TRANSACTION 1839539621, not started MySQL thread id 220, OS thread handle 0x7fdf3643d700, query id 1666172 10.20.10.122 web cleaning up ---TRANSACTION 1839538602, not started MySQL thread id 219, OS thread handle 0x7fdf1d3b6700, query id 1664229 10.20.10.122 web cleaning up ---TRANSACTION 1839538601, not started MySQL thread id 218, OS thread handle 0x7fdf2076d700, query id 1664169 10.20.10.122 web cleaning up ---TRANSACTION 1839538414, not started MySQL thread id 217, OS thread handle 0x7fdf364cf700, query id 1663810 10.20.10.122 web cleaning up ---TRANSACTION 1839538413, not started MySQL thread id 216, OS thread handle 0x7fdf29bff700, query id 1663801 10.20.10.122 web cleaning up ---TRANSACTION 1839539620, not started MySQL thread id 215, OS thread handle 0x7fdf365aa700, query id 1666163 10.20.10.122 web cleaning up ---TRANSACTION 1839539663, not started MySQL thread id 214, OS thread handle 0x7fdf1fbff700, query id 1666280 10.20.10.122 web cleaning up ---TRANSACTION 1839543311, not started MySQL thread id 213, OS thread handle 0x7fdf213ff700, query id 1674037 10.20.10.122 web cleaning up ---TRANSACTION 1839543142, not started MySQL thread id 212, OS thread handle 0x7fdf347ff700, query id 1673683 10.20.10.122 web cleaning up ---TRANSACTION 1839543310, not started MySQL thread id 211, OS thread handle 0x7fdf365f3700, query id 1674021 10.20.10.122 web cleaning up ---TRANSACTION 1839543141, not started MySQL thread id 210, OS thread handle 0x7fdf277ff700, query id 1673670 10.20.10.122 web cleaning up ---TRANSACTION 1839543077, not started MySQL thread id 209, OS thread handle 0x7fdf253ff700, query id 1673544 10.20.10.122 web cleaning up ---TRANSACTION 1839538412, not started MySQL thread id 207, OS thread handle 0x7fdf361f5700, query id 1663792 10.20.10.122 web cleaning up ---TRANSACTION 1839542892, not started MySQL thread id 206, OS thread handle 0x7fdf36287700, query id 1673156 10.20.10.122 web cleaning up ---TRANSACTION 1839539660, not started MySQL thread id 205, OS thread handle 0x7fdf36319700, query id 1666258 10.20.10.122 web cleaning up ---TRANSACTION 1839542927, not started MySQL thread id 204, OS thread handle 0x7fdf1d292700, query id 1673240 10.20.10.122 web cleaning up ---TRANSACTION 1839542891, not started MySQL thread id 203, OS thread handle 0x7fe547192700, query id 1673145 10.20.10.122 web cleaning up ---TRANSACTION 1839542898, not started MySQL thread id 202, OS thread handle 0x7fdf1d324700, query id 1673178 10.20.10.122 web cleaning up ---TRANSACTION 1839542888, not started MySQL thread id 201, OS thread handle 0x7fdf32fff700, query id 1673118 10.20.10.122 web cleaning up ---TRANSACTION 1839542890, not started MySQL thread id 200, OS thread handle 0x7fdf3623e700, query id 1673136 10.20.10.122 web cleaning up ---TRANSACTION 1839542885, not started MySQL thread id 199, OS thread handle 0x7fdf366ce700, query id 1673091 10.20.10.122 web cleaning up ---TRANSACTION 1839542889, not started MySQL thread id 198, OS thread handle 0x7fdf323b6700, query id 1673127 10.20.10.122 web cleaning up ---TRANSACTION 1839542887, not started MySQL thread id 197, OS thread handle 0x7fdf32fb6700, query id 1673109 10.20.10.122 web cleaning up ---TRANSACTION 1839542884, not started MySQL thread id 196, OS thread handle 0x7fdf3643d700, query id 1673082 10.20.10.122 web cleaning up ---TRANSACTION 1839542282, not started MySQL thread id 195, OS thread handle 0x7fdf347b6700, query id 1671898 10.20.10.122 web cleaning up ---TRANSACTION 1839542283, not started MySQL thread id 194, OS thread handle 0x7fdf2076d700, query id 1671921 10.20.10.122 web cleaning up ---TRANSACTION 1839542260, not started MySQL thread id 193, OS thread handle 0x7fdf364cf700, query id 1671840 10.20.10.122 web cleaning up ---TRANSACTION 1839542886, not started MySQL thread id 192, OS thread handle 0x7fdf207b6700, query id 1673100 10.20.10.122 web cleaning up ---TRANSACTION 1839542270, not started MySQL thread id 191, OS thread handle 0x7fdf353ff700, query id 1671859 10.20.10.122 web cleaning up ---TRANSACTION 1839542240, not started MySQL thread id 190, OS thread handle 0x7fdf2b7b6700, query id 1671781 10.20.10.122 web cleaning up ---TRANSACTION 1839542928, not started MySQL thread id 189, OS thread handle 0x7fdf35ed2700, query id 1673258 10.20.10.122 web cleaning up ---TRANSACTION 1839542244, not started MySQL thread id 188, OS thread handle 0x7fdf347ff700, query id 1671797 10.20.10.122 web cleaning up ---TRANSACTION 1839542226, not started MySQL thread id 187, OS thread handle 0x7fdf2e7b6700, query id 1671739 10.20.10.122 web cleaning up ---TRANSACTION 1839542230, not started MySQL thread id 186, OS thread handle 0x7fdf30bb6700, query id 1671764 10.20.10.122 web cleaning up ---TRANSACTION 1839542225, not started MySQL thread id 185, OS thread handle 0x7fdf253ff700, query id 1671730 10.20.10.122 web cleaning up ---TRANSACTION 1839542227, not started MySQL thread id 184, OS thread handle 0x7fdf2cfff700, query id 1671748 10.20.10.122 web cleaning up ---TRANSACTION 1839542221, not started MySQL thread id 183, OS thread handle 0x7fdf361f5700, query id 1671709 10.20.10.122 web cleaning up ---TRANSACTION 1839542219, not started MySQL thread id 182, OS thread handle 0x7fdf36287700, query id 1671691 10.20.10.122 web cleaning up ---TRANSACTION 1839542222, not started MySQL thread id 181, OS thread handle 0x7fdf36319700, query id 1671718 10.20.10.122 web cleaning up ---TRANSACTION 1839542256, not started MySQL thread id 180, OS thread handle 0x7fdf1d292700, query id 1671822 10.20.10.122 web cleaning up ---TRANSACTION 1839542217, not started MySQL thread id 179, OS thread handle 0x7fdf360d1700, query id 1671673 10.20.10.122 web cleaning up ---TRANSACTION 1839542216, not started MySQL thread id 178, OS thread handle 0x7fdf36518700, query id 1671664 10.20.10.122 web cleaning up ---TRANSACTION 1839542215, not started MySQL thread id 177, OS thread handle 0x7fdf32fff700, query id 1671655 10.20.10.122 web cleaning up ---TRANSACTION 1839542211, not started MySQL thread id 176, OS thread handle 0x7fdf317ff700, query id 1671619 10.20.10.122 web cleaning up ---TRANSACTION 1839542214, not started MySQL thread id 175, OS thread handle 0x7fdf1d2db700, query id 1671646 10.20.10.122 web cleaning up ---TRANSACTION 1839542210, not started MySQL thread id 174, OS thread handle 0x7fdf323b6700, query id 1671610 10.20.10.122 web cleaning up ---TRANSACTION 1839542213, not started MySQL thread id 173, OS thread handle 0x7fdf1fb6d700, query id 1671637 10.20.10.122 web cleaning up ---TRANSACTION 1839542085, not started MySQL thread id 172, OS thread handle 0x7fdf363ab700, query id 1671357 10.20.10.122 web cleaning up ---TRANSACTION 1839542208, not started MySQL thread id 171, OS thread handle 0x7fdf347b6700, query id 1671592 10.20.10.122 web cleaning up ---TRANSACTION 1839542076, not started MySQL thread id 170, OS thread handle 0x7fdf2076d700, query id 1671328 10.20.10.122 web cleaning up ---TRANSACTION 1839542209, not started MySQL thread id 169, OS thread handle 0x7fdf364cf700, query id 1671601 10.20.10.122 web cleaning up ---TRANSACTION 1839542063, not started MySQL thread id 168, OS thread handle 0x7fdf29bff700, query id 1671306 10.20.10.122 web cleaning up ---TRANSACTION 1839542056, not started MySQL thread id 167, OS thread handle 0x7fdf365aa700, query id 1671261 10.20.10.122 web cleaning up ---TRANSACTION 1839542044, not started MySQL thread id 166, OS thread handle 0x7fdf2b7b6700, query id 1671232 10.20.10.122 web cleaning up ---TRANSACTION 1839542212, not started MySQL thread id 165, OS thread handle 0x7fdf213ff700, query id 1671628 10.20.10.122 web cleaning up ---TRANSACTION 1839542062, not started MySQL thread id 164, OS thread handle 0x7fdf347ff700, query id 1671279 10.20.10.122 web cleaning up ---TRANSACTION 1839542041, not started MySQL thread id 163, OS thread handle 0x7fdf2e7b6700, query id 1671219 10.20.10.122 web cleaning up ---TRANSACTION 1839542040, not started MySQL thread id 162, OS thread handle 0x7fdf30bb6700, query id 1671209 10.20.10.122 web cleaning up ---TRANSACTION 1839542037, not started MySQL thread id 161, OS thread handle 0x7fdf253ff700, query id 1671187 10.20.10.122 web cleaning up ---TRANSACTION 1839542038, not started MySQL thread id 160, OS thread handle 0x7fdf361ac700, query id 1671199 10.20.10.122 web cleaning up ---TRANSACTION 1839542035, not started MySQL thread id 159, OS thread handle 0x7fdf361f5700, query id 1671169 10.20.10.122 web cleaning up ---TRANSACTION 1839542034, not started MySQL thread id 158, OS thread handle 0x7fdf36287700, query id 1671158 10.20.10.122 web cleaning up ---TRANSACTION 1839542031, not started MySQL thread id 157, OS thread handle 0x7fdf36319700, query id 1671143 10.20.10.122 web cleaning up ---TRANSACTION 1839541977, not started MySQL thread id 154, OS thread handle 0x7fdf36518700, query id 1671065 10.20.10.122 web cleaning up ---TRANSACTION 1839541882, not started MySQL thread id 153, OS thread handle 0x7fdf1b76d700, query id 1670844 10.20.10.122 web cleaning up ---TRANSACTION 1839541976, not started MySQL thread id 152, OS thread handle 0x7fdf3623e700, query id 1671033 10.20.10.122 web cleaning up ---TRANSACTION 1839541877, not started MySQL thread id 151, OS thread handle 0x7fdf366ce700, query id 1670799 10.20.10.122 web cleaning up ---TRANSACTION 1839542036, not started MySQL thread id 150, OS thread handle 0x7fdf30bff700, query id 1671178 10.20.10.122 web cleaning up ---TRANSACTION 1839541878, not started MySQL thread id 149, OS thread handle 0x7fdf32fb6700, query id 1670808 10.20.10.122 web cleaning up ---TRANSACTION 1839541881, not started MySQL thread id 148, OS thread handle 0x7fdf363ab700, query id 1670835 10.20.10.122 web cleaning up ---TRANSACTION 1839541875, not started MySQL thread id 147, OS thread handle 0x7fdf1d3b6700, query id 1670781 10.20.10.122 web cleaning up ---TRANSACTION 1839541880, not started MySQL thread id 146, OS thread handle 0x7fdf2076d700, query id 1670826 10.20.10.122 web cleaning up ---TRANSACTION 1839541874, not started MySQL thread id 145, OS thread handle 0x7fdf364cf700, query id 1670772 10.20.10.122 web cleaning up ---TRANSACTION 1839541876, not started MySQL thread id 144, OS thread handle 0x7fdf29bff700, query id 1670790 10.20.10.122 web cleaning up ---TRANSACTION 1839541847, not started MySQL thread id 143, OS thread handle 0x7fdf365aa700, query id 1670734 10.20.10.122 web cleaning up ---TRANSACTION 1839541846, not started MySQL thread id 142, OS thread handle 0x7fdf2b7b6700, query id 1670701 10.20.10.122 web cleaning up ---TRANSACTION 1839541492, not started MySQL thread id 140, OS thread handle 0x7fdf347ff700, query id 1669998 10.20.10.122 web cleaning up ---TRANSACTION 1839541453, not started MySQL thread id 139, OS thread handle 0x7fdf365f3700, query id 1669918 10.20.10.122 web cleaning up ---TRANSACTION 0, not started MySQL thread id 138, OS thread handle 0x7fdf30bb6700, query id 3157063 10.20.20.60 guru cleaning up ---TRANSACTION 1839540721, not started MySQL thread id 134, OS thread handle 0x7fdf36287700, query id 1668443 10.20.10.122 web cleaning up ---TRANSACTION 1839541879, not started MySQL thread id 136, OS thread handle 0x7fdf361ac700, query id 1670817 10.20.10.122 web cleaning up ---TRANSACTION 1839541452, not started MySQL thread id 135, OS thread handle 0x7fdf361f5700, query id 1669909 10.20.10.122 web cleaning up ---TRANSACTION 1839540499, not started MySQL thread id 133, OS thread handle 0x7fdf36319700, query id 1668005 10.20.10.122 web cleaning up ---TRANSACTION 1839541407, not started MySQL thread id 132, OS thread handle 0x7fdf1d292700, query id 1669780 10.20.10.122 web cleaning up ---TRANSACTION 1839542897, not started MySQL thread id 131, OS thread handle 0x7fe547192700, query id 1673169 10.20.10.122 web cleaning up ---TRANSACTION 1839540498, not started MySQL thread id 127, OS thread handle 0x7fdf366ce700, query id 1667987 10.20.10.122 web cleaning up ---TRANSACTION 1839539854, not started MySQL thread id 126, OS thread handle 0x7fdf30bff700, query id 1666731 10.20.10.122 web cleaning up ---TRANSACTION 1839540383, not started MySQL thread id 125, OS thread handle 0x7fdf1fb6d700, query id 1667752 10.20.10.122 web cleaning up ---TRANSACTION 1839539849, not started MySQL thread id 124, OS thread handle 0x7fdf3643d700, query id 1666690 10.20.10.122 web cleaning up ---TRANSACTION 1839539684, not started MySQL thread id 123, OS thread handle 0x7fdf347b6700, query id 1666360 10.20.10.122 web cleaning up ---TRANSACTION 1840281300, not started MySQL thread id 95, OS thread handle 0x7fdf353ff700, query id 3180093 10.20.20.202 app cleaning up ---TRANSACTION 1840281266, not started MySQL thread id 94, OS thread handle 0x7fdf1fbff700, query id 3180023 10.20.20.202 app cleaning up ---TRANSACTION 1840281212, not started MySQL thread id 85, OS thread handle 0x7fdf36319700, query id 3179908 10.20.20.202 app cleaning up ---TRANSACTION 1840281232, not started MySQL thread id 92, OS thread handle 0x7fdf36486700, query id 3179945 10.20.20.202 app cleaning up ---TRANSACTION 1840281216, not started MySQL thread id 91, OS thread handle 0x7fdf365f3700, query id 3179921 10.20.20.202 app cleaning up ---TRANSACTION 1840281233, not started MySQL thread id 90, OS thread handle 0x7fdf277ff700, query id 3179953 10.20.20.202 app cleaning up ---TRANSACTION 1840281277, not started MySQL thread id 84, OS thread handle 0x7fdf1d292700, query id 3180041 10.20.20.202 app cleaning up ---TRANSACTION 1840281297, not started MySQL thread id 86, OS thread handle 0x7fdf36287700, query id 3180082 10.20.20.202 app cleaning up ---TRANSACTION 1840281220, not started MySQL thread id 88, OS thread handle 0x7fdf36088700, query id 3179932 10.20.20.202 app cleaning up ---TRANSACTION 1840281295, not started MySQL thread id 89, OS thread handle 0x7fdf253ff700, query id 3180080 10.20.20.202 app cleaning up ---TRANSACTION 1840281243, not started MySQL thread id 87, OS thread handle 0x7fdf361f5700, query id 3179977 10.20.20.202 app cleaning up ---TRANSACTION 1840281261, not started MySQL thread id 82, OS thread handle 0x7fdf2ffff700, query id 3180019 10.20.20.202 app cleaning up ---TRANSACTION 1840281290, not started MySQL thread id 83, OS thread handle 0x7fdf360d1700, query id 3180056 10.20.20.202 app cleaning up ---TRANSACTION 1840281239, not started MySQL thread id 80, OS thread handle 0x7fdf3623e700, query id 3179975 10.20.20.202 app cleaning up ---TRANSACTION 1840281278, not started MySQL thread id 81, OS thread handle 0x7fdf35d65700, query id 3180043 10.20.20.202 app cleaning up ---TRANSACTION 1840281302, not started MySQL thread id 77, OS thread handle 0x7fdf1b76d700, query id 3180095 10.20.20.202 app cleaning up ---TRANSACTION 1840281244, not started MySQL thread id 76, OS thread handle 0x7fdf363ab700, query id 3179984 10.20.20.202 app cleaning up ---TRANSACTION 1840281291, not started MySQL thread id 75, OS thread handle 0x7fdf1d3b6700, query id 3180064 10.20.20.202 app cleaning up ---TRANSACTION 1840281246, not started MySQL thread id 73, OS thread handle 0x7fdf364cf700, query id 3179986 10.20.20.202 app cleaning up ---TRANSACTION 1840281262, not started MySQL thread id 72, OS thread handle 0x7fdf29bff700, query id 3180016 10.20.20.202 app cleaning up ---TRANSACTION 1840281276, not started MySQL thread id 74, OS thread handle 0x7fdf317ff700, query id 3180033 10.20.20.202 app cleaning up ---TRANSACTION 1840273440, not started MySQL thread id 69, OS thread handle 0x7fdf213ff700, query id 3164638 10.20.10.181 app cleaning up ---TRANSACTION 1840273442, not started MySQL thread id 65, OS thread handle 0x7fdf253ff700, query id 3164641 10.20.10.181 app cleaning up ---TRANSACTION 1840276967, not started MySQL thread id 62, OS thread handle 0x7fdf36287700, query id 3171528 10.20.20.211 app cleaning up ---TRANSACTION 1840281097, not started MySQL thread id 61, OS thread handle 0x7fdf36319700, query id 3179691 10.20.20.201 app cleaning up ---TRANSACTION 1840281148, not started MySQL thread id 60, OS thread handle 0x7fdf1d292700, query id 3179796 10.20.20.201 app cleaning up ---TRANSACTION 1840281147, not started MySQL thread id 58, OS thread handle 0x7fdf36518700, query id 3179788 10.20.20.201 app cleaning up ---TRANSACTION 1840281187, not started MySQL thread id 57, OS thread handle 0x7fdf35d65700, query id 3179860 10.20.20.201 app cleaning up ---TRANSACTION 1840281119, not started MySQL thread id 56, OS thread handle 0x7fdf3623e700, query id 3179736 10.20.20.201 app cleaning up ---TRANSACTION 1840281085, not started MySQL thread id 55, OS thread handle 0x7fdf207ff700, query id 3179678 10.20.20.201 app cleaning up ---TRANSACTION 1840281292, not started MySQL thread id 54, OS thread handle 0x7fdf323b6700, query id 3180071 10.20.20.201 app cleaning up ---TRANSACTION 1840281111, not started MySQL thread id 53, OS thread handle 0x7fdf1b76d700, query id 3179716 10.20.20.201 app cleaning up ---TRANSACTION 1840281294, not started MySQL thread id 52, OS thread handle 0x7fdf3643d700, query id 3180073 10.20.20.201 app cleaning up ---TRANSACTION 1840281214, not started MySQL thread id 51, OS thread handle 0x7fdf1d3b6700, query id 3179911 10.20.20.201 app cleaning up ---TRANSACTION 1840281129, not started MySQL thread id 50, OS thread handle 0x7fdf317ff700, query id 3179761 10.20.20.201 app cleaning up ---TRANSACTION 1840281247, not started MySQL thread id 49, OS thread handle 0x7fdf364cf700, query id 3179988 10.20.20.201 app cleaning up ---TRANSACTION 1840281215, not started MySQL thread id 48, OS thread handle 0x7fdf29bff700, query id 3179916 10.20.20.201 app cleaning up ---TRANSACTION 1840281206, not started MySQL thread id 46, OS thread handle 0x7fdf1fbff700, query id 3179906 10.20.20.201 app cleaning up ---TRANSACTION 1840281186, not started MySQL thread id 45, OS thread handle 0x7fdf35ed2700, query id 3179859 10.20.20.201 app cleaning up ---TRANSACTION 1840281114, not started MySQL thread id 44, OS thread handle 0x7fdf347ff700, query id 3179730 10.20.20.201 app cleaning up ---TRANSACTION 1840281241, not started MySQL thread id 43, OS thread handle 0x7fdf2e7b6700, query id 3179972 10.20.20.201 app cleaning up ---TRANSACTION 1840281299, not started MySQL thread id 42, OS thread handle 0x7fdf30bb6700, query id 3180086 10.20.20.211 app cleaning up ---TRANSACTION 1840281236, not started MySQL thread id 41, OS thread handle 0x7fdf30bff700, query id 3179963 10.20.20.201 app cleaning up ---TRANSACTION 1840281173, not started MySQL thread id 40, OS thread handle 0x7fdf361ac700, query id 3179854 10.20.20.201 app cleaning up ---TRANSACTION 1840281259, not started MySQL thread id 39, OS thread handle 0x7fdf361f5700, query id 3180001 10.20.20.201 app cleaning up ---TRANSACTION 1840281164, not started MySQL thread id 37, OS thread handle 0x7fdf36319700, query id 3179820 10.20.20.201 app cleaning up ---TRANSACTION 1840281108, not started MySQL thread id 36, OS thread handle 0x7fdf1d292700, query id 3179712 10.20.20.201 app cleaning up ---TRANSACTION 1840281127, not started MySQL thread id 35, OS thread handle 0x7fe547192700, query id 3179759 10.20.20.201 app cleaning up ---TRANSACTION 1840281170, not started MySQL thread id 34, OS thread handle 0x7fdf36518700, query id 3179834 10.20.20.201 app cleaning up ---TRANSACTION 1840281171, not started MySQL thread id 33, OS thread handle 0x7fdf35d65700, query id 3179836 10.20.20.201 app cleaning up ---TRANSACTION 1840281098, not started MySQL thread id 32, OS thread handle 0x7fdf35ff6700, query id 3179699 10.20.20.201 app cleaning up ---TRANSACTION 1840281166, not started MySQL thread id 31, OS thread handle 0x7fdf207ff700, query id 3179825 10.20.20.201 app cleaning up ---TRANSACTION 1840281165, not started MySQL thread id 30, OS thread handle 0x7fdf323b6700, query id 3179823 10.20.20.201 app cleaning up ---TRANSACTION 1840281235, not started MySQL thread id 29, OS thread handle 0x7fdf1b76d700, query id 3179957 10.20.20.201 app cleaning up ---TRANSACTION 1840281199, not started MySQL thread id 28, OS thread handle 0x7fdf363ab700, query id 3179891 10.20.20.201 app cleaning up ---TRANSACTION 1840281219, not started MySQL thread id 27, OS thread handle 0x7fdf1d3b6700, query id 3179930 10.20.20.201 app cleaning up ---TRANSACTION 1840281188, not started MySQL thread id 24, OS thread handle 0x7fdf207b6700, query id 3179868 10.20.20.201 app cleaning up ---TRANSACTION 1840281240, not started MySQL thread id 23, OS thread handle 0x7fdf353ff700, query id 3179970 10.20.20.201 app cleaning up ---TRANSACTION 1840281217, not started MySQL thread id 22, OS thread handle 0x7fdf323ff700, query id 3179928 10.20.20.201 app cleaning up ---TRANSACTION 1840281260, not started MySQL thread id 21, OS thread handle 0x7fdf35ed2700, query id 3180009 10.20.20.201 app cleaning up ---TRANSACTION 1840281135, not started MySQL thread id 19, OS thread handle 0x7fdf365f3700, query id 3179775 10.20.20.201 app cleaning up ---TRANSACTION 1840281118, not started MySQL thread id 18, OS thread handle 0x7fdf30bb6700, query id 3179734 10.20.20.201 app cleaning up ---TRANSACTION 1840281234, not started MySQL thread id 17, OS thread handle 0x7fdf30bff700, query id 3179955 10.20.20.201 app cleaning up ---TRANSACTION 1840281198, not started MySQL thread id 16, OS thread handle 0x7fdf36088700, query id 3179889 10.20.20.201 app cleaning up ---TRANSACTION 1840281167, not started MySQL thread id 15, OS thread handle 0x7fdf35f64700, query id 3179831 10.20.20.201 app cleaning up ---TRANSACTION 1840281298, not started MySQL thread id 9, OS thread handle 0x7fdf35d65700, query id 3180085 10.20.20.211 app cleaning up ---TRANSACTION 1840281172, not started MySQL thread id 8, OS thread handle 0x7fdf3623e700, query id 3179839 10.20.20.201 app cleaning up ---TRANSACTION 1838725379, not started MySQL thread id 3, OS thread handle 0x7fdf371f3700, query id 0 Waiting for background binlog tasks -------- FILE I/O -------- I/O thread 0 state: waiting for completed aio requests (insert buffer thread) I/O thread 1 state: waiting for completed aio requests (log thread) I/O thread 2 state: waiting for completed aio requests (read thread) I/O thread 3 state: waiting for completed aio requests (read thread) I/O thread 4 state: waiting for completed aio requests (read thread) I/O thread 5 state: waiting for completed aio requests (read thread) I/O thread 6 state: waiting for completed aio requests (write thread) I/O thread 7 state: waiting for completed aio requests (write thread) I/O thread 8 state: waiting for completed aio requests (write thread) I/O thread 9 state: waiting for completed aio requests (write thread) Pending normal aio reads: 0 [0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0] , ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 98074 OS file reads, 643043 OS file writes, 495199 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 47.33 writes/s, 37.33 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 591, seg size 593, 10785 merges merged operations: insert 12866, delete mark 12067, delete 3588 discarded operations: insert 0, delete mark 0, delete 0 16120.98 hash searches/s, 1481.25 non-hash searches/s --- LOG --- Log sequence number 6680515295513 Log flushed up to 6680515295217 Pages flushed up to 6680416966628 Last checkpoint at 6680416930269 Max checkpoint age 865244898 Checkpoint age target 838205995 Modified age 98328885 Checkpoint age 98365244 0 pending log writes, 0 pending chkp writes 229882 log i/o's done, 12.17 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 21978152960; in additional pool allocated 0 Total memory allocated by read views 23752 Internal hash tables (constant factor + variable factor) Adaptive hash index 491125264 (339995048 + 151130216) Page hash 2657176 (buffer pool 0 only) Dictionary cache 85726975 (85000144 + 726831) File system 868360 (812272 + 56088) Lock system 53198696 (53125256 + 73440) Recovery system 0 (0 + 0) Dictionary memory allocated 726831 Buffer pool size 1310712 Buffer pool size, bytes 21474705408 Free buffers 1141135 Database pages 160353 Old database pages 59053 Modified db pages 17848 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1293, not young 0 0.17 youngs/s, 0.00 non-youngs/s Pages read 97964, created 62389, written 297723 0.00 reads/s, 4.17 creates/s, 23.66 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: 160353, unzip_LRU len: 0 I/O sum[0]:cur[24], unzip sum[0]:cur[0] ---------------------- INDIVIDUAL BUFFER POOL INFO ---------------------- ---BUFFER POOL 0 Buffer pool size 163839 Buffer pool size, bytes 2684338176 Free buffers 142712 Database pages 19980 Old database pages 7355 Modified db pages 2330 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 135, not young 0 0.17 youngs/s, 0.00 non-youngs/s Pages read 12263, created 7717, written 34710 0.00 reads/s, 4.17 creates/s, 1.67 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: 19980, unzip_LRU len: 0 I/O sum[0]:cur[3], unzip sum[0]:cur[0] ---BUFFER POOL 1 Buffer pool size 163839 Buffer pool size, bytes 2684338176 Free buffers 143175 Database pages 19505 Old database pages 7180 Modified db pages 1984 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 147, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 11872, created 7633, written 34926 0.00 reads/s, 0.00 creates/s, 1.50 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: 19505, unzip_LRU len: 0 I/O sum[0]:cur[3], unzip sum[0]:cur[0] ---BUFFER POOL 2 Buffer pool size 163839 Buffer pool size, bytes 2684338176 Free buffers 142901 Database pages 19750 Old database pages 7276 Modified db pages 2070 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 159, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 12673, created 7077, written 38340 0.00 reads/s, 0.00 creates/s, 2.83 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: 19750, unzip_LRU len: 0 I/O sum[0]:cur[3], unzip sum[0]:cur[0] ---BUFFER POOL 3 Buffer pool size 163839 Buffer pool size, bytes 2684338176 Free buffers 142002 Database pages 20718 Old database pages 7633 Modified db pages 2221 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 146, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 12033, created 8685, written 35898 0.00 reads/s, 0.00 creates/s, 2.33 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: 20718, unzip_LRU len: 0 I/O sum[0]:cur[3], unzip sum[0]:cur[0] ---BUFFER POOL 4 Buffer pool size 163839 Buffer pool size, bytes 2684338176 Free buffers 142144 Database pages 20572 Old database pages 7583 Modified db pages 2155 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 145, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 12170, created 8402, written 39515 0.00 reads/s, 0.00 creates/s, 2.17 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: 20572, unzip_LRU len: 0 I/O sum[0]:cur[3], unzip sum[0]:cur[0] ---BUFFER POOL 5 Buffer pool size 163839 Buffer pool size, bytes 2684338176 Free buffers 142871 Database pages 19780 Old database pages 7283 Modified db pages 2228 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 201, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 12147, created 7633, written 38122 0.00 reads/s, 0.00 creates/s, 2.67 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: 19780, unzip_LRU len: 0 I/O sum[0]:cur[3], unzip sum[0]:cur[0] ---BUFFER POOL 6 Buffer pool size 163839 Buffer pool size, bytes 2684338176 Free buffers 142823 Database pages 19856 Old database pages 7310 Modified db pages 2478 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 160, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 12079, created 7777, written 37358 0.00 reads/s, 0.00 creates/s, 3.33 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: 19856, unzip_LRU len: 0 I/O sum[0]:cur[3], unzip sum[0]:cur[0] ---BUFFER POOL 7 Buffer pool size 163839 Buffer pool size, bytes 2684338176 Free buffers 142507 Database pages 20192 Old database pages 7433 Modified db pages 2382 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 200, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 12727, created 7465, written 38854 0.00 reads/s, 0.00 creates/s, 7.17 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: 20192, unzip_LRU len: 0 I/O sum[0]:cur[3], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 0 read views open inside InnoDB 0 RW transactions active inside InnoDB 0 RO transactions active inside InnoDB 0 out of 1000 descriptors used Main thread process no. 29777, id 140596752656128, state: sleeping Number of rows inserted 8153063, updated 190796, deleted 110651, read 568295674 548.58 inserts/s, 7.33 updates/s, 0.00 deletes/s, 31358.44 reads/s ------------ TRANSACTIONS ------------ Trx id counter 1840281303 Purge done for trx's n:o < 1840281302 undo n:o < 0 state: running but idle History list length 2009 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0, not started MySQL thread id 541, OS thread handle 0x7fdf36319700, query id 3180096 localhost guru init SHOW ENGINE INNODB STATUS ---TRANSACTION 1840272689, not started MySQL thread id 543, OS thread handle 0x7fdf361f5700, query id 3163168 10.20.10.181 app cleaning up ---TRANSACTION 1840272688, not started MySQL thread id 544, OS thread handle 0x7fdf36088700, query id 3163165 10.20.10.181 app cleaning up ---TRANSACTION 1840271597, not started MySQL thread id 542, OS thread handle 0x7fdf36287700, query id 3160939 10.20.10.181 app cleaning up ---TRANSACTION 1840271859, not started MySQL thread id 540, OS thread handle 0x7fdf1d292700, query id 3161477 10.20.10.121 web cleaning up ---TRANSACTION 1840271866, not started MySQL thread id 538, OS thread handle 0x7fdf36518700, query id 3161540 10.20.10.121 web cleaning up ---TRANSACTION 1840251612, not started MySQL thread id 537, OS thread handle 0x7fdf35d65700, query id 3120848 10.20.10.121 web cleaning up ---TRANSACTION 1840263720, not started MySQL thread id 536, OS thread handle 0x7fdf3623e700, query id 3144944 10.20.10.122 app cleaning up ---TRANSACTION 1840268139, not started MySQL thread id 535, OS thread handle 0x7fdf207ff700, query id 3153586 10.20.10.122 web cleaning up ---TRANSACTION 1840268149, not started MySQL thread id 533, OS thread handle 0x7fdf1d3ff700, query id 3153658 10.20.10.122 web cleaning up ---TRANSACTION 1840243827, not started MySQL thread id 532, OS thread handle 0x7fdf363ab700, query id 3105289 10.20.10.121 web cleaning up ---TRANSACTION 1840279909, not started MySQL thread id 530, OS thread handle 0x7fdf317ff700, query id 3177334 10.20.10.121 app cleaning up ---TRANSACTION 1840275906, not started MySQL thread id 528, OS thread handle 0x7fdf207b6700, query id 3169465 10.20.10.182 app cleaning up ---TRANSACTION 1840256088, not started MySQL thread id 527, OS thread handle 0x7fdf365aa700, query id 3129970 10.20.10.121 app cleaning up ---TRANSACTION 1840279616, not started MySQL thread id 507, OS thread handle 0x7fdf1d3b6700, query id 3176771 10.20.10.122 web cleaning up ---TRANSACTION 1840275595, not started MySQL thread id 503, OS thread handle 0x7fdf365aa700, query id 3168851 10.20.10.182 app cleaning up ---TRANSACTION 1840272690, not started MySQL thread id 494, OS thread handle 0x7fdf36287700, query id 3163170 10.20.10.181 app cleaning up ---TRANSACTION 1840280825, not started MySQL thread id 488, OS thread handle 0x7fdf35ff6700, query id 3179149 10.20.10.121 web cleaning up ---TRANSACTION 1840280990, not started MySQL thread id 480, OS thread handle 0x7fdf29bff700, query id 3179478 10.20.10.121 web cleaning up ---TRANSACTION 1840280187, not started MySQL thread id 474, OS thread handle 0x7fdf30bb6700, query id 3177872 10.20.10.182 app cleaning up ---TRANSACTION 1840279622, not started MySQL thread id 475, OS thread handle 0x7fdf2e7b6700, query id 3176785 10.20.10.182 app cleaning up ---TRANSACTION 1840275905, not started MySQL thread id 477, OS thread handle 0x7fdf213ff700, query id 3169459 10.20.10.182 app cleaning up ---TRANSACTION 1840279620, not started MySQL thread id 476, OS thread handle 0x7fdf347ff700, query id 3176782 10.20.10.182 app cleaning up ---TRANSACTION 1840280188, not started MySQL thread id 473, OS thread handle 0x7fdf253ff700, query id 3177878 10.20.10.182 app cleaning up ---TRANSACTION 1840272679, not started MySQL thread id 470, OS thread handle 0x7fdf36287700, query id 3163140 10.20.10.181 app cleaning up ---TRANSACTION 1840280992, not started MySQL thread id 382, OS thread handle 0x7fdf323ff700, query id 3179493 10.20.10.121 web cleaning up ---TRANSACTION 1840278100, not started MySQL thread id 381, OS thread handle 0x7fdf35ed2700, query id 3173767 10.20.10.121 web cleaning up ---TRANSACTION 1839533849, not started MySQL thread id 364, OS thread handle 0x7fdf363ab700, query id 1654595 10.20.10.122 app cleaning up ---TRANSACTION 1840267475, not started MySQL thread id 334, OS thread handle 0x7fdf323ff700, query id 3152272 10.20.20.211 app cleaning up ---TRANSACTION 1840261100, not started MySQL thread id 337, OS thread handle 0x7fdf364cf700, query id 3139800 10.20.20.211 app cleaning up ---TRANSACTION 1840275059, not started MySQL thread id 333, OS thread handle 0x7fdf35ed2700, query id 3167806 10.20.20.211 app cleaning up ---TRANSACTION 1840273933, not started MySQL thread id 330, OS thread handle 0x7fdf277ff700, query id 3165582 10.20.20.211 app cleaning up ---TRANSACTION 1839542050, not started MySQL thread id 294, OS thread handle 0x7fdf30bff700, query id 1671244 10.20.10.122 web cleaning up ---TRANSACTION 1839539675, not started MySQL thread id 231, OS thread handle 0x7fdf35f64700, query id 1666309 10.20.10.122 web cleaning up ---TRANSACTION 1839543078, not started MySQL thread id 208, OS thread handle 0x7fdf2cfff700, query id 1673553 10.20.10.122 web cleaning up ---TRANSACTION 1839542220, not started MySQL thread id 119, OS thread handle 0x7fdf353ff700, query id 1671700 10.20.10.122 web cleaning up ---TRANSACTION 1839542218, not started MySQL thread id 118, OS thread handle 0x7fdf2b7b6700, query id 1671682 10.20.10.122 web cleaning up ---TRANSACTION 1839542894, not started MySQL thread id 234, OS thread handle 0x7fdf277ff700, query id 1673161 10.20.10.122 web cleaning up ---TRANSACTION 1839541493, not started MySQL thread id 141, OS thread handle 0x7fdf213ff700, query id 1670007 10.20.10.122 web cleaning up ---TRANSACTION 1839540720, not started MySQL thread id 128, OS thread handle 0x7fdf317ff700, query id 1668434 10.20.10.122 web cleaning up ---TRANSACTION 1839539680, not started MySQL thread id 122, OS thread handle 0x7fdf2076d700, query id 1666335 10.20.10.122 web cleaning up ---TRANSACTION 1839539668, not started MySQL thread id 121, OS thread handle 0x7fdf364cf700, query id 1666293 10.20.10.122 web cleaning up ---TRANSACTION 1839539681, not started MySQL thread id 117, OS thread handle 0x7fdf213ff700, query id 1666344 10.20.10.122 web cleaning up ---TRANSACTION 1839540384, not started MySQL thread id 227, OS thread handle 0x7fdf360d1700, query id 1667761 10.20.10.122 web cleaning up ---TRANSACTION 1839539661, not started MySQL thread id 224, OS thread handle 0x7fdf317ff700, query id 1666267 10.20.10.122 web cleaning up ---TRANSACTION 1839539679, not started MySQL thread id 221, OS thread handle 0x7fdf32fb6700, query id 1666326 10.20.10.122 web cleaning up ---TRANSACTION 1839539621, not started MySQL thread id 220, OS thread handle 0x7fdf3643d700, query id 1666172 10.20.10.122 web cleaning up ---TRANSACTION 1839538602, not started MySQL thread id 219, OS thread handle 0x7fdf1d3b6700, query id 1664229 10.20.10.122 web cleaning up ---TRANSACTION 1839538601, not started MySQL thread id 218, OS thread handle 0x7fdf2076d700, query id 1664169 10.20.10.122 web cleaning up ---TRANSACTION 1839538414, not started MySQL thread id 217, OS thread handle 0x7fdf364cf700, query id 1663810 10.20.10.122 web cleaning up ---TRANSACTION 1839538413, not started MySQL thread id 216, OS thread handle 0x7fdf29bff700, query id 1663801 10.20.10.122 web cleaning up ---TRANSACTION 1839539620, not started MySQL thread id 215, OS thread handle 0x7fdf365aa700, query id 1666163 10.20.10.122 web cleaning up ---TRANSACTION 1839539663, not started MySQL thread id 214, OS thread handle 0x7fdf1fbff700, query id 1666280 10.20.10.122 web cleaning up ---TRANSACTION 1839543311, not started MySQL thread id 213, OS thread handle 0x7fdf213ff700, query id 1674037 10.20.10.122 web cleaning up ---TRANSACTION 1839543142, not started MySQL thread id 212, OS thread handle 0x7fdf347ff700, query id 1673683 10.20.10.122 web cleaning up ---TRANSACTION 1839543310, not started MySQL thread id 211, OS thread handle 0x7fdf365f3700, query id 1674021 10.20.10.122 web cleaning up ---TRANSACTION 1839543141, not started MySQL thread id 210, OS thread handle 0x7fdf277ff700, query id 1673670 10.20.10.122 web cleaning up ---TRANSACTION 1839543077, not started MySQL thread id 209, OS thread handle 0x7fdf253ff700, query id 1673544 10.20.10.122 web cleaning up ---TRANSACTION 1839538412, not started MySQL thread id 207, OS thread handle 0x7fdf361f5700, query id 1663792 10.20.10.122 web cleaning up ---TRANSACTION 1839542892, not started MySQL thread id 206, OS thread handle 0x7fdf36287700, query id 1673156 10.20.10.122 web cleaning up ---TRANSACTION 1839539660, not started MySQL thread id 205, OS thread handle 0x7fdf36319700, query id 1666258 10.20.10.122 web cleaning up ---TRANSACTION 1839542927, not started MySQL thread id 204, OS thread handle 0x7fdf1d292700, query id 1673240 10.20.10.122 web cleaning up ---TRANSACTION 1839542891, not started MySQL thread id 203, OS thread handle 0x7fe547192700, query id 1673145 10.20.10.122 web cleaning up ---TRANSACTION 1839542898, not started MySQL thread id 202, OS thread handle 0x7fdf1d324700, query id 1673178 10.20.10.122 web cleaning up ---TRANSACTION 1839542888, not started MySQL thread id 201, OS thread handle 0x7fdf32fff700, query id 1673118 10.20.10.122 web cleaning up ---TRANSACTION 1839542890, not started MySQL thread id 200, OS thread handle 0x7fdf3623e700, query id 1673136 10.20.10.122 web cleaning up ---TRANSACTION 1839542885, not started MySQL thread id 199, OS thread handle 0x7fdf366ce700, query id 1673091 10.20.10.122 web cleaning up ---TRANSACTION 1839542889, not started MySQL thread id 198, OS thread handle 0x7fdf323b6700, query id 1673127 10.20.10.122 web cleaning up ---TRANSACTION 1839542887, not started MySQL thread id 197, OS thread handle 0x7fdf32fb6700, query id 1673109 10.20.10.122 web cleaning up ---TRANSACTION 1839542884, not started MySQL thread id 196, OS thread handle 0x7fdf3643d700, query id 1673082 10.20.10.122 web cleaning up ---TRANSACTION 1839542282, not started MySQL thread id 195, OS thread handle 0x7fdf347b6700, query id 1671898 10.20.10.122 web cleaning up ---TRANSACTION 1839542283, not started MySQL thread id 194, OS thread handle 0x7fdf2076d700, query id 1671921 10.20.10.122 web cleaning up ---TRANSACTION 1839542260, not started MySQL thread id 193, OS thread handle 0x7fdf364cf700, query id 1671840 10.20.10.122 web cleaning up ---TRANSACTION 1839542886, not started MySQL thread id 192, OS thread handle 0x7fdf207b6700, query id 1673100 10.20.10.122 web cleaning up ---TRANSACTION 1839542270, not started MySQL thread id 191, OS thread handle 0x7fdf353ff700, query id 1671859 10.20.10.122 web cleaning up ---TRANSACTION 1839542240, not started MySQL thread id 190, OS thread handle 0x7fdf2b7b6700, query id 1671781 10.20.10.122 web cleaning up ---TRANSACTION 1839542928, not started MySQL thread id 189, OS thread handle 0x7fdf35ed2700, query id 1673258 10.20.10.122 web cleaning up ---TRANSACTION 1839542244, not started MySQL thread id 188, OS thread handle 0x7fdf347ff700, query id 1671797 10.20.10.122 web cleaning up ---TRANSACTION 1839542226, not started MySQL thread id 187, OS thread handle 0x7fdf2e7b6700, query id 1671739 10.20.10.122 web cleaning up ---TRANSACTION 1839542230, not started MySQL thread id 186, OS thread handle 0x7fdf30bb6700, query id 1671764 10.20.10.122 web cleaning up ---TRANSACTION 1839542225, not started MySQL thread id 185, OS thread handle 0x7fdf253ff700, query id 1671730 10.20.10.122 web cleaning up ---TRANSACTION 1839542227, not started MySQL thread id 184, OS thread handle 0x7fdf2cfff700, query id 1671748 10.20.10.122 web cleaning up ---TRANSACTION 1839542221, not started MySQL thread id 183, OS thread handle 0x7fdf361f5700, query id 1671709 10.20.10.122 web cleaning up ---TRANSACTION 1839542219, not started MySQL thread id 182, OS thread handle 0x7fdf36287700, query id 1671691 10.20.10.122 web cleaning up ---TRANSACTION 1839542222, not started MySQL thread id 181, OS thread handle 0x7fdf36319700, query id 1671718 10.20.10.122 web cleaning up ---TRANSACTION 1839542256, not started MySQL thread id 180, OS thread handle 0x7fdf1d292700, query id 1671822 10.20.10.122 web cleaning up ---TRANSACTION 1839542217, not started MySQL thread id 179, OS thread handle 0x7fdf360d1700, query id 1671673 10.20.10.122 web cleaning up ---TRANSACTION 1839542216, not started MySQL thread id 178, OS thread handle 0x7fdf36518700, query id 1671664 10.20.10.122 web cleaning up ---TRANSACTION 1839542215, not started MySQL thread id 177, OS thread handle 0x7fdf32fff700, query id 1671655 10.20.10.122 web cleaning up ---TRANSACTION 1839542211, not started MySQL thread id 176, OS thread handle 0x7fdf317ff700, query id 1671619 10.20.10.122 web cleaning up ---TRANSACTION 1839542214, not started MySQL thread id 175, OS thread handle 0x7fdf1d2db700, query id 1671646 10.20.10.122 web cleaning up ---TRANSACTION 1839542210, not started MySQL thread id 174, OS thread handle 0x7fdf323b6700, query id 1671610 10.20.10.122 web cleaning up ---TRANSACTION 1839542213, not started MySQL thread id 173, OS thread handle 0x7fdf1fb6d700, query id 1671637 10.20.10.122 web cleaning up ---TRANSACTION 1839542085, not started MySQL thread id 172, OS thread handle 0x7fdf363ab700, query id 1671357 10.20.10.122 web cleaning up ---TRANSACTION 1839542208, not started MySQL thread id 171, OS thread handle 0x7fdf347b6700, query id 1671592 10.20.10.122 web cleaning up ---TRANSACTION 1839542076, not started MySQL thread id 170, OS thread handle 0x7fdf2076d700, query id 1671328 10.20.10.122 web cleaning up ---TRANSACTION 1839542209, not started MySQL thread id 169, OS thread handle 0x7fdf364cf700, query id 1671601 10.20.10.122 web cleaning up ---TRANSACTION 1839542063, not started MySQL thread id 168, OS thread handle 0x7fdf29bff700, query id 1671306 10.20.10.122 web cleaning up ---TRANSACTION 1839542056, not started MySQL thread id 167, OS thread handle 0x7fdf365aa700, query id 1671261 10.20.10.122 web cleaning up ---TRANSACTION 1839542044, not started MySQL thread id 166, OS thread handle 0x7fdf2b7b6700, query id 1671232 10.20.10.122 web cleaning up ---TRANSACTION 1839542212, not started MySQL thread id 165, OS thread handle 0x7fdf213ff700, query id 1671628 10.20.10.122 web cleaning up ---TRANSACTION 1839542062, not started MySQL thread id 164, OS thread handle 0x7fdf347ff700, query id 1671279 10.20.10.122 web cleaning up ---TRANSACTION 1839542041, not started MySQL thread id 163, OS thread handle 0x7fdf2e7b6700, query id 1671219 10.20.10.122 web cleaning up ---TRANSACTION 1839542040, not started MySQL thread id 162, OS thread handle 0x7fdf30bb6700, query id 1671209 10.20.10.122 web cleaning up ---TRANSACTION 1839542037, not started MySQL thread id 161, OS thread handle 0x7fdf253ff700, query id 1671187 10.20.10.122 web cleaning up ---TRANSACTION 1839542038, not started MySQL thread id 160, OS thread handle 0x7fdf361ac700, query id 1671199 10.20.10.122 web cleaning up ---TRANSACTION 1839542035, not started MySQL thread id 159, OS thread handle 0x7fdf361f5700, query id 1671169 10.20.10.122 web cleaning up ---TRANSACTION 1839542034, not started MySQL thread id 158, OS thread handle 0x7fdf36287700, query id 1671158 10.20.10.122 web cleaning up ---TRANSACTION 1839542031, not started MySQL thread id 157, OS thread handle 0x7fdf36319700, query id 1671143 10.20.10.122 web cleaning up ---TRANSACTION 1839541977, not started MySQL thread id 154, OS thread handle 0x7fdf36518700, query id 1671065 10.20.10.122 web cleaning up ---TRANSACTION 1839541882, not started MySQL thread id 153, OS thread handle 0x7fdf1b76d700, query id 1670844 10.20.10.122 web cleaning up ---TRANSACTION 1839541976, not started MySQL thread id 152, OS thread handle 0x7fdf3623e700, query id 1671033 10.20.10.122 web cleaning up ---TRANSACTION 1839541877, not started MySQL thread id 151, OS thread handle 0x7fdf366ce700, query id 1670799 10.20.10.122 web cleaning up ---TRANSACTION 1839542036, not started MySQL thread id 150, OS thread handle 0x7fdf30bff700, query id 1671178 10.20.10.122 web cleaning up ---TRANSACTION 1839541878, not started MySQL thread id 149, OS thread handle 0x7fdf32fb6700, query id 1670808 10.20.10.122 web cleaning up ---TRANSACTION 1839541881, not started MySQL thread id 148, OS thread handle 0x7fdf363ab700, query id 1670835 10.20.10.122 web cleaning up ---TRANSACTION 1839541875, not started MySQL thread id 147, OS thread handle 0x7fdf1d3b6700, query id 1670781 10.20.10.122 web cleaning up ---TRANSACTION 1839541880, not started MySQL thread id 146, OS thread handle 0x7fdf2076d700, query id 1670826 10.20.10.122 web cleaning up ---TRANSACTION 1839541874, not started MySQL thread id 145, OS thread handle 0x7fdf364cf700, query id 1670772 10.20.10.122 web cleaning up ---TRANSACTION 1839541876, not started MySQL thread id 144, OS thread handle 0x7fdf29bff700, query id 1670790 10.20.10.122 web cleaning up ---TRANSACTION 1839541847, not started MySQL thread id 143, OS thread handle 0x7fdf365aa700, query id 1670734 10.20.10.122 web cleaning up ---TRANSACTION 1839541846, not started MySQL thread id 142, OS thread handle 0x7fdf2b7b6700, query id 1670701 10.20.10.122 web cleaning up ---TRANSACTION 1839541492, not started MySQL thread id 140, OS thread handle 0x7fdf347ff700, query id 1669998 10.20.10.122 web cleaning up ---TRANSACTION 1839541453, not started MySQL thread id 139, OS thread handle 0x7fdf365f3700, query id 1669918 10.20.10.122 web cleaning up ---TRANSACTION 0, not started MySQL thread id 138, OS thread handle 0x7fdf30bb6700, query id 3157063 10.20.20.60 guru cleaning up ---TRANSACTION 1839540721, not started MySQL thread id 134, OS thread handle 0x7fdf36287700, query id 1668443 10.20.10.122 web cleaning up ---TRANSACTION 1839541879, not started MySQL thread id 136, OS thread handle 0x7fdf361ac700, query id 1670817 10.20.10.122 web cleaning up ---TRANSACTION 1839541452, not started MySQL thread id 135, OS thread handle 0x7fdf361f5700, query id 1669909 10.20.10.122 web cleaning up ---TRANSACTION 1839540499, not started MySQL thread id 133, OS thread handle 0x7fdf36319700, query id 1668005 10.20.10.122 web cleaning up ---TRANSACTION 1839541407, not started MySQL thread id 132, OS thread handle 0x7fdf1d292700, query id 1669780 10.20.10.122 web cleaning up ---TRANSACTION 1839542897, not started MySQL thread id 131, OS thread handle 0x7fe547192700, query id 1673169 10.20.10.122 web cleaning up ---TRANSACTION 1839540498, not started MySQL thread id 127, OS thread handle 0x7fdf366ce700, query id 1667987 10.20.10.122 web cleaning up ---TRANSACTION 1839539854, not started MySQL thread id 126, OS thread handle 0x7fdf30bff700, query id 1666731 10.20.10.122 web cleaning up ---TRANSACTION 1839540383, not started MySQL thread id 125, OS thread handle 0x7fdf1fb6d700, query id 1667752 10.20.10.122 web cleaning up ---TRANSACTION 1839539849, not started MySQL thread id 124, OS thread handle 0x7fdf3643d700, query id 1666690 10.20.10.122 web cleaning up ---TRANSACTION 1839539684, not started MySQL thread id 123, OS thread handle 0x7fdf347b6700, query id 1666360 10.20.10.122 web cleaning up ---TRANSACTION 1840281300, not started MySQL thread id 95, OS thread handle 0x7fdf353ff700, query id 3180093 10.20.20.202 app cleaning up ---TRANSACTION 1840281266, not started MySQL thread id 94, OS thread handle 0x7fdf1fbff700, query id 3180023 10.20.20.202 app cleaning up ---TRANSACTION 1840281212, not started MySQL thread id 85, OS thread handle 0x7fdf36319700, query id 3179908 10.20.20.202 app cleaning up ---TRANSACTION 1840281232, not started MySQL thread id 92, OS thread handle 0x7fdf36486700, query id 3179945 10.20.20.202 app cleaning up ---TRANSACTION 1840281216, not started MySQL thread id 91, OS thread handle 0x7fdf365f3700, query id 3179921 10.20.20.202 app cleaning up ---TRANSACTION 1840281233, not started MySQL thread id 90, OS thread handle 0x7fdf277ff700, query id 3179953 10.20.20.202 app cleaning up ---TRANSACTION 1840281277, not started MySQL thread id 84, OS thread handle 0x7fdf1d292700, query id 3180041 10.20.20.202 app cleaning up ---TRANSACTION 1840281297, not started MySQL thread id 86, OS thread handle 0x7fdf36287700, query id 3180082 10.20.20.202 app cleaning up ---TRANSACTION 1840281220, not started MySQL thread id 88, OS thread handle 0x7fdf36088700, query id 3179932 10.20.20.202 app cleaning up ---TRANSACTION 1840281295, not started MySQL thread id 89, OS thread handle 0x7fdf253ff700, query id 3180080 10.20.20.202 app cleaning up ---TRANSACTION 1840281243, not started MySQL thread id 87, OS thread handle 0x7fdf361f5700, query id 3179977 10.20.20.202 app cleaning up ---TRANSACTION 1840281261, not started MySQL thread id 82, OS thread handle 0x7fdf2ffff700, query id 3180019 10.20.20.202 app cleaning up ---TRANSACTION 1840281290, not started MySQL thread id 83, OS thread handle 0x7fdf360d1700, query id 3180056 10.20.20.202 app cleaning up ---TRANSACTION 1840281239, not started MySQL thread id 80, OS thread handle 0x7fdf3623e700, query id 3179975 10.20.20.202 app cleaning up ---TRANSACTION 1840281278, not started MySQL thread id 81, OS thread handle 0x7fdf35d65700, query id 3180043 10.20.20.202 app cleaning up ---TRANSACTION 1840281302, not started MySQL thread id 77, OS thread handle 0x7fdf1b76d700, query id 3180095 10.20.20.202 app cleaning up ---TRANSACTION 1840281244, not started MySQL thread id 76, OS thread handle 0x7fdf363ab700, query id 3179984 10.20.20.202 app cleaning up ---TRANSACTION 1840281291, not started MySQL thread id 75, OS thread handle 0x7fdf1d3b6700, query id 3180064 10.20.20.202 app cleaning up ---TRANSACTION 1840281246, not started MySQL thread id 73, OS thread handle 0x7fdf364cf700, query id 3179986 10.20.20.202 app cleaning up ---TRANSACTION 1840281262, not started MySQL thread id 72, OS thread handle 0x7fdf29bff700, query id 3180016 10.20.20.202 app cleaning up ---TRANSACTION 1840281276, not started MySQL thread id 74, OS thread handle 0x7fdf317ff700, query id 3180033 10.20.20.202 app cleaning up ---TRANSACTION 1840273440, not started MySQL thread id 69, OS thread handle 0x7fdf213ff700, query id 3164638 10.20.10.181 app cleaning up ---TRANSACTION 1840273442, not started MySQL thread id 65, OS thread handle 0x7fdf253ff700, query id 3164641 10.20.10.181 app cleaning up ---TRANSACTION 1840276967, not started MySQL thread id 62, OS thread handle 0x7fdf36287700, query id 3171528 10.20.20.211 app cleaning up ---TRANSACTION 1840281097, not started MySQL thread id 61, OS thread handle 0x7fdf36319700, query id 3179691 10.20.20.201 app cleaning up ---TRANSACTION 1840281148, not started MySQL thread id 60, OS thread handle 0x7fdf1d292700, query id 3179796 10.20.20.201 app cleaning up ---TRANSACTION 1840281147, not started MySQL thread id 58, OS thread handle 0x7fdf36518700, query id 3179788 10.20.20.201 app cleaning up ---TRANSACTION 1840281187, not started MySQL thread id 57, OS thread handle 0x7fdf35d65700, query id 3179860 10.20.20.201 app cleaning up ---TRANSACTION 1840281119, not started MySQL thread id 56, OS thread handle 0x7fdf3623e700, query id 3179736 10.20.20.201 app cleaning up ---TRANSACTION 1840281085, not started MySQL thread id 55, OS thread handle 0x7fdf207ff700, query id 3179678 10.20.20.201 app cleaning up ---TRANSACTION 1840281292, not started MySQL thread id 54, OS thread handle 0x7fdf323b6700, query id 3180071 10.20.20.201 app cleaning up ---TRANSACTION 1840281111, not started MySQL thread id 53, OS thread handle 0x7fdf1b76d700, query id 3179716 10.20.20.201 app cleaning up ---TRANSACTION 1840281294, not started MySQL thread id 52, OS thread handle 0x7fdf3643d700, query id 3180073 10.20.20.201 app cleaning up ---TRANSACTION 1840281214, not started MySQL thread id 51, OS thread handle 0x7fdf1d3b6700, query id 3179911 10.20.20.201 app cleaning up ---TRANSACTION 1840281129, not started MySQL thread id 50, OS thread handle 0x7fdf317ff700, query id 3179761 10.20.20.201 app cleaning up ---TRANSACTION 1840281247, not started MySQL thread id 49, OS thread handle 0x7fdf364cf700, query id 3179988 10.20.20.201 app cleaning up ---TRANSACTION 1840281215, not started MySQL thread id 48, OS thread handle 0x7fdf29bff700, query id 3179916 10.20.20.201 app cleaning up ---TRANSACTION 1840281206, not started MySQL thread id 46, OS thread handle 0x7fdf1fbff700, query id 3179906 10.20.20.201 app cleaning up ---TRANSACTION 1840281186, not started MySQL thread id 45, OS thread handle 0x7fdf35ed2700, query id 3179859 10.20.20.201 app cleaning up ---TRANSACTION 1840281114, not started MySQL thread id 44, OS thread handle 0x7fdf347ff700, query id 3179730 10.20.20.201 app cleaning up ---TRANSACTION 1840281241, not started MySQL thread id 43, OS thread handle 0x7fdf2e7b6700, query id 3179972 10.20.20.201 app cleaning up ---TRANSACTION 1840281299, not started MySQL thread id 42, OS thread handle 0x7fdf30bb6700, query id 3180086 10.20.20.211 app cleaning up ---TRANSACTION 1840281236, not started MySQL thread id 41, OS thread handle 0x7fdf30bff700, query id 3179963 10.20.20.201 app cleaning up ---TRANSACTION 1840281173, not started MySQL thread id 40, OS thread handle 0x7fdf361ac700, query id 3179854 10.20.20.201 app cleaning up ---TRANSACTION 1840281259, not started MySQL thread id 39, OS thread handle 0x7fdf361f5700, query id 3180001 10.20.20.201 app cleaning up ---TRANSACTION 1840281164, not started MySQL thread id 37, OS thread handle 0x7fdf36319700, query id 3179820 10.20.20.201 app cleaning up ---TRANSACTION 1840281108, not started MySQL thread id 36, OS thread handle 0x7fdf1d292700, query id 3179712 10.20.20.201 app cleaning up ---TRANSACTION 1840281127, not started MySQL thread id 35, OS thread handle 0x7fe547192700, query id 3179759 10.20.20.201 app cleaning up ---TRANSACTION 1840281170, not started MySQL thread id 34, OS thread handle 0x7fdf36518700, query id 3179834 10.20.20.201 app cleaning up ---TRANSACTION 1840281171, not started MySQL thread id 33, OS thread handle 0x7fdf35d65700, query id 3179836 10.20.20.201 app cleaning up ---TRANSACTION 1840281098, not started MySQL thread id 32, OS thread handle 0x7fdf35ff6700, query id 3179699 10.20.20.201 app cleaning up ---TRANSACTION 1840281166, not started MySQL thread id 31, OS thread handle 0x7fdf207ff700, query id 3179825 10.20.20.201 app cleaning up ---TRANSACTION 1840281165, not started MySQL thread id 30, OS thread handle 0x7fdf323b6700, query id 3179823 10.20.20.201 app cleaning up ---TRANSACTION 1840281235, not started MySQL thread id 29, OS thread handle 0x7fdf1b76d700, query id 3179957 10.20.20.201 app cleaning up ---TRANSACTION 1840281199, not started MySQL thread id 28, OS thread handle 0x7fdf363ab700, query id 3179891 10.20.20.201 app cleaning up ---TRANSACTION 1840281219, not started MySQL thread id 27, OS thread handle 0x7fdf1d3b6700, query id 3179930 10.20.20.201 app cleaning up ---TRANSACTION 1840281188, not started MySQL thread id 24, OS thread handle 0x7fdf207b6700, query id 3179868 10.20.20.201 app cleaning up ---TRANSACTION 1840281240, not started MySQL thread id 23, OS thread handle 0x7fdf353ff700, query id 3179970 10.20.20.201 app cleaning up ---TRANSACTION 1840281217, not started MySQL thread id 22, OS thread handle 0x7fdf323ff700, query id 3179928 10.20.20.201 app cleaning up ---TRANSACTION 1840281260, not started MySQL thread id 21, OS thread handle 0x7fdf35ed2700, query id 3180009 10.20.20.201 app cleaning up ---TRANSACTION 1840281135, not started MySQL thread id 19, OS thread handle 0x7fdf365f3700, query id 3179775 10.20.20.201 app cleaning up ---TRANSACTION 1840281118, not started MySQL thread id 18, OS thread handle 0x7fdf30bb6700, query id 3179734 10.20.20.201 app cleaning up ---TRANSACTION 1840281234, not started MySQL thread id 17, OS thread handle 0x7fdf30bff700, query id 3179955 10.20.20.201 app cleaning up ---TRANSACTION 1840281198, not started MySQL thread id 16, OS thread handle 0x7fdf36088700, query id 3179889 10.20.20.201 app cleaning up ---TRANSACTION 1840281167, not started MySQL thread id 15, OS thread handle 0x7fdf35f64700, query id 3179831 10.20.20.201 app cleaning up ---TRANSACTION 1840281298, not started MySQL thread id 9, OS thread handle 0x7fdf35d65700, query id 3180085 10.20.20.211 app cleaning up ---TRANSACTION 1840281172, not started MySQL thread id 8, OS thread handle 0x7fdf3623e700, query id 3179839 10.20.20.201 app cleaning up ---TRANSACTION 1838725379, not started MySQL thread id 3, OS thread handle 0x7fdf371f3700, query id 0 Waiting for background binlog tasks ---------------------------- END OF INNODB MONITOR OUTPUT ============================ 1 row in set (0.00 sec) MariaDB [(none)]> notee