I'm running OC 4.0.6 and have several users sharing files. On some of the users, everything is OK, but I have a few that have VERY slow access to their Shared folder. When you click on the Shared folder, it takes about 2 minutes to access. As long as you stay inside the Shared folder, everything is OK - you can go into subfolders quickly. However, if you ever leave the Shared folder and try to go back in, the clock starts again on the slow access.

The platform is Ubuntu 12.04 running Apache and MySQL.
Running "mytop" while waiting to access the Shared folder shows very few queries runnning. THe processor usage on Apache and MySQL are very high while waiting, though.

This is one of the queries running:
Query SELECT source FROM oc_sharing WHERE target = '/User.Name/files/Shared/NDW/Project Managment' AND uid_shared_with IN('User.Name', 'User.Name@All Users', 'User.Name@SEA Associate', 'public') LIMIT 1

It seems to be doing one of those for each folder.

This machine has plenty of I/O. I have the server set to log slow queries (slower than 1 second) and it is not logging anything during this process.

Any ideas on why this would only affect some users and/or what I can do to help it?


Trey Nolen

_______________________________________________
Owncloud mailing list
[email protected]
https://mail.kde.org/mailman/listinfo/owncloud

Reply via email to