High mysql CPU usage

[ZetiX]

Nextcloud version_: 19.0.2
Operating system and version (eg, Ubuntu 20.04): Raspbian GNU/Linux 10 (buster)
Apache or nginx version (eg, Apache 2.4.25): 2.4.38
PHP version (eg, 7.1): 7.3.19-1~deb10u1

The issue you are facing:
I’ve been experiencing high mysql cpu usage for a while now and I can’t seem to find the cause. It’s been slowly down my pi by a lot since the cpu usage is always 80%+ on all cores constantly.

Is this the first time you’ve seen this error? (Y/N): Y

The output of your Nextcloud log in Admin > Logging:

[OC\Log\Rotate] Warning: Log file "/media/myCloudDrive/ncdata/nextcloud.log" was over 104857600 bytes, moved to "/media/myCloudDrive/ncdata/nextcloud.log.1"

at 2020-08-31T16:30:02+00:00

The output of your config.php file in /path/to/nextcloud (make sure you remove any identifiable information!):

$CONFIG = array (
  'passwordsalt' => '',
  'secret' => '',
  'trusted_domains' =>
  array (
    0 => 'localhost',
  ),
  'datadirectory' => '/media/myCloudDrive/ncdata',
  'dbtype' => 'mysql',
  'version' => '19.0.2.2',
  'overwrite.cli.url' => '',
  'dbname' => 'nextcloud',
  'dbhost' => 'localhost',
  'dbport' => '',
  'dbtableprefix' => 'oc_',
  'mysql.utf8mb4' => true,
  'dbuser' => '',
  'dbpassword' => '',
  'installed' => true,
  'instanceid' => '',
  'memcache.local' => '\\OC\\Memcache\\Redis',
  'memcache.locking' => '\\OC\\Memcache\\Redis',
  'redis' =>
  array (
    'host' => '/var/run/redis/redis.sock',
    'port' => 0,
    'timeout' => 0.0,
    'password' => '',
  ),
  'tempdirectory' => '/media/myCloudDrive/ncdata/tmp',
  'mail_smtpmode' => 'smtp',
  'mail_smtpauthtype' => 'LOGIN',
  'mail_from_address' => '',
  'mail_domain' => 'gmail.com',
  'preview_max_x' => '2048',
  'preview_max_y' => '2048',
  'jpeg_quality' => '60',
  'overwriteprotocol' => 'https',
  'maintenance' => false,
  'logfile' => '/media/myCloudDrive/ncdata/nextcloud.log',
  'loglevel' => '2',
  'log_type' => 'file',
  'theme' => '',
  'mail_sendmailmode' => 'pipe',
  'mail_smtpauth' => 1,
  'mail_smtphost' => 'smtp.gmail.com',
  'mail_smtpport' => '465',
  'mail_smtpname' => '',
  'mail_smtppassword' => '',
  'mail_smtpsecure' => 'ssl',
  'htaccess.RewriteBase' => '/',
  'app_install_overwrite' =>
  array (
    0 => 'joplin',
    1 => 'keeweb',
  ),
);

[h3rb3rt]

I am having the same issue. I think, it started to appear after I upgraded to 19.0.x

I use NextcloudPI on a Debian System, if this makes any difference.

@ZetiX
Are you using NCP too?

[h3rb3rt]

I turned on query_cache = 1 in my mysql config which brought down the memory usage in more or less now time after restarting the service, and it stayed down.

Query Cache

Enable the query cache in MySQL to improve performance - nixCraft

[h3rb3rt]

Still investigating on this, I must assume that with NC 19 the CPU usage also for the PHP-FPM processes raised. I would appreciate if someone could help investigate.

I have no real idea how to search for the requests keeping mysql (which is better with caching turned on) and my php-fpm processes busy.

Thanks

[devnull]

Perhaps you can make some tuning configurations if not used:
https://docs.nextcloud.com/server/19/admin_manual/installation/server_tuning.html

[h3rb3rt]

Thanks, I worked through that list already, anyhow, most of the recommendations were already integrated with the NextCloudPi installation.

So there must be something else, something with NC 19 or an App used (even though I am only using “official” ones). Any way to investigate what the php-fpm processes are doing to keep them busy?

[devnull]

One of test best linux tools is “lsof”. Perhaps you can install it and list processes, port, files with “lsof”. Also you can then look with the process-id in /proc . Post some outputs.

[h3rb3rt]

One of the php processes running high on CPU

