PatrickRQ Posted July 16 Share Posted July 16 Hello, Has anyone noticed high CPU usage on 4.7.17? I upgraded while ago and noticed CPU usage in my case raised on web host serving that version where test forum that still runs on 4.7.14 is OK. Link to comment Share on other sites More sharing options...
Jim M Posted July 16 Share Posted July 16 Is it always high or only high during certain periods? Have you disabled any third party applications/plugins/themes to see if there is any correlation? Do you have any background tasks running? Have you gotten with your hosting provider to check all items on the server? While I understand you are trying to correlate this to the upgrade, correlation does not always equal causation so you must investigate it all. Link to comment Share on other sites More sharing options...
PatrickRQ Posted July 16 Author Share Posted July 16 Looks like with 4.7.17 MySQL gets overwhelmed. Quote Removed a MySQL 5.7 specific optimisation for loading content item with lots of comments. Can the change be related? Link to comment Share on other sites More sharing options...
Jim M Posted July 16 Share Posted July 16 1 minute ago, PatrickRQ said: Looks like with 4.7.17 MySQL gets overwhelmed. Can the change be related? It would be recommended to update to MySQL 8. The optimization really shouldn't impact you that much as it was removed to offer better performance in MySQL 8 and across the board. Link to comment Share on other sites More sharing options...
PatrickRQ Posted July 16 Author Share Posted July 16 1 minute ago, Jim M said: It would be recommended to update to MySQL 8. The optimization really shouldn't impact you that much as it was removed to offer better performance in MySQL 8 and across the board. Just now, Jim M said: Is it always high or only high during certain periods? Have you disabled any third party applications/plugins/themes to see if there is any correlation? Do you have any background tasks running? Have you gotten with your hosting provider to check all items on the server? While I understand you are trying to correlate this to the upgrade, correlation does not always equal causation so you must investigate it all. It is always high. I tried disabling customs, same. FYI, my test copy run on 4.7.14 with same set of custom hooks and has no problems. I tried isolating the issue by disabling different elements and from what I determine now it seems to be MySQL. Quote It would be recommended to update to MySQL 8. Will consider in some future but for now I would prefer to fix issue on current version, since I still use "compatible one". Link to comment Share on other sites More sharing options...
Jim M Posted July 16 Share Posted July 16 2 minutes ago, PatrickRQ said: Will consider in some future but for now I would prefer to fix issue on current version, since I still use "compatible one". Keep in mind that compatible just means it will run, it does not mean it will be performant. However, I have tagged a developer to see if they have any recommendations. Link to comment Share on other sites More sharing options...
PatrickRQ Posted July 16 Author Share Posted July 16 3 minutes ago, Jim M said: Keep in mind that compatible just means it will run, it does not mean it will be performant. However, I have tagged a developer to see if they have any recommendations. Appreciate, as this is not good time for me to upgrade anything in my env. Link to comment Share on other sites More sharing options...
PatrickRQ Posted July 16 Author Share Posted July 16 @Jim M I need to send some sensitive data, can I send you a private message? I think I might have found a hole somebody is using to overwhelm the MySQL Link to comment Share on other sites More sharing options...
Jim M Posted July 16 Share Posted July 16 18 minutes ago, PatrickRQ said: @Jim M I need to send some sensitive data, can I send you a private message? I think I might have found a hole somebody is using to overwhelm the MySQL If you think you found security issues, please feel free to use the contact us link at the bottom of the page. Link to comment Share on other sites More sharing options...
PatrickRQ Posted July 18 Author Share Posted July 18 I responded to your email but did not get any reply. Did you get the files I sent? Link to comment Share on other sites More sharing options...
Jim M Posted July 18 Share Posted July 18 I'm afraid, we have not received any more information from you. Link to comment Share on other sites More sharing options...
PatrickRQ Posted July 19 Author Share Posted July 19 I sent again, check your inbox, spam, etc. It was sent correctly on my end. Link to comment Share on other sites More sharing options...
Jim M Posted July 19 Share Posted July 19 This was received this time and replied to. Thanks. Link to comment Share on other sites More sharing options...
Recommended Posts