MySQL & Load Stats
The MySQL & Load Stats will silently gather data while your web site is running. Discover why it is important to check them out regularly.
The CPU load is dependent upon the time period a server spends executing a script each time a visitor opens a page on a particular script-driven website. Static HTML websites use barely any CPU time, but this is not the case with the much more sophisticated and functional scripts, that use a database and display dynamic content. The more people open this type of an Internet site, the more load shall be generated on the web server and if the database is big, the MySQL server will be loaded also. An example of what may cause high load is an online store with a large number of products. If it is popular, plenty of people will be browsing it simultaneously and if they look for items, the whole database which contains all the products shall also be constantly accessed by the script, resulting in high load. In this light, having CPU and MySQL load statistics will offer you an idea of how the Internet site is doing, if it has to be optimized or if you simply just need a more effective website hosting solution - if the Internet site is really popular and the existing setup cannot deal with the load.
-
MySQL & Load Stats in Hosting
Using the Hepsia CP, which comes with all of our
hosting packages, you shall be able to to see really comprehensive stats about the system resources that your sites use. One of the sections will give you details about the CPU load, like how much processing time the web server spent, the length of time it took for your scripts to be executed and what amount of memory they used. Statistics are consistently generated every six hours and you can also see the kinds of processes that produced the most load - PHP, Perl, and so forth. MySQL load stats are listed in a different section where you can see all the queries on an hourly, everyday, and so forth. basis. You can go back and compare statistics from various months to determine if some update has changed the resource usage if the number of site visitors hasn't changed much. That way, you can determine if your site needs to be optimized, that'll give you a better general performance and an improved user experience.
-
MySQL & Load Stats in Semi-dedicated Servers
If you want to see detailed stats with regards to the load generated by your sites, it won't take more than a few mouse clicks to do this. The Hepsia hosting CP, which comes with all
semi-dedicated servers we offer, features a section devoted to the system resource usage and the info there can tell you if your websites function properly and if the load they create corresponds to the total amount of received visitors. The CPU load stats include the script execution time and the span of time it took for the hosting server to process the requests, as well as what sorts of processes created the load. The MySQL data shall show you the number of times every database was accessed, as well as everyday and per hour statistics for the entire account. With both sorts of statistics, you are able to check the numbers for each of the past days and months, so you could see how the sites perform as the traffic to them increases or after you have applied some update.