MySQL & Load Stats
View what sort of information is gathered in the MySQL & Load Stats area and in what ways it is possible to make the most of it.
If you have an HTML Internet site, in all probability it uses a small amount of resources as it is static, but this is not the situation with dynamic database-driven Internet sites that use PHP scripts and provide you with considerably more capabilities. This kind of websites produce load on the hosting server anytime someone browses them, due to the fact that the hosting server requires time to execute the script, to access the database and then to supply the info requested by the visitor's Internet browser. A well-known discussion board, as an illustration, stores all usernames and posts within a database, so some load is created any time a thread is opened or a user looks for a specific term. If many people connect to the forum simultaneously, or if each and every search involves checking tens of thousands of database entries, this could generate high load and affect the overall performance of the website. In this regard, CPU and MySQL load statistics can provide you with data about the site’s overall performance, as you can compare the numbers with your traffic statistics to make a decision if the Internet site has to be optimized or transferred to another kind of website hosting platform that will be able to bear the high system load in case the site is very popular.
-
MySQL & Load Stats in Cloud Web Hosting
If you host your websites in a
cloud web hosting account with us, you shall have access to thorough CPU and MySQL stats which will allow you to keep tabs on their overall performance. You can see the data with a few clicks in your Hepsia Control Panel. The CPU Load section will show you the total time frame the web server spent on your scripts and just how much memory was required, and the time it took for the scripts to be executed. The daily view is the default one, but you can also see the stats from the preceding months. The MySQL Load section offer you additional information about the total amount of queries to every single database that you have set up inside the account. Once again, you can easily see monthly, day-to-day and per hour data, which will give you information that is different from the traffic or the number of visitors you get. That way, you can identify if the websites need some optimization.
-
MySQL & Load Stats in Semi-dedicated Hosting
If you have a
semi-dedicated server account with us, you will be able to access rather detailed CPU and MySQL load stats which will give you more info about the efficiency of your Internet sites. Two sections of the Hepsia CP are committed to the statistics, one for each and every type. Within the CPU Load section you are able to see the execution time of your scripts and the span of time the server processed them. You may also see the kinds of processes that were executed. Statistics are produced every six hours, but if required, you may also check statistics for previous days or months. The MySQL Load section will show you the total amount of database queries per day and per hour, plus the queries to each individual database that you have inside your semi-dedicated account. Comparing this info to your traffic statistics shall give you useful information about how your sites perform and you will determine if you must take some measures to improve them.
