If you have an HTML Internet site, it likely uses a very small amount of system resources simply because it is static, but this isn't the situation with dynamic database-driven sites that use PHP scripts and offer way more capabilities. This sort of Internet sites create load on the web hosting server each and every time somebody browses them, due to the fact that the hosting server requires time to execute the script, to access the database and then to deliver the content requested by the visitor's web browser. A famous discussion board, for instance, stores all usernames and posts inside a database, so some load is produced each time a thread is opened or a user searches for a certain word. If many people access the forum simultaneously, or if each and every search involves checking thousands of database entries, this may generate high load and affect the efficiency of the website. In this regard, CPU and MySQL load statistics can provide you with info about the site’s overall performance, as you can compare the numbers with your traffic statistics and see if the site needs to be optimized or moved to a different sort of website hosting platform which will be able to bear the high system load if the website is popular.
MySQL & Load Stats in Hosting
Using the Hepsia CP, included with all of our hosting plans, you'll be able to see incredibly comprehensive stats about the system resources your Internet sites use. One of the sections will give you details about the CPU load, like how much processing time the server spent, the time it took for your scripts to be executed and what amount of memory they used. Stats are automatically generated every 6 hours and you may also see the types of processes that produced the most load - PHP, Perl, and so forth. MySQL load data are listed within an individual section where you can see all the queries on an hourly, day-to-day, etcetera. basis. You can go back and compare statistics from different months to determine if some update has changed the resource usage if the total amount of visitors hasn't changed much. This way, you will see if your site needs to be optimized, that will lead to a better overall performance and an improved user experience.
MySQL & Load Stats in Semi-dedicated Servers
Our system produces comprehensive statistics about both different kinds of load, so if you buy a semi-dedicated server for your Internet sites, you can access the info with just a few mouse clicks inside your Hepsia hosting Control Panel. Each type of info is listed in its own section. The CPU Load section can tell you exactly what processes produced the load and the time it took for the server to execute every one of the requests. Although stats are created every six hours, you can see daily and per month stats as well. In the MySQL Load section you will find a list of all the databases created within your semi-dedicated account manually and automatically, how many queries were sent to every one of them, the total everyday queries for the account as a whole, along with the average hourly rate. This data will help you figure out how well your websites perform and if each of them requires optimization of some kind.