MySQL & Load Stats
What kind of info is available in the MySQL & Load Stats section? How can you take advantage of it?
The CPU load depends upon the time a web server spends executing a script whenever a visitor opens a page on a particular script-driven site. Static HTML Internet sites use hardly any CPU time, but this is not so with the far more advanced and functional scripts, which use a database and display dynamic content. The more individuals open this type of an Internet site, the more load will be generated on the web server and if the database is big, the MySQL server shall be loaded as well. An example of what can cause high load is a web-based store with thousands of products. If it's popular, a lot of people shall be visiting it simultaneously and if they search for items, the whole database which contains all of the products will also be frequently accessed by the script, resulting in high load. In this light, having CPU and MySQL load statistics will provide you with an idea of how the website is doing, if it needs to be optimized or if you simply just need a more effective website hosting solution - if the site is extremely popular and the current setup cannot handle the load.
MySQL & Load Stats in Shared Hosting
Using the Hepsia Control Panel, provided with all our shared hosting
packages, you shall be able to to see rather comprehensive stats regarding the system resources your websites use. One of the sections will give you information regarding the CPU load, including the amount of processing time the hosting server spent, the time it took for your scripts to be executed and the amount of memory they used. Stats are automatically produced every 6 hours and you may also see the kinds of processes that produced the most load - PHP, Perl, etc. MySQL load statistics are listed in an individual section in which you'll be able to see all the queries on a per hour, day-to-day, etc. basis. You could go back and compare data from various months to see if some update has changed the resource usage if the number of visitors has not changed much. That way, you can determine if your Internet site needs to be optimized, which will give you a better general performance and an improved user experience.
MySQL & Load Stats in Semi-dedicated Servers
Due to the fact that our system keeps detailed stats for the load that every semi-dedicated server
account produces, you will be aware of how your sites perform at any time. As soon as you log in to the Hepsia Control Panel, supplied with every account, you can go to the section committed to the system load. There, you can easily 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 sorts of processes created the load - cron jobs, PHP pages, Perl scripts, and so on. You may also see the amount of queries to each and every database inside your semi-dedicated account, the total everyday stats for the account in general, plus the average hourly rate. With both the CPU and the MySQL load data, you may always go back to past days or months and assess the overall performance of your sites after some update or after a sizeable rise in the number of your site visitors.