Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count: Time taken:
Options
Restore default values
Collapse Expand Requery Edit Explain Profiling Query failed Database: Queried time:

mysql

columns_priv

Table comments: Column privileges

Column Type Null Default Comments
Host (Primary) char(255) No
Db (Primary) char(64) No
User (Primary) char(32) No
Table_name (Primary) char(64) No
Column_name (Primary) char(64) No
Timestamp timestamp No CURRENT_TIMESTAMP
Column_priv set('Select', 'Insert', 'Update', 'References') No

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No Host 0 A No
Db 0 A No
User 0 A No
Table_name 0 A No
Column_name 0 A No

component

Table comments: Components

Column Type Null Default Comments
component_id (Primary) int(10) No
component_group_id int(10) No
component_urn text No

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No component_id 0 A No

db

Table comments: Database privileges

Column Type Null Default Comments
Host (Primary) char(255) No
Db (Primary) char(64) No
User (Primary) char(32) No
Select_priv enum('N', 'Y') No N
Insert_priv enum('N', 'Y') No N
Update_priv enum('N', 'Y') No N
Delete_priv enum('N', 'Y') No N
Create_priv enum('N', 'Y') No N
Drop_priv enum('N', 'Y') No N
Grant_priv enum('N', 'Y') No N
References_priv enum('N', 'Y') No N
Index_priv enum('N', 'Y') No N
Alter_priv enum('N', 'Y') No N
Create_tmp_table_priv enum('N', 'Y') No N
Lock_tables_priv enum('N', 'Y') No N
Create_view_priv enum('N', 'Y') No N
Show_view_priv enum('N', 'Y') No N
Create_routine_priv enum('N', 'Y') No N
Alter_routine_priv enum('N', 'Y') No N
Execute_priv enum('N', 'Y') No N
Event_priv enum('N', 'Y') No N
Trigger_priv enum('N', 'Y') No N

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No Host 2 A No
Db 5 A No
User 5 A No
User BTREE No No User 5 A No

default_roles

Table comments: Default roles

Column Type Null Default Comments
HOST (Primary) char(255) No
USER (Primary) char(32) No
DEFAULT_ROLE_HOST (Primary) char(255) No %
DEFAULT_ROLE_USER (Primary) char(32) No

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No HOST 0 A No
USER 0 A No
DEFAULT_ROLE_HOST 0 A No
DEFAULT_ROLE_USER 0 A No

engine_cost

Column Type Null Default Comments
engine_name (Primary) varchar(64) No
device_type (Primary) int(11) No
cost_name (Primary) varchar(64) No
cost_value float Yes NULL
last_update timestamp No CURRENT_TIMESTAMP
comment varchar(1024) Yes NULL
default_value float Yes NULL

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No cost_name 2 A No
engine_name 2 A No
device_type 2 A No

func

Table comments: User defined functions

Column Type Null Default Comments
name (Primary) char(64) No
ret tinyint(1) No 0
dl char(128) No
type enum('function', 'aggregate') No

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No name 0 A No

general_log

Table comments: General log

Column Type Null Default Comments
event_time timestamp(6) No CURRENT_TIMESTAMP(6)
user_host mediumtext No
thread_id bigint(21) No
server_id int(10) No
command_type varchar(64) No
argument mediumblob No

No index defined!

global_grants

Table comments: Extended global grants

Column Type Null Default Comments
USER (Primary) char(32) No
HOST (Primary) char(255) No
PRIV (Primary) char(32) No
WITH_GRANT_OPTION enum('N', 'Y') No N

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No USER 3 A No
HOST 4 A No
PRIV 76 A No

gtid_executed

Column Type Null Default Comments
source_uuid (Primary) char(36) No uuid of the source where the transaction was originally executed.
interval_start (Primary) bigint(20) No First number of interval.
interval_end bigint(20) No Last number of interval.

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No source_uuid 0 A No
interval_start 0 A No

help_category

Table comments: help categories

Column Type Null Default Comments
help_category_id (Primary) smallint(5) No
name char(64) No
parent_category_id smallint(5) Yes NULL
url text No

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No help_category_id 44 A No
name BTREE Yes No name 44 A No

help_keyword

Table comments: help keywords

Column Type Null Default Comments
help_keyword_id (Primary) int(10) No
name char(64) No

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No help_keyword_id 726 A No
name BTREE Yes No name 717 A No

