MySQL & Load Stats
What kind of data is available in the MySQL & Load Stats section? How can you benefit from it?
When a visitor opens your Internet site, the Internet browser sends a request to the hosting server, which executes it and provides the desired data as a response. A standard HTML site uses minimal resources due to the fact that it's static, but database-driven platforms are more requiring and use a lot more processing time. Every single webpage that is served generates 2 forms of load - CPU load, which depends on the span of time the server spends executing a certain script; and MySQL load, that depends on the number of database queries created by the script while the client browses the site. Larger load shall be generated if a whole lot of people look through a particular website all at once or if numerous database calls are made concurrently. Two examples are a discussion board with a large number of users or an online store in which a visitor enters a term within a search box and a large number of items are searched. Having in depth data about the load that your site generates will help you boost the content or see if it's time to switch to a more powerful kind of web hosting service, if the Internet site is simply getting quite popular.
-
MySQL & Load Stats in Shared Hosting
Using the Hepsia CP, bundled with all of our
shared hosting packages, you will be able to see really comprehensive statistics concerning the system resources your Internet sites use. One of the sections will give you info on the CPU load, including how much processing time the web server spent, the amount of time it took for your scripts to be executed and how much memory they used. Stats are automatically produced every six hours and you can also see the types of processes that generated the most load - PHP, Perl, etc. MySQL load statistics are listed inside an individual section where you are able to see all the queries on a per hour, everyday, etcetera. basis. You'll be able to go back and compare data from different months to find out if some update has altered the resource usage if the number of visitors has not changed much. Thus, you can see if your Internet site needs to be optimized, that will contribute to a better general performance and an improved user experience.
-
MySQL & Load Stats in Semi-dedicated Servers
If you want to see detailed statistics about the load produced by your websites, it won't take more than several mouse clicks to do this. The Hepsia hosting CP, which comes with all
semi-dedicated servers that we offer, features a section focused on the system resource usage and the data there can tell you if your sites operate properly and if the load they create corresponds to the number of received visitors. The CPU load statistics include the script execution time and the length of time it took for the web server to process the requests, and what types of processes produced the load. The MySQL data will show you the number of times every database was accessed, and daily and per hour data for the whole account. With both kinds of statistics, you'll be able to check the numbers for each of the past days and months, so you can easily see how sites perform as the traffic to them increases or once you've applied some update.