If you manage a live website with a database, you probably What are slow MySQL understand that when. A visitor enters your site, tons of scripts start running, some of which request information from your database. For example, if you have an online store. And a visitor tries to purchase an item, your store needs to check its. Availability in the database and display if it is orderable.
This check triggers a MySQL query. And depending uk phone number library on how this query is written, it can be quite heavy and take. A long time for the server to process. For you as a webmaster, these slow queries are a problem because you will lose customers. As you know, visitors leave the site when they have to wait more than 2 to 3 seconds for a page to load.
What have we done? What are slow MySQL
The battle against slow MySQL queries is an ongoing process that involves both the webmaster and the hosting provider. That’s why we recently launched a new MySQL configuration on our servers. Which takes an innovative approach to distributing server RAM and allocating it to MySQL.
The new configuration allows for a much higher number of parallel queries to be processed simultaneously, which has a significant impact on efficiently handling heavy MySQL queries. So great that system administrators, observing the server load after launching the new MySQL configuration, still can’t believe it—they’ve seen a 10-20x decrease in slow queries!
All of our latest paid media: what it is main channels and how to invest service improvements, such as ultra-fast PHP and now MySQL configuration, are made possible by two tools: Google Cloud Platform and the move from cPanel to Site Tools. Since moving to Google Cloud, we’ve upgraded our server configurations with more RAM.
The unit price of RAM isn’t any cheaper, but working in the cloud offers opportunities for better distribution of this resource between different machines. And the fact that we’re not bound by the software resource requirements of third parties such as cPanel gives us more freedom to innovate. Our DevOps feel empowered to create and continue developing smart technologies that benefit the vast majority of the sites we host!
Who can access it?
All users hosted on our shared and cloud servers europe email have already received the new MySQL configuration! If you’ve noticed improved performance over the past week, it’s thanks to the new configuration.
This means we’re less likely to ask you to fix a slow query and “social distance” your site because of it. Fewer slow queries, faster servers, less hassle for you!