New MySQL Setup For Faster Query Processing

Two of the most frequent reasons a site might be slow are unoptimized PHP processes and heavy MySQL queries. Website code optimization is always a crucial part of the constant battle for more website speed. However, webmasters hosting with SiteGround, have always had a reliable ally by their side in this quest.

Recently we have announced the new Ultrafast PHP, which significantly speeds up the processing of PHP scripts and improve the website performance up to 30%. 
As a natural next step in our efforts to offer a premium and superfast service, we deployed a server-side solution to optimise database queries which has already brought down the number of slow queries between 10 and 20 times!

What are slow MySQL queries and why they matter ?

If you are managing an active site with a database, you probably understand that when a visitor enters your site, there are tons of scripts that start running, some of which ask your database for information. For example, if you have an online shop and a visitor is trying to purchase an item, your store should check for its availability in the database and display if it’s possible to be ordered. That check triggers a MySQL query. And depending on how that query is written it may be quite heavy and time-consuming to be processed by the server. For you as a webmaster, these slow queries are a problem because you will be losing clients. You know how visitors drop out of the site when they have to wait longer than 2-3 seconds for a page to load? Well, you get it. For us as your host, we don’t like it when our servers get throttled processing too many slow queries because this means that the CPU and RAM of the machine get blocked and cannot be used for other processes, which are also important for yours and the other websites hosted on the server.

What did we do?

The battle with slow MySQL queries is an ongoing process, which involves both the webmaster and the host. That is why we recently launched a new MySQL setup on our servers, which takes an innovative approach to distributing the server RAM and allocating it to the MySQL. The new setup allows a much higher number of parallel requests to be processed simultaneously and this has a great impact on the effective handling of heavy MySQL queries. So great that the Sys Admins, watching the server load after the new MySQL setup launch, still don’t believe it – they saw a drop in slow queries between 10 and 20 times! 

All of our latest service improvements such as the Ultrafast PHP and now the MySQL setup are possible thanks to two things – the Google Cloud platform and the switch from cPanel to Site Tools. Since moving to Google Cloud, we upgraded our server configurations with more RAM. The RAM unit price is not cheaper, but working in the cloud offers possibilities for better distribution of that resource among different machines. And the fact that we don’t comply with third-party’s software resource requirements such as cPanel, gives us more freedom to innovate. Our DevOps feel empowered to create and keep developing smart technologies that benefit the greater majority of the sites we host spot on!

Who gets it?

Everyone hosted on our shared Site Tools servers already got the new MySQL setup! If you have been seeing an enhancement in the performance for the last week or so, it’s because of the new setup.

That means it’s less likely that you hear from us asking you to fix a slow query and “socially-distancing” your site due to that. Fewer slow queries, faster servers, less hassle for you!

Cloud accounts are also scheduled to receive the new MySQL setup by the end of February, 2021.

Still a SiteGround client on cPanel? We expect to migrate everyone by the end of March 2021 so all you need to do is wait just a little bit longer.

Access email sent!

Sign Up For
More Awesome Content!

Subscribe to receive our monthly newsletters with the latest helpful content and offers from SiteGround.

Thanks!

Please check your email to confirm your subscription.

author avatar

Hristo Pandjarov

WordPress Initiatives Manager

Enthusiastic about all Open Source applications you can think of, but mostly about WordPress. Add a pinch of love for web design, new technologies, search engine optimisation and you are pretty much there!

Speed

Comments ( 50 )

author avatar

Janine Rauwenhoff

Jan 30, 2021

can you please upgrade MySQL to version 5.7 as it is required by the latest version of moodle Also am i ugraded to the MY SQL for a faster website speed ? Kindest, Janine Rauwenhoff

Reply
author avatar

Hristo Pandjarov Siteground Team

Feb 01, 2021

It is available on Site Tools, once your account is migrated you will automatically start using it. We should complete migrations by March.

Reply
author avatar

Brian

Feb 03, 2021

What could help alot of people, was some default settings for some wordpress themes... Divi, avada and other well known.. could save support some calls and time for us users. Get at guy to optimize speed on 5-6 of the most used themes, add em as a selection in the SG optimizer. Just a thought.

Reply
author avatar

Hristo Pandjarov Siteground Team

Feb 04, 2021

Well, we could do that but that would mean we interfere with others' software which is not well accepted if not forbiden for plugins and themes in the official WordPress repository. Generally, a theme should not be doing stuff like minification, combination and caching on the fly but theme providers are doing it so they can advertise their themes better and because they run on standard hosting providers that don't have any special caching solutions and rely on plugins. Otherwise it is 5 minutes of coding to disable their optimizations and enable ours but sometimes our hands are tied...

