In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
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.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.