mysql获取配置文件信息_mysql配置文件信息

key_buffer_size=

table_cache_size=

thread_cache_size=

query_cache_size=

read_buffer_size=

read_rnd_buffer_size=

sort_buffer_size=

join buffer size=

[mysqld]

#GENERAL

datadir=/var/lib/mysql

socket=/var/lib/mysql/mysql.sock

pid_file=/var/lib/mysql/mysql.pid

user=mysql

port=3306

default_storage_engine=Innodb

#INNODB

innodb_buffer_pool_size=

innodb_log_file_size=

innodb_file_per_table=

innodb_flush_method=

#MyISAM

key_bugger_size=

#LOGGING

log_error=/var/lib/mysql/mysqld.err

slow_query_log=/var/lib/mysql/mysql_slow.log

#OTHER

tmp_table_size=126M

max_heap_table_size=126M

query_cache_type=

query_cache_size=

max_connections=4096

thread_cache_size=300

table_cache_size=8000

open_files_limit=

[client]

socket=/var/lib/mysql/mysql.sock

port=3306

#内存

innodb_buffer_pool_size=

innodb_max_dirty_pages_pct=

init_file=

key_buffer_size=

#缓存

thread_cache_size=

table_cache_size=

#innodb数据字典

innodb_file_per_table=

innodb_open_files=

#I/O

innodb_log_file_size=

innodb_log_files_in_group=

innodb_log_buffer_size=

innodb_flush_log_at_trx_commit=

innodb_flush_method=

innodb_doublewrite=

sync_binlog=

expire_logs_days=

#mysql并发

innodb_thread_concurrency=0

innodb_commit_concurrency=

#基本配置

tmp_table_size=126M

max_heap_table_size=126M

max_connections=4096

thread_cache_size=300

table_cache_size=8000

#安全

expire_logs_days=

max_allowed_packet=

max_connect_errors=

skip_name_resolve=

sql_mode=

sysdate_is_now=

#复制

read_only=

skip_salve_start=

slave_net_timeout=

sync_master_info,sync_relay_log,sync_relay_log_info

#innodb

innodb=

innodb_autoinc_lock_mode=

innodb_buffer_pool_instances=

innodb_io_capacity=600

innodb_read_io_threads = 8

innodb_write_io_threads = 8

innodb_strict_mode=

innodb_old_blocks_time=

mysql配置文件信息

标签：cli   engine   use   inf   join   table   缓存   page   ast

本条技术文章来源于互联网，如果无意侵犯您的权益请点击此处反馈版权投诉

本文系统来源：https://www.cnblogs.com/owlin/p/12512476.html