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.

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.

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 on cPanel? We expect to migrate everyone by the end of March so all you need to do is wait just a little bit longer.

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!

Comments ( 21 )

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

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

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

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

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

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

Simon Womersley

Feb 03, 2021

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

Reply

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

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

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

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

Sid @ DigitalWellness.directory

Feb 26, 2021

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

Reply

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

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

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

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

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

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

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

Allen Hicks

Mar 01, 2021

How does the new Google Cloud setup require a CDN?

Reply

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

Start discussion

Ready to get your website started?

Choose a hosting plan, start or migrate your site in a few clicks, and grow your online presence!

Get Started Chat with an expert