Go to:
Gentoo Home
Documentation
Forums
Lists
Bugs
Planet
Store
Wiki
Get Gentoo!
Gentoo's Bugzilla – Attachment 568766 Details for
Bug 680124
dev-db/mariadb-10.1.37 fails "main.mysqldump 'xtradb'" and "main.mysqldump 'innodb_plugin'" tests
Home
|
New
–
[Ex]
|
Browse
|
Search
|
Privacy Policy
|
[?]
|
Reports
|
Requests
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
check-mysqld_1.log
check-mysqld_1.log (text/x-log), 56.64 KB, created by
Paolo Pedroni
on 2019-03-12 14:10:07 UTC
(
hide
)
Description:
check-mysqld_1.log
Filename:
MIME Type:
Creator:
Paolo Pedroni
Created:
2019-03-12 14:10:07 UTC
Size:
56.64 KB
patch
obsolete
>Slave_IO_State >Master_Host 127.0.0.1 >Master_User root >Master_Port # >Connect_Retry # >Master_Log_File # >Read_Master_Log_Pos # >Relay_Log_File # >Relay_Log_Pos # >Relay_Master_Log_File # >Slave_IO_Running No >Slave_SQL_Running No >Replicate_Do_DB # >Replicate_Ignore_DB # >Replicate_Do_Table # >Replicate_Ignore_Table # >Replicate_Wild_Do_Table # >Replicate_Wild_Ignore_Table # >Last_Errno 0 >Last_Error >Skip_Counter 0 >Exec_Master_Log_Pos # >Relay_Log_Space # >Until_Condition # >Until_Log_File # >Until_Log_Pos # >Master_SSL_Allowed No >Master_SSL_CA_File >Master_SSL_CA_Path >Master_SSL_Cert >Master_SSL_Cipher >Master_SSL_Key >Seconds_Behind_Master NULL >Master_SSL_Verify_Server_Cert No >Last_IO_Errno 0 >Last_IO_Error >Last_SQL_Errno 0 >Last_SQL_Error >Replicate_Ignore_Server_Ids >Master_Server_Id # >Master_SSL_Crl # >Master_SSL_Crlpath # >Using_Gtid No >Gtid_IO_Pos # >Replicate_Do_Domain_Ids >Replicate_Ignore_Domain_Ids >Parallel_Mode conservative >VARIABLE_NAME VARIABLE_VALUE >ARIA_BLOCK_SIZE 8192 >ARIA_CHECKPOINT_INTERVAL 30 >ARIA_CHECKPOINT_LOG_ACTIVITY 1048576 >ARIA_ENCRYPT_TABLES OFF >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_PAGECACHE_AGE_THRESHOLD 300 >ARIA_PAGECACHE_BUFFER_SIZE 8388608 >ARIA_PAGECACHE_DIVISION_LIMIT 100 >ARIA_PAGECACHE_FILE_HASH_SIZE 512 >ARIA_PAGE_CHECKSUM ON >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 >AUTOCOMMIT ON >AUTOMATIC_SP_PRIVILEGES ON >AUTO_INCREMENT_INCREMENT 1 >AUTO_INCREMENT_OFFSET 1 >BACK_LOG 80 >BASEDIR /var/tmp/portage/dev-db/mariadb-10.1.37/work/mysql >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 ON >BINLOG_FORMAT STATEMENT >BINLOG_OPTIMIZE_THREAD_SCHEDULING ON >BINLOG_ROW_IMAGE FULL >BINLOG_STMT_CACHE_SIZE 32768 >BULK_INSERT_BUFFER_SIZE 8388608 >CHARACTER_SETS_DIR /var/tmp/portage/dev-db/mariadb-10.1.37/work/mysql/sql/share/charsets/ >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 >COLLATION_CONNECTION latin1_swedish_ci >COLLATION_DATABASE latin1_swedish_ci >COLLATION_SERVER latin1_swedish_ci >COMPLETION_TYPE NO_CHAIN >CONCURRENT_INSERT AUTO >CONNECT_TIMEOUT 60 >CORE_FILE ON >DATADIR /var/tmp/portage/dev-db/mariadb-10.1.37/temp/var-tests/4/mysqld.1/data/ >DATETIME_FORMAT %Y-%m-%d %H:%i:%s >DATE_FORMAT %Y-%m-%d >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 MyISAM >DEFAULT_TMP_STORAGE_ENGINE >DEFAULT_WEEK_FORMAT 0 >DELAYED_INSERT_LIMIT 100 >DELAYED_INSERT_TIMEOUT 300 >DELAYED_QUEUE_SIZE 1000 >DELAY_KEY_WRITE ON >DIV_PRECISION_INCREMENT 4 >ENCRYPT_BINLOG OFF >ENCRYPT_TMP_DISK_TABLES OFF >ENCRYPT_TMP_FILES OFF >ENFORCE_STORAGE_ENGINE >EVENT_SCHEDULER OFF >EXPENSIVE_SUBQUERY_LIMIT 100 >EXPIRE_LOGS_DAYS 0 >EXPLICIT_DEFAULTS_FOR_TIMESTAMP OFF >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 ON >GENERAL_LOG_FILE /var/tmp/portage/dev-db/mariadb-10.1.37/temp/var-tests/4/mysqld.1/mysqld.log >GROUP_CONCAT_MAX_LEN 1024 >GTID_DOMAIN_ID 0 >GTID_IGNORE_DUPLICATES OFF >GTID_STRICT_MODE OFF >HAVE_COMPRESS YES >HAVE_CRYPT YES >HAVE_DYNAMIC_LOADING YES >HAVE_GEOMETRY YES >HAVE_OPENSSL YES >HAVE_PROFILING NO >HAVE_QUERY_CACHE YES >HAVE_RTREE_KEYS YES >HAVE_SSL YES >HAVE_SYMLINK YES >HISTOGRAM_SIZE 0 >HISTOGRAM_TYPE SINGLE_PREC_HB >HOSTNAME principale >HOST_CACHE_SIZE 279 >IGNORE_BUILTIN_INNODB ON >IGNORE_DB_DIRS >INIT_CONNECT >INIT_FILE >INIT_SLAVE >INNODB_ADAPTIVE_FLUSHING ON >INNODB_ADAPTIVE_FLUSHING_LWM 10.000000 >INNODB_ADAPTIVE_HASH_INDEX ON >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_BACKGROUND_SCRUB_DATA_CHECK_INTERVAL 3600 >INNODB_BACKGROUND_SCRUB_DATA_COMPRESSED OFF >INNODB_BACKGROUND_SCRUB_DATA_INTERVAL 604800 >INNODB_BACKGROUND_SCRUB_DATA_UNCOMPRESSED OFF >INNODB_BUFFER_POOL_DUMP_AT_SHUTDOWN OFF >INNODB_BUFFER_POOL_DUMP_NOW OFF >INNODB_BUFFER_POOL_DUMP_PCT 100 >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_SIZE 8388608 >INNODB_BUF_DUMP_STATUS_FREQUENCY 0 >INNODB_CHANGE_BUFFERING all >INNODB_CHANGE_BUFFER_MAX_SIZE 25 >INNODB_CHECKSUMS ON >INNODB_CHECKSUM_ALGORITHM INNODB >INNODB_CMP_PER_INDEX_ENABLED OFF >INNODB_COMMIT_CONCURRENCY 0 >INNODB_COMPRESSION_ALGORITHM zlib >INNODB_COMPRESSION_FAILURE_THRESHOLD_PCT 5 >INNODB_COMPRESSION_LEVEL 6 >INNODB_COMPRESSION_PAD_PCT_MAX 50 >INNODB_CONCURRENCY_TICKETS 5000 >INNODB_DATA_FILE_PATH ibdata1:12M:autoextend >INNODB_DATA_HOME_DIR >INNODB_DEFAULT_ENCRYPTION_KEY_ID 1 >INNODB_DEFAULT_ROW_FORMAT compact >INNODB_DEFRAGMENT OFF >INNODB_DEFRAGMENT_FILL_FACTOR 0.900000 >INNODB_DEFRAGMENT_FILL_FACTOR_N_RECS 20 >INNODB_DEFRAGMENT_FREQUENCY 40 >INNODB_DEFRAGMENT_N_PAGES 7 >INNODB_DEFRAGMENT_STATS_ACCURACY 0 >INNODB_DISABLE_SORT_FILE_CACHE OFF >INNODB_DOUBLEWRITE ON >INNODB_ENCRYPTION_ROTATE_KEY_AGE 1 >INNODB_ENCRYPTION_ROTATION_IOPS 100 >INNODB_ENCRYPTION_THREADS 0 >INNODB_ENCRYPT_LOG OFF >INNODB_ENCRYPT_TABLES OFF >INNODB_FAST_SHUTDOWN 1 >INNODB_FATAL_SEMAPHORE_WAIT_THRESHOLD 600 >INNODB_FILE_FORMAT Antelope >INNODB_FILE_FORMAT_CHECK ON >INNODB_FILE_PER_TABLE ON >INNODB_FLUSHING_AVG_LOOPS 30 >INNODB_FLUSH_LOG_AT_TIMEOUT 1 >INNODB_FLUSH_LOG_AT_TRX_COMMIT 1 >INNODB_FLUSH_METHOD >INNODB_FLUSH_NEIGHBORS 1 >INNODB_FORCE_LOAD_CORRUPTED OFF >INNODB_FORCE_PRIMARY_KEY OFF >INNODB_FORCE_RECOVERY 0 >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_IDLE_FLUSH_PCT 100 >INNODB_IMMEDIATE_SCRUB_DATA_UNCOMPRESSED OFF >INNODB_INSTRUMENT_SEMAPHORES OFF >INNODB_IO_CAPACITY 200 >INNODB_IO_CAPACITY_MAX 2000 >INNODB_LARGE_PREFIX OFF >INNODB_LOCKS_UNSAFE_FOR_BINLOG OFF >INNODB_LOCK_SCHEDULE_ALGORITHM fcfs >INNODB_LOCK_WAIT_TIMEOUT 50 >INNODB_LOG_BUFFER_SIZE 1048576 >INNODB_LOG_COMPRESSED_PAGES ON >INNODB_LOG_FILES_IN_GROUP 2 >INNODB_LOG_FILE_SIZE 5242880 >INNODB_LOG_GROUP_HOME_DIR ./ >INNODB_LRU_SCAN_DEPTH 100 >INNODB_MAX_DIRTY_PAGES_PCT 75.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_MTFLUSH_THREADS 8 >INNODB_OLD_BLOCKS_PCT 37 >INNODB_OLD_BLOCKS_TIME 1000 >INNODB_ONLINE_ALTER_LOG_MAX_SIZE 134217728 >INNODB_OPEN_FILES 2000 >INNODB_OPTIMIZE_FULLTEXT_ONLY OFF >INNODB_PAGE_SIZE 16384 >INNODB_PREFIX_INDEX_CLUSTER_OPTIMIZATION OFF >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 2 >INNODB_READ_ONLY OFF >INNODB_REPLICATION_DELAY 0 >INNODB_ROLLBACK_ON_TIMEOUT OFF >INNODB_ROLLBACK_SEGMENTS 128 >INNODB_SCRUB_LOG OFF >INNODB_SCRUB_LOG_SPEED 256 >INNODB_SIMULATE_COMP_FAILURES 0 >INNODB_SORT_BUFFER_SIZE 1048576 >INNODB_SPIN_WAIT_DELAY 6 >INNODB_STATS_AUTO_RECALC ON >INNODB_STATS_INCLUDE_DELETE_MARKED OFF >INNODB_STATS_METHOD nulls_equal >INNODB_STATS_MODIFIED_COUNTER 0 >INNODB_STATS_ON_METADATA OFF >INNODB_STATS_PERSISTENT OFF >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 0 >INNODB_THREAD_SLEEP_DELAY 10000 >INNODB_TMPDIR >INNODB_UNDO_DIRECTORY . >INNODB_UNDO_LOGS 128 >INNODB_UNDO_TABLESPACES 0 >INNODB_USE_ATOMIC_WRITES OFF >INNODB_USE_FALLOCATE OFF >INNODB_USE_MTFLUSH OFF >INNODB_USE_SYS_MALLOC ON >INNODB_USE_TRIM OFF >INNODB_VERSION 5.6.42 >INNODB_WRITE_IO_THREADS 2 >INTERACTIVE_TIMEOUT 28800 >JOIN_BUFFER_SIZE 262144 >JOIN_BUFFER_SPACE_LIMIT 2097152 >JOIN_CACHE_LEVEL 2 >KEEP_FILES_ON_CREATE OFF >KEY_BUFFER_SIZE 1048576 >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_PAGES OFF >LARGE_PAGE_SIZE 0 >LC_MESSAGES en_US >LC_MESSAGES_DIR /var/tmp/portage/dev-db/mariadb-10.1.37/work/mariadb-10.1.37_build/sql/share/ >LC_TIME_NAMES en_US >LICENSE GPL >LOCAL_INFILE ON >LOCKED_IN_MEMORY OFF >LOCK_WAIT_TIMEOUT 31536000 >LOG_BIN ON >LOG_BIN_BASENAME /var/tmp/portage/dev-db/mariadb-10.1.37/temp/var-tests/4/mysqld.1/data/master-bin >LOG_BIN_INDEX /var/tmp/portage/dev-db/mariadb-10.1.37/temp/var-tests/4/mysqld.1/data/mysqld-bin.index >LOG_BIN_TRUST_FUNCTION_CREATORS ON >LOG_ERROR >LOG_OUTPUT FILE >LOG_QUERIES_NOT_USING_INDEXES OFF >LOG_SLAVE_UPDATES OFF >LOG_SLOW_ADMIN_STATEMENTS 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_SLAVE_STATEMENTS OFF >LOG_SLOW_VERBOSITY >LOG_TC_SIZE 24576 >LOG_WARNINGS 1 >LONG_QUERY_TIME 10.000000 >LOWER_CASE_FILE_SYSTEM OFF >LOWER_CASE_TABLE_NAMES 0 >LOW_PRIORITY_UPDATES OFF >MASTER_VERIFY_CHECKSUM OFF >MAX_ALLOWED_PACKET 4194304 >MAX_BINLOG_CACHE_SIZE 18446744073709547520 >MAX_BINLOG_SIZE 1073741824 >MAX_BINLOG_STMT_CACHE_SIZE 18446744073709547520 >MAX_CONNECTIONS 151 >MAX_CONNECT_ERRORS 100 >MAX_DELAYED_THREADS 20 >MAX_DIGEST_LENGTH 1024 >MAX_ERROR_COUNT 64 >MAX_HEAP_TABLE_SIZE 1048576 >MAX_INSERT_DELAYED_THREADS 20 >MAX_JOIN_SIZE 18446744073709551615 >MAX_LENGTH_FOR_SORT_DATA 1024 >MAX_LONG_DATA_SIZE 4194304 >MAX_PREPARED_STMT_COUNT 16382 >MAX_RELAY_LOG_SIZE 1073741824 >MAX_SEEKS_FOR_KEY 4294967295 >MAX_SESSION_MEM_USED 9223372036854775807 >MAX_SORT_LENGTH 1024 >MAX_SP_RECURSION_DEPTH 0 >MAX_STATEMENT_TIME 0.000000 >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 9223372036853727232 >MYISAM_MMAP_SIZE 18446744073709551615 >MYISAM_RECOVER_OPTIONS DEFAULT >MYISAM_REPAIR_THREADS 1 >MYISAM_SORT_BUFFER_SIZE 134216704 >MYISAM_STATS_METHOD NULLS_UNEQUAL >MYISAM_USE_MMAP OFF >MYSQL56_TEMPORAL_FORMAT ON >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 1024 >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,orderby_uses_equalities=off >OPTIMIZER_USE_CONDITION_SELECTIVITY 1 >PERFORMANCE_SCHEMA ON >PERFORMANCE_SCHEMA_ACCOUNTS_SIZE 100 >PERFORMANCE_SCHEMA_DIGESTS_SIZE 200 >PERFORMANCE_SCHEMA_EVENTS_STAGES_HISTORY_LONG_SIZE 1000 >PERFORMANCE_SCHEMA_EVENTS_STAGES_HISTORY_SIZE 10 >PERFORMANCE_SCHEMA_EVENTS_STATEMENTS_HISTORY_LONG_SIZE 1000 >PERFORMANCE_SCHEMA_EVENTS_STATEMENTS_HISTORY_SIZE 10 >PERFORMANCE_SCHEMA_EVENTS_WAITS_HISTORY_LONG_SIZE 10000 >PERFORMANCE_SCHEMA_EVENTS_WAITS_HISTORY_SIZE 10 >PERFORMANCE_SCHEMA_HOSTS_SIZE 100 >PERFORMANCE_SCHEMA_MAX_COND_CLASSES 80 >PERFORMANCE_SCHEMA_MAX_COND_INSTANCES 1000 >PERFORMANCE_SCHEMA_MAX_DIGEST_LENGTH 1024 >PERFORMANCE_SCHEMA_MAX_FILE_CLASSES 50 >PERFORMANCE_SCHEMA_MAX_FILE_HANDLES 32768 >PERFORMANCE_SCHEMA_MAX_FILE_INSTANCES 10000 >PERFORMANCE_SCHEMA_MAX_MUTEX_CLASSES 200 >PERFORMANCE_SCHEMA_MAX_MUTEX_INSTANCES 5000 >PERFORMANCE_SCHEMA_MAX_RWLOCK_CLASSES 40 >PERFORMANCE_SCHEMA_MAX_RWLOCK_INSTANCES 5000 >PERFORMANCE_SCHEMA_MAX_SOCKET_CLASSES 10 >PERFORMANCE_SCHEMA_MAX_SOCKET_INSTANCES 1000 >PERFORMANCE_SCHEMA_MAX_STAGE_CLASSES 150 >PERFORMANCE_SCHEMA_MAX_STATEMENT_CLASSES 178 >PERFORMANCE_SCHEMA_MAX_TABLE_HANDLES 1000 >PERFORMANCE_SCHEMA_MAX_TABLE_INSTANCES 500 >PERFORMANCE_SCHEMA_MAX_THREAD_CLASSES 50 >PERFORMANCE_SCHEMA_MAX_THREAD_INSTANCES 200 >PERFORMANCE_SCHEMA_SESSION_CONNECT_ATTRS_SIZE 2048 >PERFORMANCE_SCHEMA_SETUP_ACTORS_SIZE 100 >PERFORMANCE_SCHEMA_SETUP_OBJECTS_SIZE 100 >PERFORMANCE_SCHEMA_USERS_SIZE 100 >PID_FILE /var/tmp/portage/dev-db/mariadb-10.1.37/temp/var-tests/4/run/mysqld.1.pid >PLUGIN_DIR /var/tmp/portage/dev-db/mariadb-10.1.37/temp/var-tests/4/plugins/ >PLUGIN_MATURITY unknown >PORT 11760 >PRELOAD_BUFFER_SIZE 32768 >PROGRESS_REPORT_TIME 5 >PROTOCOL_VERSION 10 >QUERY_ALLOC_BLOCK_SIZE 16384 >QUERY_CACHE_LIMIT 1048576 >QUERY_CACHE_MIN_RES_UNIT 4096 >QUERY_CACHE_SIZE 1048576 >QUERY_CACHE_STRIP_COMMENTS OFF >QUERY_CACHE_TYPE OFF >QUERY_CACHE_WLOCK_INVALIDATE OFF >QUERY_PREALLOC_SIZE 24576 >RANGE_ALLOC_BLOCK_SIZE 4096 >READ_BUFFER_SIZE 131072 >READ_ONLY OFF >READ_RND_BUFFER_SIZE 262144 >RELAY_LOG mysqld-relay-bin >RELAY_LOG_BASENAME /var/tmp/portage/dev-db/mariadb-10.1.37/temp/var-tests/4/mysqld.1/data/mysqld-relay-bin >RELAY_LOG_INDEX /var/tmp/portage/dev-db/mariadb-10.1.37/temp/var-tests/4/mysqld.1/data/mysqld-relay-bin.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 11760 >REPORT_USER >ROWID_MERGE_BUFF_SIZE 8388608 >SECURE_AUTH ON >SECURE_FILE_PRIV /var/tmp/portage/dev-db/mariadb-10.1.37/temp/var-tests/4/ >SERVER_ID 1 >SKIP_EXTERNAL_LOCKING ON >SKIP_NAME_RESOLVE OFF >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 /var/tmp/portage/dev-db/mariadb-10.1.37/temp/var-tests/tmp/4/mysqld.1 >SLAVE_MAX_ALLOWED_PACKET 1073741824 >SLAVE_NET_TIMEOUT 120 >SLAVE_PARALLEL_MAX_QUEUED 131072 >SLAVE_PARALLEL_MODE conservative >SLAVE_PARALLEL_THREADS 0 >SLAVE_RUN_TRIGGERS_FOR_RBR NO >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 /var/tmp/portage/dev-db/mariadb-10.1.37/temp/var-tests/4/mysqld.1/mysqld-slow.log >SOCKET /var/tmp/portage/dev-db/mariadb-10.1.37/temp/var-tests/tmp/4/mysqld.1.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 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 /var/tmp/portage/dev-db/mariadb-10.1.37/work/mysql/mysql-test/std_data/cacert.pem >SSL_CAPATH >SSL_CERT /var/tmp/portage/dev-db/mariadb-10.1.37/work/mysql/mysql-test/std_data/server-cert.pem >SSL_CIPHER >SSL_CRL >SSL_CRLPATH >SSL_KEY /var/tmp/portage/dev-db/mariadb-10.1.37/work/mysql/mysql-test/std_data/server-key.pem >STORAGE_ENGINE MyISAM >STORED_PROGRAM_CACHE 256 >STRICT_PASSWORD_VALIDATION ON >SYNC_BINLOG 0 >SYNC_FRM ON >SYNC_MASTER_INFO 10000 >SYNC_RELAY_LOG 10000 >SYNC_RELAY_LOG_INFO 10000 >SYSTEM_TIME_ZONE CET >TABLE_DEFINITION_CACHE 400 >TABLE_OPEN_CACHE 421 >THREAD_CACHE_SIZE 0 >THREAD_CONCURRENCY 10 >THREAD_HANDLING one-thread-per-connection >THREAD_POOL_IDLE_TIMEOUT 60 >THREAD_POOL_MAX_THREADS 1000 >THREAD_POOL_OVERSUBSCRIBE 3 >THREAD_POOL_SIZE 6 >THREAD_POOL_STALL_LIMIT 500 >THREAD_STACK 295936 >TIMED_MUTEXES OFF >TIME_FORMAT %H:%i:%s >TIME_ZONE SYSTEM >TMPDIR /var/tmp/portage/dev-db/mariadb-10.1.37/temp/var-tests/tmp/4/mysqld.1 >TMP_TABLE_SIZE 16777216 >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 >USERSTAT OFF >USE_STAT_TABLES NEVER >VERSION 10.1.37-MariaDB >VERSION_COMMENT Gentoo Linux mariadb-10.1.37 >VERSION_COMPILE_MACHINE x86_64 >VERSION_COMPILE_OS Linux >VERSION_MALLOC_LIBRARY system >VERSION_SSL_LIBRARY OpenSSL 1.0.2r 26 Feb 2019 >WAIT_TIMEOUT 28800 >CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH >def information_schema utf8 utf8_general_ci NULL >def mtr latin1 latin1_swedish_ci NULL >def mysql latin1 latin1_swedish_ci NULL >def performance_schema utf8 utf8_general_ci NULL >def test latin1 latin1_swedish_ci NULL >CATALOG_NAME SCHEMA_NAME DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME SQL_PATH >def information_schema utf8 utf8_general_ci NULL >def mtr latin1 latin1_swedish_ci NULL >def mysql latin1 latin1_swedish_ci NULL >def performance_schema utf8 utf8_general_ci NULL >def test latin1 latin1_swedish_ci NULL >tables_in_test >tables_in_mysql >mysql.columns_priv >mysql.column_stats >mysql.db >mysql.event >mysql.func >mysql.general_log >mysql.gtid_slave_pos >mysql.help_category >mysql.help_keyword >mysql.help_relation >mysql.help_topic >mysql.host >mysql.index_stats >mysql.innodb_index_stats >mysql.innodb_table_stats >mysql.plugin >mysql.proc >mysql.procs_priv >mysql.proxies_priv >mysql.roles_mapping >mysql.servers >mysql.slow_log >mysql.tables_priv >mysql.table_stats >mysql.time_zone >mysql.time_zone_leap_second >mysql.time_zone_name >mysql.time_zone_transition >mysql.time_zone_transition_type >mysql.user >columns_in_mysql column_name ordinal_position column_default is_nullable data_type character_maximum_length character_octet_length numeric_precision numeric_scale character_set_name collation_name column_type column_key extra column_comment >mysql.columns_priv Host 1 NO char 60 180 NULL NULL utf8 utf8_bin char(60) PRI >mysql.columns_priv Db 2 NO char 64 192 NULL NULL utf8 utf8_bin char(64) PRI >mysql.columns_priv User 3 NO char 80 240 NULL NULL utf8 utf8_bin char(80) PRI >mysql.columns_priv Table_name 4 NO char 64 192 NULL NULL utf8 utf8_bin char(64) PRI >mysql.columns_priv Column_name 5 NO char 64 192 NULL NULL utf8 utf8_bin char(64) PRI >mysql.columns_priv Timestamp 6 CURRENT_TIMESTAMP NO timestamp NULL NULL NULL NULL NULL NULL timestamp on update CURRENT_TIMESTAMP >mysql.columns_priv Column_priv 7 NO set 31 93 NULL NULL utf8 utf8_general_ci set('Select','Insert','Update','References') >mysql.column_stats db_name 1 NULL NO varchar 64 192 NULL NULL utf8 utf8_bin varchar(64) PRI >mysql.column_stats table_name 2 NULL NO varchar 64 192 NULL NULL utf8 utf8_bin varchar(64) PRI >mysql.column_stats column_name 3 NULL NO varchar 64 192 NULL NULL utf8 utf8_bin varchar(64) PRI >mysql.column_stats min_value 4 NULL YES varbinary 255 255 NULL NULL NULL NULL varbinary(255) >mysql.column_stats max_value 5 NULL YES varbinary 255 255 NULL NULL NULL NULL varbinary(255) >mysql.column_stats nulls_ratio 6 NULL YES decimal NULL NULL 12 4 NULL NULL decimal(12,4) >mysql.column_stats avg_length 7 NULL YES decimal NULL NULL 12 4 NULL NULL decimal(12,4) >mysql.column_stats avg_frequency 8 NULL YES decimal NULL NULL 12 4 NULL NULL decimal(12,4) >mysql.column_stats hist_size 9 NULL YES tinyint NULL NULL 3 0 NULL NULL tinyint(3) unsigned >mysql.column_stats hist_type 10 NULL YES enum 14 42 NULL NULL utf8 utf8_bin enum('SINGLE_PREC_HB','DOUBLE_PREC_HB') >mysql.column_stats histogram 11 NULL YES varbinary 255 255 NULL NULL NULL NULL varbinary(255) >mysql.db Host 1 NO char 60 180 NULL NULL utf8 utf8_bin char(60) PRI >mysql.db Db 2 NO char 64 192 NULL NULL utf8 utf8_bin char(64) PRI >mysql.db User 3 NO char 80 240 NULL NULL utf8 utf8_bin char(80) PRI >mysql.db Select_priv 4 N NO enum 1 3 NULL NULL utf8 utf8_general_ci enum('N','Y') >mysql.db Insert_priv 5 N NO enum 1 3 NULL NULL utf8 utf8_general_ci enum('N','Y') >mysql.db Update_priv 6 N NO enum 1 3 NULL NULL utf8 utf8_general_ci enum('N','Y') >mysql.db Delete_priv 7 N NO enum 1 3 NULL NULL utf8 utf8_general_ci enum('N','Y') >mysql.db Create_priv 8 N NO enum 1 3 NULL NULL utf8 utf8_general_ci enum('N','Y') >mysql.db Drop_priv 9 N NO enum 1 3 NULL NULL utf8 utf8_general_ci enum('N','Y') >mysql.db Grant_priv 10 N NO enum 1 3 NULL NULL utf8 utf8_general_ci enum('N','Y') >mysql.db References_priv 11 N NO enum 1 3 NULL NULL utf8 utf8_general_ci enum('N','Y') >mysql.db Index_priv 12 N NO enum 1 3 NULL NULL utf8 utf8_general_ci enum('N','Y') >mysql.db Alter_priv 13 N NO enum 1 3 NULL NULL utf8 utf8_general_ci enum('N','Y') >mysql.db Create_tmp_table_priv 14 N NO enum 1 3 NULL NULL utf8 utf8_general_ci enum('N','Y') >mysql.db Lock_tables_priv 15 N NO enum 1 3 NULL NULL utf8 utf8_general_ci enum('N','Y') >mysql.db Create_view_priv 16 N NO enum 1 3 NULL NULL utf8 utf8_general_ci enum('N','Y') >mysql.db Show_view_priv 17 N NO enum 1 3 NULL NULL utf8 utf8_general_ci enum('N','Y') >mysql.db Create_routine_priv 18 N NO enum 1 3 NULL NULL utf8 utf8_general_ci enum('N','Y') >mysql.db Alter_routine_priv 19 N NO enum 1 3 NULL NULL utf8 utf8_general_ci enum('N','Y') >mysql.db Execute_priv 20 N NO enum 1 3 NULL NULL utf8 utf8_general_ci enum('N','Y') >mysql.db Event_priv 21 N NO enum 1 3 NULL NULL utf8 utf8_general_ci enum('N','Y') >mysql.db Trigger_priv 22 N NO enum 1 3 NULL NULL utf8 utf8_general_ci enum('N','Y') >mysql.event db 1 NO char 64 192 NULL NULL utf8 utf8_bin char(64) PRI >mysql.event name 2 NO char 64 192 NULL NULL utf8 utf8_general_ci char(64) PRI >mysql.event body 3 NULL NO longblob 4294967295 4294967295 NULL NULL NULL NULL longblob >mysql.event definer 4 NO char 141 423 NULL NULL utf8 utf8_bin char(141) >mysql.event execute_at 5 NULL YES datetime NULL NULL NULL NULL NULL NULL datetime >mysql.event interval_value 6 NULL YES int NULL NULL 10 0 NULL NULL int(11) >mysql.event interval_field 7 NULL YES enum 18 54 NULL NULL utf8 utf8_general_ci enum('YEAR','QUARTER','MONTH','DAY','HOUR','MINUTE','WEEK','SECOND','MICROSECOND','YEAR_MONTH','DAY_HOUR','DAY_MINUTE','DAY_SECOND','HOUR_MINUTE','HOUR_SECOND','MINUTE_SECOND','DAY_MICROSECOND','HOUR_MICROSECOND','MINUTE_MICROSECOND','SECOND_MICROSECOND') >mysql.event created 8 CURRENT_TIMESTAMP NO timestamp NULL NULL NULL NULL NULL NULL timestamp on update CURRENT_TIMESTAMP >mysql.event modified 9 0000-00-00 00:00:00 NO timestamp NULL NULL NULL NULL NULL NULL timestamp >mysql.event last_executed 10 NULL YES datetime NULL NULL NULL NULL NULL NULL datetime >mysql.event starts 11 NULL YES datetime NULL NULL NULL NULL NULL NULL datetime >mysql.event ends 12 NULL YES datetime NULL NULL NULL NULL NULL NULL datetime >mysql.event status 13 ENABLED NO enum 18 54 NULL NULL utf8 utf8_general_ci enum('ENABLED','DISABLED','SLAVESIDE_DISABLED') >mysql.event on_completion 14 DROP NO enum 8 24 NULL NULL utf8 utf8_general_ci enum('DROP','PRESERVE') >mysql.event sql_mode 15 NO set 494 1482 NULL NULL utf8 utf8_general_ci set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','IGNORE_BAD_TABLE_OPTIONS','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH') >mysql.event comment 16 NO char 64 192 NULL NULL utf8 utf8_bin char(64) >mysql.event originator 17 NULL NO int NULL NULL 10 0 NULL NULL int(10) unsigned >mysql.event time_zone 18 SYSTEM NO char 64 64 NULL NULL latin1 latin1_swedish_ci char(64) >mysql.event character_set_client 19 NULL YES char 32 96 NULL NULL utf8 utf8_bin char(32) >mysql.event collation_connection 20 NULL YES char 32 96 NULL NULL utf8 utf8_bin char(32) >mysql.event db_collation 21 NULL YES char 32 96 NULL NULL utf8 utf8_bin char(32) >mysql.event body_utf8 22 NULL YES longblob 4294967295 4294967295 NULL NULL NULL NULL longblob >mysql.func name 1 NO char 64 192 NULL NULL utf8 utf8_bin char(64) PRI >mysql.func ret 2 0 NO tinyint NULL NULL 3 0 NULL NULL tinyint(1) >mysql.func dl 3 NO char 128 384 NULL NULL utf8 utf8_bin char(128) >mysql.func type 4 NULL NO enum 9 27 NULL NULL utf8 utf8_general_ci enum('function','aggregate') >mysql.general_log event_time 1 CURRENT_TIMESTAMP(6) NO timestamp NULL NULL NULL NULL NULL NULL timestamp(6) on update CURRENT_TIMESTAMP >mysql.general_log user_host 2 NULL NO mediumtext 16777215 16777215 NULL NULL utf8 utf8_general_ci mediumtext >mysql.general_log thread_id 3 NULL NO bigint NULL NULL 20 0 NULL NULL bigint(21) unsigned >mysql.general_log server_id 4 NULL NO int NULL NULL 10 0 NULL NULL int(10) unsigned >mysql.general_log command_type 5 NULL NO varchar 64 192 NULL NULL utf8 utf8_general_ci varchar(64) >mysql.general_log argument 6 NULL NO mediumtext 16777215 16777215 NULL NULL utf8 utf8_general_ci mediumtext >mysql.gtid_slave_pos domain_id 1 NULL NO int NULL NULL 10 0 NULL NULL int(10) unsigned PRI >mysql.gtid_slave_pos sub_id 2 NULL NO bigint NULL NULL 20 0 NULL NULL bigint(20) unsigned PRI >mysql.gtid_slave_pos server_id 3 NULL NO int NULL NULL 10 0 NULL NULL int(10) unsigned >mysql.gtid_slave_pos seq_no 4 NULL NO bigint NULL NULL 20 0 NULL NULL bigint(20) unsigned >mysql.help_category help_category_id 1 NULL NO smallint NULL NULL 5 0 NULL NULL smallint(5) unsigned PRI >mysql.help_category name 2 NULL NO char 64 192 NULL NULL utf8 utf8_general_ci char(64) UNI >mysql.help_category parent_category_id 3 NULL YES smallint NULL NULL 5 0 NULL NULL smallint(5) unsigned >mysql.help_category url 4 NULL NO text 65535 65535 NULL NULL utf8 utf8_general_ci text >mysql.help_keyword help_keyword_id 1 NULL NO int NULL NULL 10 0 NULL NULL int(10) unsigned PRI >mysql.help_keyword name 2 NULL NO char 64 192 NULL NULL utf8 utf8_general_ci char(64) UNI >mysql.help_relation help_topic_id 1 NULL NO int NULL NULL 10 0 NULL NULL int(10) unsigned PRI >mysql.help_relation help_keyword_id 2 NULL NO int NULL NULL 10 0 NULL NULL int(10) unsigned PRI >mysql.help_topic help_topic_id 1 NULL NO int NULL NULL 10 0 NULL NULL int(10) unsigned PRI >mysql.help_topic name 2 NULL NO char 64 192 NULL NULL utf8 utf8_general_ci char(64) UNI >mysql.help_topic help_category_id 3 NULL NO smallint NULL NULL 5 0 NULL NULL smallint(5) unsigned >mysql.help_topic description 4 NULL NO text 65535 65535 NULL NULL utf8 utf8_general_ci text >mysql.help_topic example 5 NULL NO text 65535 65535 NULL NULL utf8 utf8_general_ci text >mysql.help_topic url 6 NULL NO text 65535 65535 NULL NULL utf8 utf8_general_ci text >mysql.host Host 1 NO char 60 180 NULL NULL utf8 utf8_bin char(60) PRI >mysql.host Db 2 NO char 64 192 NULL NULL utf8 utf8_bin char(64) PRI >mysql.host Select_priv 3 N NO enum 1 3 NULL NULL utf8 utf8_general_ci enum('N','Y') >mysql.host Insert_priv 4 N NO enum 1 3 NULL NULL utf8 utf8_general_ci enum('N','Y') >mysql.host Update_priv 5 N NO enum 1 3 NULL NULL utf8 utf8_general_ci enum('N','Y') >mysql.host Delete_priv 6 N NO enum 1 3 NULL NULL utf8 utf8_general_ci enum('N','Y') >mysql.host Create_priv 7 N NO enum 1 3 NULL NULL utf8 utf8_general_ci enum('N','Y') >mysql.host Drop_priv 8 N NO enum 1 3 NULL NULL utf8 utf8_general_ci enum('N','Y') >mysql.host Grant_priv 9 N NO enum 1 3 NULL NULL utf8 utf8_general_ci enum('N','Y') >mysql.host References_priv 10 N NO enum 1 3 NULL NULL utf8 utf8_general_ci enum('N','Y') >mysql.host Index_priv 11 N NO enum 1 3 NULL NULL utf8 utf8_general_ci enum('N','Y') >mysql.host Alter_priv 12 N NO enum 1 3 NULL NULL utf8 utf8_general_ci enum('N','Y') >mysql.host Create_tmp_table_priv 13 N NO enum 1 3 NULL NULL utf8 utf8_general_ci enum('N','Y') >mysql.host Lock_tables_priv 14 N NO enum 1 3 NULL NULL utf8 utf8_general_ci enum('N','Y') >mysql.host Create_view_priv 15 N NO enum 1 3 NULL NULL utf8 utf8_general_ci enum('N','Y') >mysql.host Show_view_priv 16 N NO enum 1 3 NULL NULL utf8 utf8_general_ci enum('N','Y') >mysql.host Create_routine_priv 17 N NO enum 1 3 NULL NULL utf8 utf8_general_ci enum('N','Y') >mysql.host Alter_routine_priv 18 N NO enum 1 3 NULL NULL utf8 utf8_general_ci enum('N','Y') >mysql.host Execute_priv 19 N NO enum 1 3 NULL NULL utf8 utf8_general_ci enum('N','Y') >mysql.host Trigger_priv 20 N NO enum 1 3 NULL NULL utf8 utf8_general_ci enum('N','Y') >mysql.index_stats db_name 1 NULL NO varchar 64 192 NULL NULL utf8 utf8_bin varchar(64) PRI >mysql.index_stats table_name 2 NULL NO varchar 64 192 NULL NULL utf8 utf8_bin varchar(64) PRI >mysql.index_stats index_name 3 NULL NO varchar 64 192 NULL NULL utf8 utf8_bin varchar(64) PRI >mysql.index_stats prefix_arity 4 NULL NO int NULL NULL 10 0 NULL NULL int(11) unsigned PRI >mysql.index_stats avg_frequency 5 NULL YES decimal NULL NULL 12 4 NULL NULL decimal(12,4) >mysql.innodb_index_stats database_name 1 NULL NO varchar 64 192 NULL NULL utf8 utf8_bin varchar(64) PRI >mysql.innodb_index_stats table_name 2 NULL NO varchar 64 192 NULL NULL utf8 utf8_bin varchar(64) PRI >mysql.innodb_index_stats index_name 3 NULL NO varchar 64 192 NULL NULL utf8 utf8_bin varchar(64) PRI >mysql.innodb_index_stats last_update 4 CURRENT_TIMESTAMP NO timestamp NULL NULL NULL NULL NULL NULL timestamp on update CURRENT_TIMESTAMP >mysql.innodb_index_stats stat_name 5 NULL NO varchar 64 192 NULL NULL utf8 utf8_bin varchar(64) PRI >mysql.innodb_index_stats stat_value 6 NULL NO bigint NULL NULL 20 0 NULL NULL bigint(20) unsigned >mysql.innodb_index_stats sample_size 7 NULL YES bigint NULL NULL 20 0 NULL NULL bigint(20) unsigned >mysql.innodb_index_stats stat_description 8 NULL NO varchar 1024 3072 NULL NULL utf8 utf8_bin varchar(1024) >mysql.innodb_table_stats database_name 1 NULL NO varchar 64 192 NULL NULL utf8 utf8_bin varchar(64) PRI >mysql.innodb_table_stats table_name 2 NULL NO varchar 64 192 NULL NULL utf8 utf8_bin varchar(64) PRI >mysql.innodb_table_stats last_update 3 CURRENT_TIMESTAMP NO timestamp NULL NULL NULL NULL NULL NULL timestamp on update CURRENT_TIMESTAMP >mysql.innodb_table_stats n_rows 4 NULL NO bigint NULL NULL 20 0 NULL NULL bigint(20) unsigned >mysql.innodb_table_stats clustered_index_size 5 NULL NO bigint NULL NULL 20 0 NULL NULL bigint(20) unsigned >mysql.innodb_table_stats sum_of_other_index_sizes 6 NULL NO bigint NULL NULL 20 0 NULL NULL bigint(20) unsigned >mysql.plugin name 1 NO varchar 64 192 NULL NULL utf8 utf8_general_ci varchar(64) PRI >mysql.plugin dl 2 NO varchar 128 384 NULL NULL utf8 utf8_general_ci varchar(128) >mysql.proc db 1 NO char 64 192 NULL NULL utf8 utf8_bin char(64) PRI >mysql.proc name 2 NO char 64 192 NULL NULL utf8 utf8_general_ci char(64) PRI >mysql.proc type 3 NULL NO enum 9 27 NULL NULL utf8 utf8_general_ci enum('FUNCTION','PROCEDURE') PRI >mysql.proc specific_name 4 NO char 64 192 NULL NULL utf8 utf8_general_ci char(64) >mysql.proc language 5 SQL NO enum 3 9 NULL NULL utf8 utf8_general_ci enum('SQL') >mysql.proc sql_data_access 6 CONTAINS_SQL NO enum 17 51 NULL NULL utf8 utf8_general_ci enum('CONTAINS_SQL','NO_SQL','READS_SQL_DATA','MODIFIES_SQL_DATA') >mysql.proc is_deterministic 7 NO NO enum 3 9 NULL NULL utf8 utf8_general_ci enum('YES','NO') >mysql.proc security_type 8 DEFINER NO enum 7 21 NULL NULL utf8 utf8_general_ci enum('INVOKER','DEFINER') >mysql.proc param_list 9 NULL NO blob 65535 65535 NULL NULL NULL NULL blob >mysql.proc returns 10 NULL NO longblob 4294967295 4294967295 NULL NULL NULL NULL longblob >mysql.proc body 11 NULL NO longblob 4294967295 4294967295 NULL NULL NULL NULL longblob >mysql.proc definer 12 NO char 141 423 NULL NULL utf8 utf8_bin char(141) >mysql.proc created 13 CURRENT_TIMESTAMP NO timestamp NULL NULL NULL NULL NULL NULL timestamp on update CURRENT_TIMESTAMP >mysql.proc modified 14 0000-00-00 00:00:00 NO timestamp NULL NULL NULL NULL NULL NULL timestamp >mysql.proc sql_mode 15 NO set 494 1482 NULL NULL utf8 utf8_general_ci set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','IGNORE_BAD_TABLE_OPTIONS','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH') >mysql.proc comment 16 NULL NO text 65535 65535 NULL NULL utf8 utf8_bin text >mysql.proc character_set_client 17 NULL YES char 32 96 NULL NULL utf8 utf8_bin char(32) >mysql.proc collation_connection 18 NULL YES char 32 96 NULL NULL utf8 utf8_bin char(32) >mysql.proc db_collation 19 NULL YES char 32 96 NULL NULL utf8 utf8_bin char(32) >mysql.proc body_utf8 20 NULL YES longblob 4294967295 4294967295 NULL NULL NULL NULL longblob >mysql.procs_priv Host 1 NO char 60 180 NULL NULL utf8 utf8_bin char(60) PRI >mysql.procs_priv Db 2 NO char 64 192 NULL NULL utf8 utf8_bin char(64) PRI >mysql.procs_priv User 3 NO char 80 240 NULL NULL utf8 utf8_bin char(80) PRI >mysql.procs_priv Routine_name 4 NO char 64 192 NULL NULL utf8 utf8_general_ci char(64) PRI >mysql.procs_priv Routine_type 5 NULL NO enum 9 27 NULL NULL utf8 utf8_bin enum('FUNCTION','PROCEDURE') PRI >mysql.procs_priv Grantor 6 NO char 141 423 NULL NULL utf8 utf8_bin char(141) MUL >mysql.procs_priv Proc_priv 7 NO set 27 81 NULL NULL utf8 utf8_general_ci set('Execute','Alter Routine','Grant') >mysql.procs_priv Timestamp 8 CURRENT_TIMESTAMP NO timestamp NULL NULL NULL NULL NULL NULL timestamp on update CURRENT_TIMESTAMP >mysql.proxies_priv Host 1 NO char 60 180 NULL NULL utf8 utf8_bin char(60) PRI >mysql.proxies_priv User 2 NO char 80 240 NULL NULL utf8 utf8_bin char(80) PRI >mysql.proxies_priv Proxied_host 3 NO char 60 180 NULL NULL utf8 utf8_bin char(60) PRI >mysql.proxies_priv Proxied_user 4 NO char 80 240 NULL NULL utf8 utf8_bin char(80) PRI >mysql.proxies_priv With_grant 5 0 NO tinyint NULL NULL 3 0 NULL NULL tinyint(1) >mysql.proxies_priv Grantor 6 NO char 141 423 NULL NULL utf8 utf8_bin char(141) MUL >mysql.proxies_priv Timestamp 7 CURRENT_TIMESTAMP NO timestamp NULL NULL NULL NULL NULL NULL timestamp on update CURRENT_TIMESTAMP >mysql.roles_mapping Host 1 NO char 60 180 NULL NULL utf8 utf8_bin char(60) PRI >mysql.roles_mapping User 2 NO char 80 240 NULL NULL utf8 utf8_bin char(80) PRI >mysql.roles_mapping Role 3 NO char 80 240 NULL NULL utf8 utf8_bin char(80) PRI >mysql.roles_mapping Admin_option 4 N NO enum 1 3 NULL NULL utf8 utf8_general_ci enum('N','Y') >mysql.servers Server_name 1 NO char 64 192 NULL NULL utf8 utf8_general_ci char(64) PRI >mysql.servers Host 2 NO char 64 192 NULL NULL utf8 utf8_general_ci char(64) >mysql.servers Db 3 NO char 64 192 NULL NULL utf8 utf8_general_ci char(64) >mysql.servers Username 4 NO char 80 240 NULL NULL utf8 utf8_general_ci char(80) >mysql.servers Password 5 NO char 64 192 NULL NULL utf8 utf8_general_ci char(64) >mysql.servers Port 6 0 NO int NULL NULL 10 0 NULL NULL int(4) >mysql.servers Socket 7 NO char 64 192 NULL NULL utf8 utf8_general_ci char(64) >mysql.servers Wrapper 8 NO char 64 192 NULL NULL utf8 utf8_general_ci char(64) >mysql.servers Owner 9 NO char 64 192 NULL NULL utf8 utf8_general_ci char(64) >mysql.slow_log start_time 1 CURRENT_TIMESTAMP(6) NO timestamp NULL NULL NULL NULL NULL NULL timestamp(6) on update CURRENT_TIMESTAMP >mysql.slow_log user_host 2 NULL NO mediumtext 16777215 16777215 NULL NULL utf8 utf8_general_ci mediumtext >mysql.slow_log query_time 3 NULL NO time NULL NULL NULL NULL NULL NULL time(6) >mysql.slow_log lock_time 4 NULL NO time NULL NULL NULL NULL NULL NULL time(6) >mysql.slow_log rows_sent 5 NULL NO int NULL NULL 10 0 NULL NULL int(11) >mysql.slow_log rows_examined 6 NULL NO int NULL NULL 10 0 NULL NULL int(11) >mysql.slow_log db 7 NULL NO varchar 512 1536 NULL NULL utf8 utf8_general_ci varchar(512) >mysql.slow_log last_insert_id 8 NULL NO int NULL NULL 10 0 NULL NULL int(11) >mysql.slow_log insert_id 9 NULL NO int NULL NULL 10 0 NULL NULL int(11) >mysql.slow_log server_id 10 NULL NO int NULL NULL 10 0 NULL NULL int(10) unsigned >mysql.slow_log sql_text 11 NULL NO mediumtext 16777215 16777215 NULL NULL utf8 utf8_general_ci mediumtext >mysql.slow_log thread_id 12 NULL NO bigint NULL NULL 20 0 NULL NULL bigint(21) unsigned >mysql.slow_log rows_affected 13 NULL NO int NULL NULL 10 0 NULL NULL int(11) >mysql.tables_priv Host 1 NO char 60 180 NULL NULL utf8 utf8_bin char(60) PRI >mysql.tables_priv Db 2 NO char 64 192 NULL NULL utf8 utf8_bin char(64) PRI >mysql.tables_priv User 3 NO char 80 240 NULL NULL utf8 utf8_bin char(80) PRI >mysql.tables_priv Table_name 4 NO char 64 192 NULL NULL utf8 utf8_bin char(64) PRI >mysql.tables_priv Grantor 5 NO char 141 423 NULL NULL utf8 utf8_bin char(141) MUL >mysql.tables_priv Timestamp 6 CURRENT_TIMESTAMP NO timestamp NULL NULL NULL NULL NULL NULL timestamp on update CURRENT_TIMESTAMP >mysql.tables_priv Table_priv 7 NO set 98 294 NULL NULL utf8 utf8_general_ci set('Select','Insert','Update','Delete','Create','Drop','Grant','References','Index','Alter','Create View','Show view','Trigger') >mysql.tables_priv Column_priv 8 NO set 31 93 NULL NULL utf8 utf8_general_ci set('Select','Insert','Update','References') >mysql.table_stats db_name 1 NULL NO varchar 64 192 NULL NULL utf8 utf8_bin varchar(64) PRI >mysql.table_stats table_name 2 NULL NO varchar 64 192 NULL NULL utf8 utf8_bin varchar(64) PRI >mysql.table_stats cardinality 3 NULL YES bigint NULL NULL 20 0 NULL NULL bigint(21) unsigned >mysql.time_zone Time_zone_id 1 NULL NO int NULL NULL 10 0 NULL NULL int(10) unsigned PRI auto_increment >mysql.time_zone Use_leap_seconds 2 N NO enum 1 3 NULL NULL utf8 utf8_general_ci enum('Y','N') >mysql.time_zone_leap_second Transition_time 1 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) PRI >mysql.time_zone_leap_second Correction 2 NULL NO int NULL NULL 10 0 NULL NULL int(11) >mysql.time_zone_name Name 1 NULL NO char 64 192 NULL NULL utf8 utf8_general_ci char(64) PRI >mysql.time_zone_name Time_zone_id 2 NULL NO int NULL NULL 10 0 NULL NULL int(10) unsigned >mysql.time_zone_transition Time_zone_id 1 NULL NO int NULL NULL 10 0 NULL NULL int(10) unsigned PRI >mysql.time_zone_transition Transition_time 2 NULL NO bigint NULL NULL 19 0 NULL NULL bigint(20) PRI >mysql.time_zone_transition Transition_type_id 3 NULL NO int NULL NULL 10 0 NULL NULL int(10) unsigned >mysql.time_zone_transition_type Time_zone_id 1 NULL NO int NULL NULL 10 0 NULL NULL int(10) unsigned PRI >mysql.time_zone_transition_type Transition_type_id 2 NULL NO int NULL NULL 10 0 NULL NULL int(10) unsigned PRI >mysql.time_zone_transition_type Offset 3 0 NO int NULL NULL 10 0 NULL NULL int(11) >mysql.time_zone_transition_type Is_DST 4 0 NO tinyint NULL NULL 3 0 NULL NULL tinyint(3) unsigned >mysql.time_zone_transition_type Abbreviation 5 NO char 8 24 NULL NULL utf8 utf8_general_ci char(8) >mysql.user Host 1 NO char 60 180 NULL NULL utf8 utf8_bin char(60) PRI >mysql.user User 2 NO char 80 240 NULL NULL utf8 utf8_bin char(80) PRI >mysql.user Password 3 NO char 41 41 NULL NULL latin1 latin1_bin char(41) >mysql.user Select_priv 4 N NO enum 1 3 NULL NULL utf8 utf8_general_ci enum('N','Y') >mysql.user Insert_priv 5 N NO enum 1 3 NULL NULL utf8 utf8_general_ci enum('N','Y') >mysql.user Update_priv 6 N NO enum 1 3 NULL NULL utf8 utf8_general_ci enum('N','Y') >mysql.user Delete_priv 7 N NO enum 1 3 NULL NULL utf8 utf8_general_ci enum('N','Y') >mysql.user Create_priv 8 N NO enum 1 3 NULL NULL utf8 utf8_general_ci enum('N','Y') >mysql.user Drop_priv 9 N NO enum 1 3 NULL NULL utf8 utf8_general_ci enum('N','Y') >mysql.user Reload_priv 10 N NO enum 1 3 NULL NULL utf8 utf8_general_ci enum('N','Y') >mysql.user Shutdown_priv 11 N NO enum 1 3 NULL NULL utf8 utf8_general_ci enum('N','Y') >mysql.user Process_priv 12 N NO enum 1 3 NULL NULL utf8 utf8_general_ci enum('N','Y') >mysql.user File_priv 13 N NO enum 1 3 NULL NULL utf8 utf8_general_ci enum('N','Y') >mysql.user Grant_priv 14 N NO enum 1 3 NULL NULL utf8 utf8_general_ci enum('N','Y') >mysql.user References_priv 15 N NO enum 1 3 NULL NULL utf8 utf8_general_ci enum('N','Y') >mysql.user Index_priv 16 N NO enum 1 3 NULL NULL utf8 utf8_general_ci enum('N','Y') >mysql.user Alter_priv 17 N NO enum 1 3 NULL NULL utf8 utf8_general_ci enum('N','Y') >mysql.user Show_db_priv 18 N NO enum 1 3 NULL NULL utf8 utf8_general_ci enum('N','Y') >mysql.user Super_priv 19 N NO enum 1 3 NULL NULL utf8 utf8_general_ci enum('N','Y') >mysql.user Create_tmp_table_priv 20 N NO enum 1 3 NULL NULL utf8 utf8_general_ci enum('N','Y') >mysql.user Lock_tables_priv 21 N NO enum 1 3 NULL NULL utf8 utf8_general_ci enum('N','Y') >mysql.user Execute_priv 22 N NO enum 1 3 NULL NULL utf8 utf8_general_ci enum('N','Y') >mysql.user Repl_slave_priv 23 N NO enum 1 3 NULL NULL utf8 utf8_general_ci enum('N','Y') >mysql.user Repl_client_priv 24 N NO enum 1 3 NULL NULL utf8 utf8_general_ci enum('N','Y') >mysql.user Create_view_priv 25 N NO enum 1 3 NULL NULL utf8 utf8_general_ci enum('N','Y') >mysql.user Show_view_priv 26 N NO enum 1 3 NULL NULL utf8 utf8_general_ci enum('N','Y') >mysql.user Create_routine_priv 27 N NO enum 1 3 NULL NULL utf8 utf8_general_ci enum('N','Y') >mysql.user Alter_routine_priv 28 N NO enum 1 3 NULL NULL utf8 utf8_general_ci enum('N','Y') >mysql.user Create_user_priv 29 N NO enum 1 3 NULL NULL utf8 utf8_general_ci enum('N','Y') >mysql.user Event_priv 30 N NO enum 1 3 NULL NULL utf8 utf8_general_ci enum('N','Y') >mysql.user Trigger_priv 31 N NO enum 1 3 NULL NULL utf8 utf8_general_ci enum('N','Y') >mysql.user Create_tablespace_priv 32 N NO enum 1 3 NULL NULL utf8 utf8_general_ci enum('N','Y') >mysql.user ssl_type 33 NO enum 9 27 NULL NULL utf8 utf8_general_ci enum('','ANY','X509','SPECIFIED') >mysql.user ssl_cipher 34 NULL NO blob 65535 65535 NULL NULL NULL NULL blob >mysql.user x509_issuer 35 NULL NO blob 65535 65535 NULL NULL NULL NULL blob >mysql.user x509_subject 36 NULL NO blob 65535 65535 NULL NULL NULL NULL blob >mysql.user max_questions 37 0 NO int NULL NULL 10 0 NULL NULL int(11) unsigned >mysql.user max_updates 38 0 NO int NULL NULL 10 0 NULL NULL int(11) unsigned >mysql.user max_connections 39 0 NO int NULL NULL 10 0 NULL NULL int(11) unsigned >mysql.user max_user_connections 40 0 NO int NULL NULL 10 0 NULL NULL int(11) >mysql.user plugin 41 NO char 64 64 NULL NULL latin1 latin1_swedish_ci char(64) >mysql.user authentication_string 42 NULL NO text 65535 65535 NULL NULL utf8 utf8_bin text >mysql.user password_expired 43 N NO enum 1 3 NULL NULL utf8 utf8_general_ci enum('N','Y') >mysql.user is_role 44 N NO enum 1 3 NULL NULL utf8 utf8_general_ci enum('N','Y') >mysql.user default_role 45 NO char 80 240 NULL NULL utf8 utf8_bin char(80) >mysql.user max_statement_time 46 0.000000 NO decimal NULL NULL 12 6 NULL NULL decimal(12,6) >EVENT_CATALOG EVENT_SCHEMA EVENT_NAME DEFINER TIME_ZONE EVENT_BODY EVENT_DEFINITION EVENT_TYPE EXECUTE_AT INTERVAL_VALUE INTERVAL_FIELD SQL_MODE STARTS ENDS STATUS ON_COMPLETION CREATED LAST_ALTERED LAST_EXECUTED EVENT_COMMENT ORIGINATOR CHARACTER_SET_CLIENT COLLATION_CONNECTION DATABASE_COLLATION >TRIGGER_CATALOG TRIGGER_SCHEMA TRIGGER_NAME EVENT_MANIPULATION EVENT_OBJECT_CATALOG EVENT_OBJECT_SCHEMA EVENT_OBJECT_TABLE ACTION_ORDER ACTION_CONDITION ACTION_STATEMENT ACTION_ORIENTATION ACTION_TIMING ACTION_REFERENCE_OLD_TABLE ACTION_REFERENCE_NEW_TABLE ACTION_REFERENCE_OLD_ROW ACTION_REFERENCE_NEW_ROW CREATED SQL_MODE DEFINER CHARACTER_SET_CLIENT COLLATION_CONNECTION DATABASE_COLLATION >SPECIFIC_NAME ROUTINE_CATALOG ROUTINE_SCHEMA ROUTINE_NAME ROUTINE_TYPE DATA_TYPE CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH NUMERIC_PRECISION NUMERIC_SCALE DATETIME_PRECISION CHARACTER_SET_NAME COLLATION_NAME DTD_IDENTIFIER ROUTINE_BODY ROUTINE_DEFINITION EXTERNAL_NAME EXTERNAL_LANGUAGE PARAMETER_STYLE IS_DETERMINISTIC SQL_DATA_ACCESS SQL_PATH SECURITY_TYPE CREATED LAST_ALTERED SQL_MODE ROUTINE_COMMENT DEFINER CHARACTER_SET_CLIENT COLLATION_CONNECTION DATABASE_COLLATION >add_suppression def mtr add_suppression PROCEDURE NULL NULL NULL NULL NULL NULL NULL NULL SQL BEGIN INSERT INTO test_suppressions (pattern) VALUES (pattern); FLUSH NO_WRITE_TO_BINLOG TABLE test_suppressions; END NULL NULL SQL NO CONTAINS SQL NULL DEFINER 2019-03-12 13:44:22 2019-03-12 13:44:22 root@localhost utf8 utf8_general_ci latin1_swedish_ci >check_testcase def mtr check_testcase PROCEDURE NULL NULL NULL NULL NULL NULL NULL NULL SQL BEGIN SELECT * FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE variable_name NOT IN ('timestamp', 'innodb_file_format_max') AND variable_name not like "Last_IO_Err*" AND variable_name != 'INNODB_IBUF_MAX_SIZE' AND variable_name != 'INNODB_USE_NATIVE_AIO' AND variable_name not like 'GTID%POS' AND variable_name != 'GTID_BINLOG_STATE' ORDER BY variable_name; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA; SELECT * FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME NOT IN ('mtr_wsrep_notify', 'wsrep_schema'); SELECT table_name AS tables_in_test FROM INFORMATION_SCHEMA.TABLES WHERE table_schema='test'; SELECT CONCAT(table_schema, '.', table_name) AS tables_in_mysql FROM INFORMATION_SCHEMA.TABLES WHERE table_schema='mysql' ORDER BY tables_in_mysql; SELECT CONCAT(table_schema, '.', table_name) AS columns_in_mysql, column_name, ordinal_position, column_default, is_nullable, data_type, character_maximum_length, character_octet_length, numeric_precision, numeric_scale, character_set_name, collation_name, column_type, column_key, extra, column_comment FROM INFORMATION_SCHEMA.COLUMNS WHERE table_schema='mysql' ORDER BY columns_in_mysql; SELECT * FROM INFORMATION_SCHEMA.EVENTS; SELECT * FROM INFORMATION_SCHEMA.TRIGGERS WHERE TRIGGER_NAME NOT IN ('gs_insert', 'ts_insert'); SELECT * FROM INFORMATION_SCHEMA.ROUTINES; SHOW STATUS LIKE 'slave_open_temp_tables'; checksum table mysql.columns_priv, mysql.db, mysql.func, mysql.help_category, mysql.help_keyword, mysql.help_relation, mysql.host, mysql.plugin, mysql.proc, mysql.procs_priv, mysql.roles_mapping, mysql.tables_priv, mysql.time_zone, mysql.time_zone_leap_second, mysql.time_zone_name, mysql.time_zone_transition, mysql.time_zone_transition_type, mysql.user; SELECT * FROM INFORMATION_SCHEMA.PLUGINS; select * from information_schema.session_variables where variable_name = 'debug_sync'; END NULL NULL SQL NO CONTAINS SQL NULL DEFINER 2019-03-12 13:44:22 2019-03-12 13:44:22 root@localhost utf8 utf8_general_ci latin1_swedish_ci >check_warnings def mtr check_warnings PROCEDURE NULL NULL NULL NULL NULL NULL NULL NULL SQL BEGIN DECLARE `pos` bigint unsigned; SET SQL_LOG_BIN=0; UPDATE error_log el, global_suppressions gs SET suspicious=0 WHERE el.suspicious=1 AND el.line REGEXP gs.pattern; UPDATE error_log el, test_suppressions ts SET suspicious=0 WHERE el.suspicious=1 AND el.line REGEXP ts.pattern; SELECT COUNT(*) INTO @num_warnings FROM error_log WHERE suspicious=1; IF @num_warnings > 0 THEN SELECT line FROM error_log WHERE suspicious=1; SELECT 2 INTO result; ELSE SELECT 0 INTO RESULT; END IF; TRUNCATE test_suppressions; DROP TABLE error_log; END NULL NULL SQL NO CONTAINS SQL NULL DEFINER 2019-03-12 13:44:22 2019-03-12 13:44:22 root@localhost utf8 utf8_general_ci latin1_swedish_ci >Variable_name Value >Slave_open_temp_tables 0 >Table Checksum >mysql.columns_priv 0 >mysql.db 757413194 >mysql.func 0 >mysql.help_category 3825230053 >mysql.help_keyword 2852638618 >mysql.help_relation 1430273680 >mysql.host 0 >mysql.plugin 0 >mysql.proc 1224208439 >mysql.procs_priv 0 >mysql.roles_mapping 0 >mysql.tables_priv 0 >mysql.time_zone 2420313365 >mysql.time_zone_leap_second 3799112081 >mysql.time_zone_name 2268956709 >mysql.time_zone_transition 3895294076 >mysql.time_zone_transition_type 168184411 >mysql.user 46898821 >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 100137.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.1 NULL NULL R.J.Silk, Sergei Golubchik Native MySQL authentication GPL FORCE Stable 1.0 >mysql_old_password 1.0 ACTIVE AUTHENTICATION 2.1 NULL NULL R.J.Silk, Sergei Golubchik Old MySQL-4.0 authentication GPL FORCE Stable 1.0 >CSV 1.0 ACTIVE STORAGE ENGINE 100137.0 NULL NULL Brian Aker, MySQL AB Stores tables as CSV files GPL FORCE Stable 1.0 >MEMORY 1.0 ACTIVE STORAGE ENGINE 100137.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 100137.0 NULL NULL MySQL AB Non-transactional engine with good performance and small data footprint GPL FORCE Stable 1.0 >MRG_MyISAM 1.0 ACTIVE STORAGE ENGINE 100137.0 NULL NULL MySQL AB Collection of identical MyISAM tables GPL FORCE Stable 1.0 >CLIENT_STATISTICS 2.0 ACTIVE INFORMATION SCHEMA 100137.0 NULL NULL Percona and Sergei Golubchik Client Statistics GPL FORCE Stable 2.0 >INDEX_STATISTICS 2.0 ACTIVE INFORMATION SCHEMA 100137.0 NULL NULL Percona and Sergei Golubchik Index Statistics GPL FORCE Stable 2.0 >TABLE_STATISTICS 2.0 ACTIVE INFORMATION SCHEMA 100137.0 NULL NULL Percona and Sergei Golubchik Table Statistics GPL FORCE Stable 2.0 >USER_STATISTICS 2.0 ACTIVE INFORMATION SCHEMA 100137.0 NULL NULL Percona and Sergei Golubchik User Statistics GPL FORCE Stable 2.0 >ARCHIVE 3.0 DISABLED STORAGE ENGINE 100137.0 NULL NULL Brian Aker, MySQL AB gzip-compresses tables for a low storage footprint GPL OFF Stable 1.0 >BLACKHOLE 1.0 DISABLED STORAGE ENGINE 100137.0 NULL NULL MySQL AB /dev/null storage engine (anything you write to it disappears) GPL OFF Stable 1.0 >CONNECT 1.7 DISABLED STORAGE ENGINE 100137.0 NULL NULL Olivier Bertrand Management of External Data (SQL/NOSQL/MED), including many file formats GPL OFF Stable 1.06.0008 >Aria 1.5 ACTIVE STORAGE ENGINE 100137.0 NULL NULL Monty Program Ab Crash-safe tables with MyISAM heritage GPL ON Stable 1.5 >PERFORMANCE_SCHEMA 0.1 ACTIVE STORAGE ENGINE 100137.0 NULL NULL Marc Alff, Oracle Performance Schema GPL FORCE Stable 5.6.40 >SEQUENCE 1.0 DISABLED STORAGE ENGINE 100137.0 NULL NULL Sergei Golubchik Generated tables filled with sequential values GPL OFF Stable 0.1 >XTRADB_READ_VIEW 5.6 DISABLED INFORMATION SCHEMA 100137.0 NULL NULL Percona Inc. InnoDB Read View information GPL OFF Stable 5.6.41-84.1 >XTRADB_INTERNAL_HASH_TABLES 5.6 DISABLED INFORMATION SCHEMA 100137.0 NULL NULL Percona Inc. InnoDB internal hash tables information GPL OFF Stable 5.6.41-84.1 >XTRADB_RSEG 5.6 DISABLED INFORMATION SCHEMA 100137.0 NULL NULL Percona Inc. InnoDB rollback segment information GPL OFF Stable 5.6.41-84.1 >CHANGED_PAGE_BITMAPS 5.6 DISABLED INFORMATION SCHEMA 100137.0 NULL NULL MariaDB Corporation XtraDB dummy changed_page_bitmaps table GPL OFF Stable 5.6.41-84.1 >FEEDBACK 1.1 DISABLED INFORMATION SCHEMA 100137.0 NULL NULL Sergei Golubchik MariaDB User Feedback Plugin GPL OFF Stable 1.1 >partition 1.0 DISABLED STORAGE ENGINE 100137.0 NULL NULL Mikael Ronstrom, MySQL AB Partition Storage Engine Helper GPL OFF Stable 1.0 >InnoDB 5.6 ACTIVE STORAGE ENGINE 100137.0 ha_innodb.so 1.13 Oracle Corporation Supports transactions, row-level locking, foreign keys and encryption for tables GPL ON Stable 5.6.42 >INNODB_TRX 5.6 ACTIVE INFORMATION SCHEMA 100137.0 ha_innodb.so 1.13 Oracle Corporation InnoDB transactions GPL ON Stable 5.6.42 >INNODB_LOCKS 5.6 ACTIVE INFORMATION SCHEMA 100137.0 ha_innodb.so 1.13 Oracle Corporation InnoDB conflicting locks GPL ON Stable 5.6.42 >INNODB_LOCK_WAITS 5.6 DISABLED INFORMATION SCHEMA 100137.0 ha_innodb.so 1.13 Oracle Corporation InnoDB which lock is blocking which GPL OFF Stable 5.6.42 >INNODB_CMP 5.6 DISABLED INFORMATION SCHEMA 100137.0 ha_innodb.so 1.13 Oracle Corporation Statistics for the InnoDB compression GPL OFF Stable 5.6.42 >INNODB_CMP_RESET 5.6 DISABLED INFORMATION SCHEMA 100137.0 ha_innodb.so 1.13 Oracle Corporation Statistics for the InnoDB compression; reset cumulated counts GPL OFF Stable 5.6.42 >INNODB_CMPMEM 5.6 ACTIVE INFORMATION SCHEMA 100137.0 ha_innodb.so 1.13 Oracle Corporation Statistics for the InnoDB compressed buffer pool GPL ON Stable 5.6.42 >INNODB_CMPMEM_RESET 5.6 DISABLED INFORMATION SCHEMA 100137.0 ha_innodb.so 1.13 Oracle Corporation Statistics for the InnoDB compressed buffer pool; reset cumulated counts GPL OFF Stable 5.6.42 >INNODB_CMP_PER_INDEX 5.6 ACTIVE INFORMATION SCHEMA 100137.0 ha_innodb.so 1.13 Oracle Corporation Statistics for the InnoDB compression (per index) GPL ON Stable 5.6.42 >INNODB_CMP_PER_INDEX_RESET 5.6 DISABLED INFORMATION SCHEMA 100137.0 ha_innodb.so 1.13 Oracle Corporation Statistics for the InnoDB compression (per index); reset cumulated counts GPL OFF Stable 5.6.42 >INNODB_BUFFER_PAGE 5.6 ACTIVE INFORMATION SCHEMA 100137.0 ha_innodb.so 1.13 Oracle Corporation InnoDB Buffer Page Information GPL ON Stable 5.6.42 >INNODB_BUFFER_PAGE_LRU 5.6 ACTIVE INFORMATION SCHEMA 100137.0 ha_innodb.so 1.13 Oracle Corporation InnoDB Buffer Page in LRU GPL ON Stable 5.6.42 >INNODB_BUFFER_POOL_STATS 5.6 ACTIVE INFORMATION SCHEMA 100137.0 ha_innodb.so 1.13 Oracle Corporation InnoDB Buffer Pool Statistics Information GPL ON Stable 5.6.42 >INNODB_METRICS 5.6 ACTIVE INFORMATION SCHEMA 100137.0 ha_innodb.so 1.13 Oracle Corporation InnoDB Metrics Info GPL ON Stable 5.6.42 >INNODB_FT_DEFAULT_STOPWORD 5.6 DISABLED INFORMATION SCHEMA 100137.0 ha_innodb.so 1.13 Oracle Corporation Default stopword list for InnoDB Full Text Search GPL OFF Stable 5.6.42 >INNODB_FT_DELETED 5.6 DISABLED INFORMATION SCHEMA 100137.0 ha_innodb.so 1.13 Oracle Corporation INNODB AUXILIARY FTS DELETED TABLE GPL OFF Stable 5.6.42 >INNODB_FT_BEING_DELETED 5.6 DISABLED INFORMATION SCHEMA 100137.0 ha_innodb.so 1.13 Oracle Corporation INNODB AUXILIARY FTS BEING DELETED TABLE GPL OFF Stable 5.6.42 >INNODB_FT_CONFIG 5.6 DISABLED INFORMATION SCHEMA 100137.0 ha_innodb.so 1.13 Oracle Corporation INNODB AUXILIARY FTS CONFIG TABLE GPL OFF Stable 5.6.42 >INNODB_FT_INDEX_CACHE 5.6 DISABLED INFORMATION SCHEMA 100137.0 ha_innodb.so 1.13 Oracle Corporation INNODB AUXILIARY FTS INDEX CACHED GPL OFF Stable 5.6.42 >INNODB_FT_INDEX_TABLE 5.6 DISABLED INFORMATION SCHEMA 100137.0 ha_innodb.so 1.13 Oracle Corporation INNODB AUXILIARY FTS INDEX TABLE GPL OFF Stable 5.6.42 >INNODB_SYS_TABLES 5.6 ACTIVE INFORMATION SCHEMA 100137.0 ha_innodb.so 1.13 Oracle Corporation InnoDB SYS_TABLES GPL ON Stable 5.6.42 >INNODB_SYS_TABLESTATS 5.6 DISABLED INFORMATION SCHEMA 100137.0 ha_innodb.so 1.13 Oracle Corporation InnoDB SYS_TABLESTATS GPL OFF Stable 5.6.42 >INNODB_SYS_INDEXES 5.6 DISABLED INFORMATION SCHEMA 100137.0 ha_innodb.so 1.13 Oracle Corporation InnoDB SYS_INDEXES GPL OFF Stable 5.6.42 >INNODB_SYS_COLUMNS 5.6 DISABLED INFORMATION SCHEMA 100137.0 ha_innodb.so 1.13 Oracle Corporation InnoDB SYS_COLUMNS GPL OFF Stable 5.6.42 >INNODB_SYS_FIELDS 5.6 DISABLED INFORMATION SCHEMA 100137.0 ha_innodb.so 1.13 Oracle Corporation InnoDB SYS_FIELDS GPL OFF Stable 5.6.42 >INNODB_SYS_FOREIGN 5.6 ACTIVE INFORMATION SCHEMA 100137.0 ha_innodb.so 1.13 Oracle Corporation InnoDB SYS_FOREIGN GPL ON Stable 5.6.42 >INNODB_SYS_FOREIGN_COLS 5.6 ACTIVE INFORMATION SCHEMA 100137.0 ha_innodb.so 1.13 Oracle Corporation InnoDB SYS_FOREIGN_COLS GPL ON Stable 5.6.42 >INNODB_SYS_TABLESPACES 5.6 DISABLED INFORMATION SCHEMA 100137.0 ha_innodb.so 1.13 Oracle Corporation InnoDB SYS_TABLESPACES GPL OFF Stable 5.6.42 >INNODB_SYS_DATAFILES 5.6 DISABLED INFORMATION SCHEMA 100137.0 ha_innodb.so 1.13 Oracle Corporation InnoDB SYS_DATAFILES GPL OFF Stable 5.6.42 >INNODB_MUTEXES 5.6 DISABLED INFORMATION SCHEMA 100137.0 ha_innodb.so 1.13 Oracle Corporation InnoDB SYS_DATAFILES GPL OFF Stable 5.6.42 >INNODB_SYS_SEMAPHORE_WAITS 5.6 DISABLED INFORMATION SCHEMA 100137.0 ha_innodb.so 1.13 MariaDB Corporation InnoDB SYS_SEMAPHORE_WAITS GPL OFF Stable 5.6.42 >INNODB_TABLESPACES_ENCRYPTION 5.6 DISABLED INFORMATION SCHEMA 100137.0 ha_innodb.so 1.13 Google Inc InnoDB TABLESPACES_ENCRYPTION BSD OFF Stable 5.6.42 >INNODB_TABLESPACES_SCRUBBING 5.6 DISABLED INFORMATION SCHEMA 100137.0 ha_innodb.so 1.13 Google Inc InnoDB TABLESPACES_SCRUBBING BSD OFF Stable 5.6.42 >VARIABLE_NAME VARIABLE_VALUE
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Raw
Actions:
View
Attachments on
bug 680124
:
568760
|
568762
|
568764
| 568766