gistfile1

A Text snippet, saved for reference.

Text

1 file

Created 1 year ago

Updated 1 year ago

gistfile1.txt

1	# Example MySQL config file for small systems.
2	#
3	# This is for a system with little memory (<= 64M) where MySQL is only used
4	# from time to time and it's important that the mysqld daemon
5	# doesn't use much resources.
6	#
7	# You can copy this file to
8	# C:/xampp/mysql/bin/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:/xampp/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
20	port = 3306
21	socket = "C:/xampp/mysql/mysql.sock"
22
23
24	# Here follows entries for some specific programs
25
26	# The MySQL server
27	[mysqld]
28	port= 3306
29	socket = "C:/xampp/mysql/mysql.sock"
30	basedir = "C:/xampp/mysql"
31	tmpdir = "C:/xampp/tmp"
32	datadir = "C:/xampp/mysql/data"
33	pid_file = "mysql.pid"
34	# enable-named-pipe
35	key_buffer = 16M
36	max_allowed_packet = 1M
37	sort_buffer_size = 512K
38	net_buffer_length = 8K
39	read_buffer_size = 256K
40	read_rnd_buffer_size = 512K
41	myisam_sort_buffer_size = 8M
42	log_error = "mysql_error.log"
43
44	# Change here for bind listening
45	# bind-address="127.0.0.1"
46	# bind-address = ::1 # for ipv6
47
48	# Where do all the plugins live
49	plugin_dir = "C:/xampp/mysql/lib/plugin/"
50
51	# Don't listen on a TCP/IP port at all. This can be a security enhancement,
52	# if all processes that need to connect to mysqld run on the same host.
53	# All interaction with mysqld must be made via Unix sockets or named pipes.
54	# Note that using this option without enabling named pipes on Windows
55	# (via the "enable-named-pipe" option) will render mysqld useless!
56	#
57	# commented in by lampp security
58	#skip-networking
59	#skip-federated
60
61	# Replication Master Server (default)
62	# binary logging is required for replication
63	# log-bin deactivated by default since XAMPP 1.4.11
64	#log-bin=mysql-bin
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
69	server-id = 1
70
71	# Replication Slave (comment out master section to use this)
72	#
73	# To configure this host as a replication slave, you can choose between
74	# two methods :
75	#
76	# 1) Use the CHANGE MASTER TO command (fully described in our manual) -
77	# the syntax is:
78	#
79	# CHANGE MASTER TO MASTER_HOST=<host>, MASTER_PORT=<port>,
80	# MASTER_USER=<user>, MASTER_PASSWORD=<password> ;
81	#
82	# where you replace <host>, <user>, <password> by quoted strings and
83	# <port> by the master's port number (3306 by default).
84	#
85	# Example:
86	#
87	# CHANGE MASTER TO MASTER_HOST='125.564.12.1', MASTER_PORT=3306,
88	# MASTER_USER='joe', MASTER_PASSWORD='secret';
89	#
90	# OR
91	#
92	# 2) Set the variables below. However, in case you choose this method, then
93	# start replication for the first time (even unsuccessfully, for example
94	# if you mistyped the password in master-password and the slave fails to
95	# connect), the slave will create a master.info file, and any later
96	# change in this file to the variables' values below will be ignored and
97	# overridden by the content of the master.info file, unless you shutdown
98	# the slave server, delete master.info and restart the slaver server.
99	# For that reason, you may want to leave the lines below untouched
100	# (commented) and instead use CHANGE MASTER TO (see above)
101	#
102	# required unique id between 2 and 2^32 - 1
103	# (and different from the master)
104	# defaults to 2 if master-host is set
105	# but will not function as a slave if omitted
106	#server-id = 2
107	#
108	# The replication master for this slave - required
109	#master-host = <hostname>
110	#
111	# The username the slave will use for authentication when connecting
112	# to the master - required
113	#master-user = <username>
114	#
115	# The password the slave will authenticate with when connecting to
116	# the master - required
117	#master-password = <password>
118	#
119	# The port the master is listening on.
120	# optional - defaults to 3306
121	#master-port = <port>
122	#
123	# binary logging - not required for slaves, but recommended
124	#log-bin=mysql-bin
125
126
127	# Point the following paths to different dedicated disks
128	#tmpdir = "C:/xampp/tmp"
129	#log-update = /path-to-dedicated-directory/hostname
130
131	# Uncomment the following if you are using BDB tables
132	#bdb_cache_size = 4M
133	#bdb_max_lock = 10000
134
135	# Comment the following if you are using InnoDB tables
136	#skip-innodb
137	innodb_data_home_dir = "C:/xampp/mysql/data"
138	innodb_data_file_path = ibdata1:10M:autoextend
139	innodb_log_group_home_dir = "C:/xampp/mysql/data"
140	#innodb_log_arch_dir = "C:/xampp/mysql/data"
141	## You can set .._buffer_pool_size up to 50 - 80 %
142	## of RAM but beware of setting memory usage too high
143	innodb_buffer_pool_size = 16M
144	innodb_additional_mem_pool_size = 2M
145	## Set .._log_file_size to 25 % of buffer pool size
146	innodb_log_file_size = 5M
147	innodb_log_buffer_size = 8M
148	innodb_flush_log_at_trx_commit = 1
149	innodb_lock_wait_timeout = 50
150
151	## UTF 8 Settings
152	#init-connect=\'SET NAMES utf8\'
153	#collation_server=utf8_unicode_ci
154	#character_set_server=utf8
155	#skip-character-set-client-handshake
156	#character_sets-dir="C:/xampp/mysql/share/charsets"
157
158	[mysqldump]
159	quick
160	max_allowed_packet = 16M
161
162	[mysql]
163	no-auto-rehash
164	# Remove the next comment character if you are not familiar with SQL
165	#safe-updates
166
167	[isamchk]
168	key_buffer = 20M
169	sort_buffer_size = 20M
170	read_buffer = 2M
171	write_buffer = 2M
172
173	[myisamchk]
174	key_buffer = 20M
175	sort_buffer_size = 20M
176	read_buffer = 2M
177	write_buffer = 2M
178
179	[mysqlhotcopy]
180	interactive-timeout