Forums | Mahara Community
File Listing very slow
10 August 2017, 6:24 PM
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
11 August 2017, 3:57 AM
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, 5:47 PM
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 AM
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.