10 August 2017, 18:24

Since our Update from 16.10 to 17.04 (about 2 weeks ago) the file listing (User and Group Files) ist very slow. It takes up to 30s until the listing appears (depending on the number of personal files) - We didn`t have this problem with version 16.10

Is it possible that something went wrong during the update?

Thanks for any help

Gerald

11 August 2017, 3:57

i forgot to mention some technical details:

• operating System: OpenSuSE Leap 42.1
• PHP: 5.5.14
• MariaDB: 10.0.29 (SLE 12 SP1 package)
• Number of files in artefact directory: 338118

The slow response happens in Content => files or in  group => files  or in editing a Portfolio and adding a block "FileDownload"

12 August 2017, 17:47

i did some further tests (and changes) on my server:

• Update openSuSE Leap 42.3
• PHP: 5.5.14 (still the same)
• MariaDB - Version: 10.0.31

My VM has now 4vCPUs and 16G RAM

I changed "innodb_buffer_pool_size = 8192M" (my.cnf)

it seems to be quicker, but the file listing in one of the groups still takes about 10s

On the server console i can see, that during this access the CPU load for mysqld is around 100%

Any suggestions? (Could a database change to PostgreSQL be a solution?)

03 October 2017, 11:07

Can you enable the slow query log and try to capture the query/queries that are taking the time?

Also might be worth checking that the host is not swapping/low on memory.