MySQL & Load Stats
See what sort of info is gathered in the MySQL & Load Stats section and the way 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 because it is static, but that isn't the situation with dynamic database-driven Internet sites that use PHP scripts and offer you far more functions. This sort of Internet sites create load on the hosting server each and 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 supply the info requested by the visitor's web browser. A well known discussion board, for example, stores all usernames and posts in a database, so some load is created every single time a thread is opened or an end user searches for a certain term. If lots of people connect to the forum simultaneously, or if each and every search involves checking tens of thousands of database entries, this may generate high load and affect the overall performance of the site. In this regard, CPU and MySQL load stats can present you with data about the site’s efficiency, as you can compare the numbers with your traffic data to make a decision if the Internet site should be optimized or migrated to another sort of web hosting platform that will be able to bear the high system load in case the site is very popular.
-
MySQL & Load Stats in Shared Website Hosting
Using the Hepsia CP, provided with all our
shared website hosting packages, you will be able to see rather comprehensive data regarding the system resources that your websites use. One of the sections will give you information regarding the CPU load, including the amount of processing time the web server spent, the length of time it took for your scripts to be executed and exactly how much memory they used. Stats are consistently generated every six hours and you may also see the kinds of processes that produced the most load - PHP, Perl, etc. MySQL load stats are listed within a separate section where you could see all the queries on a per hour, daily, and so on. basis. You can go back and compare stats from various months to find out if some update has transformed the resource usage if the number of site visitors hasn't changed much. In this way, you can determine if your website needs to be optimized, that'll result in a better overall performance and an improved user experience.
-
MySQL & Load Stats in Semi-dedicated Hosting
If you have a
semi-dedicated server account with our company, you'll be able to access very detailed CPU and MySQL load stats that'll give you more info about the functionality of your websites. Two sections of the Hepsia CP are focused on the statistics, one for each kind. Within the CPU Load section you could see the execution time of your scripts and the span of time the web server processed them. You can even see the types of processes which were executed. Statistics are produced every 6 hours, but if necessary, you can also check statistics for previous days or months. The MySQL Load section shall show you the total number of database queries each and every day and on an hourly basis, along with the queries to each individual database which you have inside your semi-dedicated account. Comparing this information to your traffic stats will give you useful information about how your websites perform and you will determine if you must take some measures to optimize them.