MySQL & Load Stats
The MySQL & Load Stats will quietly gather data while your website is working. See why it's important to check them out frequently.
If you have an HTML Internet site, in all probability it uses a very small amount of system resources due to the fact that it's static, but that isn't so with dynamic database-driven sites that use PHP scripts and offer a lot more capabilities. This type of websites create load on the web hosting server each time someone browses them, since the hosting server requires time to execute the script, to access the database and then to supply the content requested by the visitor's web browser. A well known discussion board, as an illustration, stores all usernames and posts inside a database, so some load is produced any time a thread is opened or an end user searches for a particular term. If a lot of people connect to the forum all at once, or if each search involves checking hundreds of thousands of database entries, this may create high load and affect the overall performance of the site. In this regard, CPU and MySQL load stats can present you with info about the site’s efficiency, as you can compare the numbers with your traffic data to decide if the website needs to be optimized or transferred to a different kind of hosting platform that will be able to bear the high system load in the event that the Internet site is very popular.
MySQL & Load Stats in Web Hosting
Using the Hepsia Control Panel, which comes with all of our web hosting
packages, you shall be able to to see very comprehensive statistics about the resources which your Internet sites use. One of the sections shall give you info on the CPU load, such as how much processing time the hosting server spent, the amount of time it took for your scripts to be executed and what amount of memory they used. Stats are automatically provided every 6 hours and you can also see the types of processes that produced the most load - PHP, Perl, and so on. MySQL load stats are listed within a separate section in which you could see all the queries on an hourly, day-to-day, and so forth. basis. You could go back and compare stats from various months to determine if some update has changed the resource usage if the number of site visitors has not changed much. This way, you will see if your website needs to be optimized, which will lead to a better general performance and an improved user experience.
MySQL & Load Stats in Semi-dedicated Servers
Since our system keeps in depth stats for the load which each semi-dedicated server
account produces, you will be aware of how your sites perform at any time. When you log in to the Hepsia Control Panel, which comes with every single account, you can go to the section dedicated to the system load. There, you are able to see the processing time our system spent on your scripts, the length of time it took for the scripts to be actually executed and what sorts of processes created the load - cron jobs, PHP pages, Perl scripts, etc. Also you can see the amount of queries to each and every database within your semi-dedicated account, the total everyday figures for the account as a whole, 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 functionality of your sites after some update or after a major boost in the number of your visitors.