Anomalies


Things that might not be 'quite right' about your database and schema

Columns whose name and type imply a relationship to another table's primary key

Child Column Implied Parent Column
data_lock_waits.[BLOCKING_ENGINE_TRANSACTION_ID] processlist.[ID]
data_lock_waits.[BLOCKING_EVENT_ID] processlist.[ID]
data_lock_waits.[REQUESTING_ENGINE_TRANSACTION_ID] processlist.[ID]
data_lock_waits.[REQUESTING_EVENT_ID] processlist.[ID]
data_locks.[ENGINE_TRANSACTION_ID] processlist.[ID]
data_locks.[EVENT_ID] processlist.[ID]
data_locks.[INDEX_NAME] setup_consumers.[NAME]
data_locks.[OBJECT_NAME] setup_consumers.[NAME]
data_locks.[PARTITION_NAME] setup_consumers.[NAME]
data_locks.[SUBPARTITION_NAME] setup_consumers.[NAME]
events_errors_summary_by_account_by_error.[ERROR_NAME] setup_consumers.[NAME]
events_errors_summary_by_host_by_error.[ERROR_NAME] setup_consumers.[NAME]
events_errors_summary_by_thread_by_error.[ERROR_NAME] setup_consumers.[NAME]
events_errors_summary_by_user_by_error.[ERROR_NAME] setup_consumers.[NAME]
events_errors_summary_global_by_error.[ERROR_NAME] setup_consumers.[NAME]
events_stages_current.[END_EVENT_ID] processlist.[ID]
events_stages_current.[NESTING_EVENT_ID] processlist.[ID]
events_stages_history.[END_EVENT_ID] processlist.[ID]
events_stages_history.[NESTING_EVENT_ID] processlist.[ID]
events_stages_history_long.[END_EVENT_ID] processlist.[ID]
events_stages_history_long.[EVENT_ID] processlist.[ID]
events_stages_history_long.[NESTING_EVENT_ID] processlist.[ID]
events_statements_current.[END_EVENT_ID] processlist.[ID]
events_statements_current.[NESTING_EVENT_ID] processlist.[ID]
events_statements_current.[OBJECT_NAME] setup_consumers.[NAME]
events_statements_current.[STATEMENT_ID] processlist.[ID]
events_statements_histogram_by_digest.[BUCKET_NUMBER] events_statements_histogram_global.[BUCKET_NUMBER]
events_statements_histogram_by_digest.[SCHEMA_NAME] setup_consumers.[NAME]
events_statements_history.[END_EVENT_ID] processlist.[ID]
events_statements_history.[NESTING_EVENT_ID] processlist.[ID]
events_statements_history.[OBJECT_NAME] setup_consumers.[NAME]
events_statements_history.[STATEMENT_ID] processlist.[ID]
events_statements_history_long.[END_EVENT_ID] processlist.[ID]
events_statements_history_long.[EVENT_ID] processlist.[ID]
events_statements_history_long.[NESTING_EVENT_ID] processlist.[ID]
events_statements_history_long.[OBJECT_NAME] setup_consumers.[NAME]
events_statements_history_long.[STATEMENT_ID] processlist.[ID]
events_statements_summary_by_digest.[SCHEMA_NAME] setup_consumers.[NAME]
events_transactions_current.[END_EVENT_ID] processlist.[ID]
events_transactions_current.[NESTING_EVENT_ID] processlist.[ID]
events_transactions_current.[TRX_ID] processlist.[ID]
events_transactions_history.[END_EVENT_ID] processlist.[ID]
events_transactions_history.[NESTING_EVENT_ID] processlist.[ID]
events_transactions_history.[TRX_ID] processlist.[ID]
events_transactions_history_long.[END_EVENT_ID] processlist.[ID]
events_transactions_history_long.[EVENT_ID] processlist.[ID]
events_transactions_history_long.[NESTING_EVENT_ID] processlist.[ID]
events_transactions_history_long.[TRX_ID] processlist.[ID]
events_waits_current.[END_EVENT_ID] processlist.[ID]
events_waits_current.[INDEX_NAME] setup_consumers.[NAME]
events_waits_current.[NESTING_EVENT_ID] processlist.[ID]
events_waits_history.[END_EVENT_ID] processlist.[ID]
events_waits_history.[INDEX_NAME] setup_consumers.[NAME]
events_waits_history.[NESTING_EVENT_ID] processlist.[ID]
events_waits_history_long.[END_EVENT_ID] processlist.[ID]
events_waits_history_long.[EVENT_ID] processlist.[ID]
events_waits_history_long.[INDEX_NAME] setup_consumers.[NAME]
events_waits_history_long.[NESTING_EVENT_ID] processlist.[ID]
file_summary_by_instance.[FILE_NAME] file_instances.[FILE_NAME]
metadata_locks.[COLUMN_NAME] setup_consumers.[NAME]
metadata_locks.[OBJECT_NAME] setup_consumers.[NAME]
metadata_locks.[OWNER_EVENT_ID] processlist.[ID]
objects_summary_global_by_type.[OBJECT_NAME] setup_consumers.[NAME]
prepared_statements_instances.[OWNER_EVENT_ID] processlist.[ID]
prepared_statements_instances.[OWNER_OBJECT_NAME] setup_consumers.[NAME]
prepared_statements_instances.[STATEMENT_ID] processlist.[ID]
prepared_statements_instances.[STATEMENT_NAME] setup_consumers.[NAME]
setup_objects.[OBJECT_NAME] setup_consumers.[NAME]
socket_instances.[IP] host_cache.[IP]
table_handles.[OBJECT_NAME] setup_consumers.[NAME]
table_handles.[OWNER_EVENT_ID] processlist.[ID]
table_io_waits_summary_by_index_usage.[INDEX_NAME] setup_consumers.[NAME]
table_io_waits_summary_by_index_usage.[OBJECT_NAME] setup_consumers.[NAME]
table_io_waits_summary_by_table.[OBJECT_NAME] setup_consumers.[NAME]
table_lock_waits_summary_by_table.[OBJECT_NAME] setup_consumers.[NAME]
threads.[PROCESSLIST_ID] processlist.[ID]
threads.[THREAD_OS_ID] processlist.[ID]

Tables without indexes

Table Rows
binary_log_transaction_compression_stats 0
events_stages_history_long 10000
events_statements_history_long 10000
events_transactions_history_long 10000
events_waits_history_long 10000
keyring_component_status 64
keyring_keys 96
log_status 1
performance_timers 5
replication_applier_filters 0
replication_applier_global_filters 0
replication_asynchronous_connection_failover 0
replication_asynchronous_connection_failover_managed 0
replication_group_member_stats 0
replication_group_members 0
tls_channel_status 96
variables_info 662

Tables that contain a single column

Table Column
Anomaly not detected

Tables with incrementing column names, potentially indicating denormalization

Table
Anomaly not detected

Columns whose default value is the word 'NULL' or 'null'

Table
Anomaly not detected