存储引擎

InnoDB

Percona-XtraDB, Supports transactions, row-level locking, foreign keys and encryption for tables

[ 变量 | 缓冲池 | InnoDB 状态 ]

InnoDB 是该 MySQL 服务器的默认存储引擎。

	innodb_adaptive_flushing	ON
	innodb_adaptive_flushing_lwm	10.000000
	innodb_adaptive_hash_index	ON
	innodb_adaptive_hash_index_partitions	1
	innodb_adaptive_max_sleep_delay	150000
	innodb_additional_mem_pool_size	8,192 KB
	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
数据表空间不足时自动增加的大小。	自动增加	64
	innodb_autoinc_lock_mode	1
	innodb_background_scrub_data_check_interval	3600
	innodb_background_scrub_data_compressed	OFF
	innodb_background_scrub_data_interval	604800
	innodb_background_scrub_data_uncompressed	OFF
	innodb_buf_dump_status_frequency	0
	innodb_buffer_pool_dump_at_shutdown	OFF
	innodb_buffer_pool_dump_now	OFF
	innodb_buffer_pool_dump_pct	100
	innodb_buffer_pool_filename	ib_buffer_pool
	innodb_buffer_pool_instances	8
	innodb_buffer_pool_load_abort	OFF
	innodb_buffer_pool_load_at_startup	OFF
	innodb_buffer_pool_load_now	OFF
	innodb_buffer_pool_populate	OFF
InnoDB 用于缓存数据和索引要使用的内存缓冲大小。	缓冲池大小	20,480 KB
	innodb_change_buffer_max_size	25
	innodb_change_buffering	all
	innodb_checksum_algorithm	INNODB
	innodb_checksums	ON
	innodb_cleaner_lsn_age_factor	HIGH_CHECKPOINT
	innodb_cmp_per_index_enabled	OFF
	innodb_commit_concurrency	0
	innodb_compression_algorithm	zlib
	innodb_compression_failure_threshold_pct	5
	innodb_compression_level	6
	innodb_compression_pad_pct_max	50
	innodb_concurrency_tickets	5 k
	innodb_corrupt_table_action	assert
	数据文件	ibdata1:10M:autoextend
所有 InnoDB 数据文件的公共路径.	数据主文件夹	/opt/lampp/var/mysql/
	innodb_default_encryption_key_id	1
	innodb_defragment	OFF
	innodb_defragment_fill_factor	0.900000
	innodb_defragment_fill_factor_n_recs	20
	innodb_defragment_frequency	40
	innodb_defragment_n_pages	7
	innodb_defragment_stats_accuracy	0
	innodb_disable_sort_file_cache	OFF
	innodb_disallow_writes	OFF
	innodb_doublewrite	ON
	innodb_empty_free_list_algorithm	LEGACY
	innodb_encrypt_log	OFF
	innodb_encrypt_tables	OFF
	innodb_encryption_rotate_key_age	1
	innodb_encryption_rotation_iops	100
	innodb_encryption_threads	0
	innodb_fake_changes	OFF
	innodb_fast_shutdown	1
	innodb_fatal_semaphore_wait_threshold	600
	innodb_file_format	Antelope
	innodb_file_format_check	ON
	innodb_file_format_max	Antelope
	innodb_file_per_table	ON
	innodb_flush_log_at_timeout	1
	innodb_flush_log_at_trx_commit	1
	innodb_flush_method
	innodb_flush_neighbors	1
	innodb_flushing_avg_loops	30
	innodb_force_load_corrupted	OFF
	innodb_force_primary_key	OFF
	innodb_force_recovery	0
	innodb_foreground_preflush	EXPONENTIAL_BACKOFF
	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_immediate_scrub_data_uncompressed	OFF
	innodb_instrument_semaphores	OFF
	innodb_io_capacity	200
	innodb_io_capacity_max	2000
	innodb_kill_idle_transaction	0
	innodb_large_prefix	OFF
	innodb_lock_schedule_algorithm	fcfs
	innodb_lock_wait_timeout	50
	innodb_locking_fake_changes	ON
	innodb_locks_unsafe_for_binlog	OFF
	innodb_log_arch_dir	/opt/lampp/var/mysql/
	innodb_log_arch_expire_sec	0
	innodb_log_archive	OFF
	innodb_log_block_size	512
	innodb_log_buffer_size	8,192 KB
	innodb_log_checksum_algorithm	INNODB
	innodb_log_compressed_pages	ON
	innodb_log_file_size	5,120 KB
	innodb_log_files_in_group	2
	innodb_log_group_home_dir	/opt/lampp/var/mysql/
	innodb_lru_scan_depth	1024
	innodb_max_bitmap_file_size	104857600
	innodb_max_changed_pages	1000000
	innodb_max_dirty_pages_pct	75
	innodb_max_dirty_pages_pct_lwm	0.001000
	innodb_max_purge_lag	0
	innodb_max_purge_lag_delay	0
	innodb_mirrored_log_groups	1
	innodb_monitor_disable
	innodb_monitor_enable
	innodb_monitor_reset
	innodb_monitor_reset_all
	innodb_mtflush_threads	8
	innodb_old_blocks_pct	37
	innodb_old_blocks_time	1000
	innodb_online_alter_log_max_size	134217728
	innodb_open_files	300
	innodb_optimize_fulltext_only	OFF
	innodb_page_size	16384
	innodb_prefix_index_cluster_optimization	OFF
	innodb_print_all_deadlocks	OFF
	innodb_purge_batch_size	300
	innodb_purge_threads	1
	innodb_random_read_ahead	OFF
	innodb_read_ahead_threshold	56
	innodb_read_io_threads	4
	innodb_read_only	OFF
	innodb_replication_delay	0
	innodb_rollback_on_timeout	OFF
	innodb_rollback_segments	128
	innodb_sched_priority_cleaner	19
	innodb_scrub_log	OFF
	innodb_scrub_log_speed	256
	innodb_show_locks_held	10
	innodb_show_verbose_locks	0
	innodb_simulate_comp_failures	0
	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_modified_counter	0
	innodb_stats_on_metadata	OFF
	innodb_stats_persistent	ON
	innodb_stats_persistent_sample_pages	20
	innodb_stats_sample_pages	8
	innodb_stats_traditional	ON
	innodb_stats_transient_sample_pages	8
	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_thread_concurrency	0
	innodb_thread_sleep_delay	10 k
	innodb_tmpdir
	innodb_track_changed_pages	OFF
	innodb_undo_directory	.
	innodb_undo_logs	128
	innodb_undo_tablespaces	0
	innodb_use_atomic_writes	OFF
	innodb_use_fallocate	OFF
	innodb_use_global_flush_log_at_trx_commit	ON
	innodb_use_mtflush	OFF
	innodb_use_native_aio	OFF
	innodb_use_stacktrace	OFF
	innodb_use_sys_malloc	ON
	innodb_use_trim	OFF
	innodb_version	5.6.36-82.2
	innodb_write_io_threads	4