Shulou(Shulou.com)05/31 Report--

This article mainly explains "how to configure my.conf under mysql etc". The content in the article is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn "how to configure my.conf under mysql etc".

Brief introduction

Configuration details of my.conf under mysql etc are as follows

[client]

Port = 3306

Socket = / tmp/mysql.sock

Default-character-set = utf8mb4

[mysql]

Prompt= "MySQL [\ d] >"

No-auto-rehash

[mysqld]

Port = 3306

Socket = / tmp/mysql.sock

Basedir = / usr/local/mysql

Datadir = / data/mysql

Pid-file = / data/mysql/mysql.pid

User = mysql

Bind-address = 0.0.0.0

Server-id = 1

Init-connect = 'SET NAMES utf8mb4'

Character-set-server = utf8mb4

Skip-name-resolve

# skip-networking

Back_log = 300

Max_connections = 613

Max_connect_errors = 6000

Open_files_limit = 65535

Table_open_cache = 256

Max_allowed_packet = 500m

Binlog_cache_size = 1m

Max_heap_table_size = 8m

Tmp_table_size = 32m

Read_buffer_size = 2m

Read_rnd_buffer_size = 8m

Sort_buffer_size = 8m

Join_buffer_size = 8m

Key_buffer_size = 16m

Thread_cache_size = 16

Query_cache_type = 1

Query_cache_size = 16m

Query_cache_limit = 2m

Ft_min_word_len = 4

Log_bin = mysql-bin

Binlog_format = mixed

Expire_logs_days = 7

Log_error = / data/mysql/mysql-error.log

Slow_query_log = 1

Long_query_time = 1

Slow_query_log_file = / data/mysql/mysql-slow.log

Performance_schema = 0

Explicit_defaults_for_timestamp

# lower_case_table_names = 1

Skip-external-locking

# default_storage_engine = InnoDB

Default-storage-engine = MyISAM

Innodb_file_per_table = 1

Innodb_open_files = 500,

Innodb_buffer_pool_size = 128m

Innodb_write_io_threads = 4

Innodb_read_io_threads = 4

Innodb_thread_concurrency = 0

Innodb_purge_threads = 1

Innodb_flush_log_at_trx_commit = 2

Innodb_log_buffer_size = 2m

Innodb_log_file_size = 32m

Innodb_log_files_in_group = 3

Innodb_max_dirty_pages_pct = 90

Innodb_lock_wait_timeout = 120

Bulk_insert_buffer_size = 8m

Myisam_sort_buffer_size = 16m

Myisam_max_sort_file_size = 10G

Myisam_repair_threads = 1

Interactive_timeout = 28800

Wait_timeout = 28800

[mysqldump]

Quick

Max_allowed_packet = 500m

[myisamchk]

Key_buffer_size = 16m

Sort_buffer_size = 8m

Read_buffer = 4m

Write_buffer = 4m

Thank you for your reading, the above is the content of "how to configure my.conf under mysql etc". After the study of this article, I believe you have a deeper understanding of how to configure my.conf under mysql etc, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.