MySQL & Load Stats
Discover what sort of data is gathered in the MySQL & Load Stats section and exactly how you are able to reap the benefits of it.
If you have an HTML site, it probably uses a very small amount of system resources as it is static, but this is not so with dynamic database-driven websites that use PHP scripts and offer you a lot more capabilities. This kind of sites create load on the hosting server each and every time someone browses them, due to the fact that the hosting server requires time to execute the script, to access the database and then to supply the content requested by the visitor's browser. A famous discussion board, as an illustration, stores all usernames and posts inside a database, so some load is produced each time a thread is opened or an end user looks for a specific phrase. If a lot of people connect to the forum at the same time, or if each and every search involves checking a large number of database entries, this may generate high load and affect the performance of the Internet site. In this regard, CPU and MySQL load stats can present you with info about the site’s performance, as you can compare the numbers with your traffic stats to decide if the site should be optimized or migrated to a new sort of 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 Cloud Website Hosting
Using the Hepsia CP, provided with all of our cloud website hosting
plans, you will be able to see incredibly detailed statistics about the system resources that your websites use. One of the sections shall give you information regarding the CPU load, like how much processing time the hosting server spent, the length of time it took for your scripts to be executed and what amount of memory they used. Stats are routinely produced 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 inside an individual section in which you'll be able to see all the queries on an hourly, daily, etcetera. basis. You'll be able to go back and compare stats from different months to determine if some update has changed the resource usage if the amount of visitors hasn't changed much. That way, you will see if your Internet site needs to be optimized, that'll lead to a better overall performance and an improved user experience.
MySQL & Load Stats in Semi-dedicated Hosting
If you have a semi-dedicated server
account with our company, you shall be able to access quite comprehensive CPU and MySQL load data which will give you addiitional information about the functionality of your sites. Two sections of the Hepsia CP are dedicated to the statistics, one for every single kind. Within the CPU Load section you are able to see the execution time of your scripts and the span of time the web server processed them. You may also see the types of processes that were executed. Stats are generated every six hours, but if necessary, you can also check statistics for previous days or months. The MySQL Load section will show you the entire amount of database queries daily and on an hourly basis, 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 valuable info about how your Internet sites perform and you will see if you must take some measures to improve them.