Suljettu

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

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.

Taidot: PHP, MySQL, HTML, verkkosivujen suunnittelu, WordPress

Näytä lisää: wampserver website server, sql server 2000 sql save image, mysql server optimization, migrating website server, windows 2003 server optimization, website server system diagnosis, web quiz script website server, sql server output sql xml, copying website server, setup website server, removing virus website server, asp website back end sql server, sp optimization sql server 2008 free lancer, sql server optimization, Code Cleanup | Website speed optimization (on page & server side), database optimization sql server, sql server optimization techniques, sql server optimization tips, website seo optimization services, sql server optimization settings

Tietoa työnantajasta:
( 57 arvostelua ) Muscatine, United States

Projektin tunnus: #26949444

17 freelanceria on tarjonnut keskimäärin 163$ tähän työhön

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 Lisää

$200 USD 7 päivässä
(107 arvostelua)
6.9
TurboWebWP

I can help. I am an expert in this specific field of speed optimization and own a company from Romania doing exclusively ADVANCED speed optimization. ([login to view URL]) I only deliver ADVANCED optimizations, not mediu Lisää

$300 USD 7 päivässä
(43 arvostelua)
6.3
(36 arvostelua)
6.1
(160 arvostelua)
6.0
archanacodenomad

Hi,  Greetings! You would be delighted to know I am a developer/ designer who is available on an immediate basis to assist you in your project. SKILLS AND EXPERIENCES:- Front End:  Angular JS, Bootstrap, D3.Js, HTML Lisää

$220 USD 7 päivässä
(11 arvostelua)
5.7
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 7 päivässä
(27 arvostelua)
5.4
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 Lisää

$140 USD 7 päivässä
(16 arvostelua)
4.0
yevgeniyrup20

Dear Christopher Michael A . Here is senior web developer. I am a PHP expert with over 6 years experience dealing with SEO projects, I can help you. I have previously completed many optimization projects for other empl Lisää

$100 USD 6 päivässä
(9 arvostelua)
3.7
vikramsomi04

Hello there, I am website developer. I went through your requirements and have a clear image of what you are trying to build. I would like to inform you that me along with my team are able to build similar platform. W Lisää

$140 USD 2 päivässä
(6 arvostelua)
2.6
revealsolution

Hello, We are highly interested to work on your [login to view URL] have been gone thorough your description & attachments and understand complete [login to view URL] will able to optimize my website and server as your requirements Lisää

$140 USD 7 päivässä
(3 arvostelua)
2.7
(2 arvostelua)
2.9
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 3 päivässä
(4 arvostelua)
2.1
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 Lisää

$200 USD 5 päivässä
(1 arvostelu)
1.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 Lisää

$140 USD 7 päivässä
(0 arvostelua)
0.0
shamimian777

Hi Sir, High Quality & Fast Delivery is promised.I am professional [login to view URL] Work will be Done as you say as you want. I can start right now. 100% Satisfacation Guaranteed with my work.I have gone through your Lisää

$200 USD 7 päivässä
(0 arvostelua)
0.0
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, Lisää

$140 USD 7 päivässä
(0 arvostelua)
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 Lisää

$140 USD 7 päivässä
(0 arvostelua)
0.0