MySQL & Load Stats
The MySQL & Load Stats will silently gather data while your website is running. Discover why you need to check them out regularly.
If you have an HTML website, it likely uses a small amount of resources because it's static, but this is not the situation with dynamic database-driven Internet sites that use PHP scripts and provide you with far more capabilities. This type of websites create load on the hosting server when anyone browses them, because the web server needs time to execute the script, to access the database and then to provide the info requested by the visitor's browser. A popular discussion board, as an illustration, stores all usernames and posts inside a database, so some load is created each time a thread is opened or a user searches for a certain name. If many people connect to the forum simultaneously, or if every single search involves checking tens of thousands of database entries, this may create high load and affect the performance of the website. In this regard, CPU and MySQL load data can present you with info about the site’s overall performance, as you can compare the numbers with your traffic data to make a decision if the Internet site needs to be optimized or migrated to a different type of 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 Control Panel, included with all our
hosting packages, you will be able to see really comprehensive data concerning the system resources your Internet sites use. One of the sections will give you details about the CPU load, such as the amount of processing time the hosting server spent, the span of time it took for your scripts to be executed and exactly how much memory they used. Statistics are automatically created every 6 hours and you could also see the different types of processes that produced the most load - PHP, Perl, and so on. MySQL load statistics are listed in a different section in which you are able to see all the queries on a per hour, everyday, and so forth. basis. You could go back and compare data from various months to determine if some update has changed the resource usage if the amount of website visitors hasn't changed much. In this way, you can see if your website needs to be optimized, that will lead to a better functionality and an improved user experience.
-
MySQL & Load Stats in Semi-dedicated Hosting
Due to the fact that our system keeps in depth statistics for the load that every
semi-dedicated server account generates, you'll be aware of how your sites perform at any time. Once you log in to the Hepsia CP, provided with every single account, you can go to the section dedicated to the system load. There, you can see the processing time our system spent on your scripts, the length of time it took for the scripts to be actually executed and what types of processes created the load - cron jobs, PHP pages, Perl scripts, and so on. Also you can see the total number of queries to each database within your semi-dedicated account, the total daily stats for the account overall, plus the average hourly rate. With both the CPU and the MySQL load stats, you can always go back to past days or months and review the performance of your sites after some update or after a major rise in the number of your site visitors.