MySQL & Load Stats
What type of information is provided in the MySQL & Load Stats section? How could you take advantage of it?
Each time a visitor opens your Internet site, the Internet browser sends a request to the hosting server, which in turn executes it and provides the desired content as a response. A standard HTML Internet site uses minimum resources as it is static, but database-driven platforms are more demanding and use more processing time. Each and every page that's served generates two sorts of load - CPU load, which depends on the length of time the web server spends executing a particular script; and MySQL load, that depends on the total number of database queries created by the script while the client browses the site. Bigger load will be created if a considerable amount of people browse a certain site at the same time or if a lot of database calls are made at the same time. 2 good examples are a discussion board with tens of thousands of users or an online store in which a visitor enters a term in a search box and a large number of items are searched. Having comprehensive statistics about the load that your website generates can help you boost the content or see if it is time for you to switch to a more powerful kind of web hosting service, if the Internet site is simply getting extremely popular.
MySQL & Load Stats in Cloud Website Hosting
Using the Hepsia Control Panel, bundled with all of our cloud website hosting
offers, you shall be able to to see incredibly comprehensive stats regarding the resources which your websites use. One of the sections will give you info on the CPU load, like how much processing time the hosting server spent, the amount of time it took for your scripts to be executed and what amount of memory they used. Statistics are routinely produced every 6 hours and you may also see the types of processes that produced the most load - PHP, Perl, and so forth. MySQL load statistics are listed in a different section where you'll be able to see all the queries on a per hour, everyday, and so on. basis. You could go back and compare data from various months to see if some update has altered the resource usage if the total amount of site visitors has not changed much. Thus, you will see if your Internet site needs to be optimized, that'll lead to a better general performance and an improved user experience.
MySQL & Load Stats in Semi-dedicated Hosting
Our system creates detailed statistics about both kinds of load, so if you get a semi-dedicated server
for your sites, you can access the information with just a few mouse clicks within your Hepsia hosting CP. Every type of data is listed within its own section. The CPU Load section will tell you what processes generated the load and the length of time it took for the web server to execute each of the requests. Although statistics are produced every 6 hours, you can see day by day and monthly statistics as well. In the MySQL Load section you'll find a list of all the databases produced in your semi-dedicated account manually and automatically, how many queries were sent to each one of them, the total day-to-day queries for the account overall, as well as the average per hour rate. This information shall help you see how well your sites perform and if each of them requires optimization of some kind.