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
Set default
Collapse Expand Requery Edit Explain Profiling Query failed Database: Queried time:

Export Exporting tables from "sys" database

Export defaults
Customize default export options.
Export defaults
Restore default value
Quick
Restore default value
Restore default value
Custom
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
SQL
Customize default options.
SQL
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Structure
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Data
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
CodeGen
Customize default options.
CodeGen
Restore default value
CSV
Customize default options.
CSV
CSV
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
CSV for MS Excel
Restore default value
Restore default value
Restore default value
Restore default value
LaTeX
Customize default options.
LaTeX
Restore default value
Restore default value
Structure
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Data
Restore default value
Restore default value
Restore default value
Restore default value
Restore default value
Microsoft Office
Customize default options.
Microsoft Office
Microsoft Word 2000
Restore default value
Restore default value
Restore default value
OpenDocument
Customize default options.
OpenDocument
OpenDocument Spreadsheet
Restore default value
Restore default value
OpenDocument Text
Restore default value
Structure
Restore default value
Restore default value
Restore default value
Data
Restore default value
Restore default value
Texy! text
Customize default options
Texy! text
Restore default value
Data
Restore default value
Restore default value
Export method:
Format:
Tables:
Tables Structure Data
Select all
host_summary
host_summary_by_file_io
host_summary_by_file_io_type
host_summary_by_stages
host_summary_by_statement_latency
host_summary_by_statement_type
innodb_buffer_stats_by_schema
innodb_buffer_stats_by_table
innodb_lock_waits
io_by_thread_by_latency
io_global_by_file_by_bytes
io_global_by_file_by_latency
io_global_by_wait_by_bytes
io_global_by_wait_by_latency
latest_file_io
memory_by_host_by_current_bytes
memory_by_thread_by_current_bytes
memory_by_user_by_current_bytes
memory_global_by_current_bytes
memory_global_total
metrics
processlist
ps_check_lost_instrumentation
schema_auto_increment_columns
schema_index_statistics
schema_object_overview
schema_redundant_indexes
schema_tables_with_full_table_scans
schema_table_lock_waits
schema_table_statistics
schema_table_statistics_with_buffer
schema_unused_indexes
session
session_ssl_status
statements_with_errors_or_warnings
statements_with_full_table_scans
statements_with_runtimes_in_95th_percentile
statements_with_sorting
statements_with_temp_tables
statement_analysis
sys_config
user_summary
user_summary_by_file_io
user_summary_by_file_io_type
user_summary_by_stages
user_summary_by_statement_latency
user_summary_by_statement_type
version
waits_by_host_by_latency
waits_by_user_by_latency
waits_global_by_latency
wait_classes_global_by_avg_latency
wait_classes_global_by_latency
x$host_summary
x$host_summary_by_file_io
x$host_summary_by_file_io_type
x$host_summary_by_stages
x$host_summary_by_statement_latency
x$host_summary_by_statement_type
x$innodb_buffer_stats_by_schema
x$innodb_buffer_stats_by_table
x$innodb_lock_waits
x$io_by_thread_by_latency
x$io_global_by_file_by_bytes
x$io_global_by_file_by_latency
x$io_global_by_wait_by_bytes
x$io_global_by_wait_by_latency
x$latest_file_io
x$memory_by_host_by_current_bytes
x$memory_by_thread_by_current_bytes
x$memory_by_user_by_current_bytes
x$memory_global_by_current_bytes
x$memory_global_total
x$processlist
x$ps_digest_95th_percentile_by_avg_us
x$ps_digest_avg_latency_distribution
x$ps_schema_table_statistics_io
x$schema_flattened_keys
x$schema_index_statistics
x$schema_tables_with_full_table_scans
x$schema_table_lock_waits
x$schema_table_statistics
x$schema_table_statistics_with_buffer
x$session
x$statements_with_errors_or_warnings
x$statements_with_full_table_scans
x$statements_with_runtimes_in_95th_percentile
x$statements_with_sorting
x$statements_with_temp_tables
x$statement_analysis
x$user_summary
x$user_summary_by_file_io
x$user_summary_by_file_io_type
x$user_summary_by_stages
x$user_summary_by_statement_latency
x$user_summary_by_statement_type
x$waits_by_host_by_latency
x$waits_by_user_by_latency
x$waits_global_by_latency
x$wait_classes_global_by_avg_latency
x$wait_classes_global_by_latency
Output:
  • The size is measured in MiB.
Format-specific options:

CodeGen

CSV

CSV for MS Excel

JSON

LaTeX

Dump table
Object creation options
Data dump options

MediaWiki Table

Dump table

Microsoft Word 2000

Dump table
Data dump options

OpenDocument Spreadsheet

OpenDocument Text

Dump table
Object creation options
Data dump options

PHP array

This format has no options

SQL

Object creation options
  • Add statements:
Data creation options
  • Syntax to use when inserting data:

Texy! text

Dump table
Data dump options

XML

Object creation options (all are recommended)
Data dump options

YAML

This format has no options