help_relation

Table comments: keyword-topic relation

Column Type Null Default Comments
help_topic_id (Primary) int(10) No
help_keyword_id (Primary) int(10) No

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No help_keyword_id 734 A No
help_topic_id 1837 A No

help_topic

Table comments: help topics

Column Type Null Default Comments
help_topic_id (Primary) int(10) No
name char(64) No
help_category_id smallint(5) No
description text No
example text No
url text No

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No help_topic_id 553 A No
name BTREE Yes No name 553 A No

innodb_index_stats

Column Type Null Default Comments
database_name (Primary) varchar(64) No
table_name (Primary) varchar(199) No
index_name (Primary) varchar(64) No
last_update timestamp No CURRENT_TIMESTAMP
stat_name (Primary) varchar(64) No
stat_value bigint(20) No
sample_size bigint(20) Yes NULL
stat_description varchar(1024) No

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No database_name 24 A No
table_name 64 A No
index_name 100 A No
stat_name 355 A No

innodb_table_stats

Column Type Null Default Comments
database_name (Primary) varchar(64) No
table_name (Primary) varchar(199) No
last_update timestamp No CURRENT_TIMESTAMP
n_rows bigint(20) No
clustered_index_size bigint(20) No
sum_of_other_index_sizes bigint(20) No

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No database_name 21 A No
table_name 61 A No

password_history

Table comments: Password history for user accounts

Column Type Null Default Comments
Host (Primary) char(255) No
User (Primary) char(32) No
Password_timestamp (Primary) timestamp(6) No CURRENT_TIMESTAMP(6)
Password text Yes NULL

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No Host 0 A No
User 0 A No
Password_timestamp 0 D No

plugin

Table comments: MySQL plugins

Column Type Null Default Comments
name (Primary) varchar(64) No
dl varchar(128) No

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No name 1 A No

procs_priv

Table comments: Procedure privileges

Column Type Null Default Comments
Host (Primary) char(255) No
Db (Primary) char(64) No
User (Primary) char(32) No
Routine_name (Primary) char(64) No
Routine_type (Primary) enum('FUNCTION', 'PROCEDURE') No
Grantor varchar(288) No
Proc_priv set('Execute', 'Alter Routine', 'Grant') No
Timestamp timestamp No CURRENT_TIMESTAMP

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No Host 0 A No
Db 0 A No
User 0 A No
Routine_name 0 A No
Routine_type 0 A No
Grantor BTREE No No Grantor 0 A No

proxies_priv

Table comments: User proxy privileges

Column Type Null Default Comments
Host (Primary) char(255) No
User (Primary) char(32) No
Proxied_host (Primary) char(255) No
Proxied_user (Primary) char(32) No
With_grant tinyint(1) No 0
Grantor varchar(288) No
Timestamp timestamp No CURRENT_TIMESTAMP

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No Host 1 A No
User 1 A No
Proxied_host 1 A No
Proxied_user 1 A No
Grantor BTREE No No Grantor 1 A No

role_edges

Table comments: Role hierarchy and role grants

Column Type Null Default Comments
FROM_HOST (Primary) char(255) No
FROM_USER (Primary) char(32) No
TO_HOST (Primary) char(255) No
TO_USER (Primary) char(32) No
WITH_ADMIN_OPTION enum('N', 'Y') No N

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No FROM_HOST 0 A No
FROM_USER 0 A No
TO_HOST 0 A No
TO_USER 0 A No

servers

Table comments: MySQL Foreign Servers table

Column Type Null Default Comments
Server_name (Primary) char(64) No
Host char(255) No
Db char(64) No
Username char(64) No
Password char(64) No
Port int(4) No 0
Socket char(64) No
Wrapper char(64) No
Owner char(64) No

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No Server_name 0 A No

server_cost

Column Type Null Default Comments
cost_name (Primary) varchar(64) No
cost_value float Yes NULL
last_update timestamp No CURRENT_TIMESTAMP
comment varchar(1024) Yes NULL
default_value float Yes NULL

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No cost_name 6 A No

slave_master_info

Table comments: Master Information

