MySQL & Load Stats
What type of information is available in the MySQL & Load Stats section? How could you benefit from it?
Each time a visitor opens your website, the web browser sends a request to the hosting server, which executes it and gives the required information as a response. A basic HTML Internet site uses minimum resources for the reason that it's static, but database-driven platforms are more requiring and use far more processing time. Every single page which is served creates 2 sorts of load - CPU load, which depends on the amount of time the web server spends executing a certain script; and MySQL load, which depends on the amount of database queries generated by the script while the user browses the site. Bigger load will be generated if a lot of people browse a given website all at once or if a considerable amount of database calls are made concurrently. Two illustrations are a discussion board with thousands of users or an online store in which a client enters a term within a search box and a large number of items are searched. Having comprehensive statistics about the load that your site generates will help you boost the content or see if it is time to switch to a more powerful sort of hosting service, if the site is simply getting very popular.
MySQL & Load Stats in Cloud Web Hosting
Using the Hepsia CP, included with all of our cloud web hosting
packages, you will be able to see really comprehensive statistics concerning the resources your Internet sites use. One of the sections shall give you details about the CPU load, like the amount of processing time the web server spent, the span of time it took for your scripts to be executed and exactly how much memory they used. Statistics are automatically provided every six hours and you could also see the different types of processes that produced the most load - PHP, Perl, etc. MySQL load statistics are listed within a separate section where you'll be able to see all the queries on a per hour, day-to-day, and so forth. basis. You'll be able to go back and compare data from various months to find out if some update has transformed the resource usage if the number of site visitors hasn't changed much. This way, you can see if your Internet site needs to be optimized, that'll give you a better performance and an improved user experience.
MySQL & Load Stats in Semi-dedicated Servers
As our system keeps comprehensive stats for the load that every semi-dedicated server
account produces, you'll be aware of how your websites perform at any time. When you log in to the Hepsia CP, included with each account, you can check out the section dedicated to the system load. There, you will see the processing time our system spent on your scripts, the length of time it took for the scripts to be actually executed and what kinds of processes produced the load - cron jobs, PHP pages, Perl scripts, etc. Also you can see the amount of queries to each database within your semi-dedicated account, the total everyday numbers for the account overall, along with the average hourly rate. With both the CPU and the MySQL load data, you can always go back to past days or months and assess the overall performance of your sites after some update or after a substantial increase in the number of your visitors.