www.schloemer.biz / rdbms.strato.de

Recent

There are no recent tables.

Favorites

There are no favorite tables.

cm9vdA==.REI2OTU3MA==cm9vdA==.REI2OTU3MA==0
DB69570

Navigation panel
Navigation tree
Servers
Databases
Tables

Navigation panel

Customize appearance of the 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.

Navigation tree

Customize the 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

Servers

Servers display options.

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

Databases display options.

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

Tables

Tables display options.

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-

Server: rdbms.strato.de

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 Bookmark 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	256
	innodb_autoinc_lock_mode	1
	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_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	12,288 MiB
	innodb_change_buffer_max_size	25
	innodb_change_buffering	all
	innodb_checksum_algorithm	crc32
	innodb_checksums	ON
	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:128M:autoextend
The common part of the directory path for all InnoDB data files.	Data home directory	/DBDATA/rdbng/data
	innodb_deadlock_detect	ON
	innodb_default_row_format	dynamic
	innodb_disable_sort_file_cache	OFF
	innodb_doublewrite	ON
	innodb_fast_shutdown	1
	innodb_file_format	Barracuda
	innodb_file_format_check	ON
	innodb_file_format_max	Barracuda
	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	O_DIRECT
	innodb_flush_neighbors	1
	innodb_flush_sync	ON
	innodb_flushing_avg_loops	30
	innodb_force_load_corrupted	OFF
	innodb_force_recovery	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_io_capacity	200
	innodb_io_capacity_max	2000
	innodb_large_prefix	ON
	innodb_lock_wait_timeout	50
	innodb_locks_unsafe_for_binlog	OFF
	innodb_log_buffer_size	16,384 KiB
	innodb_log_checksums	ON
	innodb_log_compressed_pages	ON
	innodb_log_file_size	524 k KiB
	innodb_log_files_in_group	3
	innodb_log_group_home_dir	/DBDATA/rdbng/data
	innodb_log_write_ahead_size	8192
	innodb_lru_scan_depth	256
	innodb_max_dirty_pages_pct	10
	innodb_max_dirty_pages_pct_lwm	0.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	6 k
	innodb_optimize_fulltext_only	OFF
	innodb_page_cleaners	1
	innodb_page_size	16384
	innodb_print_all_deadlocks	OFF
	innodb_purge_batch_size	300
	innodb_purge_rseg_truncate_frequency	128
	innodb_purge_threads	1
	innodb_random_read_ahead	OFF
	innodb_read_ahead_threshold	56
	innodb_read_io_threads	8
	innodb_read_only	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_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_sample_pages	16
	innodb_stats_transient_sample_pages	16
	innodb_status_output	OFF
	innodb_status_output_locks	OFF
	innodb_strict_mode	OFF
	innodb_support_xa	ON
	innodb_sync_array_size	1
	innodb_sync_spin_loops	30
	innodb_table_locks	ON
	innodb_temp_data_file_path	ibtmp1:12M:autoextend:max:512M
	innodb_thread_concurrency	0
	innodb_thread_sleep_delay	10 k
	innodb_tmpdir
	innodb_undo_directory	./
	innodb_undo_log_truncate	OFF
	innodb_undo_logs	128
	innodb_undo_tablespaces	0
	innodb_use_native_aio	ON
	innodb_version	5.7.42
	innodb_write_io_threads	8