Forums | Mahara Community

Support /
File Listing very slow


Gerald Stachl's profile picture
Posts: 4

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

Gerald

Gerald Stachl's profile picture
Posts: 4

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"

 

Gerald Stachl's profile picture
Posts: 4

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?)

 

Mark Kirkwood's profile picture
Posts: 3

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.

4 results