Siteground: Greatly reduce the number of queries by optimizing the database

Siteground's optimized database solution can effectively optimize the number of database queries. After actual testing and use, it was found that the number of MySQL slow queries was reduced by 10 to 20 times. After the SiteGround virtual host supports Brotli compression and Siteground enables Ultrafast PHP and other speed-up operations, Siteground optimizes the new settings of the database, which greatly reduces the number of database queries. Two common causes of slow websites are unoptimized PHP code and too many MySQL queries. The key to improving website speed is to continuously optimize the website code and reduce the number of database queries. The current SiteGround hosting autumn promotion has started, the original price of the StartUp plan is US$14.99, the current price is only US$3.99

SiteGround official website

What is MySQL slow query?

When a visitor enters the website, any website that uses a database will have a large number of PHP codes running, and some of the PHP codes will query the database for information. This is when problems arise. For example, in an online e-commerce website, a visitor is trying to purchase a product, and the website program will check the remaining product quantity in the database and display on the front end whether it can be ordered. This back and forth visit will trigger multiple MySQL queries. Depending on how PHP code is written, the process of processing queries by the server may be very cumbersome and time-consuming. As a webmaster, when visitors have to wait more than 2-3 seconds for a page to load, you are likely to lose customers.

What has Siteground done to reduce the number of database queries?

Siteground launches a new MySQL setup on the server, taking an innovative approach to arranging server memory and allocating it to the MySQL database. The new settings allow a larger number of parallel requests to be processed simultaneously, which can improve the performance of processing MySQL queries. After starting the new MySQL setup, and after long-term monitoring of the server load, the number of slow queries in the database dropped by 10 to 20 times!

Siteground's latest service improvements (such as Ultrafast PHP and now MySQL settings) can be attributed to: the migration to Google Cloud Platform (Google Cloud) and the switch from cPanel to Site Tools (backend control panel). After migrating to Google Cloud, Siteground upgraded its server configuration and added memory to distribute more resources among different machines.

1. Foreign trade, B2C/C2C and other websites are recommended to register domain names abroad. Open the namesilo official website, enter it in the search box and select it before registering. Remember to use the discount code to save money. To obtain the discount code, click on the domain name registration tutorial of Namesilo, a foreign domain name provider.

2. Foreign trade website Lao Yang recommends choosing siteground virtual host. Siteground virtual host is the officially recommended host by WordPress and is an excellent match with WordPress. The WordPress website speed and stability on Siteground virtual host are very good, and the evaluation of the test website abroad is very high. 23% off Starup $3.99/month growbig $6.69/month

3. About Siteground website building: siteground topic

Who can enjoy the Siteground optimized database?

Every website hosted on Siteground hosting can take advantage of the new MySQL settings, and if you notice performance improvements on your site, that's why.

Through continuous innovation in technology, including the Siteground optimized database mentioned in this article, we provide users with fewer slow database queries, faster servers and faster website access speeds.

Recommended site search: pw domain name, independent ip space, wordpress space, free virtual host application, windows host, apply for free space and domain name, proxy ip address, US php space, php space application, 1g US virtual host,