Reply
author avatar

Mark

Feb 10, 2023

Good answer!

Reply
author avatar

Simon Womersley

Feb 01, 2021

Thanks for doing this. I find all your service tweaks make my websites fast and I don't need to do anything :) I've found for some time now one of my websites is slow to connect. Once loaded it's super-fast (via SG Optimiser and basic speed optimisation tactics). It's just the initial load/ connection. Maybe out of this blog's scope, but is there any speed benefit of moving my domain registrar, so it's also with SiteGround?

Reply
author avatar

Hristo Pandjarov Siteground Team

Feb 03, 2021

Thanks for the kind words :) It doesn't matter where your domain is registered, it won't affect your loading speeds.

Reply
author avatar

Simon Womersley

Feb 03, 2021

Thanks for getting back to me. I'll tick that off the list and investigate some more.

Reply
author avatar

Josh

Feb 04, 2021

Great to hear - thank you! For someone with a Cloud account, and on Site Tools, will there be a way to check if we have been switched to the new version other than "feeling it"? Thanks!

Reply
author avatar

Hristo Pandjarov Siteground Team

Feb 05, 2021

Once we complete raising the minimum cloud configuration we will deploy the latest changes. There will be a minimal downtime for the service restart in the least busy time of the day so we don't plan on mailing and scheduling. I would say it's best to monitor the blog for new posts since we will announce more info on the matter soon.

Reply
author avatar

Jean-S.

Feb 26, 2021

Following this too. I'm on Cloud Account and my minimum requirements (CPU, Memory) have been upgraded a few days ago, but no noticeable change in terms of speed.

Reply
author avatar

Hristo Pandjarov Siteground Team

Feb 26, 2021

The new MySQL setup is probably not yet applied on your Cloud account since it rolls out after the resources increase.

Reply
author avatar

Sid @ DigitalWellness.directory

Feb 26, 2021

Amazing new updates, this is why we recommend only SiteGround to all our clients!

Reply
author avatar

Lazhar

Feb 26, 2021

Hristo and the team have been doing some amazing work over the last few months with speed optimizations and overall tangible benefits to us, website owners. Thank you all.

Reply
author avatar

Jason B

Feb 26, 2021

Great stuff Siteground. I've been trying to get my sites to 100% page speed and now the move to ultra fast PHP and new mySQL theyvare literally there Consistently 98 99%. What I have noticed however is that both Google and Lighthouse now report unused css process is slowing site speed. When looking into it they are http://siteground . Anyideas what this might be. They never showed up before migration.

Reply
author avatar

Hristo Pandjarov Siteground Team

Mar 01, 2021

Our migrations does not affect your code or the CSS generated. Usually, that happens when you combine your CSS files - it saves requests but there's unused css on some pages.

Reply
author avatar

RSA

Feb 26, 2021

Thank you for your hard work on this! I've found that our "front end" loading speeds are very good for our WP Woocommerce site. The challenge has been slow, sometimes very slow response and MySQL database errors on the admin side due to timeouts. I've noted posts on WP and other forums complaining about this with SG hosting. Hopefully this will help address those issues. Thanks again!

Reply
author avatar

Hristo Pandjarov Siteground Team

Mar 01, 2021

The thing is that the latest WooCommerce versions are very heavy on the admin backend. In particular the very slow analytics screen they have added. You should check the "Remove WooCommerce Bloat" plugin and give it a try. It removes that page and the tons of queries it generates.

Reply
author avatar

Mike

Feb 26, 2021

Is there any risk of some sites not working correctly with this update? Is there a way to test this change before we receive it? Thanks

Reply
author avatar

Hristo Pandjarov Siteground Team

Mar 01, 2021

The update is mostly "under the hood" and it won't affect the queries result but rather their performance. We don't expect any problems at all, most probably, your site is already updated :)

Reply
author avatar

Allen Hicks

Mar 01, 2021

How does the new Google Cloud setup require a CDN?

Reply
author avatar

Hristo Pandjarov Siteground Team

Mar 01, 2021

Whether you need a CDN or not depends on your particular website and the audience you're after. Most sites don't since they target the same continent they are hosted in.

Reply
author avatar

Chris

Mar 03, 2021

Hi Hristo, I have a Cloud Server. How can I check if my site is running the new MySQL setup? Thanks,

Reply
author avatar

Hristo Pandjarov Siteground Team

Mar 04, 2021

We're progressing with the update, I expect that by the end of next week we will update all Cloud servers but I can't give you exact date for your particular account.

Reply
author avatar

