MySQL under the bin directory of no my - default. Ini and my ini (no), affect the use, or the file is doing

CodePudding user response:

Reference: http://bbs.csdn.net/topics/390340540

CodePudding user response:

Details refer to the following url:
http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html

Specific content as follows: the main is the database of general Settings

[mysqld]

# # Remove leading and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of the total RAM for dedicated server, the else 10%.
# innodb_buffer_pool_size=128 m

# # Remove leading to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin

# These are commonly set, remove the # and set as required.
# basedir=...
# datadir=...
# port=...
# server_id=...
# socket=...

# # Remove leading to set the options mainly useful for reporting the servers.
# The server defaults are faster - for The transactions and fast SELECTs.
# Adjust sizes as men, experiment to find the optimal values. The r advice on how to change Settings both please see

CodePudding user response:

What all need not set can be used in it

CodePudding user response:

# # Remove leading to set the options mainly useful for reporting the servers.
# The server defaults are faster - for The transactions and fast SELECTs.
# Adjust sizes as men, experiment to find the optimal values.
# join_buffer_size=128 m
# sort_buffer_size=2 m
# read_rnd_buffer_size=2 m

sql_mode=NO_ENGINE_SUBSTITUTION, STRICT_TRANS_TABLES
# lower_case_table_names=1

Main use is red the words

CodePudding user response:

Configuration files, no can also be used?