MySQL & Load Stats
What type of information is available in the MySQL & Load Stats section? How could you take full advantage of it?
If you have an HTML Internet site, it probably uses a really small amount of system resources simply because it is static, but that isn't the case with dynamic database-driven sites that use PHP scripts and provide you with far more features. Such websites create load on the website hosting server each and every time anyone browses them, as the web server needs time to execute the script, to access the database and then to provide the data requested by the visitor's Internet browser. A well-known discussion board, for instance, stores all usernames and posts in a database, so some load is created each time a thread is opened or an end user looks for a specific phrase. If many people connect to the forum all at once, or if every single search involves checking thousands of database entries, this can create high load and affect the performance of the website. In this regard, CPU and MySQL load data can provide you with info about the site’s efficiency, as you can compare the numbers with your traffic data and see if the site must be optimized or moved to a different kind of website hosting platform which will be able to bear the high system load in the event that the Internet site is very popular.
MySQL & Load Stats in Cloud Hosting
Using the Hepsia Control Panel, included with all our cloud hosting
plans, you shall be able to to see very comprehensive stats concerning the system resources your sites use. One of the sections will give you information about the CPU load, like how much processing time the server spent, the time it took for your scripts to be executed and what amount of memory they used. Stats are routinely generated every 6 hours and you may also see the different kinds of processes that produced the most load - PHP, Perl, and so forth. MySQL load statistics are listed in a separate section in which you can see all the queries on an hourly, daily, and so forth. basis. You could go back and compare stats from different months to find out whether some update has transformed the resource usage if the number of website visitors has not changed much. This way, you will see if your site needs to be optimized, which will contribute to a better overall performance and an improved user experience.
MySQL & Load Stats in Semi-dedicated Hosting
Since our system keeps thorough statistics for the load that every semi-dedicated server
account produces, you shall be aware of how your Internet sites perform at any time. After you log in to the Hepsia Control Panel, which comes with every single 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 span of time it took for the scripts to be actually executed and what sorts of processes generated the load - cron jobs, PHP pages, Perl scripts, and so on. You could also see the total number of queries to each and every database within your semi-dedicated account, the total daily figures for the account overall, and also the average hourly rate. With both the CPU and the MySQL load data, you may always go back to past days or months and examine the functionality of your sites after some update or after a sizeable rise in the number of your website visitors.