PHP

mysql optimization – if you are using Word Press, do not turn off persistent connection
CK CK 3788 
Created at  
 591 0 0

I am using Virtual Private Hosting service, and I found that my server has some problem as below. As you can see the CPU occupation rate is more than 300%. So my server response speed is the most slower than I had experiences before.

mysql optimization – if you are using Word Press, do not turn off persistent connection

I had read some articles on internet, and the most of the recommendation was turning off the persistent connection option (mysql.allow_persistent).

So I tried to change the setting by opening /etc/php.ini to check persistent connection setting.

Following is the basic setting on my server:

mysql optimization – if you are using Word Press, do not turn off persistent connection

And I changed as below:

 mysql optimization – if you are using Word Press, do not turn off persistent connection

But the result is very disappointed. As you can see the maximum CPU occupation rate is more than 800%. My apache does not response at all.

mysql optimization – if you are using Word Press, do not turn off persistent connection

In terms of Word Press point of view, persistent connection option is very helpful, because Word Press requires persistent connection.

Tags PHP VPS Virtual Private Hosting allow_persistent blog body copy & paste metaWeblog API file attachment mt_rand timeout Facebook X
Comments 0
Similar posts
  1. File downloading function through PHP code
    532
  2. Image file resizing in PHP
    561
  3. Apache server unstable detection and the related server(mysql, apache) restart automatically
    536
  4. JSON format control in PHP
    691
  5. How to optimize MySQL automatically in CentOS Linux
    1,007
  6. GD library version in PHP
    505
  8. Convert plain HTML to XHTML
    452
  9. Simple PHP code performance measuring example
    792
  10. Simple PHP calendar
    474
  11. Function can extract file name in string having full path in PHP
    567
  12. Checking similarity between two strings in PHP
    674
  13. How to create private URL on S3/CloudFront with time-limit ?
    919
  14. PHP Code can know the current OS is windows or not
    584
  15. Uploading files to Amazon S3 with REST API in PHP
    841
  16. Human readable random string for captchas in PHP
    559
  17. How to get the duration between days in PHP
    423
  18. Date format validation in PHP
    571
  19. PHP function converts new line to BR tag
    560
  20. Email Validation Snipet in PHP
    379
  21. PHP socket programming to get content with post method
    410
  22. Get Remote IP Address in PHP
    498
  24. How to remove HTML tags in text string?
    405
  25. Directory listing in PHP
    512
  26. Seconds to String in PHP
    436
  27. Setup Apache+PHP+MySQL on Centos 6.7
    605
  28. How to delete file on certain path ?
    389
  29. ASCII Artwork Generator from image file
    469
  30. How to limit by Timeout when opening URL ?
    458
  31. How to put timeout when opening URL by fopen ?
    441
  32. How to convert W3C Date Time Format ?
    456
More in PHP
  1. CentOS 7 PHP Apache Kafka: Installation, Examples, and System Diagram
    306
  2. Apache Kafka Explained: Powering Netflix, Building with PHP
    491
  4. Array of arguments passed to script in PHP
    90
  5. Bob Jenkins' One-At-A-Time hashing algorithm in PHP
    52
  6. 32bits simple hash function in PHP
    38
  7. PHP Code Compression Tool by removing whitespace, strips comments - PHP Minifier/Compressor
    1,412
  8. Setup Apache+PHP+MySQL on Centos 6.7
    605
  9. mcrypt missing when using phpMyAdmin on Centos 6.7
    548
  10. PHP Code can know the current OS is windows or not
    584
  11. Checking similarity between two strings in PHP
    674
  12. Simple PHP calendar
    474
  13. Simple PHP code performance measuring example
    792
  14. Convert plain HTML to XHTML
    452
  15. GD library version in PHP
    505
  16. JSON format control in PHP
    691
  18. File downloading function through PHP code
    532
  19. Image file resizing in PHP
    561
  20. Apache server unstable detection and the related server(mysql, apache) restart automatically
    536
  21. How to set AUTO_INCREMENT ID in mySQL ?
    606
  22. Function can extract file name in string having full path in PHP
    567
  23. How to create private URL on S3/CloudFront with time-limit ?
    919
  24. Parsing XML in PHP
    1,192
  25. Unzip a ZIP file in PHP
    503
  26. Uploading files to Amazon S3 with REST API in PHP
    841
  27. Human readable random string for captchas in PHP
    559
  28. How to get browser information in PHP?
    852
  29. How to get the duration between days in PHP
    423
  30. Date format validation in PHP
    571
  31. PHP function converts new line to BR tag
    560
  32. Email Validation Snipet in PHP
    379
Recently updated
  1. Why 100% SEO Guarantees Better User Engagement and How to Achieve It in Your Service
    40
  2. Why SPF and DKIM Are Essential for Linux Email Servers?
    34
  3. How do I create animated background for Google Meet?
    20,611
  4. MaxMind GeoLite2 vs. DB-IP Lite vs. ip-api.com: Choosing the Right Free IP Geolocation Solution
    244
  5. Meet Valkey: Why Redis Changed Its License, Why Valkey is Better, and How to Use It as a Drop-in Replacement
    94
  6. How Rogue Web Scrapers Are Stealing My Content and Destroying My Server
    157
  7. Array of arguments passed to script in PHP
    90
  8. Invalid Auction Storms in Ad Tech
    98
  9. Building MRC-Compliant Instrumentation in Ad Tech: Implementation Steps and Key Challenges
    202
  10. The Two Clocks of Ad Server Architecture
    70
  12. Frequency Cap Architecture Overview
    514
  13. Collecting Proof-of-Play from 100,000 Screens
    146
  14. Vector Search in Relational Databases (RDBs): Trends & Usage Environments
    287
  15. What is RedisVL?
    109
  16. Designing a Skill Registry Architecture: Minimize Token Usage and Maximize AI Performance
    230
  17. TPU & GPU Cluster Management Tools
    243
  18. The Concept of Scaffolding in AI Agents
    233
  19. Beyond Static Pipelines: Architecting LLM Multi-Agent Systems for Autonomous Workflow Orchestration
    583
  20. AI-DLC vs. AI-SDLC: Model-Centric vs. System-Centric AI Development
    258
  21. Fine-Tuning Open-Weight LLMs: Training, Licensing, and Deploying Custom Models with Ollama
    339
  22. Inside the Next-Generation Streaming Architecture: Ultra-Low Latency, SGAI, and AI Codecs
    202
  24. Machine Learning: Training vs. Ranking
    221
  25. The Continuous Learning Machine: Designing a Loop That Actually Turns
    222
  26. The Next-Gen Low-Latency Standards: LL-HLS & MoQ
    195
  27. Designing a Data Curation System Around a Vector Database
    220
  28. Extracting Context from Live Video: The Architecture Got Simpler When We Stopped Building Features
    256
  29. The New Ad Stack Behind Live Sports Streaming: Inside SGAI, EABN, and the Standards Race to Fix Live Monetization
    656
  30. Designing MLOps Architectures to Handle Seasonal Data Drift in EV Fleet Models
    195
  31. From 15 to 40+ FPS: Accelerating PyTorch Object Detection on Automotive ECUs
    217
  32. Understanding Data Lineage
    260