MySQL & Load Stats
Discover the kind of info is gathered in the MySQL & Load Stats area and just how you can take advantage of it.
If you have an HTML website, most likely it uses a small amount of resources simply because it's static, but this is not so with dynamic database-driven sites that use PHP scripts and provide a lot more features. This type of websites create load on the website hosting server anytime anyone browses them, due to the fact that the hosting server requires time to execute the script, to access the database and then to deliver the data requested by the visitor's web browser. A well known discussion board, as an illustration, stores all usernames and posts within a database, so some load is created any time a thread is opened or a user searches for a specific word. If many people connect to the forum at the same time, or if each and every search involves checking thousands of database entries, this could produce high load and affect the functionality of the site. In this regard, CPU and MySQL load data can present you with info about the site’s functionality, as you can compare the numbers with your traffic stats to decide if the website should be optimized or moved to another type of hosting platform that will be able to bear the high system load in the event that the site is really popular.
-
MySQL & Load Stats in Cloud Hosting
Using the Hepsia CP, included with all of our
cloud hosting offers, you'll be able to see rather comprehensive stats regarding the resources which your sites use. One of the sections will give you information regarding the CPU load, including how much processing time the server spent, the span of time it took for your scripts to be executed and what amount of memory they used. Stats are consistently produced every six hours and you could also see the kinds of processes that produced the most load - PHP, Perl, etc. MySQL load data are listed inside an individual section in which you can see all the queries on a per hour, day-to-day, etcetera. basis. You'll be able to go back and compare data from different months to see if some update has transformed the resource usage if the total amount of visitors hasn't changed much. Thus, you can determine if your website needs to be optimized, which will contribute to a better overall performance and an improved user experience.
-
MySQL & Load Stats in Semi-dedicated Servers
As our system keeps thorough statistics for the load that every
semi-dedicated server account generates, you'll be aware of how your sites perform at any time. As soon as you log in to the Hepsia CP, supplied with each and every account, you can check out the section committed to the system load. In it, you will see the processing time our system spent on your scripts, how much time it took for the scripts to be actually executed and what sorts of processes generated the load - cron jobs, PHP pages, Perl scripts, and so forth. You could also see the amount of queries to each database within your semi-dedicated account, the total day-to-day stats for the account altogether, plus the average hourly rate. With both the CPU and the MySQL load statistics, you may always go back to past days or months and evaluate the efficiency of your Internet sites after some update or after a major boost in the number of your visitors.