MySQL & Load Stats
Discover what sort of data is gathered in the MySQL & Load Stats area and in what ways you'll be able to take advantage of it.
The CPU load depends on the time a web server spends executing a script any time a visitor opens a webpage on a specific script-driven site. Static HTML websites use hardly any CPU time, but it's not the situation with the far more sophisticated and functional scripts, which use a database and display dynamic content. The more people open this type of a website, the more load will be generated on the web server and if the database is big, the MySQL server shall be loaded also. An example of what can cause high load is an online store with tens of thousands of products. If it is popular, many people will be visiting it simultaneously and if they search for items, the entire database containing all the products will also be frequently accessed by the script, resulting in high load. In this light, having CPU and MySQL load statistics will provide you with an idea of how the Internet site is doing, if it needs to be optimized or if you simply just need a more powerful web hosting solution - if the website is really popular and the existing setup cannot cope with the load.
MySQL & Load Stats in Hosting
Using the Hepsia Control Panel, bundled with all of our hosting
offers, you will be able to see rather detailed statistics regarding the resources that your Internet sites use. One of the sections shall give you info on the CPU load, such as how much processing time the server spent, the amount 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 can also see the different types of processes that generated the most load - PHP, Perl, and so on. MySQL load data are listed within an individual section in which you could see all the queries on an hourly, daily, etc. basis. You'll be able to go back and compare statistics from various months to find out if some update has changed the resource usage if the amount of visitors hasn't changed much. Thus, you will see if your website needs to be optimized, that'll give you a better overall performance and an improved user experience.
MySQL & Load Stats in Semi-dedicated Hosting
If you have a semi-dedicated server
account with us, you will be able to access rather comprehensive CPU and MySQL load stats that will give you addiitional information about the functionality of your websites. Two sections of the Hepsia CP are focused on the stats, one for every kind. In the CPU Load section you could see the execution time of your scripts and the length of time the web server processed them. You can even see the different types of processes that were executed. Statistics are produced every six hours, but if required, you can also check data for previous days or months. The MySQL Load section will show you the whole amount of database queries each and every day and each hour, along with the queries to each individual database which you have within your semi-dedicated account. Comparing this data to your traffic statistics shall give you useful info about how your websites perform and you will see if you must take some measures to boost them.