MySQL & Load Stats
What type of info is accessible in the MySQL & Load Stats section? How could you make use of it?
If you have an HTML Internet site, it likely uses a small amount of system resources simply because it's static, but this is not the situation with dynamic database-driven Internet sites that use PHP scripts and provide a lot more capabilities. This sort of Internet sites generate load on the website hosting server each time someone browses them, due to the fact that the hosting server needs time to execute the script, to access the database and then to provide the content requested by the visitor's browser. A popular discussion board, as an illustration, stores all usernames and posts in a database, so some load is generated every single time a thread is opened or a user looks for a particular phrase. If a lot of people connect to the forum all at once, or if every search involves checking tens of thousands of database entries, this could produce high load and affect the performance of the Internet site. In this regard, CPU and MySQL load stats can give you data about the site’s overall performance, as you can compare the numbers with your traffic stats to decide if the Internet site needs to be optimized or transferred to a different kind of website hosting platform which will be able to bear the high system load if the Internet site is popular.
MySQL & Load Stats in Cloud Hosting
Using the Hepsia CP, provided with all our cloud hosting plans, you'll be able to see rather comprehensive stats regarding the resources which your Internet sites use. One of the sections will give you information regarding the CPU load, like the amount of processing time the server spent, the length of time it took for your scripts to be executed and the amount of memory they used. Stats are automatically generated every six hours and you could also see the different types of processes that produced the most load - PHP, Perl, and so on. MySQL load stats are listed inside an individual section in which you could see all the queries on an hourly, daily, and so on. basis. You can go back and compare data from different months to find out if some update has changed the resource usage if the number of site visitors hasn't changed much. In this way, you can see if your Internet site needs to be optimized, that will result in a better general performance and an improved user experience.