WordPress High MySQL load | Moving away from LAMP stack and into cloud? | Vulnerability update and Industry News

 
From: "WebHostingTalk Insider" <insider@PROTECTED>
Subject: WordPress High MySQL load | Moving away from LAMP stack and into cloud? | Vulnerability update and Industry News
Date: December 22nd 2021

Wishing all of our readers, members and friends a very merry and safe Christmas!

December 22nd 2021

Wordpress High MySQL load

Shahzaib has a WordPress website on a dedicated server. Under traffic the load on MySQL jumps to end up consuming 30 CPUs. For caching he's using WordPress supercache plugin and PHP opcache with nginx+php-fpm. He asks if there's a way to reduce the Mysql CPU load? After some early advice in the thread he found that after creating indexes on wp_postmeta the load was drastically reduced. That was a few weeks ago but yesterday he was back to report that there has been a sudden surge on MySQL load and there are abnormal long queries running. For those that have experience of tuning WordPress sites that produce a heavy MySQL load, what advice can you offer in this thread that could help?

Join the discussion


 

 

Moving away from LAMP stack and into cloud?

A member's project has been running the traditional LAMP stack for their website (PHP+MySQL, similar to WordPress), for the past 10+ years. But as they are about to tackle some upgrade projects a question came up - Should they go to cloud? And, if they do, what should they do there? Is the obvious answer to just to get a VM in the cloud and put LAMP on it again? Something like Amazon Lightsail? Or can they do more? Should they even be doing that anymore? Does it make more sense to do it as a collection of cloud services, hosting their files in storage and use the distributed MySQL database in the cloud? They realize in this scenario they lose a lot of flexibility and control, but is this design the way of the future? Also, keeping costs low and steady is very important to them. What are your experiences on moving away from LAMP?

Join the discussion


 

 

Fully Managed Dedicated from $99/mo

Upgrade to Fully Managed Hosting with special savings on select configurations, as low as $99/mo.

  • New customers looking for the absolute best in power and performance can also take 25% off their first 6 months on servers featuring the latest Intel Xeon 6226R processors.
  • As always, migrations are free and every managed solution includes our 100% Network and Power Uptime Guarantees, industry-leading SLAs, and 24/7/365 support from the Most Helpful Humans in Hosting®.

Learn More


Vulnerability update and industry news

Last week we warned of the HApache Log4j utility zero-day exploit made public on December 9, 2021. Unfortunately there have been further updates since, with a second vulnerability, and then a third, being discovered, with the latest 2.17.0 version of Log4J being released. It is also now being reported that the Conti ransomware operation is using the critical Log4Shell exploit to gain rapid access to internal VMware vCenter Server instances and encrypt virtual machines. 

More from around our Industry:

Got some news of your own to share? If it's news from your own company it belongs in Web Hosting Industry Announcements (no ads please!). If you've scooped some news about something else going on in the hosting industry we'd love for you to share it in our Industry News section!

Browse all Industry News


 

 

Corporate and Premium Memberships

Have you ever wondered how to increase your presence and exposure on WebHostingTalk? Premium and Corporate memberships offer you opportunities to stand out in posts and advertisements, post offers more frequently, enjoy a larger PM (private message) box capacity, participate in the "VIP" area at the top of the forum and, for corporate members, receive keyword alerts which you can customize to your own needs. Find out more by visiting our memberships page.

Start the New Year with a WHT Membership


Contact:
https://www.webhostingtalk.com
insider@PROTECTED
WebHostingTalk, Inc. 2 Toronto St., Ste. #239, Toronto, ON, M5C 2B5 Canada
Phone:+1 416 277 0095
 
  • This mailing list is a public mailing list - anyone may join or leave, at any time.
  • This mailing list is announce-only.

Delivered weekly, the Web Hosting Talk Insider newsletter covers the latest news in the cloud and hosting industry, the hottest Web Hosting Talk threads, and in-depth insight and commentary on the trends impacting your business.

Privacy Policy:

https://info.webhostingtalk.com/wht-privacy-policy/

Go back to WebHostingTalk