MySQL & Load Stats
The MySQL & Load Stats will quietly gather data while your website is working. See why you need to check them out regularly.
If you have an HTML website, most likely it uses a very small amount of system resources as it is static, but that isn't so with dynamic database-driven Internet sites that use PHP scripts and offer you way more features. This type of sites produce load on the web hosting server when anyone browses them, due to the fact that the hosting server requires time to execute the script, to access the database and then to provide the data requested by the visitor's web browser. A well known discussion board, for example, stores all usernames and posts within a database, so some load is produced every time a thread is opened or a user looks for a certain term. If many people access the forum concurrently, or if every single search involves checking hundreds of thousands of database entries, this can generate high load and affect the functionality of the site. In this regard, CPU and MySQL load statistics can provide information about the site’s functionality, as you can compare the numbers with your traffic statistics to determine if the site must be optimized or moved to another sort of website hosting platform which will be able to bear the high system load in case the Internet site is very popular.
MySQL & Load Stats in Shared Hosting
Using the Hepsia CP, bundled with all our shared hosting
offers, you shall be able to to see rather comprehensive stats regarding the system resources your sites use. One of the sections will give you info on the CPU load, such as how much processing time the web server spent, how much time it took for your scripts to be executed and what amount of memory they used. Statistics are routinely generated every 6 hours and you can also see the different types of processes that generated the most load - PHP, Perl, and so forth. MySQL load stats are listed inside an individual section in which you are able to see all the queries on a per hour, daily, etcetera. basis. You could go back and compare data from various months to determine if some update has altered the resource usage if the total amount of site visitors hasn't changed much. This way, you will see if your Internet site needs to be optimized, that will give you a better overall performance and an improved user experience.
MySQL & Load Stats in Semi-dedicated Hosting
Our system produces in depth stats about both types of load, so if you buy a semi-dedicated server
for your websites, you can access the data with a few clicks in your Hepsia hosting Control Panel. Each type of data is listed inside its own section. The CPU Load section will tell you what processes generated the load and the time it took for the hosting server to execute all the requests. Though statistics are generated every six hours, you can see daily and per month statistics also. In the MySQL Load section you shall find a list of all the databases created within your semi-dedicated account manually and automatically, how many queries were sent to each of them, the total day-to-day queries for the account overall, as well as the average per hour rate. This data will help you see how well your websites perform and if any one of them needs optimization of some type.