MySQL & Load Stats
View what sort of info is gathered in the MySQL & Load Stats section and how you'll be able to benefit from it.
If you have an HTML Internet site, it likely uses a very small amount of resources simply because it is static, but this is not the case with dynamic database-driven sites that use PHP scripts and provide you with much more capabilities. This sort of Internet sites generate load on the web hosting server each time anyone browses them, simply because the hosting server needs time to execute the script, to access the database and then to deliver the data requested by the visitor's web browser. A popular discussion board, for instance, stores all usernames and posts in a database, so some load is produced each time a thread is opened or a user searches for a certain term. If a lot of people connect to the forum at the same time, or if each and every search involves checking hundreds of thousands of database entries, this can create high load and affect the overall performance of the website. In this regard, CPU and MySQL load statistics can give you info about the site’s functionality, as you can compare the numbers with your traffic statistics to decide if the Internet site has to be optimized or migrated to another sort of hosting platform that will be able to bear the high system load in the event that the Internet site is very popular.
MySQL & Load Stats in Hosting
Using the Hepsia Control Panel, bundled with all of our hosting packages, you'll be able to see very detailed data regarding the resources which your websites use. One of the sections will give you details about the CPU load, such as how much processing time the web server spent, the time it took for your scripts to be executed and the amount of memory they used. Statistics are consistently generated every 6 hours and you can also see the types of processes that generated the most load - PHP, Perl, and so forth. MySQL load data are listed inside a different section where you could see all the queries on an hourly, daily, and so forth. basis. You could go back and compare data from different months to determine if some update has transformed the resource usage if the number of site visitors hasn't changed much. This way, you can determine if your Internet site needs to be optimized, which will result in a better general performance and an improved user experience.