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.
Comments ( 30 )
Thanks! Your comment will be held for moderation and will be shortly published, if it is related to this blog article. Comments for support inquiries or issues will not be published, if you have such please report it through
Janine Rauwenhoff
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
Hristo Pandjarov Siteground Team
It is available on Site Tools, once your account is migrated you will automatically start using it. We should complete migrations by March.
Brian
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.
Hristo Pandjarov Siteground Team
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...
Mark
Good answer!
Simon Womersley
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?
Hristo Pandjarov Siteground Team
Thanks for the kind words :) It doesn't matter where your domain is registered, it won't affect your loading speeds.
Simon Womersley
Thanks for getting back to me. I'll tick that off the list and investigate some more.
Josh
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!
Hristo Pandjarov Siteground Team
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.
Jean-S.
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.
Hristo Pandjarov Siteground Team
The new MySQL setup is probably not yet applied on your Cloud account since it rolls out after the resources increase.
Sid @ DigitalWellness.directory
Amazing new updates, this is why we recommend only SiteGround to all our clients!
Lazhar
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.
Jason B
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.
Hristo Pandjarov Siteground Team
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.
RSA
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!
Hristo Pandjarov Siteground Team
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.
Mike
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
Hristo Pandjarov Siteground Team
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 :)
Allen Hicks
How does the new Google Cloud setup require a CDN?
Hristo Pandjarov Siteground Team
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.
Chris
Hi Hristo, I have a Cloud Server. How can I check if my site is running the new MySQL setup? Thanks,
Hristo Pandjarov Siteground Team
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.
Chris
Will there ab an annoucement somewhere?
Hristo Pandjarov Siteground Team
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 :)
Georgia
How does this impact people using CloudFlare?
Hristo Pandjarov Siteground Team
It doesn't really matter if you're using Cloudflare or not, the requests to your databse will just be served faster :)
Peter James
is there a roadmap/planned update for the upgrade to Mysql Ver 8 as needed by the recent update to Moodle? Many thanks
Gabriela Andonova Siteground Team
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.
Start discussion
Thanks! Your comment will be held for moderation and will be shortly published, if it is related to this blog article. Comments for support inquiries or issues will not be published, if you have such please report it through