Mysql 5.6.10 usable parameters (verification)

Source: Internet
Author: User
Tags bulk insert

Mysql 5.6.10 parameters (verification) my. there are two INI files that must be changed: Cancel table_cache and log-slow-queries = slow. log must be changed to slow-query-log-file = slow. log [mysqld] port = 3306 available basedir = D:/wamp/mysql available datadir = D:/wamp/mysql/data/available tmpdir = D: /wamp/tmp/replace character-set-server = utf8 with character-set-server. It seems that table_cache = 2048 has been canceled, if it is added, wait_timeout = 30 available interactive_timeout = 30 available skip-name-resolve available bind-address = 0.0.0.0 available innodb_file_per_table = 1 available innodb_open_files = 2048 available back_log = 500 available max_connections = 1000 available bytes = 100 available table_open_cache = 2048 available bytes = 32 m available bytes = 1 m available bytes = 256M available read_buffer_size = 16 m available bytes = 16 m available sort_buffer_size = 16 m available bytes = 32 m available thread_cache_size = 64 available thread_concurrency = 4 available query_cache_size = 256M available bytes = 8 m available bytes = 4 available # memlock default-storage-engine = Innodb available thread_stack = 192K available transaction_isolation = REPEATABLE-READ available tmp_table_size = 256M available max_tmp_tables = 512 is available # Enable binary logging. this is required for acting as a MASTER in a # replication configuration. you also need the binary log if you need # the ability to do point in time recovery from your latest backup. # log-bin = mysql-bin # binary logging format-mixed recommended # binlog_format = mixed # If you're using replication with chained slaves (A-> B-> C ), you need to # enable this option on server B. it enables logging of updates done by # the slave thread into the slave's binary log. # log_slave_updates # Enable the full query log. every query (even ones with incorrect # syntax) that the server will be logged. this is useful for # debugging, it is usually disabled in production use. # log # Print warnings to the error log file. if you have any problem with # MySQL you shocould enable logging of warnings and examine the error log # for possible explanations. # log_warnings # Log slow queries. slow queries are queries which take more than the # amount of time defined in "long_query_time" or which do not use # indexes well, if log_short_format is not enabled. it is normally good idea # to have this turned on if you frequently add new queries to the # system. slow-query-log = 1 available # All queries taking more than this amount of time (in seconds) will be # trated as slow. do not use "1" as a value here, as this will result in # even very fast queries being logged from time to time (as MySQL # currently measures time with second accuracy only ). long_query_time = 5 available slow-query-log-file = slow. log change # log-queries-not-using-indexes # *** Replication related settings # Unique server identification number between 1 and 2 ^ 32-1. this value # is required for both master and slave hosts. it ults to 1 if # "master-host" is not set, but will MySQL will not function as a master # if it is omitted. server-id = 1 available # Replication Slave (comment out master section to use this) # To configure this host as a replication slave, you can choose between # two methods: #1) Use the change master to command (fully described in our manual)-# the syntax is: # change master to MASTER_HOST =

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.