MySQL & Load Stats
What sort of information is provided in the MySQL & Load Stats section? How could you take full advantage of it?
The CPU load is dependent upon the length of time a web server spends executing a script when a visitor opens a page on a particular script-driven website. Static HTML sites use hardly any CPU time, but this is not the situation with the far more complex and functional scripts, which use a database and display dynamic content. The more customers open such a website, the more load shall be generated on the server and if the database is big, the MySQL server will be loaded as well. A good example of what could cause high load is an online store with tens of thousands of products. If it's popular, a lot of people will be exploring it at the same time and if they seek out items, the whole database which contains all 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 can provide an idea of how the Internet site is doing, if it needs to be optimized or if you simply just need a more efficient hosting solution - if the site is really popular and the current setup can't deal with the load.
-
MySQL & Load Stats in Shared Website Hosting
Using the Hepsia Control Panel, included with all of our
shared website hosting plans, you will be able to see rather detailed data about the system resources that your websites use. One of the sections will give you information about the CPU load, like how much processing time the hosting server spent, the length of time it took for your scripts to be executed and how much memory they used. Statistics are consistently generated every six hours and you could also see the types of processes that generated the most load - PHP, Perl, etc. MySQL load data are listed in a different section where you are able to see all the queries on a per hour, daily, and so forth. basis. You could go back and compare stats from different months to find out if some update has altered the resource usage if the number of website visitors has not changed much. That way, you can see if your site needs to be optimized, that will contribute to a better general performance and an improved user experience.
-
MySQL & Load Stats in Semi-dedicated Servers
If you have a
semi-dedicated server account with us, you will be able to access rather comprehensive CPU and MySQL load stats that'll give you addiitional information about the efficiency of your Internet sites. 2 sections of the Hepsia CP are focused on the statistics, one for each and every kind. Inside the CPU Load section you are able to see the execution time of your scripts and the amount of time the hosting server processed them. Additionally you can see the kinds of processes which were executed. Stats are produced every six hours, but if needed, you can also check figures for previous days or months. The MySQL Load section shall show you the entire number of database queries each day and each hour, as well as the queries to each individual database you have in your semi-dedicated account. Comparing this data to your traffic stats will give you valuable information about how your sites perform and you shall see if you need to take some measures to optimize them.