MySQL & Load Stats

What kind of information is available in the MySQL & Load Stats section? How could you take full advantage of it?

The CPU load is dependent upon the time period a hosting server spends executing a script every time a visitor opens a webpage on a specific script-driven website. Static HTML websites use barely any CPU time, but this isn't the situation with the much more sophisticated and functional scripts, which use a database and display dynamic content. The more individuals open this kind of an Internet site, the more load shall be generated on the web server and if the database is big, the MySQL server will be loaded also. An example of what can cause high load is an online store with a large number of products. If it's popular, a lot of people will be visiting it concurrently and if they search for items, the entire database containing all of the products shall also be constantly accessed by the script, resulting 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 web hosting solution - if the website is extremely popular and the existing setup can't cope with the load.

: MySQL & Load Stats in Shared Hosting

Using the Hepsia Control Panel, provided with all of our shared hosting plans, you shall be able to to see rather comprehensive stats about the resources which your Internet sites use. One of the sections will give you details about the CPU load, like the amount of processing time the web server spent, the length of time it took for your scripts to be executed and the amount of memory they used. Stats are automatically provided every six hours and you may also see the different kinds of processes that generated the most load - PHP, Perl, etc. MySQL load stats are listed in a separate section in which you can see all the queries on a per hour, day-to-day, etc. basis. You can go back and compare data from various months to find out whether some update has transformed the resource usage if the number of site visitors has not changed much. In this way, you can see if your website needs to be optimized, that'll result in a better performance and an improved user experience.; MySQL & Load Stats in Semi-dedicated Hosting

Since our system keeps detailed statistics for the load that each semi-dedicated server account produces, you shall be aware of how your sites perform at any time. After you log in to the Hepsia CP, provided with every account, you can check out the section dedicated to the system load. In it, you will see the processing time our system spent on your scripts, the 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. You can also see the number of queries to each database in your semi-dedicated account, the total everyday stats for the account altogether, 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 review the general performance of your Internet sites after some update or after a sizeable rise in the number of your visitors.