MySQL & Load Stats
What kind of info is available in the MySQL & Load Stats section? How could you make use of it?
The CPU load depends on the length of time a hosting server spends executing a script when a visitor opens a webpage on a given script-driven site. Static HTML sites use hardly any CPU time, but this is not the case with the far more complex and functional scripts, that use a database and display dynamic content. The more individuals open this type of an Internet site, the more load will be generated on the server and if the database is large, the MySQL server shall be loaded too. A good example of what could cause high load is an Internet store with a large number of products. If it is popular, a lot of people shall be browsing it concurrently and if they seek out items, the whole database which contains all the products will also be frequently accessed by the script, resulting in high load. In this light, having CPU and MySQL load data will give you an idea of how the Internet site is doing, if it needs to be optimized or if you simply need a more efficient web hosting solution - if the site is really popular and the current setup cannot handle the load.
-
MySQL & Load Stats in Cloud Website Hosting
Using the Hepsia CP, included with all our
cloud website hosting packages, you'll be able to see really detailed statistics regarding the resources which your sites use. One of the sections will give you details about the CPU load, like the amount of processing time the hosting server spent, the amount of time it took for your scripts to be executed and the amount of memory they used. Stats are automatically created every six hours and you can also see the kinds of processes that produced the most load - PHP, Perl, and so on. MySQL load statistics are listed in a different section where you can see all the queries on a per hour, day-to-day, etc. basis. You could go back and compare stats from different months to see if some update has altered the resource usage if the amount of website visitors hasn't changed much. In this way, you can determine if your site needs to be optimized, which will give you a better general performance and an improved user experience.
-
MySQL & Load Stats in Semi-dedicated Hosting
Because our system keeps in depth stats for the load which every
semi-dedicated server account generates, you will be aware of how your websites perform at any time. Once you log in to the Hepsia CP, provided with every account, you can check out the section committed to the system load. There, you are able to see the processing time our system spent on your scripts, the amount of time it took for the scripts to be actually executed and what types of processes created the load - cron jobs, PHP pages, Perl scripts, etc. You can also see the total number of queries to every database within your semi-dedicated account, the total day-to-day statistics for the account overall, plus the average hourly rate. With both the CPU and the MySQL load data, you may always go back to past days or months and examine the overall performance of your sites after some update or after a substantial rise in the number of your visitors.