MySQL & Load Stats
Discover the type of data is gathered in the MySQL & Load Stats section and exactly how it is possible to take advantage of it.
The CPU load depends upon the time period a server spends executing a script each time a visitor opens a webpage on a certain script-driven website. Static HTML websites use barely any CPU time, but this is not the situation with the much more advanced and functional scripts, which use a database and display dynamic content. The more individuals open this sort of an Internet site, the more load shall be generated on the web server and if the database is big, the MySQL server shall be loaded also. An illustration of what could cause high load is a web-based store with tens of thousands of products. If it's popular, plenty of people will be visiting it all at once and if they search for items, the entire database which contains all of the products will also be constantly accessed by the script, resulting in high load. In this light, having CPU and MySQL load stats will provide you with an idea of how the Internet site is doing, if it needs to be optimized or if you just need a more efficient hosting solution - if the site is very popular and the current setup can't handle the load.
-
MySQL & Load Stats in Cloud Hosting
Using the Hepsia CP, included with all of our
cloud hosting packages, you shall be able to to see incredibly detailed data about the system resources which your sites use. One of the sections shall give you information regarding 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 exactly how much memory they used. Stats are automatically created every 6 hours and you can also see the different kinds of processes that produced the most load - PHP, Perl, etc. MySQL load stats are listed in a separate section in which you can see all the queries on a per hour, day-to-day, and so forth. basis. You can go back and compare stats from different months to find out if some update has changed the resource usage if the total amount of website visitors hasn't changed much. This way, you will see if your website needs to be optimized, which will result in a better performance and an improved user experience.