If you have an HTML website, it probably uses a small amount of resources because it's static, but this is not the case with dynamic database-driven websites that use PHP scripts and offer far more functions. This sort of websites produce load on the website hosting server each time anyone browses them, because the hosting server needs time to execute the script, to access the database and then to provide the info requested by the visitor's Internet browser. A famous discussion board, for instance, stores all usernames and posts inside a database, so some load is created every time a thread is opened or an end user searches for a particular phrase. If a lot of people access the forum all at once, or if every single search involves checking thousands of database entries, this could generate high load and affect the functionality of the website. In this regard, CPU and MySQL load stats can provide data about the site’s performance, as you can compare the numbers with your traffic stats and see if the website must be optimized or migrated to a new sort of hosting platform that will be able to bear the high system load in the event that the Internet site is really popular.

MySQL & Load Stats in Website Hosting

Using the Hepsia CP, which comes with all our website hosting offers, you shall be able to to see rather comprehensive stats concerning the resources your Internet sites use. One of the sections will give you info on the CPU load, such as the amount of 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 automatically provided 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 in an individual section in which you can see all the queries on an hourly, everyday, etc. basis. You can go back and compare data from various months to find out if some update has altered the resource usage if the amount of site visitors has not changed much. Thus, you can see if your site needs to be optimized, that will contribute to a better performance and an improved user experience.

MySQL & Load Stats in Semi-dedicated Hosting

If you have a semi-dedicated server account with our company, you will be able to access rather detailed CPU and MySQL load statistics which will give you addiitional information about the functionality of your Internet sites. 2 sections of the Hepsia Control Panel are focused on the stats, one for each and every kind. Inside the CPU Load section you could see the execution time of your scripts and how much time the server processed them. You may also see the different kinds of processes that were executed. Stats are produced every 6 hours, but if necessary, you may also check data for previous days or months. The MySQL Load section shall show you the entire amount of database queries each day and on an hourly basis, along with the queries to each individual database you have in your semi-dedicated account. Comparing this info to your traffic stats will give you valuable data about how your websites perform and you shall see if you must take some measures to optimize them.