MySQL & Load Stats
What type of data is accessible in the MySQL & Load Stats section? How can you take advantage of it?
The CPU load is dependent upon the amount of time a server spends executing a script each time a visitor opens a page on a specific script-driven site. Static HTML Internet sites use barely any CPU time, but it is not the situation with the considerably more advanced and functional scripts, which use a database and display dynamic content. The more people open this type of a site, the more load shall be produced on the hosting server and if the database is big, the MySQL server shall be loaded too. An illustration of what could cause high load is an online store with thousands of products. If it is popular, a lot of people will be visiting it at the same time and if they seek out items, the whole database containing all of the products shall also be frequently accessed by the script, which will result in high load. In this light, having CPU and MySQL load data will give you an idea of how the website is doing, if it needs to be optimized or if you simply need a more effective website hosting solution - if the site is very popular and the existing setup cannot cope with the load.
MySQL & Load Stats in Shared Hosting
Using the Hepsia Control Panel, bundled with all our shared hosting
packages, you shall be able to to see rather detailed statistics about the resources which your Internet sites use. One of the sections will give you info on the CPU load, such as the amount of processing time the server spent, the span of time it took for your scripts to be executed and the amount of memory they used. Stats are consistently produced every 6 hours and you may also see the types of processes that produced the most load - PHP, Perl, and so forth. MySQL load statistics are listed in a separate section where you could see all the queries on a per hour, day-to-day, etc. basis. You'll be able to go back and compare statistics from different months to determine if some update has altered the resource usage if the total amount of visitors has not changed much. This way, you will see if your site needs to be optimized, that'll result in a better overall performance and an improved user experience.
MySQL & Load Stats in Semi-dedicated Servers
Due to the fact that our system keeps detailed stats for the load which each semi-dedicated server
account produces, you will be aware of how your websites perform at any time. Once you log in to the Hepsia CP, included with each and every account, you can check out the section devoted to the system load. In it, you are able to see the processing time our system spent on your scripts, how much 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. Also you can see the number of queries to every database within your semi-dedicated account, the total daily figures for the account in general, along with the average hourly rate. With both the CPU and the MySQL load statistics, you could always go back to past days or months and examine the general performance of your Internet sites after some update or after a sizeable boost in the number of your website visitors.