COMMAND   PID     USER   FD   TYPE             DEVICE SIZE/OFF     NODE NAME
php-fpm7. 311 www-data  cwd    DIR                8,1     4096 11407538 /var/www/nextcloud
php-fpm7. 311 www-data  rtd    DIR                8,1     4096        2 /
php-fpm7. 311 www-data  txt    REG                8,1  4763032  8521053 /usr/sbin/php-fpm7.3
php-fpm7. 311 www-data  mem    REG                8,1   200752  8525792 /usr/lib/locale/C.UTF-8/LC_CTYPE
php-fpm7. 311 www-data  mem    REG                8,1  1517626  8525791 /usr/lib/locale/C.UTF-8/LC_COLLATE
php-fpm7. 311 www-data  mem    REG                8,1    14448  8534602 /usr/lib/x86_64-linux-gnu/gconv/IBM850.so
php-fpm7. 311 www-data  DEL    REG                0,5            479423 /dev/zero
php-fpm7. 311 www-data  mem    REG                8,1    18568  8534776 /usr/lib/x86_64-linux-gnu/gconv/UTF-16.so
php-fpm7. 311 www-data  mem    REG                8,1   282752  7209465 /lib/x86_64-linux-gnu/libnss_systemd.so.2
php-fpm7. 311 www-data  mem    REG                8,1   101648  8520424 /usr/lib/x86_64-linux-gnu/libzip.so.4.0
php-fpm7. 311 www-data  mem    REG                8,1    67688  8913226 /usr/lib/php/20180731/zip.so
php-fpm7. 311 www-data  mem    REG                8,1   264320  8528982 /usr/lib/x86_64-linux-gnu/libxslt.so.1.1.32
php-fpm7. 311 www-data  mem    REG                8,1    92008  8528981 /usr/lib/x86_64-linux-gnu/libexslt.so.0.8.20
php-fpm7. 311 www-data  mem    REG                8,1    38856  9045390 /usr/lib/x86_64-linux-gnu/samba/gensec/krb5.so
php-fpm7. 311 www-data  mem    REG                8,1    34920  8914831 /usr/lib/php/20180731/xsl.so
php-fpm7. 311 www-data  mem    REG                8,1    51304  8914830 /usr/lib/php/20180731/xmlwriter.so
php-fpm7. 311 www-data  mem    REG                8,1    39016  8914829 /usr/lib/php/20180731/xmlreader.so
php-fpm7. 311 www-data  mem    REG                8,1    34920  8914808 /usr/lib/php/20180731/wddx.so
php-fpm7. 311 www-data  mem    REG                8,1    22632  8915207 /usr/lib/php/20180731/tokenizer.so
php-fpm7. 311 www-data  mem    REG                8,1    14440  8915206 /usr/lib/php/20180731/sysvshm.so
php-fpm7. 311 www-data  mem    REG                8,1    96360  8915203 /usr/lib/php/20180731/sockets.so
php-fpm7. 311 www-data  mem    REG                8,1    55608  8526653 /usr/lib/x86_64-linux-gnu/libjansson.so.4.11.1
php-fpm7. 311 www-data  mem    REG                8,1    14256  9045393 /usr/lib/x86_64-linux-gnu/samba/libMESSAGING-SEND.so.0
php-fpm7. 311 www-data  mem    REG                8,1    14264  9044041 /usr/lib/x86_64-linux-gnu/samba/libwinbind-client.so.0
php-fpm7. 311 www-data  mem    REG                8,1    14256  9046931 /usr/lib/x86_64-linux-gnu/samba/libflag-mapping.so.0
php-fpm7. 311 www-data  mem    REG                8,1    63480  8521838 /usr/lib/x86_64-linux-gnu/libndr-krb5pac.so.0.0.1
php-fpm7. 311 www-data  mem    REG                8,1   166000  9047849 /usr/lib/x86_64-linux-gnu/samba/libwind-samba4.so.0.0.0
php-fpm7. 311 www-data  mem    REG                8,1    59784  9047816 /usr/lib/x86_64-linux-gnu/samba/libroken-samba4.so.19.0.1
php-fpm7. 311 www-data  mem    REG                8,1   211576  9046937 /usr/lib/x86_64-linux-gnu/samba/libhcrypto-samba4.so.5.0.1
php-fpm7. 311 www-data  mem    REG                8,1   297656  9046941 /usr/lib/x86_64-linux-gnu/samba/libhx509-samba4.so.5.0.0
php-fpm7. 311 www-data  mem    REG                8,1   552560  9045398 /usr/lib/x86_64-linux-gnu/samba/libasn1-samba4.so.8.0.0
php-fpm7. 311 www-data  mem    REG                8,1    18952  9046938 /usr/lib/x86_64-linux-gnu/samba/libheimbase-samba4.so.1.0.0
php-fpm7. 311 www-data  mem    REG                8,1    14184  9046953 /usr/lib/x86_64-linux-gnu/samba/libmsghdr.so.0
php-fpm7. 311 www-data  mem    REG                8,1    34736  9046047 /usr/lib/x86_64-linux-gnu/samba/libcli-ldap-common.so.0
php-fpm7. 311 www-data  mem    REG                8,1    51120  9046922 /usr/lib/x86_64-linux-gnu/samba/libcommon-auth.so.0
php-fpm7. 311 www-data  mem    REG                8,1   105048  8521908 /usr/lib/x86_64-linux-gnu/libsamdb.so.0.0.1
php-fpm7. 311 www-data  mem    REG                8,1    14256  9047819 /usr/lib/x86_64-linux-gnu/samba/libsamba-modules.so.0
php-fpm7. 311 www-data  mem    REG                8,1    59312  8521865 /usr/lib/x86_64-linux-gnu/libwbclient.so.0.14
php-fpm7. 311 www-data  mem    REG                8,1   202808  8526834 /usr/lib/x86_64-linux-gnu/libldb.so.1.4.6
php-fpm7. 311 www-data  mem    REG                8,1   186848  9046947 /usr/lib/x86_64-linux-gnu/samba/libldbsamba.so.0
php-fpm7. 311 www-data  mem    REG                8,1   190504  9047825 /usr/lib/x86_64-linux-gnu/samba/libsamdb-common.so.0
php-fpm7. 311 www-data  mem    REG                8,1    42928  9046050 /usr/lib/x86_64-linux-gnu/samba/libcli-nbt.so.0
php-fpm7. 311 www-data  mem    REG                8,1   112672  9046045 /usr/lib/x86_64-linux-gnu/samba/libauthkrb5.so.0
php-fpm7. 311 www-data  mem    REG                8,1    51120  9046946 /usr/lib/x86_64-linux-gnu/samba/libkrb5samba.so.0
php-fpm7. 311 www-data  mem    REG                8,1   219888  9046936 /usr/lib/x86_64-linux-gnu/samba/libgssapi-samba4.so.2.0.0
php-fpm7. 311 www-data  mem    REG                8,1    47096  9045395 /usr/lib/x86_64-linux-gnu/samba/libaddns.so.0
php-fpm7. 311 www-data  mem    REG                8,1   465288  9046945 /usr/lib/x86_64-linux-gnu/samba/libkrb5-samba4.so.26.0.0
php-fpm7. 311 www-data  mem    REG                8,1    26864  7209009 /lib/x86_64-linux-gnu/libcap.so.2.25
php-fpm7. 311 www-data  mem    REG                8,1    96264  8521961 /usr/lib/x86_64-linux-gnu/libtdb.so.1.3.16
php-fpm7. 311 www-data  mem    REG                8,1    89016  7209785 /lib/x86_64-linux-gnu/libnsl-2.28.so
php-fpm7. 311 www-data  mem    REG                8,1    14328  9047829 /usr/lib/x86_64-linux-gnu/samba/libserver-role.so.0
php-fpm7. 311 www-data  mem    REG                8,1    14256  9047842 /usr/lib/x86_64-linux-gnu/samba/libtdb-wrap.so.0
php-fpm7. 311 www-data  mem    REG                8,1    14184  9047847 /usr/lib/x86_64-linux-gnu/samba/libutil-setid.so.0
php-fpm7. 311 www-data  mem    REG                8,1    14184  9046952 /usr/lib/x86_64-linux-gnu/samba/libmessages-util.so.0
php-fpm7. 311 www-data  mem    REG                8,1    14328  9047846 /usr/lib/x86_64-linux-gnu/samba/libutil-reg.so.0
php-fpm7. 311 www-data  mem    REG                8,1    14256  9046944 /usr/lib/x86_64-linux-gnu/samba/libiov-buf.so.0
php-fpm7. 311 www-data  mem    REG                8,1    14256  9047828 /usr/lib/x86_64-linux-gnu/samba/libserver-id-db.so.0
php-fpm7. 311 www-data  mem    REG                8,1    14184  9047836 /usr/lib/x86_64-linux-gnu/samba/libsmbd-shim.so.0
php-fpm7. 311 www-data  mem    REG                8,1    51120  9046951 /usr/lib/x86_64-linux-gnu/samba/libmessages-dgm.so.0
php-fpm7. 311 www-data  mem    REG                8,1    14256  9047841 /usr/lib/x86_64-linux-gnu/samba/libtalloc-report.so.0
php-fpm7. 311 www-data  mem    REG                8,1    14256  9046943 /usr/lib/x86_64-linux-gnu/samba/libinterfaces.so.0
php-fpm7. 311 www-data  mem    REG                8,1    26544  9047832 /usr/lib/x86_64-linux-gnu/samba/libsmb-transport.so.0
php-fpm7. 311 www-data  mem    REG                8,1    92152  8521839 /usr/lib/x86_64-linux-gnu/libndr-nbt.so.0.0.1
php-fpm7. 311 www-data  mem    REG                8,1    14264  9046921 /usr/lib/x86_64-linux-gnu/samba/libcom_err-samba4.so.0.25
php-fpm7. 311 www-data  mem    REG                8,1    14256  9045391 /usr/lib/x86_64-linux-gnu/samba/libCHARSET3.so.0
php-fpm7. 311 www-data  mem    REG                8,1    34808  9046046 /usr/lib/x86_64-linux-gnu/samba/libcli-cldap.so.0
php-fpm7. 311 www-data  mem    REG                8,1    30640  9045399 /usr/lib/x86_64-linux-gnu/samba/libasn1util.so.0
php-fpm7. 311 www-data  mem    REG                8,1   186440  9046933 /usr/lib/x86_64-linux-gnu/samba/libgensec.so.0
php-fpm7. 311 www-data  mem    REG                8,1   104440  9047823 /usr/lib/x86_64-linux-gnu/samba/libsamba-sockets.so.0
php-fpm7. 311 www-data  mem    REG                8,1    14256  9047848 /usr/lib/x86_64-linux-gnu/samba/libutil-tdb.so.0
php-fpm7. 311 www-data  mem    REG                8,1   133112  8521830 /usr/lib/x86_64-linux-gnu/libdcerpc-binding.so.0.0.1
php-fpm7. 311 www-data  mem    REG                8,1    83888  9046054 /usr/lib/x86_64-linux-gnu/samba/libcliauth.so.0
php-fpm7. 311 www-data  mem    REG                8,1    47024  9046923 /usr/lib/x86_64-linux-gnu/samba/libdbwrap.so.0
php-fpm7. 311 www-data  mem    REG                8,1   184536  8521845 /usr/lib/x86_64-linux-gnu/libsamba-hostconfig.so.0.0.1
php-fpm7. 311 www-data  mem    REG                8,1  1284088  9046955 /usr/lib/x86_64-linux-gnu/samba/libndr-samba.so.0
php-fpm7. 311 www-data  mem    REG                8,1    83888  8521843 /usr/lib/x86_64-linux-gnu/libsamba-credentials.so.0.0.1
php-fpm7. 311 www-data  mem    REG                8,1    14184  9047840 /usr/lib/x86_64-linux-gnu/samba/libsys-rw.so.0
php-fpm7. 311 www-data  mem    REG                8,1    14184  9047839 /usr/lib/x86_64-linux-gnu/samba/libsocket-blocking.so.0
php-fpm7. 311 www-data  mem    REG                8,1    14184  9044040 /usr/lib/x86_64-linux-gnu/samba/libreplace.so.0
php-fpm7. 311 www-data  mem    REG                8,1    14256  9046932 /usr/lib/x86_64-linux-gnu/samba/libgenrand.so.0
php-fpm7. 311 www-data  mem    REG                8,1    34648  9045397 /usr/lib/x86_64-linux-gnu/samba/libaesni-intel.so.0
php-fpm7. 311 www-data  mem    REG                8,1    14256  9047843 /usr/lib/x86_64-linux-gnu/samba/libtime-basic.so.0
php-fpm7. 311 www-data  mem    REG                8,1    80872  8526830 /usr/lib/x86_64-linux-gnu/libtevent.so.0.9.37
php-fpm7. 311 www-data  mem    REG                8,1    83888  8526822 /usr/lib/x86_64-linux-gnu/libtalloc.so.2.1.14
php-fpm7. 311 www-data  mem    REG                8,1   104368  9047827 /usr/lib/x86_64-linux-gnu/samba/libsecrets3.so.0
php-fpm7. 311 www-data  mem    REG                8,1    47024  9047824 /usr/lib/x86_64-linux-gnu/samba/libsamba3-util.so.0
php-fpm7. 311 www-data  mem    REG                8,1    18352  9047845 /usr/lib/x86_64-linux-gnu/samba/libutil-cmdline.so.0
php-fpm7. 311 www-data  mem    REG                8,1   190456  9046051 /usr/lib/x86_64-linux-gnu/samba/libcli-smb-common.so.0
php-fpm7. 311 www-data  mem    REG                8,1  1681328  9046924 /usr/lib/x86_64-linux-gnu/samba/libdcerpc-samba.so.0
php-fpm7. 311 www-data  mem    REG                8,1  3319800  8521840 /usr/lib/x86_64-linux-gnu/libndr-standard.so.0.0.1
php-fpm7. 311 www-data  mem    REG                8,1   170096  9046935 /usr/lib/x86_64-linux-gnu/samba/libgse.so.0
php-fpm7. 311 www-data  mem    REG                8,1    22448  8526795 /usr/lib/x86_64-linux-gnu/libtevent-util.so.0.0.1
php-fpm7. 311 www-data  mem    REG                8,1  1349624  8521844 /usr/lib/x86_64-linux-gnu/libsamba-errors.so.1
php-fpm7. 311 www-data  mem    REG                8,1    31024  9047818 /usr/lib/x86_64-linux-gnu/samba/libsamba-debug.so.0
php-fpm7. 311 www-data  mem    REG                8,1    92152  8521841 /usr/lib/x86_64-linux-gnu/libndr.so.0.1.0
php-fpm7. 311 www-data  mem    REG                8,1   630000  8526793 /usr/lib/x86_64-linux-gnu/libsmbconf.so.0
php-fpm7. 311 www-data  mem    REG                8,1   133208  9047822 /usr/lib/x86_64-linux-gnu/samba/libsamba-security.so.0
php-fpm7. 311 www-data  mem    REG                8,1   460720  9046950 /usr/lib/x86_64-linux-gnu/samba/liblibsmb.so.0
php-fpm7. 311 www-data  mem    REG                8,1    18352  9046948 /usr/lib/x86_64-linux-gnu/samba/liblibcli-lsa3.so.0
php-fpm7. 311 www-data  mem    REG                8,1   141304  9046954 /usr/lib/x86_64-linux-gnu/samba/libmsrpc3.so.0
php-fpm7. 311 www-data  mem    REG                8,1   493776  8521906 /usr/lib/x86_64-linux-gnu/libsamba-util.so.0.0.1
php-fpm7. 311 www-data  mem    REG                8,1   165808  8521139 /usr/lib/x86_64-linux-gnu/libsmbclient.so.0.4.0
php-fpm7. 311 www-data  mem    REG                8,1    69256  8913158 /usr/lib/php/20180731/smbclient.so
php-fpm7. 311 www-data  mem    REG                8,1    55400  8914807 /usr/lib/php/20180731/simplexml.so
php-fpm7. 311 www-data  mem    REG                8,1   528384  8913156 /usr/lib/php/20180731/redis.so
php-fpm7. 311 www-data  mem    REG                8,1   183528  7209092 /lib/x86_64-linux-gnu/libtinfo.so.6.1
php-fpm7. 311 www-data  mem    REG                8,1   165824  7209154 /lib/x86_64-linux-gnu/libncurses.so.6.1
php-fpm7. 311 www-data  mem    REG                8,1   204344  8525503 /usr/lib/x86_64-linux-gnu/libedit.so.2.0.59
php-fpm7. 311 www-data  mem    REG                8,1    14440  8915205 /usr/lib/php/20180731/sysvsem.so
php-fpm7. 311 www-data  mem    REG                8,1    22632  8915204 /usr/lib/php/20180731/sysvmsg.so
php-fpm7. 311 www-data  mem    REG                8,1    34920  8914981 /usr/lib/php/20180731/readline.so
php-fpm7. 311 www-data  mem    REG                8,1    39016  8915201 /usr/lib/php/20180731/posix.so
php-fpm7. 311 www-data  mem    REG                8,1   280680  8915200 /usr/lib/php/20180731/phar.so
php-fpm7. 311 www-data  mem    REG                8,1   141416  8915082 /usr/lib/php/20180731/mysqli.so
php-fpm7. 311 www-data  mem    REG                8,1    55792  7209957 /lib/x86_64-linux-gnu/libnss_files-2.28.so
php-fpm7. 311 www-data  DEL    REG                0,5            479428 /dev/zero
php-fpm7. 311 www-data  mem    REG                8,1    26402  8534786 /usr/lib/x86_64-linux-gnu/gconv/gconv-modules.cache
php-fpm7. 311 www-data  mem    REG                8,1  1611912  8915087 /usr/lib/php/20180731/mbstring.so
php-fpm7. 311 www-data  mem    REG                8,1    96360  8915088 /usr/lib/php/20180731/ldap.so
php-fpm7. 311 www-data  mem    REG                8,1    47208  8915136 /usr/lib/php/20180731/json.so
php-fpm7. 311 www-data  mem    REG                8,1    55304  8523041 /usr/lib/x86_64-linux-gnu/libicuio.so.63.1
php-fpm7. 311 www-data  mem    REG                8,1    30824  8915085 /usr/lib/php/20180731/pdo_mysql.so
php-fpm7. 311 www-data  mem    REG                8,1   489672  8915137 /usr/lib/php/20180731/intl.so
php-fpm7. 311 www-data  mem    REG                8,1   211168  8913155 /usr/lib/php/20180731/igbinary.so
php-fpm7. 311 www-data  mem    REG                8,1    47208  8915198 /usr/lib/php/20180731/iconv.so
php-fpm7. 311 www-data  mem    REG                8,1    75880  8915173 /usr/lib/php/20180731/gmp.so
php-fpm7. 311 www-data  mem    REG                8,1    96568  8524645 /usr/lib/x86_64-linux-gnu/libbsd.so.0.9.1
php-fpm7. 311 www-data  mem    REG                8,1    22728  8528919 /usr/lib/x86_64-linux-gnu/libXdmcp.so.6.0.0
php-fpm7. 311 www-data  mem    REG                8,1    14528  8522948 /usr/lib/x86_64-linux-gnu/libXau.so.6.0.0
php-fpm7. 311 www-data  mem    REG                8,1    58384  8529806 /usr/lib/x86_64-linux-gnu/libjbig.so.0
php-fpm7. 311 www-data  mem    REG                8,1   649136  8519859 /usr/lib/x86_64-linux-gnu/libzstd.so.1.3.8
php-fpm7. 311 www-data  mem    REG                8,1    30776  7209624 /lib/x86_64-linux-gnu/libuuid.so.1.3.0
php-fpm7. 311 www-data  mem    REG                8,1   243840  7208964 /lib/x86_64-linux-gnu/libexpat.so.1.6.8
php-fpm7. 311 www-data  mem    REG                8,1   166824  8526816 /usr/lib/x86_64-linux-gnu/libxcb.so.1.1.0
php-fpm7. 311 www-data  mem    REG                8,1   522776  8520082 /usr/lib/x86_64-linux-gnu/libtiff.so.5.5.0
php-fpm7. 311 www-data  mem    REG                8,1   281592  8520370 /usr/lib/x86_64-linux-gnu/libfontconfig.so.1.12.0
php-fpm7. 311 www-data  mem    REG                8,1   763816  8521371 /usr/lib/x86_64-linux-gnu/libfreetype.so.6.16.1
php-fpm7. 311 www-data  mem    REG                8,1   420472  8520376 /usr/lib/x86_64-linux-gnu/libwebp.so.6.0.2
php-fpm7. 311 www-data  mem    REG                8,1   428032  8523437 /usr/lib/x86_64-linux-gnu/libjpeg.so.62.2.0
php-fpm7. 311 www-data  mem    REG                8,1   227248  8523417 /usr/lib/x86_64-linux-gnu/libpng16.so.16.36.0
php-fpm7. 311 www-data  mem    REG                8,1    72872  8520378 /usr/lib/x86_64-linux-gnu/libXpm.so.4.11.0
php-fpm7. 311 www-data  mem    REG                8,1  1310216  8526818 /usr/lib/x86_64-linux-gnu/libX11.so.6.3.0
php-fpm7. 311 www-data  mem    REG                8,1   414376  8528350 /usr/lib/x86_64-linux-gnu/libgd.so.3.0.5
php-fpm7. 311 www-data  mem    REG                8,1   108648  8915179 /usr/lib/php/20180731/gd.so
php-fpm7. 311 www-data  mem    REG                8,1    67688  8915196 /usr/lib/php/20180731/ftp.so
php-fpm7. 311 www-data  mem    REG                8,1  5429360  8915195 /usr/lib/php/20180731/fileinfo.so
php-fpm7. 311 www-data  mem    REG                8,1    92264  8915194 /usr/lib/php/20180731/exif.so
php-fpm7. 311 www-data  mem    REG                8,1   165992  8913227 /usr/lib/php/20180731/dom.so
php-fpm7. 311 www-data  mem    REG                8,1    35224  8522193 /usr/lib/x86_64-linux-gnu/libffi.so.6.0.4
php-fpm7. 311 www-data  mem    REG                8,1    75776  8522533 /usr/lib/x86_64-linux-gnu/libtasn1.so.6.5.5
php-fpm7. 311 www-data  mem    REG                8,1  1236720  8522531 /usr/lib/x86_64-linux-gnu/libp11-kit.so.0.3.0
php-fpm7. 311 www-data  mem    REG                8,1   113392  8521334 /usr/lib/x86_64-linux-gnu/libsasl2.so.2.0.25
php-fpm7. 311 www-data  mem    REG                8,1    56352  8520509 /usr/lib/x86_64-linux-gnu/libkrb5support.so.0.1
php-fpm7. 311 www-data  mem    REG                8,1   533280  8525329 /usr/lib/x86_64-linux-gnu/libgmp.so.10.3.2
php-fpm7. 311 www-data  mem    REG                8,1   224472  8522497 /usr/lib/x86_64-linux-gnu/libnettle.so.6.5
php-fpm7. 311 www-data  mem    REG                8,1   229192  8522499 /usr/lib/x86_64-linux-gnu/libhogweed.so.4.5
php-fpm7. 311 www-data  mem    REG                8,1  1748352  8521369 /usr/lib/x86_64-linux-gnu/libgnutls.so.30.23.2
php-fpm7. 311 www-data  mem    REG                8,1  1583144  8522501 /usr/lib/x86_64-linux-gnu/libunistring.so.2.1.0
php-fpm7. 311 www-data  mem    REG                8,1    63672  8526986 /usr/lib/x86_64-linux-gnu/liblber-2.4.so.2.10.10
php-fpm7. 311 www-data  mem    REG                8,1   331088  8526987 /usr/lib/x86_64-linux-gnu/libldap_r-2.4.so.2.10.10
php-fpm7. 311 www-data  mem    REG                8,1   203600  8520507 /usr/lib/x86_64-linux-gnu/libk5crypto.so.3.1
php-fpm7. 311 www-data  mem    REG                8,1   913280  8520514 /usr/lib/x86_64-linux-gnu/libkrb5.so.3.3
php-fpm7. 311 www-data  mem    REG                8,1   309744  8520511 /usr/lib/x86_64-linux-gnu/libgssapi_krb5.so.2.2
php-fpm7. 311 www-data  mem    REG                8,1    71520  8527061 /usr/lib/x86_64-linux-gnu/libpsl.so.5.3.1
php-fpm7. 311 www-data  mem    REG                8,1   186696  8525432 /usr/lib/x86_64-linux-gnu/libssh2.so.1.0.1
php-fpm7. 311 www-data  mem    REG                8,1   118184  8525430 /usr/lib/x86_64-linux-gnu/librtmp.so.1
php-fpm7. 311 www-data  mem    REG                8,1   120752  8537672 /usr/lib/x86_64-linux-gnu/libidn2.so.0.3.4
php-fpm7. 311 www-data  mem    REG                8,1   588232  8520871 /usr/lib/x86_64-linux-gnu/libcurl.so.4.5.0
php-fpm7. 311 www-data  mem    REG                8,1  4618768  8526896 /usr/lib/locale/locale-archive
php-fpm7. 311 www-data  mem    REG                8,1    22448  7208966 /lib/x86_64-linux-gnu/libkeyutils.so.1.8
php-fpm7. 311 www-data  mem    REG                8,1    18344  7208984 /lib/x86_64-linux-gnu/libcom_err.so.2.1
php-fpm7. 311 www-data  mem    REG                8,1   158128  8520054 /usr/lib/x86_64-linux-gnu/libnghttp2.so.14.17.1
php-fpm7. 311 www-data  mem    REG                8,1    14440  8915202 /usr/lib/php/20180731/shmop.so
php-fpm7. 311 www-data  mem    REG                8,1    14440  8915197 /usr/lib/php/20180731/gettext.so
php-fpm7. 311 www-data  mem    REG                8,1   104552  8915188 /usr/lib/php/20180731/curl.so
php-fpm7. 311 www-data  mem    REG                8,1    14440  8915193 /usr/lib/php/20180731/ctype.so
php-fpm7. 311 www-data  mem    REG                8,1    74688  7209051 /lib/x86_64-linux-gnu/libbz2.so.1.0.4
php-fpm7. 311 www-data  mem    REG                8,1    34920  8915192 /usr/lib/php/20180731/calendar.so
php-fpm7. 311 www-data  mem    REG                8,1    26728  8915189 /usr/lib/php/20180731/bz2.so
php-fpm7. 311 www-data  mem    REG                8,1    55400  8914828 /usr/lib/php/20180731/xml.so
php-fpm7. 311 www-data  mem    REG                8,1   112744  8915199 /usr/lib/php/20180731/pdo.so
php-fpm7. 311 www-data  mem    REG                8,1   251512  8915084 /usr/lib/php/20180731/mysqlnd.so
php-fpm7. 311 www-data  mem    REG                8,1   518640  8914983 /usr/lib/php/20180731/opcache.so
php-fpm7. 311 www-data  mem    REG                8,1    26960  7209951 /lib/x86_64-linux-gnu/libnss_dns-2.28.so
php-fpm7. 311 www-data  mem    REG                8,1       50  8531528 /usr/lib/locale/C.UTF-8/LC_NUMERIC
php-fpm7. 311 www-data  mem    REG                8,1     3360  8531531 /usr/lib/locale/C.UTF-8/LC_TIME
php-fpm7. 311 www-data  mem    REG                8,1      270  8531526 /usr/lib/locale/C.UTF-8/LC_MONETARY
php-fpm7. 311 www-data  mem    REG                8,1       48  8531525 /usr/lib/locale/C.UTF-8/LC_MESSAGES/SYS_LC_MESSAGES
php-fpm7. 311 www-data  mem    REG                8,1       34  8531529 /usr/lib/locale/C.UTF-8/LC_PAPER
php-fpm7. 311 www-data  mem    REG                8,1       62  8531527 /usr/lib/locale/C.UTF-8/LC_NAME
php-fpm7. 311 www-data  mem    REG                8,1      131  8525790 /usr/lib/locale/C.UTF-8/LC_ADDRESS
php-fpm7. 311 www-data  mem    REG                8,1       47  8531530 /usr/lib/locale/C.UTF-8/LC_TELEPHONE
php-fpm7. 311 www-data  mem    REG                8,1       23  8531524 /usr/lib/locale/C.UTF-8/LC_MEASUREMENT
php-fpm7. 311 www-data  mem    REG                8,1   100712  7209507 /lib/x86_64-linux-gnu/libgcc_s.so.1
php-fpm7. 311 www-data  mem    REG                8,1  1570256  8519689 /usr/lib/x86_64-linux-gnu/libstdc++.so.6.0.25
php-fpm7. 311 www-data  mem    REG                8,1   137424  7209054 /lib/x86_64-linux-gnu/libgpg-error.so.0.26.1
php-fpm7. 311 www-data  mem    REG                8,1 27190832  8522552 /usr/lib/x86_64-linux-gnu/libicudata.so.63.1
php-fpm7. 311 www-data  mem    REG                8,1  1886216  8523974 /usr/lib/x86_64-linux-gnu/libicuuc.so.63.1
php-fpm7. 311 www-data  mem    REG                8,1  2984248  8522649 /usr/lib/x86_64-linux-gnu/libicui18n.so.63.1
php-fpm7. 311 www-data  mem    REG                8,1  1168056  7209011 /lib/x86_64-linux-gnu/libgcrypt.so.20.2.4
php-fpm7. 311 www-data  mem    REG                8,1   121184  8519855 /usr/lib/x86_64-linux-gnu/liblz4.so.1.8.3
php-fpm7. 311 www-data  mem    REG                8,1   158400  7209578 /lib/x86_64-linux-gnu/liblzma.so.5.2.4
php-fpm7. 311 www-data  mem    REG                8,1   146968  7209964 /lib/x86_64-linux-gnu/libpthread-2.28.so
php-fpm7. 311 www-data  mem    REG                8,1  1824496  7209779 /lib/x86_64-linux-gnu/libc-2.28.so
php-fpm7. 311 www-data  mem    REG                8,1   350920  8528633 /usr/lib/x86_64-linux-gnu/libsodium.so.23.2.0
php-fpm7. 311 www-data  mem    REG                8,1   539304  8520426 /usr/lib/x86_64-linux-gnu/libpcre2-8.so.0.7.1
php-fpm7. 311 www-data  mem    REG                8,1  3031904  8524387 /usr/lib/x86_64-linux-gnu/libcrypto.so.1.1
php-fpm7. 311 www-data  mem    REG                8,1   593696  8524388 /usr/lib/x86_64-linux-gnu/libssl.so.1.1
php-fpm7. 311 www-data  mem    REG                8,1  1731832  8526666 /usr/lib/x86_64-linux-gnu/libxml2.so.2.9.4
php-fpm7. 311 www-data  mem    REG                8,1   651472  7209047 /lib/x86_64-linux-gnu/libsystemd.so.0.25.0
php-fpm7. 311 www-data  mem    REG                8,1    80576  7209027 /lib/x86_64-linux-gnu/libapparmor.so.1.6.0
php-fpm7. 311 www-data  mem    REG                8,1    14592  7209781 /lib/x86_64-linux-gnu/libdl-2.28.so
php-fpm7. 311 www-data  mem    REG                8,1  1579448  7209782 /lib/x86_64-linux-gnu/libm-2.28.so
php-fpm7. 311 www-data  mem    REG                8,1    35808  7209974 /lib/x86_64-linux-gnu/librt-2.28.so
php-fpm7. 311 www-data  mem    REG                8,1   121280  7208991 /lib/x86_64-linux-gnu/libz.so.1.2.11
php-fpm7. 311 www-data  mem    REG                8,1    93000  7209970 /lib/x86_64-linux-gnu/libresolv-2.28.so
php-fpm7. 311 www-data  mem    REG                8,1    34968  8527507 /usr/lib/x86_64-linux-gnu/libargon2.so.1
php-fpm7. 311 www-data  mem    REG                8,1      252  8531523 /usr/lib/locale/C.UTF-8/LC_IDENTIFICATION
php-fpm7. 311 www-data  mem    REG                8,1    39024  8913484 /usr/lib/php/20180731/bcmath.so
php-fpm7. 311 www-data  mem    REG                8,1   165632  7209770 /lib/x86_64-linux-gnu/ld-2.28.so
php-fpm7. 311 www-data    0u   CHR                1,3      0t0     1028 /dev/null
php-fpm7. 311 www-data    1u   CHR                1,3      0t0     1028 /dev/null
php-fpm7. 311 www-data    2u   CHR                1,3      0t0     1028 /dev/null
php-fpm7. 311 www-data    3ur  REG                8,1        0  6291477 /tmp/.ZendSem.5h0FHf (deleted)
php-fpm7. 311 www-data    4u  unix 0x00000000ed6ce1a8      0t0   959401 /run/php/php7.3-fpm.sock type=STREAM
php-fpm7. 311 www-data    5u  unix 0x000000008d441195      0t0   961636 type=STREAM
php-fpm7. 311 www-data    6u  unix 0x0000000029c1a1d8      0t0   960576 type=STREAM
php-fpm7. 311 www-data    9u  unix 0x0000000048784756      0t0   479431 /run/php/php7.3-fpm.sock type=STREAM
php-fpm7. 311 www-data   12r   CHR                1,9      0t0     1033 /dev/urandom

