MySQL & Load Stats
Discover what sort of information is gathered in the MySQL & Load Stats area and just how you'll be able to reap the benefits of it.
The CPU load depends on the amount of time a server spends executing a script when a visitor opens a page on a particular script-driven site. Static HTML sites use hardly any CPU time, but this isn't the case with the considerably more complex and functional scripts, which use a database and display dynamic content. The more individuals open this type of an Internet site, the more load shall be created on the server and if the database is very large, the MySQL server will be loaded as well. An illustration of what can cause high load is an online store with tens of thousands of products. If it's popular, plenty of people will be visiting it all at once and if they seek out items, the whole database which contains all of the products will also be constantly accessed by the script, which will result in high load. In this light, having CPU and MySQL load data will give you an idea of how the website is doing, if it needs to be optimized or if you just need a more powerful web hosting solution - if the website is really popular and the existing setup can't cope with the load.
-
MySQL & Load Stats in Web Hosting
Using the Hepsia Control Panel, included with all of our
web hosting packages, you'll be able to see incredibly detailed data about the system resources which your websites use. One of the sections will give you details about the CPU load, including how much processing time the web server spent, the time it took for your scripts to be executed and how much memory they used. Statistics are routinely created every six hours and you can also see the types of processes that produced the most load - PHP, Perl, etc. MySQL load stats are listed inside an individual section where you can see all the queries on an hourly, day-to-day, etc. basis. You can go back and compare statistics from various 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 can determine if your Internet site needs to be optimized, that will result in a better performance and an improved user experience.