Nextcloud server load unusually high: Difference between revisions
Jump to navigation
Jump to search
(Created page with "= The Problem = I noticed the power consumption (measured with Shelly Plug S and Home Assistant is higher than usual (see also CPU comparison (bogomips))). = The Analysis = * CPU load ist constantly around 1. That's too much for a mostly idling machine. * <code>top</code> reveals PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 1221 mysql 20 0 2573120 283648 10752...") |
No edit summary |
||
Line 21: | Line 21: | ||
= The Solution = | = The Solution = | ||
https://docs.nextcloud.com/server/28/admin_manual/configuration_files/files_locking_transactional.html |
Revision as of 14:02, 23 January 2024
The Problem
I noticed the power consumption (measured with Shelly Plug S and Home Assistant is higher than usual (see also CPU comparison (bogomips))).
The Analysis
- CPU load ist constantly around 1. That's too much for a mostly idling machine.
top
reveals
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 1221 mysql 20 0 2573120 283648 10752 S 16.89 3.546 2466:15 mysqld 18184 wwwrun 20 0 304196 222904 29312 S 9.603 2.787 0:55.97 php
show processlist;
reveals:
MariaDB [(none)]> show processlist; +--------+------+-----------+------+---------+------+----------+------------------------------------------------------------------------------------------------------+----------+ | Id | User | Host | db | Command | Time | State | Info | Progress | +--------+------+-----------+------+---------+------+----------+------------------------------------------------------------------------------------------------------+----------+ | 556827 | nc | localhost | nc | Query | 0 | Commit | UPDATE `oc_file_locks` SET `lock` = `lock` - 1 WHERE (`key` = 'files/f59c6cd9c59c75a2b6a12e00aa33a5b | 0.000 | | 557075 | root | localhost | NULL | Query | 0 | starting | show processlist | 0.000 | +--------+------+-----------+------+---------+------+----------+------------------------------------------------------------------------------------------------------+----------+ 2 rows in set (0.000 sec) MariaDB [(none)]>