MySQL & Load Stats
What kind of data is provided in the MySQL & Load Stats section? How can you take advantage of it?
If you have an HTML website, it likely uses a really small amount of resources due to the fact that it is static, but this is not so with dynamic database-driven Internet sites that use PHP scripts and offer considerably more functions. Such sites generate load on the website hosting server when someone browses them, since the web server requires time to execute the script, to access the database and then to provide the info requested by the visitor's web browser. A popular discussion board, as an illustration, stores all usernames and posts within a database, so some load is generated every single time a thread is opened or an end user looks for a certain phrase. If many people access the forum all at once, or if each and every search involves checking thousands of database entries, this can generate high load and affect the efficiency of the site. In this regard, CPU and MySQL load data can present you with information about the site’s overall performance, as you can compare the numbers with your traffic data to determine if the Internet site should be optimized or moved to another type of hosting platform which will be able to bear the high system load if the Internet site is extremely popular.
-
MySQL & Load Stats in Web Hosting
If you host your Internet sites within a
web hosting account with our company, you will have access to thorough CPU and MySQL stats that will enable you to keep an eye on their operation. You could see the stats with several mouse clicks inside your Hepsia CP. The CPU Load section can tell you the total time period the web server spent on your scripts and the amount of memory was needed, and the time it took for the scripts to be executed. The daily view is the default one, but you could also see the data from the preceding months. The MySQL Load section offer additional information about the amount of queries to each and every database that you have created within the account. Once again, you are able to see monthly, day-to-day and per hour statistics, that shall give you information that is different from the traffic or the number of visitors that you get. That way, you can determine if the Internet sites require some optimization.
-
MySQL & Load Stats in Semi-dedicated Servers
Our system creates comprehensive stats about both types of load, so if you acquire a
semi-dedicated server for your sites, you can access the data with just a couple of clicks within your Hepsia hosting Control Panel. Each type of data is listed inside its own section. The CPU Load section will tell you which processes generated the load and how much time it took for the web server to execute each of the requests. Though stats are produced every six hours, you can see daily and month-to-month stats also. In the MySQL Load section you shall find a list of all the databases created inside your semi-dedicated account manually and automatically, what number of queries were sent to each one of them, the total everyday queries for the account as a whole, plus the average hourly rate. This info shall help you figure out how well your Internet sites perform and if each of them requires optimization of some kind.