If you have an HTML Internet site, it likely uses a small amount of resources as it is static, but this isn't so with dynamic database-driven websites that use PHP scripts and provide far more capabilities. This type of sites generate load on the hosting server anytime somebody browses them, since the server needs time to execute the script, to access the database and then to supply the content requested by the visitor's browser. A widely used discussion board, for example, stores all usernames and posts in a database, so some load is produced every time a thread is opened or an end user searches for a specific word. If a lot of people access the forum all at once, or if every single search involves checking hundreds of thousands of database entries, this may generate high load and affect the overall performance of the Internet site. In this regard, CPU and MySQL load statistics can provide information about the site’s performance, as you can compare the numbers with your traffic data to decide if the Internet site should be optimized or moved to a different type of hosting platform that'll be able to bear the high system load in the event that the site is extremely popular.
MySQL & Load Stats in Shared Website Hosting
If you host your Internet sites in a shared website hosting account with our company, you shall have access to detailed CPU and MySQL statistics which will allow you to monitor their functionality. You could see the stats with a number of clicks in your Hepsia CP. The CPU Load section can tell you the total time period the hosting server spent on your scripts and the amount of memory was needed, as well as the time it took for the scripts to be executed. The day-to-day view is the default one, but you may also see the stats from the previous months. The MySQL Load section will provide you with more info about the amount of queries to each database that you have created within the account. Once again, you can easily see monthly, day-to-day and hourly statistics, which will give you information that's different from the traffic or the number of visitors you get. Thus, you can identify if the sites need some optimization.
MySQL & Load Stats in Semi-dedicated Servers
If you have a semi-dedicated server account with our company, you'll be able to access very comprehensive CPU and MySQL load statistics which will give you more info about the overall performance of your sites. Two sections of the Hepsia Control Panel are devoted to the statistics, one for every kind. Inside the CPU Load section you can see the execution time of your scripts and the length of time the hosting server processed them. You can also see the kinds of processes that were executed. Statistics are generated every six hours, but if required, you may also check stats for previous days or months. The MySQL Load section shall show you the entire amount of database queries each and every day and on an hourly basis, and also the queries to each individual database which you have in your semi-dedicated account. Comparing this data to your traffic stats shall give you valuable data about how your websites perform and you shall see if you need to take some measures to improve them.