Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

How to configure my.conf under mysql etc tutorial

2025-04-05 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

This article mainly tells you how to configure my.conf tutorials under mysql etc. You can check the relevant professional terms on the Internet or find some related books to supplement them. I will not dabble here and go straight to the topic. I hope I can bring you some practical help.

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

How to configure the my.conf under mysql etc tutorial will first tell you here, for other related issues you want to know the industry information that you can continue to pay attention to. Our section will capture some industry news and professional knowledge to share with you every day.

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.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report