[h3rb3rt]

The mysql process, high cpu usage

COMMAND  PID  USER   FD   TYPE             DEVICE   SIZE/OFF     NODE NAME
mysqld  6093 mysql  cwd    DIR                8,1       4096 11405595 /var/lib/mysql
mysqld  6093 mysql  rtd    DIR                8,1       4096        2 /
mysqld  6093 mysql  txt    REG                8,1   20689208  8523701 /usr/sbin/mysqld
mysqld  6093 mysql  mem    REG                8,1      24576 11403676 /var/lib/mysql/tc.log
mysqld  6093 mysql  DEL    REG               0,16              905139 /[aio]
mysqld  6093 mysql  DEL    REG               0,16              905138 /[aio]
mysqld  6093 mysql  DEL    REG               0,16              905137 /[aio]
mysqld  6093 mysql  DEL    REG               0,16              905136 /[aio]
mysqld  6093 mysql  DEL    REG               0,16              905135 /[aio]
mysqld  6093 mysql  DEL    REG               0,16              905134 /[aio]
mysqld  6093 mysql  DEL    REG               0,16              905133 /[aio]
mysqld  6093 mysql  DEL    REG               0,16              905132 /[aio]
mysqld  6093 mysql  mem    REG                8,1      55792  7209957 /lib/x86_64-linux-gnu/libnss_files-2.28.so
mysqld  6093 mysql  mem    REG                8,1     137424  7209054 /lib/x86_64-linux-gnu/libgpg-error.so.0.26.1
mysqld  6093 mysql  mem    REG                8,1    1168056  7209011 /lib/x86_64-linux-gnu/libgcrypt.so.20.2.4
mysqld  6093 mysql  mem    REG                8,1     158400  7209578 /lib/x86_64-linux-gnu/liblzma.so.5.2.4
mysqld  6093 mysql  mem    REG                8,1      35808  7209974 /lib/x86_64-linux-gnu/librt-2.28.so
mysqld  6093 mysql  mem    REG                8,1     100712  7209507 /lib/x86_64-linux-gnu/libgcc_s.so.1
mysqld  6093 mysql  mem    REG                8,1    1824496  7209779 /lib/x86_64-linux-gnu/libc-2.28.so
mysqld  6093 mysql  mem    REG                8,1    1579448  7209782 /lib/x86_64-linux-gnu/libm-2.28.so
mysqld  6093 mysql  mem    REG                8,1    1570256  8519689 /usr/lib/x86_64-linux-gnu/libstdc++.so.6.0.25
mysqld  6093 mysql  mem    REG                8,1      14592  7209781 /lib/x86_64-linux-gnu/libdl-2.28.so
mysqld  6093 mysql  mem    REG                8,1     651472  7209047 /lib/x86_64-linux-gnu/libsystemd.so.0.25.0
mysqld  6093 mysql  mem    REG                8,1      43328  7209780 /lib/x86_64-linux-gnu/libcrypt-2.28.so
mysqld  6093 mysql  mem    REG                8,1     465224  7209596 /lib/x86_64-linux-gnu/libpcre.so.3.13.3
mysqld  6093 mysql  mem    REG                8,1     121280  7208991 /lib/x86_64-linux-gnu/libz.so.1.2.11
mysqld  6093 mysql  mem    REG                8,1      14184  8520107 /usr/lib/x86_64-linux-gnu/libaio.so.1.0.1
mysqld  6093 mysql  mem    REG                8,1      31104  8520116 /usr/lib/x86_64-linux-gnu/libsnappy.so.1.1.7
mysqld  6093 mysql  mem    REG                8,1     121184  8519855 /usr/lib/x86_64-linux-gnu/liblz4.so.1.8.3
mysqld  6093 mysql  mem    REG                8,1     146968  7209964 /lib/x86_64-linux-gnu/libpthread-2.28.so
mysqld  6093 mysql  DEL    REG               0,16              905140 /[aio]
mysqld  6093 mysql  DEL    REG               0,16              905131 /[aio]
mysqld  6093 mysql  DEL    REG               0,16              905130 /[aio]
mysqld  6093 mysql  mem    REG                8,1     165632  7209770 /lib/x86_64-linux-gnu/ld-2.28.so
mysqld  6093 mysql    0r   CHR                1,3        0t0   905109 /dev/null
mysqld  6093 mysql    1w   REG                8,1       9047 11404396 /var/log/mysql/error.log
mysqld  6093 mysql    2w   REG                8,1       9047 11404396 /var/log/mysql/error.log
mysqld  6093 mysql    3uW  REG                8,1         52 11406097 /var/lib/mysql/aria_log_control
mysqld  6093 mysql    4r   DIR                8,1       4096 11405595 /var/lib/mysql
mysqld  6093 mysql    5u   REG                8,1      24576 11406098 /var/lib/mysql/aria_log.00000001
mysqld  6093 mysql    6uW  REG                8,1  482344960 11406099 /var/lib/mysql/ibdata1
mysqld  6093 mysql    7u   REG                8,1          0  6291466 /tmp/ib4JEtOD (deleted)
mysqld  6093 mysql    8u   REG                8,1          0  6291476 /tmp/ibnuRsXG (deleted)
mysqld  6093 mysql    9u   REG                8,1          0  6291480 /tmp/ibpWDwyN (deleted)
mysqld  6093 mysql   10uW  REG                8,1   33554432 11405096 /var/lib/mysql/ib_logfile0
mysqld  6093 mysql   11uW  REG                8,1   33554432 11405134 /var/lib/mysql/ib_logfile1
mysqld  6093 mysql   12uW  REG                8,1      65536 11404668 /var/lib/mysql/nextcloud/oc_jobs.ibd
mysqld  6093 mysql   13uW  REG                8,1 1304428544 11404440 /var/lib/mysql/nextcloud/oc_filecache.ibd
mysqld  6093 mysql   14u   REG                8,1          0  6291481 /tmp/ibmRLz5Q (deleted)
mysqld  6093 mysql   15uW  REG                8,1   12582912 11403508 /var/lib/mysql/ibtmp1
mysqld  6093 mysql   16u   REG                8,1          0 11406215 /var/lib/mysql/multi-master.info
mysqld  6093 mysql   17w   REG                8,1     112951 11406259 /var/log/mysql/slow.log
mysqld  6093 mysql   18u   REG                8,1      24576 11403676 /var/lib/mysql/tc.log
mysqld  6093 mysql   19u   REG                8,1       1024 11406135 /var/lib/mysql/mysql/servers.MYI
mysqld  6093 mysql   20u   REG                8,1          0 11406136 /var/lib/mysql/mysql/servers.MYD
mysqld  6093 mysql   21u  IPv4             910124        0t0      TCP localhost:mysql (LISTEN)
mysqld  6093 mysql   22u  unix 0x000000003262d4f4        0t0   910125 /var/run/mysqld/mysqld.sock type=STREAM
mysqld  6093 mysql   23u   REG                8,1       4096 11405169 /var/lib/mysql/mysql/user.MYI
mysqld  6093 mysql   24u   REG                8,1        340 11405167 /var/lib/mysql/mysql/user.MYD
mysqld  6093 mysql   25u   REG                8,1      10240 11404132 /var/lib/mysql/mysql/db.MYI
mysqld  6093 mysql   26u   REG                8,1       1266 11404713 /var/lib/mysql/mysql/db.MYD
mysqld  6093 mysql   27u   REG                8,1       2048 11406111 /var/lib/mysql/mysql/host.MYI
mysqld  6093 mysql   28u   REG                8,1          0 11405418 /var/lib/mysql/mysql/host.MYD
mysqld  6093 mysql   29u   REG                8,1      10240 11405209 /var/lib/mysql/mysql/proxies_priv.MYI
mysqld  6093 mysql   30u   REG                8,1       1269 11406197 /var/lib/mysql/mysql/proxies_priv.MYD
mysqld  6093 mysql   31u   REG                8,1       4096 11406116 /var/lib/mysql/mysql/roles_mapping.MYI
mysqld  6093 mysql   32u   REG                8,1          0 11406120 /var/lib/mysql/mysql/roles_mapping.MYD
mysqld  6093 mysql   33u   REG                8,1       4096 11406128 /var/lib/mysql/mysql/tables_priv.MYI
mysqld  6093 mysql   34u   REG                8,1          0 11404007 /var/lib/mysql/mysql/tables_priv.MYD
mysqld  6093 mysql   35u   REG                8,1       4096 11405277 /var/lib/mysql/mysql/columns_priv.MYI
mysqld  6093 mysql   36u   REG                8,1          0 11404183 /var/lib/mysql/mysql/columns_priv.MYD
mysqld  6093 mysql   37u   REG                8,1       4096 11406125 /var/lib/mysql/mysql/procs_priv.MYI
mysqld  6093 mysql   38u   REG                8,1          0 11406845 /var/lib/mysql/mysql/procs_priv.MYD
mysqld  6093 mysql   39u   REG                8,1       2048 11405234 /var/lib/mysql/mysql/event.MYI
mysqld  6093 mysql   40u   REG                8,1          0 11405236 /var/lib/mysql/mysql/event.MYD
mysqld  6093 mysql   41uW  REG                8,1      98304 11406541 /var/lib/mysql/mysql/gtid_slave_pos.ibd
mysqld  6093 mysql   42uW  REG                8,1      98304 11406114 /var/lib/mysql/mysql/innodb_table_stats.ibd
mysqld  6093 mysql   43uW  REG                8,1     311296 11405284 /var/lib/mysql/mysql/innodb_index_stats.ibd
mysqld  6093 mysql   44uW  REG                8,1      65536 11406140 /var/lib/mysql/nextcloud/oc_accounts.ibd
mysqld  6093 mysql   45uW  REG                8,1  113246208 11406141 /var/lib/mysql/nextcloud/oc_activity.ibd
mysqld  6093 mysql   46uW  REG                8,1      73728 11403359 /var/lib/mysql/nextcloud/oc_activity_mq.ibd
mysqld  6093 mysql   47uW  REG                8,1      81920 11403401 /var/lib/mysql/nextcloud/oc_appconfig.ibd
mysqld  6093 mysql   48uW  REG                8,1    5242880 11403571 /var/lib/mysql/nextcloud/oc_authtoken.ibd
mysqld  6093 mysql   49uW  REG                8,1    4194304 11403587 /var/lib/mysql/nextcloud/oc_bruteforce_attempts.ibd
mysqld  6093 mysql   50uW  REG                8,1     180224 11403687 /var/lib/mysql/nextcloud/oc_calendar_reminders.ibd
mysqld  6093 mysql   51uW  REG                8,1    9437184 11403752 /var/lib/mysql/nextcloud/oc_calendarobjects.ibd
mysqld  6093 mysql   52uW  REG                8,1      65536 11403776 /var/lib/mysql/nextcloud/oc_calendars.ibd
mysqld  6093 mysql   53uW  REG                8,1      65536 11403839 /var/lib/mysql/nextcloud/oc_calendarsubscriptions.ibd
mysqld  6093 mysql   54uW  REG                8,1     393216 11404030 /var/lib/mysql/nextcloud/oc_comments.ibd
mysqld  6093 mysql   55uW  REG                8,1      65536 11404654 /var/lib/mysql/nextcloud/oc_group_user.ibd
mysqld  6093 mysql   56uW  REG                8,1      65536 11404063 /var/lib/mysql/nextcloud/oc_comments_read_markers.ibd
mysqld  6093 mysql   57uW  REG                8,1      65536 11406322 /var/lib/mysql/nextcloud/oc_credentials.ibd
mysqld  6093 mysql   58uW  REG                8,1      73728 11404120 /var/lib/mysql/nextcloud/oc_dav_cal_proxy.ibd
mysqld  6093 mysql   59uW  REG                8,1      65536 11404143 /var/lib/mysql/nextcloud/oc_dav_shares.ibd
mysqld  6093 mysql   60uW  REG                8,1      65536 11404255 /var/lib/mysql/nextcloud/oc_direct_edit.ibd
mysqld  6093 mysql   61uW  REG                8,1      65536 11404290 /var/lib/mysql/nextcloud/oc_documentserver_ipc.ibd
mysqld  6093 mysql   62uW  REG                8,1      65536 11404296 /var/lib/mysql/nextcloud/oc_documentserver_locks.ibd
mysqld  6093 mysql   63uW  REG                8,1      73728 11404311 /var/lib/mysql/nextcloud/oc_documentserver_sess.ibd
mysqld  6093 mysql   64uW  REG                8,1      73728 11404333 /var/lib/mysql/nextcloud/oc_external_applicable.ibd
mysqld  6093 mysql   65uW  REG                8,1      65536 11404335 /var/lib/mysql/nextcloud/oc_external_config.ibd
mysqld  6093 mysql   66uW  REG                8,1      65536 11404355 /var/lib/mysql/nextcloud/oc_external_mounts.ibd
mysqld  6093 mysql   67uW  REG                8,1      65536 11404362 /var/lib/mysql/nextcloud/oc_external_options.ibd
mysqld  6093 mysql   68uW  REG                8,1     122880 11405140 /var/lib/mysql/nextcloud/oc_preferences.ibd
mysqld  6093 mysql   69uW  REG                8,1     229376 11404000 /var/lib/mysql/nextcloud/oc_files_trash.ibd
mysqld  6093 mysql   70uW  REG                8,1      65536 11405660 /var/lib/mysql/nextcloud/oc_users.ibd
mysqld  6093 mysql   71u   REG                8,1       1024 11405168 /var/lib/mysql/mysql/plugin.MYI
mysqld  6093 mysql   72u   REG                8,1          0 11406840 /var/lib/mysql/mysql/plugin.MYD
mysqld  6093 mysql   73u   REG                8,1       1024 11406167 /var/lib/mysql/mysql/time_zone_transition.MYI
mysqld  6093 mysql   74u   REG                8,1          0 11406168 /var/lib/mysql/mysql/time_zone_transition.MYD
mysqld  6093 mysql   75u   REG                8,1       4096 11406205 /var/lib/mysql/mysql/index_stats.MYI
mysqld  6093 mysql   76u   REG                8,1          0 11406206 /var/lib/mysql/mysql/index_stats.MYD
mysqld  6093 mysql   77u   REG                8,1       1024 11406164 /var/lib/mysql/mysql/time_zone.MYI
mysqld  6093 mysql   78u   REG                8,1          0 11406165 /var/lib/mysql/mysql/time_zone.MYD
mysqld  6093 mysql   79u   REG                8,1      16384 11405930 /var/lib/mysql/mysql/help_keyword.MYI
mysqld  6093 mysql   80u   REG                8,1      91408 11406159 /var/lib/mysql/mysql/help_keyword.MYD
mysqld  6093 mysql   81u   REG                8,1       3072 11405196 /var/lib/mysql/mysql/help_category.MYI
mysqld  6093 mysql   82u   REG                8,1       1092 11406151 /var/lib/mysql/mysql/help_category.MYD
mysqld  6093 mysql   83u   REG                8,1      19456 11406108 /var/lib/mysql/mysql/help_relation.MYI
mysqld  6093 mysql   84u   REG                8,1       9252 11406156 /var/lib/mysql/mysql/help_relation.MYD
mysqld  6093 mysql   85u   REG                8,1       1024 11406161 /var/lib/mysql/mysql/time_zone_name.MYI
mysqld  6093 mysql   86u   REG                8,1          0 11406162 /var/lib/mysql/mysql/time_zone_name.MYD
mysqld  6093 mysql   87u   REG                8,1       4096 11405247 /var/lib/mysql/mysql/proc.MYI
mysqld  6093 mysql   88u   REG                8,1     379112 11405198 /var/lib/mysql/mysql/proc.MYD
mysqld  6093 mysql   89u   REG                8,1       1024 11406170 /var/lib/mysql/mysql/time_zone_transition_type.MYI
mysqld  6093 mysql   90u   REG                8,1          0 11406171 /var/lib/mysql/mysql/time_zone_transition_type.MYD
mysqld  6093 mysql   91u   REG                8,1       1024 11406174 /var/lib/mysql/mysql/time_zone_leap_second.MYI
mysqld  6093 mysql   92u   REG                8,1          0 11406175 /var/lib/mysql/mysql/time_zone_leap_second.MYD
mysqld  6093 mysql   93u   REG                8,1       4096 11406202 /var/lib/mysql/mysql/column_stats.MYI
mysqld  6093 mysql   94u   REG                8,1          0 11406203 /var/lib/mysql/mysql/column_stats.MYD
mysqld  6093 mysql   95u   REG                8,1       2048 11406199 /var/lib/mysql/mysql/table_stats.MYI
mysqld  6093 mysql   96u   REG                8,1          0 11406200 /var/lib/mysql/mysql/table_stats.MYD
mysqld  6093 mysql   97u   REG                8,1      20480 11406109 /var/lib/mysql/mysql/help_topic.MYI
mysqld  6093 mysql   98u   REG                8,1     405476 11406148 /var/lib/mysql/mysql/help_topic.MYD
mysqld  6093 mysql   99u   REG                8,1       1024 11404297 /var/lib/mysql/mysql/func.MYI
mysqld  6093 mysql  100u   REG                8,1          0 11404732 /var/lib/mysql/mysql/func.MYD
mysqld  6093 mysql  101uW  REG                8,1      65536 11404657 /var/lib/mysql/nextcloud/oc_groups.ibd
mysqld  6093 mysql  102uW  REG                8,1      65536 11404476 /var/lib/mysql/nextcloud/oc_flow_operations.ibd
mysqld  6093 mysql  103uW  REG                8,1      65536 11405438 /var/lib/mysql/nextcloud/oc_storages.ibd
mysqld  6093 mysql  104uW  REG                8,1      65536 11405254 /var/lib/mysql/nextcloud/oc_share_external.ibd
mysqld  6093 mysql  105uW  REG                8,1     106496 11405246 /var/lib/mysql/nextcloud/oc_share.ibd
mysqld  6093 mysql  106uW  REG                8,1      65536 11404977 /var/lib/mysql/nextcloud/oc_mimetypes.ibd
mysqld  6093 mysql  107uW  REG                8,1      65536 11405503 /var/lib/mysql/nextcloud/oc_talk_rooms.ibd
mysqld  6093 mysql  108uW  REG                8,1      98304 11405501 /var/lib/mysql/nextcloud/oc_talk_participants.ibd
mysqld  6093 mysql  109uW  REG                8,1      90112 11405003 /var/lib/mysql/nextcloud/oc_mounts.ibd
mysqld  6093 mysql  110uW  REG                8,1    9437184 11403968 /var/lib/mysql/nextcloud/oc_filecache_extended.ibd
mysqld  6093 mysql  111uW  REG                8,1      81920 11405154 /var/lib/mysql/nextcloud/oc_properties.ibd
mysqld  6093 mysql  112uW  REG                8,1      65536 11404609 /var/lib/mysql/nextcloud/oc_group_admin.ibd
mysqld  6093 mysql  113uW  REG                8,1      90112 11404796 /var/lib/mysql/nextcloud/oc_mail_classifiers.ibd
mysqld  6093 mysql  114uW  REG                8,1     114688 11405060 /var/lib/mysql/nextcloud/oc_news_feeds.ibd
mysqld  6093 mysql  115uW  REG                8,1      65536 11405646 /var/lib/mysql/nextcloud/oc_twofactor_providers.ibd
mysqld  6093 mysql  116uW  REG                8,1      65536 11404779 /var/lib/mysql/nextcloud/oc_mail_accounts.ibd
mysqld  6093 mysql  117uW  REG                8,1      65536 11404822 /var/lib/mysql/nextcloud/oc_mail_mailboxes.ibd
mysqld  6093 mysql  118uW  REG                8,1    6291456 11404835 /var/lib/mysql/nextcloud/oc_mail_messages.ibd
mysqld  6093 mysql  119uW  REG                8,1    9437184 11404867 /var/lib/mysql/nextcloud/oc_mail_recipients.ibd
mysqld  6093 mysql  120uW  REG                8,1      73728 11405064 /var/lib/mysql/nextcloud/oc_news_folders.ibd
mysqld  6093 mysql  121uW  REG                8,1   54525952 11405079 /var/lib/mysql/nextcloud/oc_news_items.ibd
mysqld  6093 mysql  122uW  REG                8,1      81920 11405105 /var/lib/mysql/nextcloud/oc_notifications.ibd
mysqld  6093 mysql  123uW  REG                8,1      65536 11405137 /var/lib/mysql/nextcloud/oc_onlyoffice_filekey.ibd
mysqld  6093 mysql  124uW  REG                8,1      65536 11405143 /var/lib/mysql/nextcloud/oc_preview_generation.ibd
mysqld  6093 mysql  125uW  REG                8,1      65536 11405491 /var/lib/mysql/nextcloud/oc_systemtag_object_mapping.ibd
mysqld  6093 mysql  126uW  REG                8,1      65536 11405493 /var/lib/mysql/nextcloud/oc_talk_commands.ibd
mysqld  6093 mysql  127uW  REG                8,1      65536 11405509 /var/lib/mysql/nextcloud/oc_talk_signaling.ibd
mysqld  6093 mysql  128uW  REG                8,1      65536 11405538 /var/lib/mysql/nextcloud/oc_text_sessions.ibd
mysqld  6093 mysql  129uW  REG                8,1      73728 11405670 /var/lib/mysql/nextcloud/oc_vcategory.ibd
mysqld  6093 mysql  130uW  REG                8,1      65536 11405689 /var/lib/mysql/nextcloud/oc_vcategory_to_object.ibd
mysqld  6093 mysql  131u  unix 0x000000004e0cbe46        0t0   911495 /var/run/mysqld/mysqld.sock type=STREAM
mysqld  6093 mysql  132u  unix 0x000000005a2017f9        0t0   917946 /var/run/mysqld/mysqld.sock type=STREAM
mysqld  6093 mysql  133u  unix 0x00000000c885cc5e        0t0   920884 /var/run/mysqld/mysqld.sock type=STREAM
mysqld  6093 mysql  134u  unix 0x000000008bcb879c        0t0   920471 /var/run/mysqld/mysqld.sock type=STREAM
mysqld  6093 mysql  135u  unix 0x000000000791727c        0t0   925904 /var/run/mysqld/mysqld.sock type=STREAM
mysqld  6093 mysql  136uW  REG                8,1      73728 11404775 /var/lib/mysql/nextcloud/oc_login_flow_v2.ibd
mysqld  6093 mysql  137uW  REG                8,1      65536 11404325 /var/lib/mysql/nextcloud/oc_e2e_encryption_lock.ibd
mysqld  6093 mysql  138uW  REG                8,1      65536 11404783 /var/lib/mysql/nextcloud/oc_mail_aliases.ibd
mysqld  6093 mysql  139uW  REG                8,1     368640 11403373 /var/lib/mysql/nextcloud/oc_addressbookchanges.ibd
mysqld  6093 mysql  140uW  REG                8,1    7340032 11403424 /var/lib/mysql/nextcloud/oc_audioplayer_albums.ibd
mysqld  6093 mysql  141uW  REG                8,1      81920 11403458 /var/lib/mysql/nextcloud/oc_audioplayer_artists.ibd
mysqld  6093 mysql  142uW  REG                8,1      65536 11403494 /var/lib/mysql/nextcloud/oc_audioplayer_genre.ibd
mysqld  6093 mysql  143uW  REG                8,1      65536 11403507 /var/lib/mysql/nextcloud/oc_audioplayer_playlist_tracks.ibd
mysqld  6093 mysql  144uW  REG                8,1      65536 11403530 /var/lib/mysql/nextcloud/oc_audioplayer_playlists.ibd
mysqld  6093 mysql  145uW  REG                8,1      65536 11403547 /var/lib/mysql/nextcloud/oc_audioplayer_stats.ibd
mysqld  6093 mysql  146uW  REG                8,1      65536 11403553 /var/lib/mysql/nextcloud/oc_audioplayer_streams.ibd
mysqld  6093 mysql  147uW  REG                8,1    4194304 11403566 /var/lib/mysql/nextcloud/oc_audioplayer_tracks.ibd
mysqld  6093 mysql  148uW  REG                8,1      65536 11403648 /var/lib/mysql/nextcloud/oc_calendar_invitations.ibd
mysqld  6093 mysql  149uW  REG                8,1      73728 11403703 /var/lib/mysql/nextcloud/oc_calendar_resources.ibd
mysqld  6093 mysql  150uW  REG                8,1      65536 11403718 /var/lib/mysql/nextcloud/oc_calendar_resources_md.ibd
mysqld  6093 mysql  151uW  REG                8,1      73728 11403726 /var/lib/mysql/nextcloud/oc_calendar_rooms.ibd
mysqld  6093 mysql  152uW  REG                8,1      65536 11403744 /var/lib/mysql/nextcloud/oc_calendar_rooms_md.ibd
mysqld  6093 mysql  153uW  REG                8,1    5242880 11403747 /var/lib/mysql/nextcloud/oc_calendarchanges.ibd
mysqld  6093 mysql  154uW  REG                8,1      65536 11403394 /var/lib/mysql/nextcloud/oc_addressbooks.ibd
mysqld  6093 mysql  155uW  REG                8,1    6291456 11403908 /var/lib/mysql/nextcloud/oc_cards_properties.ibd
mysqld  6093 mysql  156uW  REG                8,1   12582912 11403880 /var/lib/mysql/nextcloud/oc_cards.ibd
mysqld  6093 mysql  157uW  REG                8,1    8388608 11403755 /var/lib/mysql/nextcloud/oc_calendarobjects_props.ibd
mysqld  6093 mysql  158uW  REG                8,1      73728 11403954 /var/lib/mysql/nextcloud/oc_collres_accesscache.ibd
mysqld  6093 mysql  159uW  REG                8,1      65536 11404003 /var/lib/mysql/nextcloud/oc_collres_collections.ibd
mysqld  6093 mysql  160uW  REG                8,1      65536 11404020 /var/lib/mysql/nextcloud/oc_collres_resources.ibd
mysqld  6093 mysql  161uW  REG                8,1      65536 11404148 /var/lib/mysql/nextcloud/oc_deck_assigned_labels.ibd
mysqld  6093 mysql  162uW  REG                8,1      65536 11404163 /var/lib/mysql/nextcloud/oc_deck_assigned_users.ibd
mysqld  6093 mysql  163uW  REG                8,1      65536 11404171 /var/lib/mysql/nextcloud/oc_deck_attachment.ibd
mysqld  6093 mysql  164uW  REG                8,1      65536 11404196 /var/lib/mysql/nextcloud/oc_deck_board_acl.ibd
mysqld  6093 mysql  165uW  REG                8,1      65536 11404215 /var/lib/mysql/nextcloud/oc_deck_boards.ibd
mysqld  6093 mysql  166uW  REG                8,1      73728 11404226 /var/lib/mysql/nextcloud/oc_deck_cards.ibd
mysqld  6093 mysql  167uW  REG                8,1      65536 11404239 /var/lib/mysql/nextcloud/oc_deck_labels.ibd
mysqld  6093 mysql  168uW  REG                8,1      65536 11404242 /var/lib/mysql/nextcloud/oc_deck_stacks.ibd
mysqld  6093 mysql  169uW  REG                8,1      65536 11404269 /var/lib/mysql/nextcloud/oc_directlink.ibd
mysqld  6093 mysql  170uW  REG                8,1      81920 11404285 /var/lib/mysql/nextcloud/oc_documentserver_changes.ibd
mysqld  6093 mysql  171uW  REG                8,1      65536 11404381 /var/lib/mysql/nextcloud/oc_federated_reshares.ibd
mysqld  6093 mysql  172uW  REG                8,1    5242880 11404392 /var/lib/mysql/nextcloud/oc_file_locks.ibd
mysqld  6093 mysql  173uW  REG                8,1      65536 11404454 /var/lib/mysql/nextcloud/oc_flow_checks.ibd
mysqld  6093 mysql  174uW  REG                8,1      65536 11404525 /var/lib/mysql/nextcloud/oc_flow_operations_scope.ibd
mysqld  6093 mysql  175uW  REG                8,1    8388608 11404558 /var/lib/mysql/nextcloud/oc_fulltextsearch_indexes.ibd
mysqld  6093 mysql  176uW  REG                8,1    5242880 11404593 /var/lib/mysql/nextcloud/oc_fulltextsearch_ticks.ibd
mysqld  6093 mysql  177uW  REG                8,1      65536 11404619 /var/lib/mysql/nextcloud/oc_group_folders.ibd
mysqld  6093 mysql  178uW  REG                8,1      73728 11404621 /var/lib/mysql/nextcloud/oc_group_folders_acl.ibd
mysqld  6093 mysql  179uW  REG                8,1      73728 11404625 /var/lib/mysql/nextcloud/oc_group_folders_groups.ibd
mysqld  6093 mysql  180uW  REG                8,1      65536 11404630 /var/lib/mysql/nextcloud/oc_group_folders_manage.ibd
mysqld  6093 mysql  181uW  REG                8,1     335872 11404643 /var/lib/mysql/nextcloud/oc_group_folders_trash.ibd
mysqld  6093 mysql  182uW  REG                8,1      65536 11404696 /var/lib/mysql/nextcloud/oc_ldap_group_mapping.ibd
mysqld  6093 mysql  183uW  REG                8,1      65536 11404729 /var/lib/mysql/nextcloud/oc_ldap_group_members.ibd
mysqld  6093 mysql  184uW  REG                8,1      65536 11404757 /var/lib/mysql/nextcloud/oc_ldap_user_mapping.ibd
mysqld  6093 mysql  185uW  REG                8,1      65536 11404766 /var/lib/mysql/nextcloud/oc_login_address.ibd
mysqld  6093 mysql  186uW  REG                8,1     221184 11404769 /var/lib/mysql/nextcloud/oc_login_address_aggregated.ibd
mysqld  6093 mysql  187uW  REG                8,1      65536 11404785 /var/lib/mysql/nextcloud/oc_mail_attachments.ibd
mysqld  6093 mysql  188uW  REG                8,1      65536 11404806 /var/lib/mysql/nextcloud/oc_mail_coll_addresses.ibd
mysqld  6093 mysql  189uW  REG                8,1      98304 11404871 /var/lib/mysql/nextcloud/oc_maps_address_geo.ibd
mysqld  6093 mysql  190uW  REG                8,1      65536 11404881 /var/lib/mysql/nextcloud/oc_maps_apikeys.ibd
mysqld  6093 mysql  191uW  REG                8,1      65536 11404886 /var/lib/mysql/nextcloud/oc_maps_device_points.ibd
mysqld  6093 mysql  192uW  REG                8,1      65536 11404888 /var/lib/mysql/nextcloud/oc_maps_devices.ibd
mysqld  6093 mysql  193uW  REG                8,1      65536 11404905 /var/lib/mysql/nextcloud/oc_maps_favorites.ibd
mysqld  6093 mysql  194uW  REG                8,1    7340032 11404908 /var/lib/mysql/nextcloud/oc_maps_photos.ibd
mysqld  6093 mysql  195uW  REG                8,1      65536 11404910 /var/lib/mysql/nextcloud/oc_maps_tracks.ibd
mysqld  6093 mysql  196uW  REG                8,1      65536 11404969 /var/lib/mysql/nextcloud/oc_migrations.ibd
mysqld  6093 mysql  197uW  REG                8,1      73728 11405008 /var/lib/mysql/nextcloud/oc_music_albums.ibd
mysqld  6093 mysql  198uW  REG                8,1      65536 11405011 /var/lib/mysql/nextcloud/oc_music_ampache_sessions.ibd
mysqld  6093 mysql  199uW  REG                8,1      65536 11405013 /var/lib/mysql/nextcloud/oc_music_ampache_users.ibd
mysqld  6093 mysql  200uW  REG                8,1      65536 11405015 /var/lib/mysql/nextcloud/oc_music_artists.ibd
mysqld  6093 mysql  201uW  REG                8,1      65536 11405037 /var/lib/mysql/nextcloud/oc_music_cache.ibd
mysqld  6093 mysql  202uW  REG                8,1      65536 11405045 /var/lib/mysql/nextcloud/oc_music_playlists.ibd
mysqld  6093 mysql  203uW  REG                8,1      98304 11405055 /var/lib/mysql/nextcloud/oc_music_tracks.ibd
mysqld  6093 mysql  204uW  REG                8,1      73728 11405089 /var/lib/mysql/nextcloud/oc_notes_meta.ibd
mysqld  6093 mysql  205uW  REG                8,1      90112 11405119 /var/lib/mysql/nextcloud/oc_notifications_pushtokens.ibd
mysqld  6093 mysql  206uW  REG                8,1      65536 11405126 /var/lib/mysql/nextcloud/oc_oauth2_access_tokens.ibd
mysqld  6093 mysql  207uW  REG                8,1      65536 11405128 /var/lib/mysql/nextcloud/oc_oauth2_clients.ibd
mysqld  6093 mysql  208uW  REG                8,1      65536 11405150 /var/lib/mysql/nextcloud/oc_privacy_admins.ibd
mysqld  6093 mysql  209uW  REG                8,1      98304 11405173 /var/lib/mysql/nextcloud/oc_recent_contact.ibd
mysqld  6093 mysql  210uW  REG                8,1      65536 11405180 /var/lib/mysql/nextcloud/oc_richdocuments_assets.ibd
mysqld  6093 mysql  211uW  REG                8,1      65536 11405186 /var/lib/mysql/nextcloud/oc_richdocuments_direct.ibd
mysqld  6093 mysql  212uW  REG                8,1      65536 11405218 /var/lib/mysql/nextcloud/oc_richdocuments_member.ibd
mysqld  6093 mysql  213uW  REG                8,1      65536 11405228 /var/lib/mysql/nextcloud/oc_richdocuments_wopi.ibd
mysqld  6093 mysql  214uW  REG                8,1     106496 11405237 /var/lib/mysql/nextcloud/oc_schedulingobjects.ibd
mysqld  6093 mysql  215uW  REG                8,1      65536 11405259 /var/lib/mysql/nextcloud/oc_social_a2_actions.ibd
mysqld  6093 mysql  216uW  REG                8,1      65536 11405290 /var/lib/mysql/nextcloud/oc_social_a2_actors.ibd
mysqld  6093 mysql  217uW  REG                8,1      65536 11405292 /var/lib/mysql/nextcloud/oc_social_a2_cache_actors.ibd
mysqld  6093 mysql  218uW  REG                8,1      65536 11405299 /var/lib/mysql/nextcloud/oc_social_a2_cache_documts.ibd
mysqld  6093 mysql  219uW  REG                8,1      65536 11405337 /var/lib/mysql/nextcloud/oc_social_a2_follows.ibd
mysqld  6093 mysql  220uW  REG                8,1      65536 11405344 /var/lib/mysql/nextcloud/oc_social_a2_hashtags.ibd
mysqld  6093 mysql  221uW  REG                8,1      65536 11405363 /var/lib/mysql/nextcloud/oc_social_a2_request_queue.ibd
mysqld  6093 mysql  222uW  REG                8,1      65536 11405381 /var/lib/mysql/nextcloud/oc_social_a2_stream.ibd
mysqld  6093 mysql  223uW  REG                8,1      65536 11405399 /var/lib/mysql/nextcloud/oc_social_a2_stream_action.ibd
mysqld  6093 mysql  224uW  REG                8,1      65536 11405406 /var/lib/mysql/nextcloud/oc_social_a2_stream_queue.ibd
mysqld  6093 mysql  225uW  REG                8,1      65536 11405409 /var/lib/mysql/nextcloud/oc_social_cache_actors.ibd
mysqld  6093 mysql  226uW  REG                8,1      65536 11405411 /var/lib/mysql/nextcloud/oc_social_cache_documents.ibd
mysqld  6093 mysql  227uW  REG                8,1      65536 11405414 /var/lib/mysql/nextcloud/oc_social_request_queue.ibd
mysqld  6093 mysql  228uW  REG                8,1      65536 11405420 /var/lib/mysql/nextcloud/oc_social_server_actors.ibd
mysqld  6093 mysql  229uW  REG                8,1      65536 11405426 /var/lib/mysql/nextcloud/oc_social_server_follows.ibd
mysqld  6093 mysql  230uW  REG                8,1      65536 11405433 /var/lib/mysql/nextcloud/oc_social_server_notes.ibd
mysqld  6093 mysql  231uW  REG                8,1   17825792 11405449 /var/lib/mysql/nextcloud/oc_suspicious_login.ibd
mysqld  6093 mysql  232uW  REG                8,1      65536 11405465 /var/lib/mysql/nextcloud/oc_suspicious_login_model.ibd
mysqld  6093 mysql  233uW  REG                8,1      65536 11405481 /var/lib/mysql/nextcloud/oc_systemtag.ibd
mysqld  6093 mysql  234uW  REG                8,1      65536 11405487 /var/lib/mysql/nextcloud/oc_systemtag_group.ibd
mysqld  6093 mysql  235uW  REG                8,1      65536 11405496 /var/lib/mysql/nextcloud/oc_talk_guests.ibd
mysqld  6093 mysql  236uW  REG                8,1      65536 11405514 /var/lib/mysql/nextcloud/oc_text_documents.ibd
mysqld  6093 mysql  237uW  REG                8,1      65536 11405586 /var/lib/mysql/nextcloud/oc_text_steps.ibd
mysqld  6093 mysql  238uW  REG                8,1      65536 11405613 /var/lib/mysql/nextcloud/oc_trusted_servers.ibd
mysqld  6093 mysql  239uW  REG                8,1      65536 11405617 /var/lib/mysql/nextcloud/oc_twofactor_backupcodes.ibd
mysqld  6093 mysql  240uW  REG                8,1      65536 11405622 /var/lib/mysql/nextcloud/oc_twofactor_nextcloud_notification_tokens.ibd
mysqld  6093 mysql  241uW  REG                8,1      65536 11405649 /var/lib/mysql/nextcloud/oc_twofactor_totp_secrets.ibd
mysqld  6093 mysql  242uW  REG                8,1      65536 11405653 /var/lib/mysql/nextcloud/oc_user_transfer_owner.ibd
mysqld  6093 mysql  243uW  REG                8,1      65536 11405664 /var/lib/mysql/nextcloud/oc_users_external.ibd
mysqld  6093 mysql  244uW  REG                8,1      65536 11405721 /var/lib/mysql/nextcloud/oc_weather_city.ibd
mysqld  6093 mysql  245uW  REG                8,1      65536 11405739 /var/lib/mysql/nextcloud/oc_weather_config.ibd
mysqld  6093 mysql  246uW  REG                8,1      65536 11405754 /var/lib/mysql/nextcloud/oc_webauthn.ibd
mysqld  6093 mysql  247uW  REG                8,1      65536 11405759 /var/lib/mysql/nextcloud/oc_whats_new.ibd
mysqld  6093 mysql  248u  unix 0x00000000e55a68cd        0t0   959674 /var/run/mysqld/mysqld.sock type=STREAM
mysqld  6093 mysql  249u  unix 0x0000000092fe2dc0        0t0   955882 /var/run/mysqld/mysqld.sock type=STREAM

