[ase@ase-compute-1 ticketSkySql]$ ./run_20_instances.sh Start 1 192.168.1.102 Start 2 192.168.1.102 Start 3 192.168.1.102 Start 4 192.168.1.102 Start 5 192.168.1.102 Start 6 192.168.1.102 Start 7 192.168.1.102 Start 8 192.168.1.102 Start 9 192.168.1.102 Start 10 192.168.1.102 Start 11 192.168.1.101 Start 12 192.168.1.101 Start 13 192.168.1.101 Start 14 192.168.1.101 Start 15 192.168.1.101 Start 16 192.168.1.101 Start 17 192.168.1.101 Start 18 192.168.1.101 Start 19 192.168.1.101 Start 20 192.168.1.101 ERROR 1062 (23000) at line 1: Duplicate entry '1-2015-10-06 00:13:09' for key 'PRIMARY' Stop 20 192.168.1.101 ERROR 1062 (23000) at line 1: Duplicate entry '1-2015-10-06 00:13:09' for key 'PRIMARY' Stop 19 192.168.1.101 ERROR 1062 (23000) at line 1: Duplicate entry '1-2015-10-06 00:13:09' for key 'PRIMARY' Stop 16 192.168.1.101 ERROR 1062 (23000) at line 1: Duplicate entry '1-2015-10-06 00:13:09' for key 'PRIMARY' ERROR 1062 (23000) at line 1: Duplicate entry '1-2015-10-06 00:13:09' for key 'PRIMARY' Stop 4 192.168.1.102 Stop 15 192.168.1.101 ERROR 1062 (23000) at line 1: Duplicate entry '1-2015-10-06 00:13:09' for key 'PRIMARY' Stop 14 192.168.1.101 ERROR 1062 (23000) at line 1: Duplicate entry '1-2015-10-06 00:13:09' for key 'PRIMARY' Stop 10 192.168.1.102 ERROR 1062 (23000) at line 1: Duplicate entry '1-2015-10-06 00:13:09' for key 'PRIMARY' Stop 9 192.168.1.102 ERROR 1062 (23000) at line 1: Duplicate entry '1-2015-10-06 00:13:09' for key 'PRIMARY' ERROR 1062 (23000) at line 1: Duplicate entry '1-2015-10-06 00:13:09' for key 'PRIMARY' Stop 6 192.168.1.102 ERROR 1062 (23000) at line 1: Duplicate entry '1-2015-10-06 00:13:09' for key 'PRIMARY' ERROR 1062 (23000) at line 1: Duplicate entry '1-2015-10-06 00:13:09' for key 'PRIMARY' Stop 11 192.168.1.101 Stop 2 192.168.1.102 Stop 8 192.168.1.102 ERROR 1062 (23000) at line 1: Duplicate entry '1-2015-10-06 00:13:09' for key 'PRIMARY' Stop 5 192.168.1.102 MariaDB [(none)]> select * from ticket_db.ym_events where creation_time='2015-10-06 00:13:09'; +---------------------+----------+-------+-----------+----------+---------------------+----------+---------+---------+---------+---------+-------------+-------------------------------+--------+---------+---------+ | creation_time | event_id | link | category | type | start_time | duration | size | node_id | user_id | task_id | database_id | command | status | summary | comment | +---------------------+----------+-------+-----------+----------+---------------------+----------+---------+---------+---------+---------+-------------+-------------------------------+--------+---------+---------+ | 2015-10-06 00:13:09 | 1 | NULL | EXECUTION | DATAPUMP | 2015-10-06 00:13:09 | 0 | 4516786 | 3 | NULL | 4 | 2 | Spider-ase-compute-2-1039-221 | START | Start | | | 2015-10-06 00:13:09 | 49222 | 49189 | EXECUTION | DATAPUMP | 2015-10-06 00:13:07 | 2 | 4516786 | 3 | NULL | 4 | 2 | Spider-ase-compute-2-1044-206 | PASS | End | | | 2015-10-06 00:13:09 | 49223 | 49196 | EXECUTION | DATAPUMP | 2015-10-06 00:13:08 | 1 | 4516786 | 3 | NULL | 4 | 2 | Spider-ase-compute-2-1047-206 | PASS | End | | | 2015-10-06 00:13:09 | 49224 | 49200 | EXECUTION | DATAPUMP | 2015-10-06 00:13:08 | 1 | 4516786 | 3 | NULL | 4 | 2 | Spider-ase-compute-2-1045-203 | PASS | End | | | 2015-10-06 00:13:09 | 49225 | 49215 | EXECUTION | DATAPUMP | 2015-10-06 00:13:08 | 1 | 4516786 | 3 | NULL | 4 | 2 | Spider-ase-compute-1-1034-184 | PASS | End | | | 2015-10-06 00:13:09 | 49226 | 49218 | EXECUTION | DATAPUMP | 2015-10-06 00:13:08 | 1 | 4516786 | 3 | NULL | 4 | 2 | Spider-ase-compute-1-1035-186 | PASS | End | | | 2015-10-06 00:13:09 | 49227 | NULL | EXECUTION | DATAPUMP | 2015-10-06 00:13:09 | 0 | 4516786 | 3 | NULL | 4 | 2 | Spider-ase-compute-1-1029-203 | START | Start | | +---------------------+----------+-------+-----------+----------+---------------------+----------+---------+---------+---------+---------+-------------+-------------------------------+--------+---------+---------+ 7 rows in set (0.11 sec) MariaDB [ticket_db]> show 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 | 128 | | basedir | /usr | | big_tables | OFF | | binlog_annotate_row_events | OFF | | binlog_cache_size | 1048576 | | binlog_checksum | NONE | | binlog_commit_wait_count | 0 | | binlog_commit_wait_usec | 100000 | | binlog_direct_non_transactional_updates | OFF | | binlog_format | STATEMENT | | binlog_optimize_thread_scheduling | ON | | binlog_stmt_cache_size | 32768 | | bulk_insert_buffer_size | 67108864 | | character_set_client | utf8 | | character_set_connection | utf8 | | character_set_database | latin1 | | character_set_filesystem | binary | | character_set_results | utf8 | | character_set_server | latin1 | | character_set_system | utf8 | | character_sets_dir | /usr/share/mysql/charsets/ | | collation_connection | utf8_general_ci | | collation_database | latin1_swedish_ci | | collation_server | latin1_swedish_ci | | completion_type | NO_CHAIN | | concurrent_insert | AUTO | | connect_timeout | 10 | | datadir | /var/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_master_connection | | | 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 | | error_count | 0 | | event_scheduler | ON | | expensive_subquery_limit | 100 | | expire_logs_days | 0 | | external_user | | | 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 | /var/log/mysql/query.log | | group_concat_max_len | 1024 | | gtid_binlog_pos | | | gtid_binlog_state | | | gtid_current_pos | | | gtid_domain_id | 0 | | gtid_ignore_duplicates | OFF | | gtid_seq_no | 0 | | 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 | ase-head | | identity | 0 | | ignore_builtin_innodb | OFF | | ignore_db_dirs | | | in_transaction | 0 | | init_connect | | | init_file | | | init_slave | | | innodb_adaptive_flushing | ON | | innodb_adaptive_flushing_lwm | 10.000000 | | innodb_adaptive_hash_index | ON | | innodb_adaptive_hash_index_partitions | 1 | | innodb_adaptive_max_sleep_delay | 150000 | | innodb_additional_mem_pool_size | 8388608 | | 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 | 1 | | innodb_buffer_pool_dump_at_shutdown | OFF | | innodb_buffer_pool_dump_now | OFF | | innodb_buffer_pool_filename | ib_buffer_pool | | innodb_buffer_pool_instances | 1 | | 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 | 268435456 | | 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:10M:autoextend | | innodb_data_home_dir | | | innodb_disable_sort_file_cache | 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 | 2 | | 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 | 300 | | innodb_io_capacity_max | 2000 | | innodb_kill_idle_transaction | 0 | | innodb_large_prefix | OFF | | innodb_lock_wait_timeout | 120 | | 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 | 8388608 | | innodb_log_checksum_algorithm | innodb | | innodb_log_compressed_pages | ON | | innodb_log_file_size | 268435456 | | 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 | 60.000000 | | innodb_max_dirty_pages_pct_lwm | 0.001000 | | 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 | 1000 | | 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 | 8 | | 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_modified_counter | 0 | | innodb_stats_on_metadata | OFF | | innodb_stats_persistent | ON | | innodb_stats_persistent_sample_pages | 20 | | innodb_stats_sample_pages | 8 | | innodb_stats_traditional | ON | | 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 | 8 | | innodb_thread_sleep_delay | 10000 | | 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.23-72.1 | | innodb_write_io_threads | 4 | | insert_id | 0 | | interactive_timeout | 28800 | | join_buffer_size | 100663296 | | join_buffer_space_limit | 100663296 | | join_cache_level | 6 | | keep_files_on_create | OFF | | key_buffer_size | 134217728 | | 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 | | last_gtid | | | last_insert_id | 0 | | lc_messages | en_US | | lc_messages_dir | | | lc_time_names | en_US | | license | GPL | | local_infile | ON | | lock_wait_timeout | 31536000 | | locked_in_memory | OFF | | log_bin | OFF | | log_bin_trust_function_creators | OFF | | log_error | /var/lib/mysql/ase-head.err | | log_output | FILE | | log_queries_not_using_indexes | OFF | | log_slave_updates | OFF | | 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 | 2 | | long_query_time | 20.000000 | | low_priority_updates | OFF | | lower_case_file_system | OFF | | lower_case_table_names | 0 | | master_verify_checksum | OFF | | max_allowed_packet | 1048576 | | max_binlog_cache_size | 18446744073709547520 | | max_binlog_size | 1073741824 | | max_binlog_stmt_cache_size | 18446744073709547520 | | max_connect_errors | 10 | | max_connections | 1000 | | max_delayed_threads | 20 | | max_digest_length | 1024 | | max_error_count | 64 | | max_heap_table_size | 100663296 | | max_insert_delayed_threads | 20 | | max_join_size | 18446744073709551615 | | max_length_for_sort_data | 1024 | | max_long_data_size | 1048576 | | 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 | 100663296 | | multi_range_count | 256 | | myisam_block_size | 1024 | | myisam_data_pointer_size | 6 | | myisam_max_sort_file_size | 10737418240 | | myisam_mmap_size | 18446744073709551615 | | myisam_recover_options | BACKUP,FORCE | | myisam_repair_threads | 1 | | myisam_sort_buffer_size | 134217728 | | 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 | 11011 | | 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=on,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=off,loosescan=off,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=off,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=off,semijoin_with_cache=off,join_cache_incremental=off,join_cache_hashed=off,join_cache_bka=off,optimize_join_buffer_size=on,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 | /var/lib/mysql/ase-head.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 | 0 | | protocol_version | 10 | | proxy_user | | | pseudo_slave_mode | OFF | | pseudo_thread_id | 29 | | 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 | | rand_seed1 | 0 | | rand_seed2 | 0 | | range_alloc_block_size | 4096 | | read_buffer_size | 262144 | | 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 | 100 | | skip_external_locking | ON | | skip_name_resolve | ON | | skip_networking | OFF | | skip_replication | 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 | /var/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 | ON | | slow_query_log_file | ase-head-slow.log | | socket | /var/lib/mysql/mysql.sock | | sort_buffer_size | 1048576 | | spider_auto_increment_mode | -1 | | spider_bgs_first_read | -1 | | spider_bgs_mode | -1 | | spider_bgs_second_read | -1 | | spider_bka_engine | | | spider_bka_mode | -1 | | spider_bka_table_name_type | -1 | | spider_block_size | 104857600 | | spider_bulk_size | 13631488 | | spider_bulk_update_mode | -1 | | spider_bulk_update_size | -1 | | spider_casual_read | -1 | | spider_conn_recycle_mode | 0 | | spider_conn_recycle_strict | 0 | | spider_connect_mutex | OFF | | spider_connect_retry_count | 1000 | | spider_connect_retry_interval | 1000 | | spider_connect_timeout | -1 | | spider_crd_bg_mode | 0 | | spider_crd_interval | -1 | | spider_crd_mode | -1 | | spider_crd_sync | -1 | | spider_crd_type | -1 | | spider_crd_weight | -1 | | spider_delete_all_rows_type | -1 | | spider_direct_dup_insert | 1 | | spider_direct_order_limit | -1 | | spider_dry_access | OFF | | spider_error_read_mode | -1 | | spider_error_write_mode | -1 | | spider_first_read | -1 | | spider_force_commit | 1 | | spider_general_log | OFF | | spider_init_sql_alloc_size | -1 | | spider_internal_limit | -1 | | spider_internal_offset | -1 | | spider_internal_optimize | -1 | | spider_internal_optimize_local | -1 | | spider_internal_sql_log_off | ON | | spider_internal_unlock | OFF | | spider_internal_xa | OFF | | spider_internal_xa_id_type | 0 | | spider_internal_xa_snapshot | 0 | | spider_local_lock_table | OFF | | spider_lock_exchange | OFF | | spider_log_result_error_with_sql | 0 | | spider_log_result_errors | 0 | | spider_low_mem_read | -1 | | spider_max_order | -1 | | spider_multi_split_read | -1 | | spider_net_read_timeout | -1 | | spider_net_write_timeout | -1 | | spider_ping_interval_at_trx_start | 3600 | | spider_quick_mode | -1 | | spider_quick_page_size | -1 | | spider_read_only_mode | -1 | | spider_remote_access_charset | | | spider_remote_autocommit | -1 | | spider_remote_default_database | | | spider_remote_sql_log_off | -1 | | spider_remote_time_zone | | | spider_remote_trx_isolation | -1 | | spider_reset_sql_alloc | -1 | | spider_same_server_link | OFF | | spider_second_read | -1 | | spider_select_column_mode | -1 | | spider_selupd_lock_mode | -1 | | spider_semi_split_read | -1 | | spider_semi_split_read_limit | -1 | | spider_semi_table_lock | 1 | | spider_semi_table_lock_connection | -1 | | spider_semi_trx | ON | | spider_semi_trx_isolation | -1 | | spider_skip_default_condition | -1 | | spider_split_read | -1 | | spider_sts_bg_mode | 0 | | spider_sts_interval | -1 | | spider_sts_mode | -1 | | spider_sts_sync | -1 | | spider_support_xa | ON | | spider_sync_autocommit | ON | | spider_sync_time_zone | OFF | | spider_sync_trx_isolation | ON | | spider_table_init_error_interval | 1 | | spider_udf_ct_bulk_insert_interval | -1 | | spider_udf_ct_bulk_insert_rows | -1 | | spider_udf_ds_bulk_insert_rows | -1 | | spider_udf_ds_table_loop_mode | -1 | | spider_udf_ds_use_real_table | -1 | | spider_udf_table_lock_mutex_count | 20 | | spider_udf_table_mon_mutex_count | 20 | | spider_use_all_conns_snapshot | OFF | | spider_use_consistent_snapshot | OFF | | spider_use_default_database | ON | | spider_use_flash_logs | OFF | | spider_use_handler | -1 | | spider_use_pushdown_udf | -1 | | spider_use_snapshot_with_flush_tables | 0 | | spider_use_table_charset | -1 | | spider_version | 3.2.21 | | sql_auto_is_null | OFF | | sql_big_selects | ON | | sql_buffer_result | OFF | | sql_log_bin | ON | | sql_log_off | OFF | | sql_mode | STRICT_ALL_TABLES | | 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 | 0 | | sync_frm | ON | | sync_master_info | 0 | | sync_relay_log | 0 | | sync_relay_log_info | 0 | | system_time_zone | CEST | | table_definition_cache | 400 | | table_open_cache | 5000 | | thread_cache_size | 8 | | thread_concurrency | 10 | | thread_handling | one-thread-per-connection | | thread_pool_idle_timeout | 60 | | thread_pool_max_threads | 500 | | thread_pool_oversubscribe | 3 | | thread_pool_size | 2 | | thread_pool_stall_limit | 500 | | thread_stack | 294912 | | time_format | %H:%i:%s | | time_zone | SYSTEM | | timed_mutexes | OFF | | timestamp | 1444081421.937702 | | tmp_table_size | 100663296 | | tmpdir | /var/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.19-MariaDB-log | | version_comment | MariaDB Server | | version_compile_machine | x86_64 | | version_compile_os | Linux | | version_malloc_library | bundled jemalloc | | wait_timeout | 28800 | | warning_count | 0 | +--------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 612 rows in set (0.01 sec) MariaDB [ticket_db]> select * from information_schema.engines; +--------------------+---------+----------------------------------------------------------------------------+--------------+------+------------+ | ENGINE | SUPPORT | COMMENT | TRANSACTIONS | XA | SAVEPOINTS | +--------------------+---------+----------------------------------------------------------------------------+--------------+------+------------+ | SPIDER | YES | Spider storage engine | YES | YES | NO | | MRG_MyISAM | YES | Collection of identical MyISAM tables | NO | NO | NO | | MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO | | BLACKHOLE | YES | /dev/null storage engine (anything you write to it disappears) | NO | NO | NO | | MyISAM | YES | MyISAM storage engine | NO | NO | NO | | InnoDB | DEFAULT | Percona-XtraDB, Supports transactions, row-level locking, and foreign keys | YES | YES | YES | | ARCHIVE | YES | Archive storage engine | NO | NO | NO | | FEDERATED | YES | FederatedX pluggable storage engine | YES | NO | YES | | PERFORMANCE_SCHEMA | YES | Performance Schema | NO | NO | NO | | Aria | YES | Crash-safe tables with MyISAM heritage | NO | NO | NO | | CSV | YES | CSV storage engine | NO | NO | NO | +--------------------+---------+----------------------------------------------------------------------------+--------------+------+------------+ 11 rows in set (0.00 sec) MariaDB [ticket_db]> select * from information_schema.plugins; +-----------------------------+----------------+---------------+--------------------+---------------------+----------------+------------------------+----------------------------+----------------------------------------------------------------------------+----------------+-------------+-----------------+---------------------+ | PLUGIN_NAME | PLUGIN_VERSION | PLUGIN_STATUS | PLUGIN_TYPE | PLUGIN_TYPE_VERSION | PLUGIN_LIBRARY | PLUGIN_LIBRARY_VERSION | PLUGIN_AUTHOR | PLUGIN_DESCRIPTION | PLUGIN_LICENSE | LOAD_OPTION | PLUGIN_MATURITY | PLUGIN_AUTH_VERSION | +-----------------------------+----------------+---------------+--------------------+---------------------+----------------+------------------------+----------------------------+----------------------------------------------------------------------------+----------------+-------------+-----------------+---------------------+ | binlog | 1.0 | ACTIVE | STORAGE ENGINE | 100019.0 | NULL | NULL | MySQL AB | This is a pseudo storage engine to represent the binlog in a transaction | GPL | FORCE | Stable | 1.0 | | mysql_native_password | 1.0 | ACTIVE | AUTHENTICATION | 2.0 | NULL | NULL | R.J.Silk, Sergei Golubchik | Native MySQL authentication | GPL | FORCE | Stable | 1.0 | | mysql_old_password | 1.0 | ACTIVE | AUTHENTICATION | 2.0 | NULL | NULL | R.J.Silk, Sergei Golubchik | Old MySQL-4.0 authentication | GPL | FORCE | Stable | 1.0 | | CSV | 1.0 | ACTIVE | STORAGE ENGINE | 100019.0 | NULL | NULL | Brian Aker, MySQL AB | CSV storage engine | GPL | FORCE | Stable | 1.0 | | MEMORY | 1.0 | ACTIVE | STORAGE ENGINE | 100019.0 | NULL | NULL | MySQL AB | Hash based, stored in memory, useful for temporary tables | GPL | FORCE | Stable | 1.0 | | MyISAM | 1.0 | ACTIVE | STORAGE ENGINE | 100019.0 | NULL | NULL | MySQL AB | MyISAM storage engine | GPL | FORCE | Stable | 1.0 | | MRG_MyISAM | 1.0 | ACTIVE | STORAGE ENGINE | 100019.0 | NULL | NULL | MySQL AB | Collection of identical MyISAM tables | GPL | FORCE | Stable | 1.0 | | BLACKHOLE | 1.0 | ACTIVE | STORAGE ENGINE | 100019.0 | NULL | NULL | MySQL AB | /dev/null storage engine (anything you write to it disappears) | GPL | ON | Stable | 1.0 | | InnoDB | 5.6 | ACTIVE | STORAGE ENGINE | 100019.0 | NULL | NULL | Oracle Corporation | Percona-XtraDB, Supports transactions, row-level locking, and foreign keys | GPL | ON | Stable | 5.6.23-72.1 | | XTRADB_READ_VIEW | 5.6 | ACTIVE | INFORMATION SCHEMA | 100019.0 | NULL | NULL | Percona Inc. | InnoDB Read View information | GPL | ON | Stable | 5.6.23-72.1 | | XTRADB_INTERNAL_HASH_TABLES | 5.6 | ACTIVE | INFORMATION SCHEMA | 100019.0 | NULL | NULL | Percona Inc. | InnoDB internal hash tables information | GPL | ON | Stable | 5.6.23-72.1 | | XTRADB_RSEG | 5.6 | ACTIVE | INFORMATION SCHEMA | 100019.0 | NULL | NULL | Percona Inc. | InnoDB rollback segment information | GPL | ON | Stable | 5.6.23-72.1 | | INNODB_TRX | 5.6 | ACTIVE | INFORMATION SCHEMA | 100019.0 | NULL | NULL | Oracle Corporation | InnoDB transactions | GPL | ON | Stable | 5.6.23-72.1 | | INNODB_LOCKS | 5.6 | ACTIVE | INFORMATION SCHEMA | 100019.0 | NULL | NULL | Oracle Corporation | InnoDB conflicting locks | GPL | ON | Stable | 5.6.23-72.1 | | INNODB_LOCK_WAITS | 5.6 | ACTIVE | INFORMATION SCHEMA | 100019.0 | NULL | NULL | Oracle Corporation | InnoDB which lock is blocking which | GPL | ON | Stable | 5.6.23-72.1 | | INNODB_CMP | 5.6 | ACTIVE | INFORMATION SCHEMA | 100019.0 | NULL | NULL | Oracle Corporation | Statistics for the InnoDB compression | GPL | ON | Stable | 5.6.23-72.1 | | INNODB_CMP_RESET | 5.6 | ACTIVE | INFORMATION SCHEMA | 100019.0 | NULL | NULL | Oracle Corporation | Statistics for the InnoDB compression; reset cumulated counts | GPL | ON | Stable | 5.6.23-72.1 | | INNODB_CMPMEM | 5.6 | ACTIVE | INFORMATION SCHEMA | 100019.0 | NULL | NULL | Oracle Corporation | Statistics for the InnoDB compressed buffer pool | GPL | ON | Stable | 5.6.23-72.1 | | INNODB_CMPMEM_RESET | 5.6 | ACTIVE | INFORMATION SCHEMA | 100019.0 | NULL | NULL | Oracle Corporation | Statistics for the InnoDB compressed buffer pool; reset cumulated counts | GPL | ON | Stable | 5.6.23-72.1 | | INNODB_CMP_PER_INDEX | 5.6 | ACTIVE | INFORMATION SCHEMA | 100019.0 | NULL | NULL | Oracle Corporation | Statistics for the InnoDB compression (per index) | GPL | ON | Stable | 5.6.23-72.1 | | INNODB_CMP_PER_INDEX_RESET | 5.6 | ACTIVE | INFORMATION SCHEMA | 100019.0 | NULL | NULL | Oracle Corporation | Statistics for the InnoDB compression (per index); reset cumulated counts | GPL | ON | Stable | 5.6.23-72.1 | | INNODB_BUFFER_PAGE | 5.6 | ACTIVE | INFORMATION SCHEMA | 100019.0 | NULL | NULL | Oracle Corporation | InnoDB Buffer Page Information | GPL | ON | Stable | 5.6.23-72.1 | | INNODB_BUFFER_PAGE_LRU | 5.6 | ACTIVE | INFORMATION SCHEMA | 100019.0 | NULL | NULL | Oracle Corporation | InnoDB Buffer Page in LRU | GPL | ON | Stable | 5.6.23-72.1 | | INNODB_BUFFER_POOL_STATS | 5.6 | ACTIVE | INFORMATION SCHEMA | 100019.0 | NULL | NULL | Oracle Corporation | InnoDB Buffer Pool Statistics Information | GPL | ON | Stable | 5.6.23-72.1 | | INNODB_METRICS | 5.6 | ACTIVE | INFORMATION SCHEMA | 100019.0 | NULL | NULL | Oracle Corporation | InnoDB Metrics Info | GPL | ON | Stable | 5.6.23-72.1 | | INNODB_FT_DEFAULT_STOPWORD | 5.6 | ACTIVE | INFORMATION SCHEMA | 100019.0 | NULL | NULL | Oracle Corporation | Default stopword list for InnDB Full Text Search | GPL | ON | Stable | 5.6.23-72.1 | | INNODB_FT_DELETED | 5.6 | ACTIVE | INFORMATION SCHEMA | 100019.0 | NULL | NULL | Oracle Corporation | INNODB AUXILIARY FTS DELETED TABLE | GPL | ON | Stable | 5.6.23-72.1 | | INNODB_FT_BEING_DELETED | 5.6 | ACTIVE | INFORMATION SCHEMA | 100019.0 | NULL | NULL | Oracle Corporation | INNODB AUXILIARY FTS BEING DELETED TABLE | GPL | ON | Stable | 5.6.23-72.1 | | INNODB_FT_CONFIG | 5.6 | ACTIVE | INFORMATION SCHEMA | 100019.0 | NULL | NULL | Oracle Corporation | INNODB AUXILIARY FTS CONFIG TABLE | GPL | ON | Stable | 5.6.23-72.1 | | INNODB_FT_INDEX_CACHE | 5.6 | ACTIVE | INFORMATION SCHEMA | 100019.0 | NULL | NULL | Oracle Corporation | INNODB AUXILIARY FTS INDEX CACHED | GPL | ON | Stable | 5.6.23-72.1 | | INNODB_FT_INDEX_TABLE | 5.6 | ACTIVE | INFORMATION SCHEMA | 100019.0 | NULL | NULL | Oracle Corporation | INNODB AUXILIARY FTS INDEX TABLE | GPL | ON | Stable | 5.6.23-72.1 | | INNODB_SYS_TABLES | 5.6 | ACTIVE | INFORMATION SCHEMA | 100019.0 | NULL | NULL | Oracle Corporation | InnoDB SYS_TABLES | GPL | ON | Stable | 5.6.23-72.1 | | INNODB_SYS_TABLESTATS | 5.6 | ACTIVE | INFORMATION SCHEMA | 100019.0 | NULL | NULL | Oracle Corporation | InnoDB SYS_TABLESTATS | GPL | ON | Stable | 5.6.23-72.1 | | INNODB_SYS_INDEXES | 5.6 | ACTIVE | INFORMATION SCHEMA | 100019.0 | NULL | NULL | Oracle Corporation | InnoDB SYS_INDEXES | GPL | ON | Stable | 5.6.23-72.1 | | INNODB_SYS_COLUMNS | 5.6 | ACTIVE | INFORMATION SCHEMA | 100019.0 | NULL | NULL | Oracle Corporation | InnoDB SYS_COLUMNS | GPL | ON | Stable | 5.6.23-72.1 | | INNODB_SYS_FIELDS | 5.6 | ACTIVE | INFORMATION SCHEMA | 100019.0 | NULL | NULL | Oracle Corporation | InnoDB SYS_FIELDS | GPL | ON | Stable | 5.6.23-72.1 | | INNODB_SYS_FOREIGN | 5.6 | ACTIVE | INFORMATION SCHEMA | 100019.0 | NULL | NULL | Oracle Corporation | InnoDB SYS_FOREIGN | GPL | ON | Stable | 5.6.23-72.1 | | INNODB_SYS_FOREIGN_COLS | 5.6 | ACTIVE | INFORMATION SCHEMA | 100019.0 | NULL | NULL | Oracle Corporation | InnoDB SYS_FOREIGN_COLS | GPL | ON | Stable | 5.6.23-72.1 | | INNODB_SYS_TABLESPACES | 5.6 | ACTIVE | INFORMATION SCHEMA | 100019.0 | NULL | NULL | Oracle Corporation | InnoDB SYS_TABLESPACES | GPL | ON | Stable | 5.6.23-72.1 | | INNODB_SYS_DATAFILES | 5.6 | ACTIVE | INFORMATION SCHEMA | 100019.0 | NULL | NULL | Oracle Corporation | InnoDB SYS_DATAFILES | GPL | ON | Stable | 5.6.23-72.1 | | INNODB_CHANGED_PAGES | 1.0 | ACTIVE | INFORMATION SCHEMA | 100019.0 | NULL | NULL | Percona | InnoDB CHANGED_PAGES table | GPL | ON | Stable | 5.6.23-72.1 | | FEDERATED | 2.1 | ACTIVE | STORAGE ENGINE | 100019.0 | NULL | NULL | Patrick Galbraith | FederatedX pluggable storage engine | GPL | ON | Stable | 2.1 | | ARCHIVE | 3.0 | ACTIVE | STORAGE ENGINE | 100019.0 | NULL | NULL | Brian Aker, MySQL AB | Archive storage engine | GPL | ON | Stable | 1.0 | | PERFORMANCE_SCHEMA | 0.1 | ACTIVE | STORAGE ENGINE | 100019.0 | NULL | NULL | Marc Alff, Oracle | Performance Schema | GPL | FORCE | Stable | 5.6.20 | | Aria | 1.5 | ACTIVE | STORAGE ENGINE | 100019.0 | NULL | NULL | Monty Program Ab | Crash-safe tables with MyISAM heritage | GPL | ON | Stable | 1.5 | | FEEDBACK | 1.1 | DISABLED | INFORMATION SCHEMA | 100019.0 | NULL | NULL | Sergei Golubchik | MariaDB User Feedback Plugin | GPL | OFF | Stable | 1.1 | | partition | 1.0 | ACTIVE | STORAGE ENGINE | 100019.0 | NULL | NULL | Mikael Ronstrom, MySQL AB | Partition Storage Engine Helper | GPL | ON | Stable | 1.0 | | SPIDER | 3.2 | ACTIVE | STORAGE ENGINE | 100019.0 | ha_spider.so | 1.8 | Kentoku Shiba | Spider storage engine | GPL | ON | Gamma | 3.2.21 | | SPIDER_ALLOC_MEM | 1.0 | ACTIVE | INFORMATION SCHEMA | 100019.0 | ha_spider.so | 1.8 | Kentoku Shiba | Spider memory allocating viewer | GPL | ON | Gamma | 1.0 | +-----------------------------+----------------+---------------+--------------------+---------------------+----------------+------------------------+----------------------------+----------------------------------------------------------------------------+----------------+-------------+-----------------+---------------------+ 49 rows in set (0.00 sec) FROM TOKUDB NODES MariaDB [(none)]> select * from information_schema.plugins; +-------------------------------+----------------+---------------+--------------------+---------------------+----------------+------------------------+----------------------------+----------------------------------------------------------------------------+----------------+-------------+-----------------+---------------------+ | PLUGIN_NAME | PLUGIN_VERSION | PLUGIN_STATUS | PLUGIN_TYPE | PLUGIN_TYPE_VERSION | PLUGIN_LIBRARY | PLUGIN_LIBRARY_VERSION | PLUGIN_AUTHOR | PLUGIN_DESCRIPTION | PLUGIN_LICENSE | LOAD_OPTION | PLUGIN_MATURITY | PLUGIN_AUTH_VERSION | +-------------------------------+----------------+---------------+--------------------+---------------------+----------------+------------------------+----------------------------+----------------------------------------------------------------------------+----------------+-------------+-----------------+---------------------+ | binlog | 1.0 | ACTIVE | STORAGE ENGINE | 100019.0 | NULL | NULL | MySQL AB | This is a pseudo storage engine to represent the binlog in a transaction | GPL | FORCE | Stable | 1.0 | | mysql_native_password | 1.0 | ACTIVE | AUTHENTICATION | 2.0 | NULL | NULL | R.J.Silk, Sergei Golubchik | Native MySQL authentication | GPL | FORCE | Stable | 1.0 | | mysql_old_password | 1.0 | ACTIVE | AUTHENTICATION | 2.0 | NULL | NULL | R.J.Silk, Sergei Golubchik | Old MySQL-4.0 authentication | GPL | FORCE | Stable | 1.0 | | CSV | 1.0 | ACTIVE | STORAGE ENGINE | 100019.0 | NULL | NULL | Brian Aker, MySQL AB | CSV storage engine | GPL | FORCE | Stable | 1.0 | | MEMORY | 1.0 | ACTIVE | STORAGE ENGINE | 100019.0 | NULL | NULL | MySQL AB | Hash based, stored in memory, useful for temporary tables | GPL | FORCE | Stable | 1.0 | | MyISAM | 1.0 | ACTIVE | STORAGE ENGINE | 100019.0 | NULL | NULL | MySQL AB | MyISAM storage engine | GPL | FORCE | Stable | 1.0 | | MRG_MyISAM | 1.0 | ACTIVE | STORAGE ENGINE | 100019.0 | NULL | NULL | MySQL AB | Collection of identical MyISAM tables | GPL | FORCE | Stable | 1.0 | | BLACKHOLE | 1.0 | ACTIVE | STORAGE ENGINE | 100019.0 | NULL | NULL | MySQL AB | /dev/null storage engine (anything you write to it disappears) | GPL | ON | Stable | 1.0 | | InnoDB | 5.6 | ACTIVE | STORAGE ENGINE | 100019.0 | NULL | NULL | Oracle Corporation | Percona-XtraDB, Supports transactions, row-level locking, and foreign keys | GPL | ON | Stable | 5.6.23-72.1 | | XTRADB_READ_VIEW | 5.6 | ACTIVE | INFORMATION SCHEMA | 100019.0 | NULL | NULL | Percona Inc. | InnoDB Read View information | GPL | ON | Stable | 5.6.23-72.1 | | XTRADB_INTERNAL_HASH_TABLES | 5.6 | ACTIVE | INFORMATION SCHEMA | 100019.0 | NULL | NULL | Percona Inc. | InnoDB internal hash tables information | GPL | ON | Stable | 5.6.23-72.1 | | XTRADB_RSEG | 5.6 | ACTIVE | INFORMATION SCHEMA | 100019.0 | NULL | NULL | Percona Inc. | InnoDB rollback segment information | GPL | ON | Stable | 5.6.23-72.1 | | INNODB_TRX | 5.6 | ACTIVE | INFORMATION SCHEMA | 100019.0 | NULL | NULL | Oracle Corporation | InnoDB transactions | GPL | ON | Stable | 5.6.23-72.1 | | INNODB_LOCKS | 5.6 | ACTIVE | INFORMATION SCHEMA | 100019.0 | NULL | NULL | Oracle Corporation | InnoDB conflicting locks | GPL | ON | Stable | 5.6.23-72.1 | | INNODB_LOCK_WAITS | 5.6 | ACTIVE | INFORMATION SCHEMA | 100019.0 | NULL | NULL | Oracle Corporation | InnoDB which lock is blocking which | GPL | ON | Stable | 5.6.23-72.1 | | INNODB_CMP | 5.6 | ACTIVE | INFORMATION SCHEMA | 100019.0 | NULL | NULL | Oracle Corporation | Statistics for the InnoDB compression | GPL | ON | Stable | 5.6.23-72.1 | | INNODB_CMP_RESET | 5.6 | ACTIVE | INFORMATION SCHEMA | 100019.0 | NULL | NULL | Oracle Corporation | Statistics for the InnoDB compression; reset cumulated counts | GPL | ON | Stable | 5.6.23-72.1 | | INNODB_CMPMEM | 5.6 | ACTIVE | INFORMATION SCHEMA | 100019.0 | NULL | NULL | Oracle Corporation | Statistics for the InnoDB compressed buffer pool | GPL | ON | Stable | 5.6.23-72.1 | | INNODB_CMPMEM_RESET | 5.6 | ACTIVE | INFORMATION SCHEMA | 100019.0 | NULL | NULL | Oracle Corporation | Statistics for the InnoDB compressed buffer pool; reset cumulated counts | GPL | ON | Stable | 5.6.23-72.1 | | INNODB_CMP_PER_INDEX | 5.6 | ACTIVE | INFORMATION SCHEMA | 100019.0 | NULL | NULL | Oracle Corporation | Statistics for the InnoDB compression (per index) | GPL | ON | Stable | 5.6.23-72.1 | | INNODB_CMP_PER_INDEX_RESET | 5.6 | ACTIVE | INFORMATION SCHEMA | 100019.0 | NULL | NULL | Oracle Corporation | Statistics for the InnoDB compression (per index); reset cumulated counts | GPL | ON | Stable | 5.6.23-72.1 | | INNODB_BUFFER_PAGE | 5.6 | ACTIVE | INFORMATION SCHEMA | 100019.0 | NULL | NULL | Oracle Corporation | InnoDB Buffer Page Information | GPL | ON | Stable | 5.6.23-72.1 | | INNODB_BUFFER_PAGE_LRU | 5.6 | ACTIVE | INFORMATION SCHEMA | 100019.0 | NULL | NULL | Oracle Corporation | InnoDB Buffer Page in LRU | GPL | ON | Stable | 5.6.23-72.1 | | INNODB_BUFFER_POOL_STATS | 5.6 | ACTIVE | INFORMATION SCHEMA | 100019.0 | NULL | NULL | Oracle Corporation | InnoDB Buffer Pool Statistics Information | GPL | ON | Stable | 5.6.23-72.1 | | INNODB_METRICS | 5.6 | ACTIVE | INFORMATION SCHEMA | 100019.0 | NULL | NULL | Oracle Corporation | InnoDB Metrics Info | GPL | ON | Stable | 5.6.23-72.1 | | INNODB_FT_DEFAULT_STOPWORD | 5.6 | ACTIVE | INFORMATION SCHEMA | 100019.0 | NULL | NULL | Oracle Corporation | Default stopword list for InnDB Full Text Search | GPL | ON | Stable | 5.6.23-72.1 | | INNODB_FT_DELETED | 5.6 | ACTIVE | INFORMATION SCHEMA | 100019.0 | NULL | NULL | Oracle Corporation | INNODB AUXILIARY FTS DELETED TABLE | GPL | ON | Stable | 5.6.23-72.1 | | INNODB_FT_BEING_DELETED | 5.6 | ACTIVE | INFORMATION SCHEMA | 100019.0 | NULL | NULL | Oracle Corporation | INNODB AUXILIARY FTS BEING DELETED TABLE | GPL | ON | Stable | 5.6.23-72.1 | | INNODB_FT_CONFIG | 5.6 | ACTIVE | INFORMATION SCHEMA | 100019.0 | NULL | NULL | Oracle Corporation | INNODB AUXILIARY FTS CONFIG TABLE | GPL | ON | Stable | 5.6.23-72.1 | | INNODB_FT_INDEX_CACHE | 5.6 | ACTIVE | INFORMATION SCHEMA | 100019.0 | NULL | NULL | Oracle Corporation | INNODB AUXILIARY FTS INDEX CACHED | GPL | ON | Stable | 5.6.23-72.1 | | INNODB_FT_INDEX_TABLE | 5.6 | ACTIVE | INFORMATION SCHEMA | 100019.0 | NULL | NULL | Oracle Corporation | INNODB AUXILIARY FTS INDEX TABLE | GPL | ON | Stable | 5.6.23-72.1 | | INNODB_SYS_TABLES | 5.6 | ACTIVE | INFORMATION SCHEMA | 100019.0 | NULL | NULL | Oracle Corporation | InnoDB SYS_TABLES | GPL | ON | Stable | 5.6.23-72.1 | | INNODB_SYS_TABLESTATS | 5.6 | ACTIVE | INFORMATION SCHEMA | 100019.0 | NULL | NULL | Oracle Corporation | InnoDB SYS_TABLESTATS | GPL | ON | Stable | 5.6.23-72.1 | | INNODB_SYS_INDEXES | 5.6 | ACTIVE | INFORMATION SCHEMA | 100019.0 | NULL | NULL | Oracle Corporation | InnoDB SYS_INDEXES | GPL | ON | Stable | 5.6.23-72.1 | | INNODB_SYS_COLUMNS | 5.6 | ACTIVE | INFORMATION SCHEMA | 100019.0 | NULL | NULL | Oracle Corporation | InnoDB SYS_COLUMNS | GPL | ON | Stable | 5.6.23-72.1 | | INNODB_SYS_FIELDS | 5.6 | ACTIVE | INFORMATION SCHEMA | 100019.0 | NULL | NULL | Oracle Corporation | InnoDB SYS_FIELDS | GPL | ON | Stable | 5.6.23-72.1 | | INNODB_SYS_FOREIGN | 5.6 | ACTIVE | INFORMATION SCHEMA | 100019.0 | NULL | NULL | Oracle Corporation | InnoDB SYS_FOREIGN | GPL | ON | Stable | 5.6.23-72.1 | | INNODB_SYS_FOREIGN_COLS | 5.6 | ACTIVE | INFORMATION SCHEMA | 100019.0 | NULL | NULL | Oracle Corporation | InnoDB SYS_FOREIGN_COLS | GPL | ON | Stable | 5.6.23-72.1 | | INNODB_SYS_TABLESPACES | 5.6 | ACTIVE | INFORMATION SCHEMA | 100019.0 | NULL | NULL | Oracle Corporation | InnoDB SYS_TABLESPACES | GPL | ON | Stable | 5.6.23-72.1 | | INNODB_SYS_DATAFILES | 5.6 | ACTIVE | INFORMATION SCHEMA | 100019.0 | NULL | NULL | Oracle Corporation | InnoDB SYS_DATAFILES | GPL | ON | Stable | 5.6.23-72.1 | | INNODB_CHANGED_PAGES | 1.0 | ACTIVE | INFORMATION SCHEMA | 100019.0 | NULL | NULL | Percona | InnoDB CHANGED_PAGES table | GPL | ON | Stable | 5.6.23-72.1 | | FEDERATED | 2.1 | ACTIVE | STORAGE ENGINE | 100019.0 | NULL | NULL | Patrick Galbraith | FederatedX pluggable storage engine | GPL | ON | Stable | 2.1 | | ARCHIVE | 3.0 | ACTIVE | STORAGE ENGINE | 100019.0 | NULL | NULL | Brian Aker, MySQL AB | Archive storage engine | GPL | ON | Stable | 1.0 | | PERFORMANCE_SCHEMA | 0.1 | ACTIVE | STORAGE ENGINE | 100019.0 | NULL | NULL | Marc Alff, Oracle | Performance Schema | GPL | FORCE | Stable | 5.6.20 | | Aria | 1.5 | ACTIVE | STORAGE ENGINE | 100019.0 | NULL | NULL | Monty Program Ab | Crash-safe tables with MyISAM heritage | GPL | ON | Stable | 1.5 | | FEEDBACK | 1.1 | DISABLED | INFORMATION SCHEMA | 100019.0 | NULL | NULL | Sergei Golubchik | MariaDB User Feedback Plugin | GPL | OFF | Stable | 1.1 | | partition | 1.0 | ACTIVE | STORAGE ENGINE | 100019.0 | NULL | NULL | Mikael Ronstrom, MySQL AB | Partition Storage Engine Helper | GPL | ON | Stable | 1.0 | | TokuDB | 7.5 | ACTIVE | STORAGE ENGINE | 100019.0 | ha_tokudb.so | 1.8 | Tokutek Inc | Tokutek TokuDB Storage Engine with Fractal Tree(tm) Technology | GPL | ON | Stable | tokudb-7.5.6 | | TokuDB_trx | 7.5 | ACTIVE | INFORMATION SCHEMA | 100019.0 | ha_tokudb.so | 1.8 | Tokutek Inc | Tokutek TokuDB Storage Engine with Fractal Tree(tm) Technology | GPL | ON | Stable | tokudb-7.5.6 | | TokuDB_lock_waits | 7.5 | ACTIVE | INFORMATION SCHEMA | 100019.0 | ha_tokudb.so | 1.8 | Tokutek Inc | Tokutek TokuDB Storage Engine with Fractal Tree(tm) Technology | GPL | ON | Stable | tokudb-7.5.6 | | TokuDB_locks | 7.5 | ACTIVE | INFORMATION SCHEMA | 100019.0 | ha_tokudb.so | 1.8 | Tokutek Inc | Tokutek TokuDB Storage Engine with Fractal Tree(tm) Technology | GPL | ON | Stable | tokudb-7.5.6 | | TokuDB_file_map | 7.5 | ACTIVE | INFORMATION SCHEMA | 100019.0 | ha_tokudb.so | 1.8 | Tokutek Inc | Tokutek TokuDB Storage Engine with Fractal Tree(tm) Technology | GPL | ON | Stable | tokudb-7.5.6 | | TokuDB_fractal_tree_info | 7.5 | ACTIVE | INFORMATION SCHEMA | 100019.0 | ha_tokudb.so | 1.8 | Tokutek Inc | Tokutek TokuDB Storage Engine with Fractal Tree(tm) Technology | GPL | ON | Stable | tokudb-7.5.6 | | TokuDB_fractal_tree_block_map | 7.5 | ACTIVE | INFORMATION SCHEMA | 100019.0 | ha_tokudb.so | 1.8 | Tokutek Inc | Tokutek TokuDB Storage Engine with Fractal Tree(tm) Technology | GPL | ON | Stable | tokudb-7.5.6 | | SPIDER | 3.2 | ACTIVE | STORAGE ENGINE | 100019.0 | ha_spider.so | 1.8 | Kentoku Shiba | Spider storage engine | GPL | ON | Gamma | 3.2.21 | | SPIDER_ALLOC_MEM | 1.0 | ACTIVE | INFORMATION SCHEMA | 100019.0 | ha_spider.so | 1.8 | Kentoku Shiba | Spider memory allocating viewer | GPL | ON | Gamma | 1.0 | +-------------------------------+----------------+---------------+--------------------+---------------------+----------------+------------------------+----------------------------+----------------------------------------------------------------------------+----------------+-------------+-----------------+---------------------+ 56 rows in set (0.01 sec)