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
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :
Table structure
Settings for the table structure (list of columns).
Table structure
Documentation Whether the table structure actions should be hidden. Restore default value
Documentation Whether column comments should be shown in table structure view Restore default value
Default transformations
Documentation Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page. Restore default value
Documentation Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page. Restore default value
Documentation Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page. Restore default value
Documentation Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page. Restore default value
Documentation Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page. Restore default value
Documentation Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page. Restore default value
Documentation Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page. Restore default value
Documentation Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page. Restore default value
Documentation Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page. Restore default value

threads

# Name Type Collation Attributes Null Default Comments Extra
1 bigint(20) UNSIGNED No None A unique thread identifier.
2 varchar(128) utf8_general_ci No None Name associated with the server's thread instrumentation code, for example thread/sql/main for the server's main() function, and thread/sql/one_connection for a user connection.
3 varchar(10) utf8_general_ci No None FOREGROUND or BACKGROUND, depending on the thread type. User connection threads are FOREGROUND, internal server threads are BACKGROUND.
4 bigint(20) UNSIGNED Yes NULL The PROCESSLIST.ID value for threads displayed in the INFORMATION_SCHEMA.PROCESSLIST table, or 0 for background threads. Also corresponds with the CONNECTION_ID() return value for the thread.
5 varchar(128) utf8_general_ci Yes NULL Foreground thread user, or NULL for a background thread.
6 varchar(60) utf8_general_ci Yes NULL Foreground thread host, or NULL for a background thread.
7 varchar(64) utf8_general_ci Yes NULL Thread's default database, or NULL if none exists.
8 varchar(16) utf8_general_ci Yes NULL Type of command executed by the thread. These correspond to the the COM_xxx client/server protocol commands, and the Com_xxx status variables. See Thread Command Values.
9 bigint(20) Yes NULL Time in seconds the thread has been in its current state.
10 varchar(64) utf8_general_ci Yes NULL Action, event or state indicating what the thread is doing.
11 longtext utf8_general_ci Yes NULL Statement being executed by the thread, or NULL if a statement is not being executed. If a statement results in calling other statements, such as for a stored procedure, the innermost statement from the stored procedure is shown here.
12 bigint(20) UNSIGNED Yes NULL THREAD_ID of the parent thread, if any. Subthreads can for example be spawned as a result of INSERT DELAYED statements.
13 varchar(64) utf8_general_ci Yes NULL Unused.
14 enum('YES', 'NO') utf8_general_ci No None YES or NO for Whether the thread is instrumented or not. For foreground threads, the initial value is determined by whether there's a user/host match in the setup_actors table. Subthreads are again matched, while for background threads, this will be set to YES by default. To monitor events that the thread executes, INSTRUMENTED must be YES and the thread_instrumentation consumer in the setup_consumers table must also be YES.
With selected: With selected:

Partitions Documentation
Information
Row statistics
Format dynamic
Collation utf8_general_ci
Rows 1,000
Row size 0 B
Next autoindex 0
Creation Jun 06, 2025 at 03:03 AM
Last update Jun 06, 2025 at 03:03 AM
Last check Jun 06, 2025 at 03:03 AM