MySQL & Load Stats
The MySQL & Load Stats will quietly gather data while your website is functioning. See why it's essential to check them out on a regular basis.
If you have an HTML site, it likely uses a very small amount of resources simply because it is static, but this is not the situation with dynamic database-driven websites that use PHP scripts and provide much more capabilities. Such websites generate load on the website hosting server every time anyone browses them, due to the fact that the server requires time to execute the script, to access the database and then to deliver the information requested by the visitor's web browser. A well known discussion board, for instance, stores all usernames and posts in a database, so some load is generated every time a thread is opened or an end user looks for a particular phrase. If many people connect to the forum concurrently, or if each and every search involves checking hundreds of thousands of database entries, this may create high load and affect the functionality of the site. In this regard, CPU and MySQL load data can present you with information about the site’s functionality, as you can compare the numbers with your traffic statistics to determine if the Internet site must be optimized or moved to a new kind of website hosting platform which will be able to bear the high system load in case the website is really popular.
MySQL & Load Stats in Shared Hosting
Using the Hepsia Control Panel, bundled with all our shared hosting
plans, you'll be able to see really comprehensive statistics regarding the resources which your sites use. One of the sections will give you information regarding the CPU load, such as how much processing time the server spent, the length of time it took for your scripts to be executed and what amount of memory they used. Stats are consistently created every 6 hours and you can also see the different kinds of processes that produced the most load - PHP, Perl, and so on. MySQL load data are listed inside a separate section in which you are able to see all the queries on an hourly, daily, and so on. basis. You could go back and compare stats from various months to find out if some update has changed the resource usage if the number of visitors hasn't changed much. Thus, you will see if your Internet site needs to be optimized, that will contribute to a better performance and an improved user experience.
MySQL & Load Stats in Semi-dedicated Servers
Our system generates in depth statistics about both different kinds of load, so if you purchase a semi-dedicated server
for your Internet sites, you can access the data with a few clicks in your Hepsia hosting Control Panel. Each kind of information is listed inside its own section. The CPU Load section will tell you which processes generated the load and the amount of time it took for the web server to execute each of the requests. Though stats are created every 6 hours, you can see day-to-day and month-to-month statistics too. In the MySQL Load section you'll find a list of all the databases produced inside your semi-dedicated account manually and automatically, what amount of queries were sent to every one of them, the total daily queries for the account in general, as well as the average per hour rate. This info shall help you figure out how well your sites perform and if each of them requires optimization of some kind.