MySQL & Load Stats
View the kind of info is gathered in the MySQL & Load Stats area and the way you can take full advantage of it.
If you have an HTML site, it likely uses a really small amount of resources as it is static, but that isn't the case with dynamic database-driven sites that use PHP scripts and offer you far more functions. This type of Internet sites produce load on the web hosting server each and every time someone browses them, since 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 well known discussion board, as an illustration, stores all usernames and posts in a database, so some load is generated any time a thread is opened or an end user looks for a specific term. If a lot of people access the forum at the same time, or if each search involves checking tens of thousands of database entries, this can generate high load and affect the overall performance of the site. In this regard, CPU and MySQL load data can provide info about the site’s overall performance, as you can compare the numbers with your traffic stats to decide if the Internet site must be optimized or transferred to another kind of hosting platform that will be able to bear the high system load if the website is extremely popular.
MySQL & Load Stats in Cloud Web Hosting
Using the Hepsia CP, bundled with all of our cloud web hosting plans, you will be able to see very comprehensive statistics concerning the system resources your Internet sites use. One of the sections will give you info on 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. Statistics are automatically produced every six hours and you could also see the kinds of processes that generated the most load - PHP, Perl, etc. MySQL load statistics are listed inside a different section in which you can see all the queries on an hourly, day-to-day, etc. basis. You'll be able to go back and compare data from various months to find out if some update has altered the resource usage if the number of visitors hasn't changed much. Thus, you will see if your website needs to be optimized, which will contribute to a better general performance and an improved user experience.