Several points on this
-
I have already explained that any issue to be investigated needs to have debug logging enabled beforehand. All logs provided had debug logging disabled. See my response to you here What do these logs mean exactly? Trying to debug general instability - #6 by sa2000
-
To investigate this, logs with debug logging enabled would need to be provided covering the time the Database Optimize was last triggered and all the time up to its completion. Also the logs need to cover the period between that time and the time when you notice an abnormal time for response time. You may need to increase the number of log files through
LogNumFiles- see https://support.plex.tv/articles/201105343-advanced-hidden-server-settings/ -
There is no personal service provided here. Support is through the forums. If there are sensitive elements - look into redacting them provided they do not impede the investigation. For some specific diagnostics you may be requested to send the files privately or share link privately - but the normal process for support is through the forums
-
More frequent optimization may be needed if there is high level of changes to the media and adding/removing and this may also get triggered by having multiple instances of same media file in the libraries as the hashes would match and Plex may switch from one to another. Logs would show if this is happening
