Performance issue after upgrade to 4.4.4

[Sonya*]

Hi,

I have performance issues since upgrade to 4.4.4. E. g. adding posts takes up to 60 seconds till it saved. Approving new images as well.

• I do not have any errors in email logs
• No long queries are seen in database processes while adding a post
• I use Elastic search
• I use Redis as caching method and File system as Datastore
• All tables (except two that are not really used) are in InnoDB
• There are three servers: nginx, database and mail

This is a log for editing image in gallery:

"01/Jul/2019:21:41:51 +0300" client=XX.XXX.18.50 method=POST request="POST /gallery/image/4807-test/?do=edit HTTP/1.1" request_length=3962 status=301 bytes_sent=440 body_bytes_sent=0 referer=https://www.example.com/gallery/image/4807-test/?do=edit user_agent="Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.131 Safari/537.36" upstream_addr=127.0.0.1:9001 upstream_status=301 request_time=31.255 upstream_response_time=31.253 upstream_connect_time=0.000 upstream_header_time=31.253

Upstream_response_time=31.253 😞

Support says, my server is misconfigurated. It is weird as till yesterday I was on 4.4.3 and had no issues. I have not changed anything on the server, just upgraded to 4.4.4 and right after that got performance issues.

Can somebody give a tip of how I can make performance debugging to investigate what is going on.

Thank you.

[bfarber]

Out of curiosity - check your email logs and see if a lot of emails are being sent out when adding posts.

[Numbered]

define('DEBUG_LOG', true); in constants.php might be useful in some situations. Or, if you fully support your environment - you can turn on NewRelic extension with demo key. It will show all bottlenecks simply.

[AlexWebsites]

I had a ticket out on something similar because it was taking a long time to comment on a galley image. Support stated it was related to emails, however I also don't recall this issue prior to the latest release. Happens sporadically and only in gallery.

[Sonya*]

I have figured it out. It is due unarchiving posts on our project. I have disabled unarchiving some weeks before update. It seems that unarchiving slows down the system significantly on 4.4.4. Support has looked into the issue and submitted a patch. It looks better now, not perfect, but better. I hope it's completely solved in some weeks when unarchiving is done completely.