MySQL & Load Stats
What type of info is available in the MySQL & Load Stats section? How do you make use of it?
If you have an HTML website, it likely uses a small amount of system resources as it's static, but this isn't the situation with dynamic database-driven websites that use PHP scripts and provide you with considerably more functions. This kind of sites produce load on the website hosting server anytime anyone browses them, since the server needs time to execute the script, to access the database and then to deliver the content requested by the visitor's Internet browser. A famous discussion board, for example, stores all usernames and posts inside a database, so some load is produced each time a thread is opened or a user searches for a specific term. If lots of people access the forum simultaneously, or if each and every search involves checking tens of thousands of database entries, this can create high load and affect the functionality of the website. In this regard, CPU and MySQL load data can provide data about the site’s performance, as you can compare the numbers with your traffic data and see if the website should be optimized or migrated to a different kind of hosting platform which will be able to bear the high system load if the Internet site is extremely popular.
-
MySQL & Load Stats in Shared Hosting
If you host your Internet sites inside a
shared hosting account with us, you will have access to in depth CPU and MySQL statistics that will enable you to keep an eye on their overall performance. You can easily see the statistics with several mouse clicks inside your Hepsia CP. The CPU Load section will show you the total time the server spent on your scripts and just how much memory was needed, as well as the time it took for the scripts to be executed. The daily view is the standard one, but you may also see the numbers from the past months. The MySQL Load section give you more details about the total amount of queries to every single database that you have created within the account. Once again, you can easily see monthly, day-to-day and per hour statistics, that shall give you info that's different from the traffic or the number of visitors you get. In this way, you can identify if the sites require some optimization.
-
MySQL & Load Stats in Semi-dedicated Servers
As our system keeps thorough statistics for the load which every
semi-dedicated server account generates, you shall be aware of how your Internet sites perform at any time. Once you log in to the Hepsia CP, which comes with each and every account, you should check out the section devoted to the system load. There, you are able to 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 generated the load - cron jobs, PHP pages, Perl scripts, and so forth. You can also see the amount of queries to each and every database inside your semi-dedicated account, the total everyday stats for the account overall, plus the average hourly rate. With both the CPU and the MySQL load statistics, you can always go back to past days or months and review the efficiency of your websites after some update or after a substantial rise in the number of your site visitors.