MySQL & Load Stats
The MySQL & Load Stats will quietly gather data while your website is running. Discover why you need to check them out on a regular basis.
If you have an HTML Internet site, most likely it uses a very small amount of system resources because it's static, but this is not the situation with dynamic database-driven websites that use PHP scripts and provide far more capabilities. This type of websites produce load on the web hosting server each and every time someone browses them, due to the fact that the hosting server needs time to execute the script, to access the database and then to provide the content requested by the visitor's web browser. A famous discussion board, as an illustration, stores all usernames and posts in a database, so some load is created every time a thread is opened or a user looks for a certain term. If a lot of people access the forum simultaneously, or if each and every search involves checking tens of thousands of database entries, this can produce high load and affect the performance of the website. In this regard, CPU and MySQL load data can provide information about the site’s functionality, as you can compare the numbers with your traffic stats and see if the site needs to be optimized or migrated to a different type of website hosting platform that'll be able to bear the high system load if the website is very popular.
-
MySQL & Load Stats in Web Hosting
If you host your websites in a
web hosting account with us, you will have access to comprehensive CPU and MySQL data that will enable you to keep track of their operation. You are able to see the stats with a number of mouse clicks inside your Hepsia Control Panel. The CPU Load section will reveal to you the total time period the web server spent on your scripts and what amount of memory was required, as well as the time it took for the scripts to be executed. The everyday view is the default one, but you'll be able to also see the statistics from the preceding months. The MySQL Load section offer you more info about the total amount of queries to each database that you have created in the account. Once again, you are able to see monthly, everyday and hourly stats, which will give you information that is different from the traffic or the number of visitors that you get. This way, you can see if the websites need some optimization.
-
MySQL & Load Stats in Semi-dedicated Servers
Our system produces comprehensive statistics about the two different types of load, so if you acquire a
semi-dedicated server for your websites, you can access the data with just a couple of mouse clicks within your Hepsia hosting CP. Each type of info is listed in its own section. The CPU Load section will show you which processes created the load and the length of time it took for the web server to execute each of the requests. Although statistics are created every 6 hours, you can see daily and monthly statistics also. In the MySQL Load section you will find a list of all the databases created inside your semi-dedicated account manually and automatically, what number of queries were sent to each of them, the total everyday queries for the account as a whole, as well as the average per hour rate. This information will help you see how well your sites perform and if any of them requires optimization of some kind.