tnAnGel
Проверенные
- Сообщения
- 1,239
- Реакции
- 910
- Баллы
- 8,265
Я окончательно запутался с конфигом, прошу помощи. Все что есть - написал сам. Писал исключительно в server.cnf -> [mysqld].
Имеем сервер с mysqld 10.1.28-MariaDB
Проблема: бесконечная загрузка панели администратора форума. Попасть в нее невозможно.
в my.cnf заинклюжена папка с конфигами:
В папке:
Имеем сервер с mysqld 10.1.28-MariaDB
Проблема: бесконечная загрузка панели администратора форума. Попасть в нее невозможно.
в my.cnf заинклюжена папка с конфигами:
!includedir /etc/my.cnf.dВ папке:
client.cnf enable_encryption.preset mysql-clients.cnf server.cnf tokudb.cnf
Код:
#
# These two groups are read by the client library
# Use it for options that affect all clients, but not the server
#
[client]
# This group is not read by mysql client library,
# If you use the same .cnf file for MySQL and MariaDB,
# use it for MariaDB-only client options
[client-mariadb]
Код:
#
# These groups are read by MariaDB command-line tools
# Use it for options that affect only one utility
#
[mysql]
[mysql_upgrade]
[mysqladmin]
[mysqlbinlog]
[mysqlcheck]
[mysqldump]
[mysqlimport]
[mysqlshow]
[mysqlslap]
Код:
#
# These groups are read by MariaDB server.
# Use it for options that only the server (but not clients) should see
#
# See the examples of server my.cnf files in /usr/share/mysql/
#
# this is read by the standalone daemon and embedded servers
[server]
# this is only for the mysqld standalone daemon
[mysqld]
key_buffer_size = 256M
max_allowed_packet = 32M
sort_buffer_size = 16M
read_buffer_size = 16M
read_rnd_buffer_size = 16M
myisam_sort_buffer_size = 512M
thread_cache_size = 128
table_open_cache = 2048
query_cache_size= 1024M
thread_concurrency = 8
#innodb_use_native_aio = 0
innodb_file_per_table
#
innodb_buffer_pool_size = 2048M
innodb_additional_mem_pool_size = 128M
#innodb_log_file_size = 2048M
innodb_flush_log_at_trx_commit = 0
innodb_log_buffer_size = 64M
#
max_connections=2000
max_user_connections=500
wait_timeout=250
interactive_timeout=2500
long_query_time=1000
#
# * Galera-related settings
#
[galera]
# Mandatory settings
#wsrep_on=ON
#wsrep_provider=
#wsrep_cluster_address=
#binlog_format=row
#default_storage_engine=InnoDB
#innodb_autoinc_lock_mode=2
#
# Allow server to accept connections on all interfaces.
#
#bind-address=0.0.0.0
#
# Optional setting
#wsrep_slave_threads=1
#innodb_flush_log_at_trx_commit=0
# this is only for embedded server
[embedded]
# This group is only read by MariaDB servers, not by MySQL.
# If you use the same .cnf file for MySQL and MariaDB,
# you can put MariaDB-only options here
[mariadb]
#General Query Log
#general_log
#general_log_file = /var/log/mariadb/mysql_query.log
#Error Log
log_error = /var/log/mariadb/mysql_error.log
#Slow Query Log
#log-slow-queries
#slow_query_log = 1
#slow_query_log_file = /var/log/mariadb/mysql_slow.log
#long_query_time = 2
#log-queries-not-using-indexes
# This group is only read by MariaDB-10.1 servers.
# If you use the same .cnf file for MariaDB of different versions,
# use this group for options that older servers don't understand
[mariadb-10.1]
]
Код:
[mariadb]
# See https://mariadb.com/kb/en/how-to-enable-tokudb-in-mariadb/
# for instructions how to enable TokuDB
#
# See https://mariadb.com/kb/en/tokudb-differences/ for differences
# between TokuDB in MariaDB and TokuDB from http://www.tokutek.com/
#plugin-load-add=ha_tokudb.so