/usr/share/digikam/database/mysql-global.conf is in digikam-data 4:5.6.0-0ubuntu10.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 | # ============================================================
#
# This file is a part of digiKam project
# http://www.digikam.org
#
# Date : 2009-07-28
# Description : Global digiKam MySQL Internal server default settings.
# These settings can be adjusted if necessary in mysql.conf
# file installed at database install path.
# Based on advice by Kris Köhntopp <kris at mysql dot com>
# for Akonadi project.
#
# Copyright (C) 2009 by Holger Foerster <hamsi2k at freenet dot de>
# Copyright (C) 2007-2013 by Marcel Wiesweg <marcel dot wiesweg at gmx dot de>
# Copyright (C) 2010-2016 by Gilles Caulier <caulier dot gilles at gmail dot com>
#
# This program is free software; you can redistribute it
# and/or modify it under the terms of the GNU General
# Public License as published by the Free Software Foundation;
# either version 2, or (at your option)
# any later version.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
# GNU General Public License for more details.
#
# ============================================================
[mysqld]
### SKIP FEATURES SETTINGS ####################################
# Be able to be connected to databse without a password
skip_grant_tables
# No remote access to database
skip_networking
# strict query parsing/interpretation
# TODO: make digiKam work with those settings enabled
#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
#sql_mode=strict_trans_tables
### CHAR ENCODING SETTINGS ####################################
# case-insensitive table names, avoids trouble on windows
#lower_case_table_names=1
character_set_server=utf8
collation_server=utf8_bin
### LOG FILES SETTINGS ########################################
# Log rules
log_bin=mysql-bin
log-bin-trust-function-creators=1
expire_logs_days=3
#sync_bin_log=0
# log file name to store errors, relative to datadir
log_error=mysql.err
log_warnings=2
# log all queries, useful for debugging but generates an enormous amount of data
#general_log=0
#general_log_file=mysql.full
# log queries slower than n seconds, log file name relative to datadir
slow_query_log_file=mysql.slow
long_query_time=1
# log queries not using indices, debug only, disable for production use
log_queries_not_using_indexes=1
### CACHE SETTINGS ###########################################
# makes sense when having the same query multiple times
# makes no sense with prepared statements and/or transactions
query_cache_type=0
query_cache_size=0
table_open_cache=200
thread_cache_size=3
### INNO DATABASE ENGINE SETTINGS #############################
innodb_file_per_table=1
innodb_log_buffer_size=1M
innodb_buffer_pool_size=80M
# 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)
innodb_log_file_size=64M
innodb_flush_log_at_trx_commit=2
### MISC SETTINGS #############################################
# maximum blob size
max_allowed_packet=128M
max_connections=256
# messure database size and adjust
# SELECT sum(data_length) as bla, sum(index_length) as blub FROM information_schema.tables WHERE table_schema not in ("mysql", "information_schema");
|