If you have an HTML site, it likely uses a small amount of resources due to the fact that it is static, but this isn't the situation with dynamic database-driven sites that use PHP scripts and offer you a lot more functions. Such Internet sites create load on the website hosting server anytime somebody browses them, as the web server requires time to execute the script, to access the database and then to deliver the information requested by the visitor's browser. A well-known discussion board, for instance, 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 specific term. If lots of people access the forum at the same time, or if each search involves checking hundreds of thousands of database entries, this could create high load and affect the functionality of the site. In this regard, CPU and MySQL load stats can provide you with data about the site’s performance, as you can compare the numbers with your traffic statistics and see if the website has to be optimized or moved to a different sort of website hosting platform which will be able to bear the high system load in the event that the site is really popular.

MySQL & Load Stats in Shared Website Hosting

Using the Hepsia Control Panel, bundled with all our shared website hosting packages, you will be able to see very detailed statistics regarding the resources that your sites use. One of the sections shall give you details about the CPU load, like how much processing time the web server spent, the time it took for your scripts to be executed and what amount of memory they used. Stats are routinely created every six hours and you can also see the types of processes that generated the most load - PHP, Perl, etc. MySQL load stats are listed in a separate section where you'll be able to see all the queries on an hourly, day-to-day, etcetera. basis. You could go back and compare stats from different months to find out whether some update has transformed the resource usage if the amount of visitors hasn't changed much. Thus, you can determine if your website needs to be optimized, which will lead to a better functionality and an improved user experience.

MySQL & Load Stats in Semi-dedicated Servers

If you have a semi-dedicated server account with our company, you'll be able to access quite comprehensive CPU and MySQL load stats that'll give you addiitional information about the efficiency of your websites. 2 sections of the Hepsia Control Panel are focused on the stats, one for each and every type. Inside the CPU Load section you can see the execution time of your scripts and how much time the server processed them. You can also see the different kinds of processes that were executed. Statistics are produced every 6 hours, but if necessary, you may also check stats for previous days or months. The MySQL Load section will show you the entire amount of database queries per day and each hour, as well as the queries to each individual database that you have inside your semi-dedicated account. Comparing this data to your traffic statistics shall give you useful info about how your sites perform and you shall see if you must take some measures to improve them.