If you have an HTML Internet site, most likely it uses a really small amount of resources as it's static, but that isn't the situation with dynamic database-driven sites that use PHP scripts and provide a lot more functions. Such websites create load on the web hosting server every time anyone browses them, due to the fact that the web server requires time to execute the script, to access the database and then to deliver the content requested by the visitor's Internet browser. A popular discussion board, as an illustration, stores all usernames and posts within a database, so some load is produced every time a thread is opened or a user looks for a particular term. If a lot of people access the forum simultaneously, or if every single search involves checking tens of thousands of database entries, this may generate high load and affect the overall performance of the website. In this regard, CPU and MySQL load stats can present you with data about the site’s overall performance, as you can compare the numbers with your traffic statistics to determine if the Internet site has to be optimized or migrated to a new kind of web hosting platform which will be able to bear the high system load in the event that the website is very popular.

MySQL & Load Stats in Web Hosting

Using the Hepsia CP, included with all of our web hosting plans, you will be able to see rather comprehensive stats concerning the system resources your sites use. One of the sections will give you information regarding the CPU load, like how much processing time the server spent, how much time it took for your scripts to be executed and what amount of memory they used. Stats are consistently generated every six hours and you can also see the types of processes that generated the most load - PHP, Perl, and so on. MySQL load statistics are listed within an individual section where you could see all the queries on an hourly, daily, and so on. basis. You can go back and compare statistics from different months to see if some update has transformed the resource usage if the number of visitors has not changed much. This way, you can see if your website needs to be optimized, which will give you a better general performance and an improved user experience.

MySQL & Load Stats in Semi-dedicated Hosting

If you have a semi-dedicated server account with us, you'll be able to access very comprehensive CPU and MySQL load stats that will give you additional information about the overall performance of your sites. Two sections of the Hepsia CP are devoted to the statistics, one for each type. Within the CPU Load section you can see the execution time of your scripts and the amount of time the server processed them. You can even see the different kinds of processes that were executed. Statistics are produced every six hours, but if needed, you can also check figures for previous days or months. The MySQL Load section will show you the total number of database queries each day and each hour, and also the queries to each individual database that you have in your semi-dedicated account. Comparing this information to your traffic stats will give you important data about how your Internet sites perform and you shall see if you must take some measures to optimize them.