MySQL & Load Stats
What kind of information is provided in the MySQL & Load Stats section? How do you take full advantage of it?
The CPU load depends upon the length of time a web server spends executing a script whenever a visitor opens a webpage on a specific script-driven website. Static HTML websites use barely any CPU time, but it is not so with the far more complex and functional scripts, which use a database and display dynamic content. The more individuals open this sort of a website, the more load shall be produced on the hosting server and if the database is large, the MySQL server will be loaded too. A good example of what can cause high load is a web-based store with a large number of products. If it's popular, plenty of people shall be browsing it concurrently and if they look for items, the entire database which contains all of the products shall also be continuously 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 site is doing, if it has to be optimized or if you simply need a more potent hosting solution - if the website is very popular and the established setup can't deal with the load.
MySQL & Load Stats in Website Hosting
Using the Hepsia Control Panel, provided with all our website hosting
offers, you will be able to see very comprehensive stats regarding the resources that your sites use. One of the sections will give you information about the CPU load, such as the amount of processing time the server spent, the amount of time it took for your scripts to be executed and what amount of memory they used. Stats are automatically generated every 6 hours and you may also see the kinds of processes that produced the most load - PHP, Perl, and so forth. MySQL load stats are listed in an individual section in which you could see all the queries on an hourly, daily, etc. basis. You can go back and compare stats from different months to see if some update has transformed the resource usage if the amount of site visitors hasn't changed much. Thus, you can determine if your site needs to be optimized, that will give you a better performance and an improved user experience.
MySQL & Load Stats in Semi-dedicated Servers
As our system keeps thorough statistics for the load that every semi-dedicated server
account generates, you will be aware of how your sites perform at any time. As soon as you log in to the Hepsia CP, which comes with each account, you can check out the section committed to the system load. In it, you are able to see the processing time our system spent on your scripts, the span of time it took for the scripts to be actually executed and what types of processes generated the load - cron jobs, PHP pages, Perl scripts, etcetera. Also you can see the number of queries to every single database within your semi-dedicated account, the total daily numbers for the account overall, as well as the average hourly rate. With both the CPU and the MySQL load data, you could always go back to past days or months and assess the general performance of your Internet sites after some update or after a significant boost in the number of your website visitors.