MySQL & Load Stats
What sort of information is accessible in the MySQL & Load Stats section? How can you take full advantage of it?
The CPU load depends on the length of time a web server spends executing a script whenever a visitor opens a page on a specific script-driven site. Static HTML websites use hardly any CPU time, but this is not the situation with the significantly more advanced and functional scripts, that use a database and display dynamic content. The more people open this sort of an Internet site, the more load shall be produced on the server and if the database is big, the MySQL server shall be loaded also. A good example of what could cause high load is a web-based store with thousands of products. If it is popular, plenty of people shall be browsing it at the same time and if they search for items, the whole database that contains all of the products will also be frequently accessed by the script, which will result in high load. In this light, having CPU and MySQL load stats will offer you an idea of how the Internet site is doing, if it needs to be optimized or if you just need a more efficient hosting solution - if the Internet site is extremely popular and the current setup can't deal with the load.
-
MySQL & Load Stats in Cloud Website Hosting
Using the Hepsia CP, which comes with all of our
cloud website hosting plans, you will be able to see very detailed data concerning the system resources that your websites use. One of the sections shall give you details about the CPU load, including how much processing time the server spent, the length of time it took for your scripts to be executed and what amount of memory they used. Statistics are consistently provided every 6 hours and you may also see the different kinds of processes that produced the most load - PHP, Perl, and so on. MySQL load statistics are listed within a separate section where you are able to see all the queries on an hourly, everyday, etcetera. basis. You could go back and compare statistics from various months to find out whether some update has changed the resource usage if the total amount of site visitors has not changed much. Thus, you can see if your website needs to be optimized, which will contribute to a better functionality and an improved user experience.
-
MySQL & Load Stats in Semi-dedicated Servers
Our system generates thorough statistics about the two different types of load, so if you buy a
semi-dedicated server for your sites, you can access the data with just a couple of clicks in your Hepsia hosting Control Panel. Each kind of data is listed in its own section. The CPU Load section will tell you which processes produced the load and the span of time it took for the server to execute all the requests. Though statistics are created every six hours, you can see day by day and month-to-month statistics also. In the MySQL Load section you shall find a list of all the databases created within your semi-dedicated account manually and automatically, the amount of queries were sent to every one of them, the total day-to-day queries for the account as a whole, along with the average hourly rate. This info shall help you determine how well your Internet sites perform and if any one of them requires optimization of some type.