For me this makes not much sense, so perhaps someone finds something

[h3rb3rt]

And an htop screenshot. It is pretty good right now I also had values within the two digits range already - perhaps they show up in the next few hours.

[ZetiX]

Yes I’m using NCP as well and it also started occuring after upgrading to 19.

But I’m glad that I’m not the only one with this issue as I haven’t been able to find any information on what’s causing it.

I was really busy with other stuff IRL and just kind of forgot about this issue entirely. There also wasn’t any emails sent so I thought the thread was dead even though notifications is enabled and I’m subscribed.

[h3rb3rt]

Not dead, but sometimes things take a little longer.
I am not satisfied yet, but what I did was turning on the query_cache again and ran mysqlcheck -o --all-databases to compress/optimize my database again.

As I said, I am fine not, but I have the feeling that with NC19 the load on the hardware was increased, without adding any special CPU intense add-ons.

[Lautre]

Hi there
Old subject, by I’ve got the same problem with my mysql CPU.
Using the pidstat -t -p [pid-of-mysqld] I can see that when I make a connexion using my browser, I’ve got threads with “connexion” using a quite large amount of CPU … and they still remain when I disconnect (I try on a one user nextloud)
THat increase my CPU that doesn’t get down and higths my CPU temperature …

Only solution : restart the mysql service

Do you think it’s because I’m using
session_lifetime ?