MySQL & Load Stats
What kind of information is provided in the MySQL & Load Stats section? How can you take full advantage of it?
If you have an HTML site, it probably uses a small amount of system resources due to the fact that it is static, but that isn't the case with dynamic database-driven websites that use PHP scripts and offer considerably more functions. This sort of sites produce load on the website hosting server every time anyone browses them, as the hosting server needs time to execute the script, to access the database and then to supply the content requested by the visitor's Internet browser. A popular discussion board, for example, stores all usernames and posts within a database, so some load is produced any time a thread is opened or a user looks for a specific word. If a lot of people connect to the forum concurrently, or if each and every search involves checking hundreds of thousands of database entries, this may produce high load and affect the overall performance of the site. In this regard, CPU and MySQL load stats can provide you with data about the site’s functionality, as you can compare the numbers with your traffic statistics to determine if the Internet site must be optimized or moved to another type of hosting platform that'll be able to bear the high system load in the event that the Internet site is popular.
-
MySQL & Load Stats in Cloud Hosting
Using the Hepsia Control Panel, bundled with all of our
cloud hosting packages, you'll be able to see incredibly comprehensive statistics about the resources that your Internet sites use. One of the sections shall give you details about the CPU load, including how much processing time the web server spent, the span of time it took for your scripts to be executed and the amount of memory they used. Statistics are routinely created every six hours and you may also see the types of processes that produced the most load - PHP, Perl, etc. MySQL load data are listed within a separate section in which you could see all the queries on an hourly, everyday, and so on. basis. You could go back and compare statistics from different months to see if some update has transformed the resource usage if the total amount of website visitors hasn't changed much. Thus, you can see if your site needs to be optimized, that will lead to a better performance and an improved user experience.
-
MySQL & Load Stats in Semi-dedicated Hosting
As our system keeps in depth stats for the load which every
semi-dedicated server account generates, you shall be aware of how your Internet sites perform at any time. After you log in to the Hepsia CP, provided with each and every account, you can go to the section committed to the system load. There, you are able to see the processing time our system spent on your scripts, how much time it took for the scripts to be actually executed and what kinds of processes produced the load - cron jobs, PHP pages, Perl scripts, etcetera. Additionally you can see the number of queries to every single database in your semi-dedicated account, the total everyday figures for the account as a whole, plus the average hourly rate. With both the CPU and the MySQL load statistics, you may always go back to past days or months and assess the overall performance of your websites after some update or after a considerable rise in the number of your visitors.