MySQL & Load Stats
What kind of information is accessible in the MySQL & Load Stats section? How could you take advantage of it?
When a visitor opens your Internet site, the Internet browser sends a request to the web server, which executes it and gives the required content as a response. A standard HTML site uses minimum resources because it is static, but database-driven platforms are more requiring and use much more processing time. Each and every page that's served creates two forms of load - CPU load, which depends on the time the hosting server spends executing a particular script; and MySQL load, which depends on the number of database queries produced by the script while the client browses the site. Greater load shall be produced if a whole lot of people surf a certain site at the same time or if numerous database calls are made all at once. 2 examples are a discussion board with thousands of users or an online store where a visitor enters a term inside a search box and tens of thousands of items are searched. Having thorough statistics about the load your website generates will help you boost the content or see if it's the perfect time to switch to a more powerful kind of website hosting service, if the Internet site is simply getting very popular.
MySQL & Load Stats in Website Hosting
Using the Hepsia CP, bundled with all of our website hosting
plans, you will be able to see incredibly detailed stats concerning the system resources your Internet sites use. One of the sections will give you information regarding the CPU load, such as the amount of processing time the web server spent, the amount of time it took for your scripts to be executed and the amount of memory they used. Stats are routinely created every 6 hours and you could also see the kinds of processes that generated the most load - PHP, Perl, and so on. MySQL load stats are listed in a separate section in which you are able to see all the queries on an hourly, daily, etc. basis. You could go back and compare stats from different months to see if some update has transformed the resource usage if the number of website visitors hasn't changed much. That way, you will see if your website needs to be optimized, that will contribute to a better performance and an improved user experience.
MySQL & Load Stats in Semi-dedicated Servers
Because our system keeps thorough stats for the load that each semi-dedicated server
account generates, you will be aware of how your sites perform at any time. Once you log in to the Hepsia Control Panel, included with every account, you can check out the section committed to the system load. In it, you will 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, etcetera. You could also see the amount of queries to every single database inside your semi-dedicated account, the total daily stats for the account overall, and also the average hourly rate. With both the CPU and the MySQL load statistics, you can always go back to past days or months and examine the general performance of your Internet sites after some update or after a major increase in the number of your visitors.