WordPress.org

Make WordPress Core

Ticket #35249: mysql5.6.17 my.ini

File mysql5.6.17 my.ini, 5.3 KB (added by jrf, 5 years ago)
Line 
1# Example MySQL config file for medium systems.
2#
3# This is for a system with little memory (32M - 64M) where MySQL plays
4# an important part, or systems up to 128M where MySQL is used together with
5# other programs (such as a web server)
6#
7# You can copy this file to
8# /etc/my.cnf to set global options,
9# mysql-data-dir/my.cnf to set server-specific options (in this
10# installation this directory is C:\mysql\data) or
11# ~/.my.cnf to set user-specific options.
12#
13# In this file, you can use all long options that a program supports.
14# If you want to know which options a program supports, run the program
15# with the "--help" option.
16
17# The following options will be passed to all MySQL clients
18[client]
19#password       = your_password
20port            = 3306
21socket          = /tmp/mysql.sock
22
23# Here follows entries for some specific programs
24
25# The MySQL server
26[wampmysqld]
27port            = 3306
28socket          = /tmp/mysql.sock
29key_buffer_size = 16M
30max_allowed_packet = 1M
31sort_buffer_size = 512K
32net_buffer_length = 8K
33read_buffer_size = 256K
34read_rnd_buffer_size = 512K
35myisam_sort_buffer_size = 8M
36basedir=c:/wamp/bin/mysql/mysql5.6.17
37log-error=c:/wamp/logs/mysql.log
38datadir=c:/wamp/bin/mysql/mysql5.6.17/data
39
40lc-messages-dir=c:/wamp/bin/mysql/mysql5.6.17/share
41
42# Change your locale here !
43lc-messages=fr_FR
44
45# Avoid warning
46explicit_defaults_for_timestamp = TRUE
47
48# Don't listen on a TCP/IP port at all. This can be a security enhancement,
49# if all processes that need to connect to mysqld run on the same host.
50# All interaction with mysqld must be made via Unix sockets or named pipes.
51# Note that using this option without enabling named pipes on Windows
52# (via the "enable-named-pipe" option) will render mysqld useless!
53#
54#skip-networking
55
56# Disable Federated by default
57skip-federated
58
59# Replication Master Server (default)
60# binary logging is required for replication
61#log-bin=mysql-bin
62
63# binary logging format - mixed recommended
64#binlog_format=mixed
65
66# required unique id between 1 and 2^32 - 1
67# defaults to 1 if master-host is not set
68# but will not function as a master if omitted
69server-id       = 1
70
71# Replication Slave (comment out master section to use this)
72
73# New for MySQL 5.6 if no slave
74skip-slave-start
75
76#
77# To configure this host as a replication slave, you can choose between
78# two methods :
79#
80# 1) Use the CHANGE MASTER TO command (fully described in our manual) -
81#    the syntax is:
82#
83#    CHANGE MASTER TO MASTER_HOST=<host>, MASTER_PORT=<port>,
84#    MASTER_USER=<user>, MASTER_PASSWORD=<password> ;
85#
86#    where you replace <host>, <user>, <password> by quoted strings and
87#    <port> by the master's port number (3306 by default).
88#
89#    Example:
90#
91#    CHANGE MASTER TO MASTER_HOST='125.564.12.1', MASTER_PORT=3306,
92#    MASTER_USER='joe', MASTER_PASSWORD='secret';
93#
94# OR
95#
96# 2) Set the variables below. However, in case you choose this method, then
97#    start replication for the first time (even unsuccessfully, for example
98#    if you mistyped the password in master-password and the slave fails to
99#    connect), the slave will create a master.info file, and any later
100#    change in this file to the variables' values below will be ignored and
101#    overridden by the content of the master.info file, unless you shutdown
102#    the slave server, delete master.info and restart the slaver server.
103#    For that reason, you may want to leave the lines below untouched
104#    (commented) and instead use CHANGE MASTER TO (see above)
105#
106# required unique id between 2 and 2^32 - 1
107# (and different from the master)
108# defaults to 2 if master-host is set
109# but will not function as a slave if omitted
110#server-id       = 2
111#
112# The replication master for this slave - required
113#master-host     =   <hostname>
114#
115# The username the slave will use for authentication when connecting
116# to the master - required
117#master-user     =   <username>
118#
119# The password the slave will authenticate with when connecting to
120# the master - required
121#master-password =   <password>
122#
123# The port the master is listening on.
124# optional - defaults to 3306
125#master-port     =  <port>
126#
127# binary logging - not required for slaves, but recommended
128#log-bin=mysql-bin
129
130# Point the following paths to different dedicated disks
131#tmpdir         = /tmp/         
132#log-update     = /path-to-dedicated-directory/hostname
133
134# Uncomment the following if you are using InnoDB tables
135#innodb_data_home_dir = C:\mysql\data/
136#innodb_data_file_path = ibdata1:10M:autoextend
137#innodb_log_group_home_dir = C:\mysql\data/
138#innodb_log_arch_dir = C:\mysql\data/
139# You can set .._buffer_pool_size up to 50 - 80 %
140# of RAM but beware of setting memory usage too high
141#innodb_buffer_pool_size = 16M
142#innodb_additional_mem_pool_size = 2M
143# Set .._log_file_size to 25 % of buffer pool size
144#innodb_log_file_size = 5M
145#innodb_log_buffer_size = 8M
146#innodb_flush_log_at_trx_commit = 1
147#innodb_lock_wait_timeout = 50
148
149[mysqldump]
150quick
151max_allowed_packet = 16M
152
153[mysql]
154no-auto-rehash
155# Remove the next comment character if you are not familiar with SQL
156#safe-updates
157
158[isamchk]
159key_buffer = 20M
160sort_buffer_size = 20M
161read_buffer = 2M
162write_buffer = 2M
163
164[myisamchk]
165key_buffer = 20M
166sort_buffer_size = 20M
167read_buffer = 2M
168write_buffer = 2M
169
170[mysqlhotcopy]
171interactive-timeout
172
173[mysqld]
174port=3306
175explicit_defaults_for_timestamp = TRUE