demo.phpmyadmin.net / phpMyAdmin demo - MySQL

Customize appearance of the navigation panel.

Navigation panel

Show databases navigation as tree In the navigation panel, replaces the database tree with a selector
Link with main panel Link with main panel by highlighting the current database or table.
Display logo Show logo in navigation panel.
Logo link URL URL where logo in the navigation panel will point to.
Logo link target Open the linked page in the main window (`main`) or in a new one (`new`).
Enable highlighting Highlight server under the mouse cursor.
Maximum items on first level The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables Maximum number of recently used tables; set 0 to disable.
Favorite tables Maximum number of favorite tables; set 0 to disable.
Navigation panel width Set to 0 to collapse navigation panel.

Customize the navigation tree.

Navigation tree

Maximum items in branch The number of items that can be displayed on each page of the navigation tree.
Group items in the tree Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree Whether to show tables under database in the navigation tree
Show views in tree Whether to show views under database in the navigation tree
Show functions in tree Whether to show functions under database in the navigation tree
Show procedures in tree Whether to show procedures under database in the navigation tree
Show events in tree Whether to show events under database in the navigation tree
Expand single database Whether to expand single database in the navigation tree automatically.

Servers display options.

Servers

Display servers selection Display server choice at the top of the navigation panel.
Display servers as a list Show server listing as a list instead of a drop down.

Databases display options.

Databases

Minimum number of databases to display the database filter box
Database tree separator String that separates databases into different tree levels.

Tables display options.

Tables

Target for quick access icon
Target for second quick access icon
Table tree separator String that separates tables into different tree levels.
Maximum table tree depth

Drop files here

SQL upload ( 0 ) x -

Click on the bar to scroll to top of page

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace Time taken:

Always expand query messages

Show query history at start

Show current browsing query

Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.

Switch to dark theme

Collapse Expand Requery Edit Explain Profiling Query failed Database: Queried time:

Storage engines

InnoDB

Supports transactions, row-level locking, and foreign keys

[ Variables | Buffer Pool | InnoDB Status ]

InnoDB is the default storage engine on this MySQL server.

	innodb_adaptive_flushing	ON
	innodb_adaptive_flushing_lwm	10
	innodb_adaptive_hash_index	ON
	innodb_adaptive_hash_index_parts	8
	innodb_adaptive_max_sleep_delay	150000
	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
The increment size for extending the size of an autoextending tablespace when it becomes full.	Autoextend increment	64
	innodb_autoinc_lock_mode	2
	innodb_buffer_pool_chunk_size	134217728
	innodb_buffer_pool_dump_at_shutdown	ON
	innodb_buffer_pool_dump_now	OFF
	innodb_buffer_pool_dump_pct	25
	innodb_buffer_pool_filename	ib_buffer_pool
	innodb_buffer_pool_in_core_file	ON
	innodb_buffer_pool_instances	1
	innodb_buffer_pool_load_abort	OFF
	innodb_buffer_pool_load_at_startup	ON
	innodb_buffer_pool_load_now	OFF
The size of the memory buffer InnoDB uses to cache data and indexes of its tables.	Buffer pool size	131 k KiB
	innodb_change_buffer_max_size	25
	innodb_change_buffering	all
	innodb_checksum_algorithm	crc32
	innodb_cmp_per_index_enabled	OFF
	innodb_commit_concurrency	0
	innodb_compression_failure_threshold_pct	5
	innodb_compression_level	6
	innodb_compression_pad_pct_max	50
	innodb_concurrency_tickets	5 k
	Data files	ibdata1:12M:autoextend
The common part of the directory path for all InnoDB data files.	Data home directory
	innodb_deadlock_detect	ON
	innodb_dedicated_server	OFF
	innodb_default_row_format	dynamic
	innodb_directories
	innodb_disable_sort_file_cache	OFF
	innodb_doublewrite	ON
	innodb_fast_shutdown	1
	innodb_file_per_table	ON
	innodb_fill_factor	100
	innodb_flush_log_at_timeout	1
	innodb_flush_log_at_trx_commit	1
	innodb_flush_method	fsync
	innodb_flush_neighbors	0
	innodb_flush_sync	ON
	innodb_flushing_avg_loops	30
	innodb_force_load_corrupted	OFF
	innodb_force_recovery	0
	innodb_fsync_threshold	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_io_capacity	200
	innodb_io_capacity_max	2000
	innodb_lock_wait_timeout	50
	innodb_log_buffer_size	16,384 KiB
	innodb_log_checksums	ON
	innodb_log_compressed_pages	ON
	innodb_log_file_size	49,152 KiB
	innodb_log_files_in_group	2
	innodb_log_group_home_dir	./
	innodb_log_spin_cpu_abs_lwm	80
	innodb_log_spin_cpu_pct_hwm	50
	innodb_log_wait_for_flush_spin_hwm	400
	innodb_log_write_ahead_size	8192
	innodb_lru_scan_depth	1024
	innodb_max_dirty_pages_pct	90
	innodb_max_dirty_pages_pct_lwm	10.000000
	innodb_max_purge_lag	0
	innodb_max_purge_lag_delay	0
	innodb_max_undo_log_size	1073741824
	innodb_monitor_disable
	innodb_monitor_enable
	innodb_monitor_reset
	innodb_monitor_reset_all
	innodb_numa_interleave	OFF
	innodb_old_blocks_pct	37
	innodb_old_blocks_time	1000
	innodb_online_alter_log_max_size	134217728
	innodb_open_files	4 k
	innodb_optimize_fulltext_only	OFF
	innodb_page_cleaners	1
	innodb_page_size	16384
	innodb_parallel_read_threads	4
	innodb_print_all_deadlocks	OFF
	innodb_print_ddl_logs	OFF
	innodb_purge_batch_size	300
	innodb_purge_rseg_truncate_frequency	128
	innodb_purge_threads	4
	innodb_random_read_ahead	OFF
	innodb_read_ahead_threshold	56
	innodb_read_io_threads	4
	innodb_read_only	OFF
	innodb_redo_log_archive_dirs
	innodb_redo_log_encrypt	OFF
	innodb_replication_delay	0
	innodb_rollback_on_timeout	OFF
	innodb_rollback_segments	128
	innodb_sort_buffer_size	1048576
	innodb_spin_wait_delay	6
	innodb_spin_wait_pause_multiplier	50
	innodb_stats_auto_recalc	ON
	innodb_stats_include_delete_marked	OFF
	innodb_stats_method	nulls_equal
	innodb_stats_on_metadata	OFF
	innodb_stats_persistent	ON
	innodb_stats_persistent_sample_pages	20
	innodb_stats_transient_sample_pages	8
	innodb_status_output	OFF
	innodb_status_output_locks	OFF
	innodb_strict_mode	ON
	innodb_sync_array_size	1
	innodb_sync_spin_loops	30
	innodb_table_locks	ON
	innodb_temp_data_file_path	ibtmp1:12M:autoextend
	innodb_temp_tablespaces_dir	./#innodb_temp/
	innodb_thread_concurrency	0
	innodb_thread_sleep_delay	10 k
	innodb_tmpdir
	innodb_undo_directory	./
	innodb_undo_log_encrypt	OFF
	innodb_undo_log_truncate	ON
	innodb_undo_tablespaces	2
	innodb_use_native_aio	ON
	innodb_version	8.0.18
	innodb_write_io_threads	4

phpMyAdmin Demo Server: Currently running Git revision RELEASE_5_2_1-4907-g5b04607256 from the master branch.