Nach dem Update auf Nextcloud 23 ist die Performace nun mehr als schlecht. Unter 22 hatten wir auch ab und zu peeks aber jetzt warten wir nur noch.
php-fpm und mysql/mariadb Prozesse liegen oft bei 100 % oder höher. Mariadb tillt vor allem bei external_storage mounts und bei der mail app.
Die Daten meines Servers:
Centos 7x64
Prozessor: Intel(R) Xeon(R) CPU E5-2620 0 @ 2.00GHz (12 cores)
Speicher: 125.73 GB
Swappen trotz genĂŒgend zugewiesnem Speicher!
Apache im http2 modus:
Server version: Apache/2.4.43 (codeit)
Server built: Apr 25 2020 01:28:33
Serverâs Module Magic Number: 20120211:92
Server loaded: APR 1.7.0, APR-UTIL 1.6.1
Compiled using: APR 1.7.0, APR-UTIL 1.6.1
Architecture: 64-bit
Server MPM: event
threaded: yes (fixed thread count)
forked: yes (variable process count)
PHP /php-fpm 7.3.12
Arbeitsspeucher-Grenzwert 16 GB
Max Upload 10 GB
redis.x86_64 3.2.12-2.el7
mariadb 4.10.12
Datenbank GröĂe 2,5GB
Unsere php.config Sektion caching:
âmemcache.localâ => â\OC\Memcache\APCuâ,
âfilelocking.enabledâ => âtrueâ,
âmemcache.lockingâ => â\OC\Memcache\Redisâ,
âmemcache.distributedâ => â\OC\Memcache\Redisâ,
âredisâ =>
array (
âhostâ => âlocalhostâ,
âportâ => 6379,
âtimeoutâ => 0.0,
),
Wir können hier keinen redis-socket einsetzen weil auf dem gleichen Host onlyoffice documentserver lÀuft.
redis.conf:
bind 127.0.0.1
port 6379
tcp-keepalive 300
php-fpm.conf:
include=/etc/php-fpm.d/*.conf
pid = /run/php-fpm/php-fpm.pid
error_log = /var/log/php-fpm/error.log
emergency_restart_threshold = 10
emergency_restart_interval = 1m
process_control_timeout = 10
php-fpm â www.conf:
[www]
user = apache
group = apache
listen = 127.0.0.1:9000
pm = dynamic
pm.max_children = 296
pm.start_servers = 147
pm.min_spare_servers = 98
pm.max_spare_servers = 197
pm.max_requests = 1000
request_terminate_timeout = 3600
10-opcache.ini:
zend_extension=opcache
opcache.enable=1
opcache.enable_cli=1
opcache.memory_consumption=256
opcache.interned_strings_buffer=16
opcache.max_accelerated_files=10000
opcache.revalidate_freq=1
opcache.max_file_size=0
opcache.file_cache_only=0
opcache.huge_code_pages=0
30-pdo_mysql.ini:
; Enable pdo_mysql extension module
extension=pdo_mysql
mariadbâ> server.cnf:
[server]
skip-name-resolve = 1
innodb_buffer_pool_size = 6000M
#innodb_buffer_pool_size = 1024M
innodb_buffer_pool_instances = 1
innodb_flush_log_at_trx_commit = 2
innodb_log_buffer_size = 32M
innodb_max_dirty_pages_pct = 90
query_cache_type = 1
query_cache_limit = 2M
query_cache_min_res_unit = 2k
query_cache_size = 64M
tmp_table_size= 64M
max_heap_table_size= 64M
slow-query-log = 1
bind-address = 127.0.0.1
slow_query_log_file = /var/log/mysql/mysql.log
key_buffer_size = 128M
lc_messages_dir = /usr/share/mysql
lc_messages = en_US
log_slow_verbosity = query_plan
log_warnings = 2
long_query_time = 1
max_allowed_packet = 16M
max_binlog_size = 100M
max_connections = 200
myisam_recover_options = BACKUP
myisam_sort_buffer_size = 512M
read_buffer_size = 2M
read_rnd_buffer_size = 1M
skip-external-locking
sort_buffer_size = 4M
table_open_cache = 400
thread_cache_size = 128
tmp_table_size = 64M
wait_timeout = 600
[mysqld]
character-set-server = utf8mb4
collation-server = utf8mb4_general_ci
transaction_isolation = READ-COMMITTED
binlog_format = ROW
innodb_large_prefix=on
innodb_file_format=barracuda
innodb_file_per_table=1
innodb_open_files = 400
innodb_io_capacity = 4000
innodb_flush_method = O_DIRECT
concurrent_insert = 2
connect_timeout = 5
expire_logs_days = 2
[client]
default-character-set = utf8mb4
[galera]
[embedded]
[mariadb]
[mariadb-10.4]
[mysqldump]
max_allowed_packet = 16M
quick
quote-names
[isamchk]
key_buffer = 16M
In den LOG-dateien von php-fpm nur das ĂŒbliche:
[17-Mar-2022 09:30:37] NOTICE: [pool www] child 13848 started
[17-Mar-2022 09:30:55] NOTICE: [pool www] child 8375 exited with code 0 after 163727.286687 seconds from start
Nextloud/mariadb log finde ich auch keinen Anhaltspunkt?
redis auch nur das ĂŒbliche:
1877:M 17 Mar 09:29:51.929 * Background saving terminated with success
1877:M 17 Mar 09:34:52.029 * 10 changes in 300 seconds. SavingâŠ
1877:M 17 Mar 09:34:52.031 * Background saving started by pid 16768
16768:C 17 Mar 09:34:52.807 * DB saved on disk
16768:C 17 Mar 09:34:52.809 * RDB: 3 MB of memory used by copy-on-write
1877:M 17 Mar 09:34:52.832 * Background saving terminated with success
1877:M 17 Mar 09:39:53.063 * 10 changes in 300 seconds. SavingâŠ
1877:M 17 Mar 09:39:53.065 * Background saving started by pid 20041
20041:C 17 Mar 09:39:53.887 * DB saved on disk
20041:C 17 Mar 09:39:53.889 * RDB: 4 MB of memory used by copy-on-write
1877:M 17 Mar 09:39:53.967 * Background saving terminated with success
Kann mir jemand weiterhelfen?