Column Type Null Default Comments
Number_of_lines int(10) No Number of lines in the file.
Master_log_name text No The name of the master binary log currently being read from the master.
Master_log_pos bigint(20) No The master log position of the last read event.
Host char(255) Yes NULL The host name of the master.
User_name text Yes NULL The user name used to connect to the master.
User_password text Yes NULL The password used to connect to the master.
Port int(10) No The network port used to connect to the master.
Connect_retry int(10) No The period (in seconds) that the slave will wait before trying to reconnect to the master.
Enabled_ssl tinyint(1) No Indicates whether the server supports SSL connections.
Ssl_ca text Yes NULL The file used for the Certificate Authority (CA) certificate.
Ssl_capath text Yes NULL The path to the Certificate Authority (CA) certificates.
Ssl_cert text Yes NULL The name of the SSL certificate file.
Ssl_cipher text Yes NULL The name of the cipher in use for the SSL connection.
Ssl_key text Yes NULL The name of the SSL key file.
Ssl_verify_server_cert tinyint(1) No Whether to verify the server certificate.
Heartbeat float No
Bind text Yes NULL Displays which interface is employed when connecting to the MySQL server
Ignored_server_ids text Yes NULL The number of server IDs to be ignored, followed by the actual server IDs
Uuid text Yes NULL The master server uuid.
Retry_count bigint(20) No Number of reconnect attempts, to the master, before giving up.
Ssl_crl text Yes NULL The file used for the Certificate Revocation List (CRL)
Ssl_crlpath text Yes NULL The path used for Certificate Revocation List (CRL) files
Enabled_auto_position tinyint(1) No Indicates whether GTIDs will be used to retrieve events from the master.
Channel_name (Primary) char(64) No The channel on which the slave is connected to a source. Used in Multisource Replication
Tls_version text Yes NULL Tls version
Public_key_path text Yes NULL The file containing public key of master server.
Get_public_key tinyint(1) No Preference to get public key from master.
Network_namespace text Yes NULL Network namespace used for communication with the master server.
Master_compression_algorithm char(64) No Compression algorithm supported for data transfer between master and slave.
Master_zstd_compression_level int(10) No Compression level associated with zstd compression algorithm.

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No Channel_name 0 A No

slave_relay_log_info

Table comments: Relay Log Information

Column Type Null Default Comments
Number_of_lines int(10) No Number of lines in the file or rows in the table. Used to version table definitions.
Relay_log_name text No The name of the current relay log file.
Relay_log_pos bigint(20) No The relay log position of the last executed event.
Master_log_name text No The name of the master binary log file from which the events in the relay log file were read.
Master_log_pos bigint(20) No The master log position of the last executed event.
Sql_delay int(11) No The number of seconds that the slave must lag behind the master.
Number_of_workers int(10) No
Id int(10) No Internal Id that uniquely identifies this record.
Channel_name (Primary) char(64) No The channel on which the slave is connected to a source. Used in Multisource Replication
Privilege_checks_username char(32) Yes NULL Username part of PRIVILEGE_CHECKS_USER.
Privilege_checks_hostname char(255) Yes NULL Hostname part of PRIVILEGE_CHECKS_USER.

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No Channel_name 0 A No

slave_worker_info

Table comments: Worker Information

Column Type Null Default Comments
Id (Primary) int(10) No
Relay_log_name text No
Relay_log_pos bigint(20) No
Master_log_name text No
Master_log_pos bigint(20) No
Checkpoint_relay_log_name text No
Checkpoint_relay_log_pos bigint(20) No
Checkpoint_master_log_name text No
Checkpoint_master_log_pos bigint(20) No
Checkpoint_seqno int(10) No
Checkpoint_group_size int(10) No
Checkpoint_group_bitmap blob No
Channel_name (Primary) char(64) No The channel on which the slave is connected to a source. Used in Multisource Replication

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No Channel_name 0 A No
Id 0 A No

slow_log

Table comments: Slow log

Column Type Null Default Comments
start_time timestamp(6) No CURRENT_TIMESTAMP(6)
user_host mediumtext No
query_time time(6) No
lock_time time(6) No
rows_sent int(11) No
rows_examined int(11) No
db varchar(512) No
last_insert_id int(11) No
insert_id int(11) No
server_id int(10) No
sql_text mediumblob No
thread_id bigint(21) No

No index defined!

tables_priv

Table comments: Table privileges

