MySQL & Load Stats
What sort of data is accessible in the MySQL & Load Stats section? How do you take advantage of it?
When a visitor opens your website, the web browser sends a request to the web server, which in turn executes it and supplies the required information as a response. A basic HTML Internet site uses minimal system resources for the reason that it is static, but database-driven platforms are more demanding and use a lot more processing time. Every single page that is served produces 2 sorts of load - CPU load, that depends on the amount of time the hosting server spends executing a particular script; and MySQL load, which depends on the total number of database queries created by the script while the customer browses the site. Greater load shall be created if many people look through a particular Internet site at the same time or if numerous database calls are made at the same time. 2 illustrations are a discussion board with tens of thousands of users or an online store in which a customer enters a term inside a search box and a large number of items are searched. Having in depth data about the load that your site generates will allow you to boost the content or see if it is time to switch to a more powerful type of web hosting service, if the Internet site is simply getting very popular.
-
MySQL & Load Stats in Cloud Hosting
Using the Hepsia Control Panel, provided with all our
cloud hosting plans, you shall be able to to see incredibly detailed data concerning the system resources which your Internet sites use. One of the sections shall give you information regarding the CPU load, including the amount of processing time the server spent, the time it took for your scripts to be executed and what amount of memory they used. Stats are automatically created every six hours and you may also see the different kinds of processes that generated the most load - PHP, Perl, and so forth. MySQL load stats are listed within an individual section where you can see all the queries on a per hour, day-to-day, and so on. basis. You can go back and compare stats from various months to find out whether some update has altered the resource usage if the number of visitors has not changed much. This way, you can see if your Internet site needs to be optimized, that'll result in a better functionality and an improved user experience.
-
MySQL & Load Stats in Semi-dedicated Hosting
If you would like to see in depth stats with regards to the load produced by your websites, it will not take more than a couple of clicks to do that. The Hepsia hosting Control Panel, supplied with all
semi-dedicated servers we offer, has a section dedicated to the system resource usage and the information there shall tell you if your websites function properly and if the load they generate corresponds to the number of received visitors. The CPU load statistics include the script execution time and the span of time it took for the machine to process the requests, as well as what sorts of processes generated the load. The MySQL statistics shall show you how frequently each individual database was accessed, and daily and hourly statistics for the whole account. With both sorts of stats, you'll be able to check the numbers for any of the past days and months, so you can easily see how the sites perform as the traffic to them increases or once you've applied some update.