If you have an HTML Internet site, most likely it uses a small amount of system resources as it's static, but this isn't so with dynamic database-driven websites that use PHP scripts and offer you much more features. Such sites create load on the hosting server anytime somebody browses them, simply because the web server requires time to execute the script, to access the database and then to deliver the data requested by the visitor's browser. A well known discussion board, for example, stores all usernames and posts in a database, so some load is created each time a thread is opened or a user looks for a particular word. If lots of people access the forum at the same time, or if every search involves checking thousands of database entries, this can generate high load and affect the overall performance of the site. In this regard, CPU and MySQL load statistics can provide you with data about the site’s overall performance, as you can compare the numbers with your traffic stats to make a decision if the Internet site needs to be optimized or transferred to a different type of hosting platform that will be able to bear the high system load in case the site is very popular.

MySQL & Load Stats in Web Hosting

If you host your sites within a web hosting account with us, you shall have access to detailed CPU and MySQL data that will permit you to keep track of their overall performance. You are able to see the stats with several mouse clicks in your Hepsia CP. The CPU Load section will reveal to you the total time frame the web server spent on your scripts and the amount of memory was required, as well as the time it took for the scripts to be executed. The daily view is the default one, but you may also see the stats from the past months. The MySQL Load section give you more details about the number of queries to every single database that you have created inside the account. Once again, you can see per month, everyday and hourly data, that shall give you information that is different from the traffic or the number of visitors you get. In this way, you can determine if the websites need some optimization.

MySQL & Load Stats in Semi-dedicated Servers

If you have a semi-dedicated server account with us, you'll be able to access quite comprehensive CPU and MySQL load stats that will give you more information about the general performance of your websites. 2 sections of the Hepsia Control Panel are devoted to the stats, one for every kind. Inside the CPU Load section you could see the execution time of your scripts and the length of time the hosting server processed them. Additionally you can see the different kinds of processes that were executed. Statistics are generated every six hours, but if required, you can also check statistics for previous days or months. The MySQL Load section will show you the whole amount of database queries per day and each hour, as well as the queries to each individual database that you have in your semi-dedicated account. Comparing this info to your traffic stats shall give you important information about how your websites perform and you will determine if you have to take some measures to improve them.