Column Type Null Default Comments
Host (Primary) char(255) No
Db (Primary) char(64) No
User (Primary) char(32) No
Table_name (Primary) char(64) No
Grantor varchar(288) No
Timestamp timestamp No CURRENT_TIMESTAMP
Table_priv set('Select', 'Insert', 'Update', 'Delete', 'Create', 'Drop', 'Grant', 'References', 'Index', 'Alter', 'Create View', 'Show view', 'Trigger') No
Column_priv set('Select', 'Insert', 'Update', 'References') No

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No Host 1 A No
Db 2 A No
User 2 A No
Table_name 2 A No
Grantor BTREE No No Grantor 2 A No

time_zone

Table comments: Time zones

Column Type Null Default Comments
Time_zone_id (Primary) int(10) No
Use_leap_seconds enum('Y', 'N') No N

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No Time_zone_id 0 A No

time_zone_leap_second

Table comments: Leap seconds information for time zones

Column Type Null Default Comments
Transition_time (Primary) bigint(20) No
Correction int(11) No

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No Transition_time 0 A No

time_zone_name

Table comments: Time zone names

Column Type Null Default Comments
Name (Primary) char(64) No
Time_zone_id int(10) No

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No Name 0 A No

time_zone_transition

Table comments: Time zone transitions

Column Type Null Default Comments
Time_zone_id (Primary) int(10) No
Transition_time (Primary) bigint(20) No
Transition_type_id int(10) No

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No Time_zone_id 0 A No
Transition_time 0 A No

time_zone_transition_type

Table comments: Time zone transition types

Column Type Null Default Comments
Time_zone_id (Primary) int(10) No
Transition_type_id (Primary) int(10) No
Offset int(11) No 0
Is_DST tinyint(3) No 0
Abbreviation char(8) No

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No Time_zone_id 0 A No
Transition_type_id 0 A No

user

Table comments: Users and global privileges

Column Type Null Default Comments
Host (Primary) char(255) No
User (Primary) char(32) No
Select_priv enum('N', 'Y') No N
Insert_priv enum('N', 'Y') No N
Update_priv enum('N', 'Y') No N
Delete_priv enum('N', 'Y') No N
Create_priv enum('N', 'Y') No N
Drop_priv enum('N', 'Y') No N
Reload_priv enum('N', 'Y') No N
Shutdown_priv enum('N', 'Y') No N
Process_priv enum('N', 'Y') No N
File_priv enum('N', 'Y') No N
Grant_priv enum('N', 'Y') No N
References_priv enum('N', 'Y') No N
Index_priv enum('N', 'Y') No N
Alter_priv enum('N', 'Y') No N
Show_db_priv enum('N', 'Y') No N
Super_priv enum('N', 'Y') No N
Create_tmp_table_priv enum('N', 'Y') No N
Lock_tables_priv enum('N', 'Y') No N
Execute_priv enum('N', 'Y') No N
Repl_slave_priv enum('N', 'Y') No N
Repl_client_priv enum('N', 'Y') No N
Create_view_priv enum('N', 'Y') No N
Show_view_priv enum('N', 'Y') No N
Create_routine_priv enum('N', 'Y') No N
Alter_routine_priv enum('N', 'Y') No N
Create_user_priv enum('N', 'Y') No N
Event_priv enum('N', 'Y') No N
Trigger_priv enum('N', 'Y') No N
Create_tablespace_priv enum('N', 'Y') No N
ssl_type enum('', 'ANY', 'X509', 'SPECIFIED') No
ssl_cipher blob No
x509_issuer blob No
x509_subject blob No
max_questions int(11) No 0
max_updates int(11) No 0
max_connections int(11) No 0
max_user_connections int(11) No 0
plugin char(64) No caching_sha2_password
authentication_string text Yes NULL
password_expired enum('N', 'Y') No N
password_last_changed timestamp Yes NULL
password_lifetime smallint(5) Yes NULL
account_locked enum('N', 'Y') No N
Create_role_priv enum('N', 'Y') No N
Drop_role_priv enum('N', 'Y') No N
Password_reuse_history smallint(5) Yes NULL
Password_reuse_time smallint(5) Yes NULL
Password_require_current enum('N', 'Y') Yes NULL
User_attributes json Yes NULL

Indexes

Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No Host 2 A No
User 9 A No