Size of oc_filecache and other param

Hi

with the covid19 i have created an owncloud instance for the student of the college (500 persons) .
The php apache service use all of the memory (14go)

I am desespeared because its not my job i search the solution but i dont find

I dont speak english i am french

If you know the rules for a good instance of owncloud i take it if you want help me
Thanks a lot
Eric

Steps to reproduce

oc_filecache
This file is very big 31 mo 150000 lines

I want truncate this file

Expected behaviour

Actual behaviour

Tell us what happens instead

Server configuration

Operating system:
CenterOs
Web server:
Apache
Database:
mysql
PHP version:
7.1
ownCloud version: (see ownCloud admin page)
10.4.0.4
Updated from an older ownCloud or fresh install:
Fresh
Where did you install ownCloud from:

Signing status (ownCloud 9.0 and above):

Login as admin user into your ownCloud and access 
http://example.com/index.php/settings/integrity/failed 
paste the results into https://gist.github.com/ and puth the link here.

The content of config/config.php:

<?php $CONFIG = array ( 'instanceid' => 'xxxxxxxxxxxxxx', 'passwordsalt' => 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxx', 'secret' => 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx', 'trusted_domains' => array ( 0 => 'xxxxxxxxxxxxxxxxxx.fr', ), 'datadirectory' => '/var/www/vhosts/xxxxxxxxxxx.fr/httpdocs/_cloud/_xxxxxx/_prod/data', 'overwrite.cli.url' => 'http://xxxxxxxxxxxxxxxxxxxx.fr', 'dbtype' => 'mysql', 'version' => '10.4.0.4', 'dbname' => '', 'dbhost' => 'localhost', 'dbtableprefix' => 'oc_', 'mysql.utf8mb4' => true, 'dbuser' => '', 'dbpassword' => '', 'logtimezone' => 'UTC', 'apps_paths' => array ( 0 => array ( 'path' => '/var/www/vhosts/xxxxxxxxxxxxxxxx.fr/httpdocs/_cloud/_xxxxxxxxx/_prod/apps', 'url' => '/apps', 'writable' => false, ), 1 => array ( 'path' => '/var/www/vhosts/xxxxxxxxxxxxxx.fr/httpdocs/_cloud/_xxxxxxxxxxx/_prod/apps-external', 'url' => '/apps-external', 'writable' => true, ), ), 'installed' => true, 'maintenance' => false, 'debug' => false, 'enable_previews' => false, 'has_rebuilt_cache' => true, 'cache_path' => '/var/www/vhosts/xxxxxxxxxxxxxxxxxx.fr/tmp/', 'mail_domain' => 'xxxxxxxxxxxxxxxx.fr', 'mail_from_address' => 'xxxxxxxxx', 'mail_smtpmode' => 'php', 'loglevel' => 3, ); ``` Log in to the web-UI with an administrator account and click on 'admin' -> 'Generate Config Report' -> 'Download ownCloud config report' This report includes the config.php settings, the list of activated apps and other details in a well sanitized form. or If you have access to your command line run e.g.: sudo -u www-data php occ config:list system from within your ownCloud installation folder *ATTENTION:* Do not post your config.php file in public as is. Please use one of the above methods whenever possible. Both, the generated reports from the web-ui and from occ config:list consistently remove sensitive data. You still may want to review the report before sending. If done manually then it is critical for your own privacy to dilligently remove *all* host names, passwords, usernames, salts and other credentials before posting. You should assume that attackers find such information and will use them against your systems. ``` https://github.com/62eric43/lazarus/blob/master/config%20report **List of activated apps:** ``` If you have access to your command line run e.g.: sudo -u www-data php occ app:list from within your ownCloud installation folder. ``` **Are you using external storage, if yes which one:** local/smb/sftp/... No **Are you using encryption:** yes/no No **Are you using an external user-backend, if yes which one:** LDAP/ActiveDirectory/Webdav/... With access to your command line run e.g.: sudo -u www-data php occ ldap:show-config from within your ownCloud installation folder Without access to your command line download the data/owncloud.db to your local computer or access your SQL server remotely and run the select query: SELECT * FROM `oc_appconfig` WHERE `appid` = 'user_ldap'; Eventually replace sensitive data as the name/IP-address of your LDAP server or groups. ``` ### Client configuration **Browser:** Edge Firefix Internet Explorer **Operating system:** W10 Education ### Logs #### Web server error log ``` Insert your webserver log here ``` #### ownCloud log (data/owncloud.log) ``` Insert your ownCloud log here ``` #### Browser log ``` Insert your browser log here, this could for example include: a) The javascript console log b) The network log c) ... ```

Hey,

from what i have read in the past the “oc_filecache” holds all information of files on the ownCloud server and this table is crucial for the operation of ownCloud so you can’t just “truncate this file”.

If there are 500 persons on this instance which are uploading files maybe the size is just normal?

Thank’s Tom

I read this on the net but i m afraid because tomorrow i have 500 students on the site !!

Eric