1 |
robbat2 14/07/29 23:14:33 |
2 |
|
3 |
Added: my.cnf-5.5 |
4 |
Log: |
5 |
Bring MySQL(percona-server) 5.6 from the overlay into the tree. Thanks to the great work of Brian Evans <grknight@g.o>. |
6 |
|
7 |
(Portage version: 2.2.10/cvs/Linux x86_64, unsigned Manifest commit) |
8 |
|
9 |
Revision Changes Path |
10 |
1.1 dev-db/percona-server/files/my.cnf-5.5 |
11 |
|
12 |
file : http://sources.gentoo.org/viewvc.cgi/gentoo-x86/dev-db/percona-server/files/my.cnf-5.5?rev=1.1&view=markup |
13 |
plain: http://sources.gentoo.org/viewvc.cgi/gentoo-x86/dev-db/percona-server/files/my.cnf-5.5?rev=1.1&content-type=text/plain |
14 |
|
15 |
Index: my.cnf-5.5 |
16 |
=================================================================== |
17 |
# @GENTOO_PORTAGE_EPREFIX@/etc/mysql/my.cnf: The global mysql configuration file. |
18 |
# $Header: /var/cvsroot/gentoo-x86/dev-db/percona-server/files/my.cnf-5.5,v 1.1 2014/07/29 23:14:33 robbat2 Exp $ |
19 |
|
20 |
# The following options will be passed to all MySQL clients |
21 |
[client] |
22 |
#password = your_password |
23 |
port = 3306 |
24 |
socket = @GENTOO_PORTAGE_EPREFIX@/var/run/mysqld/mysqld.sock |
25 |
|
26 |
[mysql] |
27 |
character-sets-dir=@GENTOO_PORTAGE_EPREFIX@/usr/share/mysql/charsets |
28 |
default-character-set=utf8 |
29 |
|
30 |
[mysqladmin] |
31 |
character-sets-dir=@GENTOO_PORTAGE_EPREFIX@/usr/share/mysql/charsets |
32 |
default-character-set=utf8 |
33 |
|
34 |
[mysqlcheck] |
35 |
character-sets-dir=@GENTOO_PORTAGE_EPREFIX@/usr/share/mysql/charsets |
36 |
default-character-set=utf8 |
37 |
|
38 |
[mysqldump] |
39 |
character-sets-dir=@GENTOO_PORTAGE_EPREFIX@/usr/share/mysql/charsets |
40 |
default-character-set=utf8 |
41 |
|
42 |
[mysqlimport] |
43 |
character-sets-dir=@GENTOO_PORTAGE_EPREFIX@/usr/share/mysql/charsets |
44 |
default-character-set=utf8 |
45 |
|
46 |
[mysqlshow] |
47 |
character-sets-dir=@GENTOO_PORTAGE_EPREFIX@/usr/share/mysql/charsets |
48 |
default-character-set=utf8 |
49 |
|
50 |
[myisamchk] |
51 |
character-sets-dir=@GENTOO_PORTAGE_EPREFIX@/usr/share/mysql/charsets |
52 |
|
53 |
[myisampack] |
54 |
character-sets-dir=@GENTOO_PORTAGE_EPREFIX@/usr/share/mysql/charsets |
55 |
|
56 |
# use [safe_mysqld] with mysql-3 |
57 |
[mysqld_safe] |
58 |
err-log = @GENTOO_PORTAGE_EPREFIX@/var/log/mysql/mysql.err |
59 |
|
60 |
# add a section [mysqld-4.1] or [mysqld-5.0] for specific configurations |
61 |
[mysqld] |
62 |
character-set-server = utf8 |
63 |
user = mysql |
64 |
port = 3306 |
65 |
socket = @GENTOO_PORTAGE_EPREFIX@/var/run/mysqld/mysqld.sock |
66 |
pid-file = @GENTOO_PORTAGE_EPREFIX@/var/run/mysqld/mysqld.pid |
67 |
log-error = @GENTOO_PORTAGE_EPREFIX@/var/log/mysql/mysqld.err |
68 |
basedir = @GENTOO_PORTAGE_EPREFIX@/usr |
69 |
datadir = @DATADIR@ |
70 |
skip-external-locking |
71 |
key_buffer_size = 16M |
72 |
max_allowed_packet = 1M |
73 |
table_open_cache = 64 |
74 |
sort_buffer_size = 512K |
75 |
net_buffer_length = 8K |
76 |
read_buffer_size = 256K |
77 |
read_rnd_buffer_size = 512K |
78 |
myisam_sort_buffer_size = 8M |
79 |
lc_messages_dir = @GENTOO_PORTAGE_EPREFIX@/usr/share/mysql |
80 |
#Set this to your desired error message language |
81 |
lc_messages = en_US |
82 |
|
83 |
# security: |
84 |
# using "localhost" in connects uses sockets by default |
85 |
# skip-networking |
86 |
bind-address = 127.0.0.1 |
87 |
|
88 |
log-bin |
89 |
server-id = 1 |
90 |
|
91 |
# point the following paths to different dedicated disks |
92 |
tmpdir = @GENTOO_PORTAGE_EPREFIX@/tmp/ |
93 |
#log-update = @GENTOO_PORTAGE_EPREFIX@/path-to-dedicated-directory/hostname |
94 |
|
95 |
# you need the debug USE flag enabled to use the following directives, |
96 |
# if needed, uncomment them, start the server and issue |
97 |
# #tail -f @GENTOO_PORTAGE_EPREFIX@/tmp/mysqld.sql @GENTOO_PORTAGE_EPREFIX@/tmp/mysqld.trace |
98 |
# this will show you *exactly* what's happening in your server ;) |
99 |
|
100 |
#log = @GENTOO_PORTAGE_EPREFIX@/tmp/mysqld.sql |
101 |
#gdb |
102 |
#debug = d:t:i:o,/tmp/mysqld.trace |
103 |
#one-thread |
104 |
|
105 |
# the following is the InnoDB configuration |
106 |
# if you wish to disable innodb instead |
107 |
# uncomment just the next line |
108 |
#skip-innodb |
109 |
# |
110 |
# the rest of the innodb config follows: |
111 |
# don't eat too much memory, we're trying to be safe on 64Mb boxes |
112 |
# you might want to bump this up a bit on boxes with more RAM |
113 |
innodb_buffer_pool_size = 16M |
114 |
# this is the default, increase it if you have lots of tables |
115 |
innodb_additional_mem_pool_size = 2M |
116 |
# |
117 |
# i'd like to use @GENTOO_PORTAGE_EPREFIX@/var/lib/mysql/innodb, but that is seen as a database :-( |
118 |
# and upstream wants things to be under @GENTOO_PORTAGE_EPREFIX@/var/lib/mysql/, so that's the route |
119 |
# we have to take for the moment |
120 |
#innodb_data_home_dir = @GENTOO_PORTAGE_EPREFIX@/var/lib/mysql/ |
121 |
#innodb_log_arch_dir = @GENTOO_PORTAGE_EPREFIX@/var/lib/mysql/ |
122 |
#innodb_log_group_home_dir = @GENTOO_PORTAGE_EPREFIX@/var/lib/mysql/ |
123 |
# you may wish to change this size to be more suitable for your system |
124 |
# the max is there to avoid run-away growth on your machine |
125 |
innodb_data_file_path = ibdata1:10M:autoextend:max:128M |
126 |
# we keep this at around 25% of of innodb_buffer_pool_size |
127 |
# sensible values range from 1MB to (1/innodb_log_files_in_group*innodb_buffer_pool_size) |
128 |
innodb_log_file_size = 5M |
129 |
# this is the default, increase it if you have very large transactions going on |
130 |
innodb_log_buffer_size = 8M |
131 |
# this is the default and won't hurt you |
132 |
# you shouldn't need to tweak it |
133 |
innodb_log_files_in_group=2 |
134 |
# see the innodb config docs, the other options are not always safe |
135 |
innodb_flush_log_at_trx_commit = 1 |
136 |
innodb_lock_wait_timeout = 50 |
137 |
innodb_file_per_table |
138 |
|
139 |
# Uncomment this to get FEDERATED engine support |
140 |
#plugin-load=federated=ha_federated.so |
141 |
loose-federated |
142 |
|
143 |
[mysqldump] |
144 |
quick |
145 |
max_allowed_packet = 16M |
146 |
|
147 |
[mysql] |
148 |
# uncomment the next directive if you are not familiar with SQL |
149 |
#safe-updates |
150 |
|
151 |
[isamchk] |
152 |
key_buffer_size = 20M |
153 |
sort_buffer_size = 20M |
154 |
read_buffer = 2M |
155 |
write_buffer = 2M |
156 |
|
157 |
[myisamchk] |
158 |
key_buffer_size = 20M |
159 |
sort_buffer_size = 20M |
160 |
read_buffer_size = 2M |
161 |
write_buffer_size = 2M |
162 |
|
163 |
[mysqlhotcopy] |
164 |
interactive-timeout |