Sonya* Posted July 1, 2019 Share Posted July 1, 2019 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. Link to comment Share on other sites More sharing options...
bfarber Posted July 8, 2019 Share Posted July 8, 2019 Out of curiosity - check your email logs and see if a lot of emails are being sent out when adding posts. Link to comment Share on other sites More sharing options...
Numbered Posted July 8, 2019 Share Posted July 8, 2019 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. Link to comment Share on other sites More sharing options...
AlexWebsites Posted July 8, 2019 Share Posted July 8, 2019 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. Link to comment Share on other sites More sharing options...
Sonya* Posted July 8, 2019 Author Share Posted July 8, 2019 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. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.