|
Lines 51-74
socket = /var/run/mysqld/mysqld.so
Link Here
|
| 51 |
pid-file = /var/run/mysqld/mysqld.pid |
51 |
pid-file = /var/run/mysqld/mysqld.pid |
| 52 |
log-error = /var/log/mysql/mysqld.err |
52 |
log-error = /var/log/mysql/mysqld.err |
| 53 |
basedir = /usr |
53 |
basedir = /usr |
| 54 |
datadir = @DATADIR@ |
54 |
datadir = /var/lib/mysql |
| 55 |
skip-locking |
55 |
skip-locking |
| 56 |
key_buffer = 16M |
56 |
|
| 57 |
max_allowed_packet = 1M |
|
|
| 58 |
table_cache = 64 |
| 59 |
sort_buffer_size = 512K |
| 60 |
net_buffer_length = 8K |
| 61 |
read_buffer_size = 256K |
| 62 |
read_rnd_buffer_size = 512K |
| 63 |
myisam_sort_buffer_size = 8M |
| 64 |
language = /usr/share/mysql/english |
57 |
language = /usr/share/mysql/english |
| 65 |
|
58 |
|
|
|
59 |
##WMAPS settings |
| 60 |
key_buffer = 160M #: 32M |
| 61 |
max_allowed_packet = 64M |
| 62 |
table_cache = 4096 |
| 63 |
sort_buffer_size = 16M |
| 64 |
net_buffer_length = 8K |
| 65 |
read_buffer_size = 4M |
| 66 |
read_rnd_buffer_size = 64M #: 8M |
| 67 |
myisam_sort_buffer_size = 128M |
| 68 |
#myisam_index_space_size = 128M |
| 69 |
#00# 2009.03.23 enter |
| 70 |
#00# max_connections = 50 |
| 71 |
#00# max_user_connections = 50 |
| 72 |
max_connections = 20 |
| 73 |
max_user_connections = 20 |
| 74 |
#00# |
| 75 |
join_buffer_size = 32M |
| 76 |
thread_cache_size = 512 |
| 77 |
interactive_timeout = 25 |
| 78 |
wait_timeout = 60 |
| 79 |
connect_timeout = 30 |
| 80 |
max_connect_errors = 999999 |
| 81 |
####tmp_table_size = 16M |
| 82 |
tmp_table_size = 800M |
| 83 |
max_heap_table_size = 800M |
| 84 |
thread_stack = 128K |
| 85 |
# * Query Cache Configuration |
| 86 |
# |
| 87 |
query_cache_type = 1 |
| 88 |
query_cache_min_res_unit=8K |
| 89 |
query_cache_limit = 8M |
| 90 |
query_cache_size = 32M |
| 91 |
long_query_time = 1 |
| 92 |
#log-slow-queries = /var/log/mysql/slow_queries.log |
| 93 |
#log-queries-not-using-indexes |
| 94 |
#expire_logs_days = 1 |
| 95 |
|
| 96 |
# Try number of CPU's*2 for thread_concurrency |
| 97 |
thread_concurrency = 4 |
| 98 |
|
| 99 |
concurrent_insert=2 |
| 100 |
|
| 101 |
|
| 66 |
# security: |
102 |
# security: |
| 67 |
# using "localhost" in connects uses sockets by default |
103 |
# using "localhost" in connects uses sockets by default |
| 68 |
# skip-networking |
104 |
# skip-networking |
| 69 |
bind-address = 127.0.0.1 |
105 |
bind-address = 127.0.0.1 |
| 70 |
|
106 |
|
| 71 |
log-bin |
107 |
#log-bin |
| 72 |
server-id = 1 |
108 |
server-id = 1 |
| 73 |
|
109 |
|
| 74 |
# point the following paths to different dedicated disks |
110 |
# point the following paths to different dedicated disks |
|
Lines 97-105
tmpdir = /tmp/
Link Here
|
| 97 |
# the rest of the innodb config follows: |
133 |
# the rest of the innodb config follows: |
| 98 |
# don't eat too much memory, we're trying to be safe on 64Mb boxes |
134 |
# don't eat too much memory, we're trying to be safe on 64Mb boxes |
| 99 |
# you might want to bump this up a bit on boxes with more RAM |
135 |
# you might want to bump this up a bit on boxes with more RAM |
| 100 |
innodb_buffer_pool_size = 16M |
136 |
innodb_buffer_pool_size = 512M |
| 101 |
# this is the default, increase it if you have lots of tables |
137 |
# this is the default, increase it if you have lots of tables |
| 102 |
innodb_additional_mem_pool_size = 2M |
138 |
innodb_additional_mem_pool_size = 20M |
| 103 |
# |
139 |
# |
| 104 |
# i'd like to use /var/lib/mysql/innodb, but that is seen as a database :-( |
140 |
# i'd like to use /var/lib/mysql/innodb, but that is seen as a database :-( |
| 105 |
# and upstream wants things to be under /var/lib/mysql/, so that's the route |
141 |
# and upstream wants things to be under /var/lib/mysql/, so that's the route |
|
Lines 112-127
innodb_additional_mem_pool_size = 2M
Link Here
|
| 112 |
innodb_data_file_path = ibdata1:10M:autoextend:max:128M |
148 |
innodb_data_file_path = ibdata1:10M:autoextend:max:128M |
| 113 |
# we keep this at around 25% of of innodb_buffer_pool_size |
149 |
# we keep this at around 25% of of innodb_buffer_pool_size |
| 114 |
# sensible values range from 1MB to (1/innodb_log_files_in_group*innodb_buffer_pool_size) |
150 |
# sensible values range from 1MB to (1/innodb_log_files_in_group*innodb_buffer_pool_size) |
| 115 |
innodb_log_file_size = 5M |
151 |
innodb_log_file_size = 128M |
| 116 |
# this is the default, increase it if you have very large transactions going on |
152 |
# this is the default, increase it if you have very large transactions going on |
| 117 |
innodb_log_buffer_size = 8M |
153 |
innodb_log_buffer_size = 8M |
| 118 |
# this is the default and won't hurt you |
154 |
# this is the default and won't hurt you |
| 119 |
# you shouldn't need to tweak it |
155 |
# you shouldn't need to tweak it |
| 120 |
set-variable = innodb_log_files_in_group=2 |
156 |
set-variable = innodb_log_files_in_group=2 |
| 121 |
# see the innodb config docs, the other options are not always safe |
157 |
# see the innodb config docs, the other options are not always safe |
| 122 |
innodb_flush_log_at_trx_commit = 1 |
158 |
##innodb_flush_log_at_trx_commit = 1 |
|
|
159 |
innodb_flush_log_at_trx_commit = 2 |
| 123 |
innodb_lock_wait_timeout = 50 |
160 |
innodb_lock_wait_timeout = 50 |
| 124 |
innodb_file_per_table |
161 |
innodb_file_per_table |
|
|
162 |
innodb_flush_method=O_DIRECT |
| 163 |
innodb_thread_concurrency=8 |
| 164 |
transaction-isolation=READ-COMMITTED |
| 165 |
|
| 166 |
default_storage_engine=InnoDB |
| 167 |
#innodb_file_per_table=1 |
| 168 |
#innodb_file_format=barracuda |
| 169 |
#innodb_strict_mode=1 |
| 170 |
|
| 125 |
|
171 |
|
| 126 |
[mysqldump] |
172 |
[mysqldump] |
| 127 |
quick |
173 |
quick |