Chris

Mar 04, 2021

Will there ab an annoucement somewhere?

Reply
author avatar

Hristo Pandjarov Siteground Team

Mar 08, 2021

We don't plan on sending mass mails or another blog post for this. I believe today or tomorrow we will have all Clouds updated :)

Reply
author avatar

Georgia

Mar 13, 2021

How does this impact people using CloudFlare?

Reply
author avatar

Hristo Pandjarov Siteground Team

Mar 15, 2021

It doesn't really matter if you're using Cloudflare or not, the requests to your databse will just be served faster :)

Reply
author avatar

Peter James

May 04, 2023

is there a roadmap/planned update for the upgrade to Mysql Ver 8 as needed by the recent update to Moodle? Many thanks

Reply
author avatar

Gabriela Andonova Siteground Team

May 09, 2023

Thank you for your comment, Peter. We appreciate your interest in MySQL 8.0, and we want to assure you that it is on our development roadmap. At this stage, we don't have a specific timeline for when the change will be implemented on our servers. In the meantime, we support Moodle versions up to 4.1, available through our App Installer in Site Tools. Feel free to contact us anytime if you have any further questions.

Reply
author avatar

Maarten

Oct 20, 2023

This week Joomla 5 was released, requiring MySQL 8 for installation. Understandable if its not on top of the development roadmap with mainly WP users @ Siteground, but maybe this is a good reason to move it up?

Reply
author avatar

Gabriela Andonova Siteground Team

Oct 25, 2023

Thanks for the comment, Maarten! We'll definitely consider your suggestion about prioritizing MySQL 8 in our development roadmap. We appreciate your feedback and your patience as we continue to improve our services for all users, including those using Joomla.

Reply
author avatar

Yosh

Oct 23, 2023

We need MySQL 8.0 asap. Until then we can't upgrade our Joomla sites to Joomla 5.x. What's taking you so long?

Reply
author avatar

Gabriela Andonova Siteground Team

Oct 31, 2023

Hello, Yosh. We understand your anticipation of the MySQL 8.0 upgrade. While we can't provide a specific timeline at the moment, we want to assure you that it is on our to-do list. In the meantime, we're committed to ensuring the security and optimization of our current MySQL setup. We'll update you on any developments via our blog. (As an interim solution, you might consider switching from MySQL to PostgreSQL, which will enable you to successfully upgrade to version 5.x). Our support team is available 24/7 for any further questions you may have.

Reply
author avatar

Jeremy

Jan 03, 2024

The PostgreSQL does NOT work. Joomla 5 requirement is PostgreSQL 12 while SiteGround server only offer version 10.21 We need MySql 8.0.13 or MariaDB 10.4.0 or PostgreSQL 12 ASAP. You guys were once early adopters and cutting edge technology but are falling behind... I can't believe I'd have to switch to GoDaddy to run a Joomla 5 website...

Reply
author avatar

Ivan Naidenov Siteground Team

Jan 11, 2024

Hello Jeremy, thank you for commenting! We have servers running PostgreSQL version 14+ and it is possible to configure Joomla 5 to run there. For more info, please reach us from the Help Center so we can find your account and take it from there: https://stgrnd.co/contactus/ . We also want to emphasize our existing MySQL setup is heavily customized for up to a 20 times reduction in slow queries compared to the standard MySQL setup. That means enhanced performance out of the box. Part of our upgrade process to MySQL 8.0 includes preserving the enhancements done on the old MySQL version and making them available on the new one as well. Precisely because we want to bring the best technology to our clients.

Reply
author avatar

Yosh

Jan 10, 2024

Although Joomla core supports PostgreSQL, many 3rd party components don't...

Reply
author avatar

Ivan Naidenov Siteground Team

Jan 16, 2024

That's one of the reasons we've already committed resources towards the upgrade to MySQL 8. Still, technical time is required to do the upgrade properly. We need to avoid compatibility issues across the many sites we host and we also need to transfer all of the custom security and performance enhancements implemented by our team on MySQL 5 to MySQL 8. The goal is, as always, to offer our clients a stable and fast platform for their projects. We'll keep you posted!

Reply
author avatar

Dave

Dec 04, 2023

I was wondering if there was any update on MySQL 8.0? I appreciate timelines can't be given, but do we have a rough time frame such as 'first quarter 2024' or end of 2024'?

Reply
author avatar

Ivan Naidenov Siteground Team

Dec 19, 2023

