5
5
# Based on advice by Kris Köhntopp <kris@mysql.com>
11
9
# strict query parsing/interpretation
12
10
# TODO: make Akonadi work with those settings enabled
13
#sql_mode=strict_trans_tables,strict_all_tables,strict_error_for_division_by_zero,no_auto_create_user,no_auto_value_on_zero,no_engine_substitution,no_zero_date,no_zero_in_date,only_full_group_by,pipes_as_concat
14
#sql_mode=strict_trans_tables
11
# sql_mode=strict_trans_tables,strict_all_tables,strict_error_for_division_by_zero,no_auto_create_user,no_auto_value_on_zero,no_engine_substitution,no_zero_date,no_zero_in_date,only_full_group_by,pipes_as_concat
12
# sql_mode=strict_trans_tables
15
# log all queries, useful for debugging but generates an enormous amount of data
17
# log queries slower than n seconds, log file name relative to datadir (for debugging only)
18
# log_slow_queries=mysql.slow
20
# log queries not using indices, debug only, disable for production use
21
# log_queries_not_using_indexes=1
23
# mesure database size and adjust innodb_buffer_pool_size
24
# SELECT sum(data_length) as bla, sum(index_length) as blub FROM information_schema.tables WHERE table_schema not in ("mysql", "information_schema");
27
# Keep Innob_log_waits and keep Innodb_buffer_pool_wait_free small (see show global status like "inno%", show global variables)
33
# Use UTF-8 encoding for tables
34
character_set_server=utf8
35
collation_server=utf8_general_ci
16
37
# use InnoDB for transactions and better crash recovery
17
38
default_storage_engine=innodb
18
# case-insensitive table names, avoids trouble on windows
19
lower_case_table_names=1
20
character_set_server=utf8
21
collation_server=utf8_general_ci
27
# error log file name, relative to datadir
40
# memory pool InnoDB uses to store data dictionary information and other internal data structures (default:1M)
41
innodb_additional_mem_pool_size=1M
43
# memory buffer InnoDB uses to cache data and indexes of its tables (default:128M)
44
# Larger values means less I/O
45
innodb_buffer_pool_size=8M
47
# Create a .ibd file for each table (default:0)
48
innodb_file_per_table=1
50
# Write out the log buffer to the log file at each commit (default:1)
51
innodb_flush_log_at_trx_commit=2
53
# Buffer size used to write to the log files on disk (default:1M for builtin, 8M for plugin)
54
# larger values means less I/O
55
innodb_log_buffer_size=1M
57
# Size of each log file in a log group (default:5M) larger means less I/O but more time for recovery.
58
innodb_log_file_size=2M
60
# # error log file name, relative to datadir (default:hostname.err)
28
61
log_error=mysql.err
63
# print warnings and connection errors (default:1)
30
# log all queries, useful for debugging but generates an enormous amount of data
32
# log queries slower than n seconds, log file name relative to datadir (for debugging only)
33
#log_slow_queries=mysql.slow
35
# log queries not using indices, debug only, disable for production use
36
#log_queries_not_using_indexes=1
66
# Convert table named to lowercase
67
lower_case_table_names=1
69
# Maximum size of one packet or any generated/intermediate string. (default:1M)
38
70
max_allowed_packet=32M
72
# Maximum simultaneous connections allowed (default:100)
39
73
max_connections=256
40
# makes sense when having the same query multiple times
41
# makes no sense with prepared statements and/or transactions
75
# The two options below make no sense with prepared statements and/or transactions
76
# (make sense when having the same query multiple times)
78
# Memory allocated for caching query results (default:0 (disabled))
81
# Do not cache results (default:1)
45
innodb_file_per_table=1
46
innodb_log_buffer_size=1M
47
innodb_additional_mem_pool_size=1M
48
# messure database size and adjust
49
# SELECT sum(data_length) as bla, sum(index_length) as blub FROM information_schema.tables WHERE table_schema not in ("mysql", "information_schema");
50
innodb_buffer_pool_size=8M
51
# size of average write burst, keep Innob_log_waits small, keep Innodb_buffer_pool_wait_free small (see show global status like "inno%", show global variables)
52
innodb_log_file_size=2M
53
innodb_flush_log_at_trx_commit=2
55
# Do not drop the connection to the DB after 8 hours of inactivity
84
# Do not use the privileges mechanisms
87
# Do not listen for TCP/IP connections at all
90
# The number of open tables for all threads. (default:64)
93
# How many threads the server should cache for reuse (default:0)
96
# wait 365d before dropping the DB connection (default:8h)
56
97
wait_timeout=31536000