MySQL & Load Stats
What kind of info is accessible in the MySQL & Load Stats section? How could you benefit from it?
If you have an HTML website, it likely uses a small amount of resources due to the fact that it is static, but that isn't so with dynamic database-driven websites that use PHP scripts and provide you with a lot more functions. This sort of Internet sites produce load on the hosting server when somebody browses them, simply because the hosting server requires time to execute the script, to access the database and then to deliver the information requested by the visitor's browser. A widely used discussion board, for example, stores all usernames and posts in a database, so some load is generated every single time a thread is opened or an end user looks for a certain name. If a lot of people access the forum at the same time, or if every search involves checking hundreds of thousands of database entries, this may produce high load and affect the efficiency of the site. In this regard, CPU and MySQL load statistics can present you with information about the site’s overall performance, as you can compare the numbers with your traffic stats to determine if the Internet site should be optimized or moved to a new sort of website hosting platform which will be able to bear the high system load in the event that the site is very popular.
-
MySQL & Load Stats in Web Hosting
Using the Hepsia Control Panel, provided with all our
web hosting plans, you'll be able to see incredibly detailed statistics about the resources your websites use. One of the sections shall give you details about the CPU load, including how much processing time the web server spent, the length of time it took for your scripts to be executed and what amount of memory they used. Statistics are automatically generated every 6 hours and you could also see the types of processes that produced the most load - PHP, Perl, etc. MySQL load stats are listed within an individual section where you are able to see all the queries on a per hour, day-to-day, etc. basis. You'll be able to go back and compare data from various months to see if some update has altered the resource usage if the number of website visitors has not changed much. Thus, you will see if your website needs to be optimized, that will give you a better overall performance and an improved user experience.
-
MySQL & Load Stats in Semi-dedicated Servers
Since our system keeps comprehensive statistics for the load which each
semi-dedicated server account produces, you will be aware of how your sites perform at any time. When you log in to the Hepsia CP, which comes with each account, you should check out the section dedicated to the system load. There, you are able to see the processing time our system spent on your scripts, the 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. Additionally you can see the total number of queries to every single database in your semi-dedicated account, the total daily statistics for the account in general, and also the average hourly rate. With both the CPU and the MySQL load stats, you could always go back to past days or months and compare the overall performance of your Internet sites after some update or after a sizeable rise in the number of your visitors.