Hello Dave! Thank you for the question. We'll notify our customers when the new MySQL version is available on our servers. Our team is already working towards upgrading the existing MySQL setup. We're extensively testing the new MySQL version under a wide range of conditions with the end goal of seamless transition and integration across all of our servers. As things are very dynamic, we're not able to provide a time frame as we don't want to mislead you. We appreciate your understanding!

Reply
author avatar

John

Dec 28, 2023

Well, just to add my voice to the throng: I can't upgrade Moodle until I have MySQL version 8.

Reply
author avatar

Ivan Naidenov Siteground Team

Dec 29, 2023

Hello John. Thank you for commenting! Most likely you've seen the other comments but just to be sure - our team is already taking steps toward upgrading the MySQL setup. We're doing extensive tests and preparations to ensure migrating all of our customers will be a seamless transition, no matter what CMS they are using as an example. To clarify - if you'd like to upgrade Moodle, you can utilize PostgreSQL on SiteGround. Reach us from the Help Center so we can help further if you'd like to go with that option.

Reply
author avatar

Steve

Jan 09, 2024

I am not understanding the time it is taking to update the MYSQL to V8? You mention the development team is working on it, that is more than 10 months ago, MYSQL 8.0 was released in 2018. One would hope we would be ahead of the curve not falling way, way behind.

Reply
author avatar

Ivan Naidenov Siteground Team

Jan 11, 2024

Hello Steve! Thank you for the question, we can see why this is a pressing issue. After reviewing the associated SiteGround account, we're happy to note that our colleague assisted by clarifying the MySQL upgrade questions over the recent chat. In short - our team is in the process of upgrading the MySQL version, still, we have two major tasks to address. Ensuring the transition goes as smoothly as possible for the diverse range of websites we host is one, we want stability for our clients. Another major point we're addressing as we're writing this comment - the current MySQL setup is custom-modded by us to supply lots of reduction in the slow DB queries compared to a normal MySQL setup as one example. We're working on transferring those enhancements to MySQL ver 8.0 as we're always in pursuit of delivering the best performance to our clients.

Reply
author avatar

Steve

Jan 11, 2024

For sure I had the initial contact, but as mentioned there is no date of completion and this is the only place where we can get and share information with the community for ideas and to track to the progress (unless you have a link to a page detailing current status and projections). It was suggested to me that Postgres be installed but that will not suit. I hope you understand the frustration when we are not supplied a roadmap of the work so we have no indication if it will be next week, months or a year away. There are major updates in functionality for both Joomla and Moodle that we need to take advantage of to help our business grow and these cannot be implemented until the new version is in place. We cannot plan our future business models until the updates are in place.

Reply
author avatar

Ivan Naidenov Siteground Team

Jan 16, 2024

Hello Steve. We appreciate the additional info, you're rasing good points. We know that many of the sites we host are business related and that's one of the big reasons to approach the upgrade from MySQL 5 to MySQL 8 with utmost care. The goal is to plan carefully and ensure that the big number of sites we're hosting right now won't be negatively impacted. Another task our team faces is to port all of the security and performance enhancements from ver 5 to ver 8 as they are important. Although we can't supply a specific roadmap as things are highly dynamic, we can say that we're moving towards MySQL 8 as we speak and we'll keep you posted.

Reply
author avatar

Miro

Feb 07, 2024

Any news regarding upgrade to Mysql8? We really need to upgrade Moodle on several accounts. It was the summer 2023 when I asked the first time... Please be more precise

Reply
author avatar

Ivan Naidenov Siteground Team

Feb 08, 2024

Hey, Miro, thank you for your question. We are aware of the importance of MySQL 8 for some of our users, especially with the release of applications like Joomla 5 and Moodle 4.3 that require it. We are working on the update as we're writing this. The thing is - the MySQL setup we're using is heavily customized by our team to enhance its security and performance when compared to the vanilla MySQL. We want our clients to benefit from those mods and that means we have to export them to the newer MySQL 8 which takes time to do properly. We'll keep you informed about the progress via our usual outlets - email, blog, social media. You can read the other comments here for additional details.

Reply
author avatar

Malcolm

Feb 28, 2024

Mysql8...??? All of us on Joomla are stuck and not able to move to Joomla 5. Any update on when this will be available?

Reply
author avatar

Lina Asenova Siteground Team

Feb 29, 2024

Hey there, Malcolm, The SiteGround Team here. We are currently in the process of upgrading our servers to MySQL 8. The upgrade will be gradually rolled out to all our users. While we currently cannot provide an exact timeline for when your account will receive it, rest assured that we will notify each client specifically via email about any upcoming changes. In the meantime, if you have any other questions or require assistance, don’t hesitate to reach out directly. We are here to help.

Reply

Start discussion

Related Posts