Performance Problems

[xxLexanixx]

Describe the bug

When i sync Photos to my Nextcloud goes the performance down.

The Troubleshooting worked not for me.

Here The Logs from occ maintenance:repair

• Repair MySQL collation
  • All tables already have the correct collation -> nothing to do
• Clean tags and favorites
  • 0 tags of deleted users have been removed.
  • 0 tags for delete files have been removed.
  • 0 tag entries for deleted tags have been removed.
  • 0 tags with no entries have been removed.
• Repair invalid shares
• Move .step file of updater to backup location
• Add move avatar background job
  • Repair step already executed
• Add preview cleanup background jobs
• Migrate oauth2_clients table to nextcloud schema
  • Update the oauth2_access_tokens table schema.
  • Update the oauth2_clients table schema.
  • Delete clients (and their related access tokens) with the redirect_uri starting with oc:// or ending with *
• Fix potential broken mount points
  • No mounts updated
• Repair language codes
• Add log rotate job
• Clear frontend caches
  • Image cache cleared
  • JS cache cleared
• Clear every generated avatar
• Add preview background cleanup job
• Queue a one-time job to cleanup old backups of the updater
• Cleanup invalid photocache files for carddav
• Add background job to cleanup login flow v2 tokens
• Remove potentially over exposing share links
  • No need to remove link shares.
• Clear access cache of projects
• Reset generated avatar flag
• Keep legacy encryption enabled
• Check encryption key format
• Remove old dashboard app config data
• Add job to cleanup the bruteforce entries
• Queue a one-time job to check for user uploaded certificates
• Repair DAV shares
• Add background job to set the lookup server share state for users
• Add token cleanup job
• Clean up abandoned apps
• Add possibly missing system config
• Add AI tasks cleanup job
• Queue a job to generate metadata
• migrate lazy config values
• Migrate user theme settings
• Fix component of birthday calendars
  • 3 birthday calendars updated.
• Regenerating birthday calendars to use new icons and fix old birthday events without year
  • Repair step already executed
• Fix broken values of calendar objects 0 [->--------------------------]
• Registering building of calendar search index as background job
  • Repair step already executed
• Register building of social profile search index as background job
  • Repair step already executed
• Registering background jobs to update cache for webcal calendars
  • Added 0 background jobs to update webcal calendars
• Registering building of calendar reminder index as background job
  • Repair step already executed
• Clean up orphan event and contact data
  • 0 events without a calendar have been cleaned up
  • 0 properties without an events have been cleaned up
  • 0 changes without a calendar have been cleaned up
  • 0 cached events without a calendar subscription have been cleaned up
  • 0 changes without a calendar subscription have been cleaned up
  • 0 contacts without an addressbook have been cleaned up
  • 0 properties without a contact have been cleaned up
  • 0 changes without an addressbook have been cleaned up
• Remove activity entries of private events
  • Removed 0 activity entries
• Clean up old calendar subscriptions from deleted users that were not cleaned-up 0 [----->----------------------]
  • 0 calendar subscriptions without an user have been cleaned up
• Remove invalid object properties
  • 0 invalid object properties removed.
• Fix the share type of guest shares when migrating from ownCloud
• Copy the share password into the dedicated column
• Set existing shares as accepted
• Repair steps for Memories
  • External table schema seem up to date
  • WARNING: Failed to create filecache trigger (compatibility mode will be used): An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1419 You do not have the SUPER privilege and binary logging is enabled (you might want to use the less safe log_bin_trust_function_creators variable)
  • exiftool binary is configured: /var/www/html/nextcloud/apps/memories/bin-ext/exiftool-amd64-glibc
  • go-vod binary is configured: /var/www/html/nextcloud/apps/memories/bin-ext/go-vod-amd64
  • ffmpeg binary is configured: /usr/bin/ffmpeg
• Clean up meta table
• Show a hint about the new editor to existing users
• Set binary permissions
• Update OAuth token expiration times
• init metadata
• Switches from default updater server to the customer one if a valid subscription is available
  • Repair step already executed
• Send an admin notification if monthly report is disabled
• Force-reset all Text document sessions
• Initialize migration of background images from dashboard to theming app
• Add background job to check for backup codes
• Populating added database structures for workflows

Steps To Reproduce

No response

Platform

- OS: ubuntu
- Browser: Google Chrome
- Memories Version: newest
- Nextcloud Version: newest
- PHP Version: 8.3.9

Screenshots

No response

Additional context

• Any errors in the JS console?
• Any errors in the Nextcloud server logs?

[pulsejet]

How many photos do you have? What hardware?

[xxLexanixx]

Currently there are around 15,000 photos.

It's an i5 4th Gen with 3GB RAM.

However, I think it's the database because it shows me an error.

[pulsejet]

15k is very small, memories can easily handle >1M photos. Try the server tuning guide of nextcloud.

[xxLexanixx]

Which server tuning guide? can you send me a link?

[pulsejet]

https://docs.nextcloud.com/server/latest/admin_manual/installation/server_tuning.html

Also you might want to turn on log_bin_trust_function_creators in your database and rerun occ maintenance repair