MySQL & Load Stats
Discover the type of information is gathered in the MySQL & Load Stats section and exactly how it is possible to take full advantage of it.
If you have an HTML Internet site, most likely it uses a small amount of resources because it is static, but this is not so with dynamic database-driven Internet sites that use PHP scripts and provide way more functions. Such websites create load on the website 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, for example, stores all usernames and posts within a database, so some load is generated every single time a thread is opened or an end user looks for a particular name. If a lot of people access the forum at the same time, or if each search involves checking tens of thousands of database entries, this may generate high load and affect the overall performance of the site. In this regard, CPU and MySQL load stats can provide you with information about the site’s functionality, as you can compare the numbers with your traffic statistics to determine if the site should be optimized or transferred to a new type of hosting platform that'll be able to bear the high system load in case the Internet site is extremely popular.
-
MySQL & Load Stats in Shared Website Hosting
Using the Hepsia CP, provided with all our
shared website hosting packages, you shall be able to to see rather detailed data concerning the system resources which your sites use. One of the sections shall give you information about the CPU load, such as the amount of processing time the hosting server spent, the time it took for your scripts to be executed and exactly how much memory they used. Statistics are automatically created every six hours and you can also see the different kinds of processes that generated the most load - PHP, Perl, and so on. MySQL load stats are listed in a different section in which you could see all the queries on a per hour, everyday, and so on. basis. You could go back and compare statistics from various months to find out whether some update has transformed the resource usage if the amount of visitors has not changed much. Thus, you can see if your Internet site needs to be optimized, which will result in a better overall performance and an improved user experience.
-
MySQL & Load Stats in Semi-dedicated Hosting
Since our system keeps comprehensive statistics for the load which each
semi-dedicated server account generates, you shall be aware of how your Internet sites perform at any time. Once you log in to the Hepsia CP, included with each account, you can check out the section devoted to the system load. In it, you can 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, and so forth. Also you can see the amount of queries to each and every database in your semi-dedicated account, the total everyday figures 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 examine the general performance of your sites after some update or after a sizeable boost in the number of your site visitors.