Website and Server PHP Optimization - PHP/SQL Hangs Forcing Restart of Services

Closed Posted 3 years ago Paid on delivery
Closed 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.

PHP MySQL HTML Website Design WordPress

Project ID: #26949444

About the project

16 proposals Remote project Active 3 years ago

16 freelancers are bidding on average $166 for this job

gauravgargcs

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

$200 USD in 7 days
(124 Reviews)
7.2
rkurilenko007

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

$140 USD in 7 days
(25 Reviews)
4.8
arjun366333

Ready to start the work to create the Website and Server PHP Optimisation , we can discuss more over chat, thanks regards kanta singh.

$100 USD in 7 days
(27 Reviews)
5.4
chandrashekhar01

Hi, I have experience in Linux system admin and aws services. I can help solve php hang issue. Please discuss to start. Thank you

$133 USD in 3 days
(5 Reviews)
2.7
twocreativepro

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

$200 USD in 5 days
(4 Reviews)
2.3
BrainSoftTechn

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

$140 USD in 7 days
(0 Reviews)
0.0
muzamilkhalid500

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

$140 USD in 7 days
(0 Reviews)
0.0
Fluffywuffy

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

$140 USD in 7 days
(0 Reviews)
0.0