Website and Server PHP Optimization - PHP/SQL Hangs Forcing Restart of Services
$30-250 USD
Paid on delivery
Hey there!
I'm in need of someone to help me optimize my website and server, specifically relating to a php/sql issue that we keep having, mainly relating to php-fpm pools not clearing out and forcing us to restart php and mysql on one domain. The attached image shows all of the pools staying open with little load on the 12 core server. It causes the website to hang and not respond. If we restart the php and sql services all is good again. It usually happens once or twice a day, not always directly related to something we're doing or traffic. The site is admittedly large (almost 4,000 posts and 5,900 items in the media library). I have root access to the server and can provide access; however, I want to know about all of the changes that will be made before they are made.
Ideas that I think need considered (but I know just enough to be dangerous):
How the pools are created and maintained (dynamic vs set) - See * below
Database type (currently myISAM)
Datebase indexing
PHP version: 7.3
Server Information:
Total processors: 12
Processor #1
Vendor
GenuineIntel
Name
Intel(R) Xeon(R) CPU E5-2430 v2 @ 2.50GHz
Speed
2799.682 MHz
Cache
15360 KB
Theme System Status Info
Theme config
Theme name i Newspaper
Theme version i 10.3.5
Theme database version i 10.3.5
HTTP channel test wordpress
Installed demo i News Magazine - demo ID: magazine | install type: no_content
Theme Mobile Newspaper mobile version
[login to view URL] configuration
Server software i Apache
PHP Version i 7.3.18
post_max_size i 2024M - You cannot upload images, themes and plugins that have a size bigger than this value. To see how you can change this please check our guide here.
max_execution_time 300
max_input_vars 5000
SUHOSIN installed false
PHP extensions
mbstring available
GD library available
WordPress and plugins
WP version i 5.5
WP multisite enabled i No
WP Language i en_US
WP Memory Limit 1 GB/request
WP_DEBUG WP_DEBUG is enabled. It may display unwanted messages. To see how you can change this please check our guide here.
Caching plugin WP Rocket
Site Health Status Issues
*An active PHP session was detected
Performance
A PHP session was created by a session_start() function call. This interferes with REST API and loopback requests. The session should be closed by session_write_close() before making any HTTP requests.
The REST API encountered an error
Performance
The REST API is one way WordPress, and other applications, communicate with the server. One example is the block editor screen, which relies on this to display, and save, your posts and pages.
The REST API request failed due to an error.
Error: cURL error 28: Operation timed out after 10001 milliseconds with 0 bytes received (http_request_failed)
Your site could not complete a loopback request
Performance
Loopback requests are used to run scheduled events, and are also used by the built-in editors for themes and plugins to verify code stability.
The loopback request to your site failed, this means features relying on them are not currently working as expected.
Error: cURL error 28: Operation timed out after 10001 milliseconds with 0 bytes received (http_request_failed)
Security
Your site is running an older version of PHP (7.3.18)
Performance
PHP is the programming language used to build and maintain WordPress. Newer versions of PHP are faster and more secure, so staying up to date will help your site’s overall performance and security. The minimum recommended version of PHP is 7.4.
A scheduled event has failed
Performance
The scheduled event, snapshot_remote_file_cron, failed to run. Your site still works, but this may indicate that scheduling posts or automated updates may not work as intended.
Project ID: #26949444
About the project
16 freelancers are bidding on average $166 for this job
Hi, I carefully read the task details and understand the project requirements and I want to discuss more over chat if possible. I will do all of the tasks and will make sure that you will be satisfied with it also. I a More
Hi Nice to meet you I wish to express my genuine interest and expertise to be associated with you and execute your esteemed project. Expert in BOTH Backend and Front-end Programming, MVC, REST API, HTML/CSS/JAVASCRIPT More
Ready to start the work to create the Website and Server PHP Optimisation , we can discuss more over chat, thanks regards kanta singh.
Hi, I have experience in Linux system admin and aws services. I can help solve php hang issue. Please discuss to start. Thank you
Hey there, Hope you are doing well. I can see that you are looking for a full stack developer. I have already done kind of this work before, and I can assure you that this would not be a complication for me. I would lo More
Do the good Jobs with Good Tools. Experienced(6 Years), Android and Ios(Native or Hybrid), PHP, Delphi , Python, Vb, C# and Java developer and web designer with the depth knowledge related to MySQL,Codeigniter,Laravel, More
Hy hopes you are well. I read the description of the project you want watched all photos you attached to project. I am a web developer and I can make beautiful, responsive frontend and fast and secured backend. I'm ex More
Dear Sir or Madam I looked into a couple of the issues. for the "session_write_close() before making any HTTP requests" there is a update threw wp that will fix this it is for 5.5 the version you have and this will hel More