MySQL & Load Stats
View what sort of info is gathered in the MySQL & Load Stats area and exactly how it is possible to take advantage of it.
When a visitor opens your Internet site, the Internet browser sends a request to the server, which executes it and provides the required data as a response. A standard HTML website uses minimal system resources as it's static, but database-driven platforms are more demanding and use more processing time. Each webpage which is served generates 2 forms of load - CPU load, which depends on the time period the server spends executing a particular script; and MySQL load, which depends on the total number of database queries generated by the script while the end user browses the Internet site. Bigger load will be created if a lot of people browse a certain Internet site simultaneously or if numerous database calls are made all at once. 2 illustrations are a discussion board with thousands of users or an online store in which a visitor enters a term within a search box and tens of thousands of items are searched. Having in depth stats about the load which your website generates will allow you to optimize the content or see if it is the perfect time to switch to a more powerful sort of website hosting service, if the Internet site is simply getting really popular.
-
MySQL & Load Stats in Shared Hosting
Using the Hepsia Control Panel, included with all our
shared hosting plans, you shall be able to to see rather comprehensive data regarding the resources that your sites use. One of the sections will give you details about the CPU load, like how much processing time the server spent, the length of time it took for your scripts to be executed and the amount of memory they used. Stats are routinely generated every six hours and you may also see the kinds of processes that produced the most load - PHP, Perl, and so on. MySQL load stats are listed inside an individual section where you'll be able to see all the queries on a per hour, daily, and so on. basis. You can go back and compare data from different months to find out whether some update has changed the resource usage if the total amount of visitors has not changed much. That way, you will see if your Internet site needs to be optimized, that will lead to a better overall performance and an improved user experience.
-
MySQL & Load Stats in Semi-dedicated Servers
Since our system keeps detailed stats for the load that every
semi-dedicated server account produces, you shall be aware of how your Internet sites perform at any time. After you log in to the Hepsia CP, included with each and every account, you should check out the section devoted to the system load. There, you are able to see the processing time our system spent on your scripts, the time it took for the scripts to be actually executed and what sorts of processes created the load - cron jobs, PHP pages, Perl scripts, and so on. You may also see the amount of queries to every single database within your semi-dedicated account, the total everyday stats for the account overall, as well as the average hourly rate. With both the CPU and the MySQL load data, you can always go back to past days or months and assess the overall performance of your sites after some update or after a significant boost in the number of your visitors.