MySQL & Load Stats
Observe which kind of data is gathered in the MySQL & Load Stats section and exactly how it is possible to take advantage of it.
If you have an HTML Internet site, most likely it uses a very small amount of resources because it is static, but that isn't so with dynamic database-driven sites that use PHP scripts and provide you with a lot more functions. This type of sites create load on the website hosting server when somebody browses them, due to the fact that the server requires time to execute the script, to access the database and then to provide the content requested by the visitor's browser. A famous discussion board, for example, stores all usernames and posts within a database, so some load is generated every time a thread is opened or a user looks for a certain phrase. If a lot of people access the forum concurrently, or if every single search involves checking a large number of database entries, this may generate high load and affect the efficiency of the website. In this regard, CPU and MySQL load data can give you data about the site’s overall performance, as you can compare the numbers with your traffic data to make a decision if the site has to be optimized or migrated to another kind of hosting platform that'll be able to bear the high system load if the website is popular.
-
MySQL & Load Stats in Shared Hosting
If you host your sites in a
shared hosting account with our company, you'll have access to in depth CPU and MySQL data that will permit you to keep track of their functionality. You are able to see the stats with a few mouse clicks within your Hepsia CP. The CPU Load section will show you the total time frame the hosting server spent on your scripts and what amount of memory was required, and the time it took for the scripts to be executed. The daily view is the default one, but you could also see the stats from the previous months. The MySQL Load section give you more details about the total amount of queries to every single database that you have created inside the account. Once again, you are able to see per month, day-to-day and hourly data, that'll give you info that's different from the traffic or the number of visitors which you get. This way, you can determine if the websites need some optimization.
-
MySQL & Load Stats in Semi-dedicated Hosting
If you have a
semi-dedicated server account with our company, you shall be able to access really comprehensive CPU and MySQL load data that'll give you addiitional information about the efficiency of your websites. 2 sections of the Hepsia CP are devoted to the stats, one for every single kind. In the CPU Load section you could see the execution time of your scripts and the length of time the hosting server processed them. Additionally you can see the types of processes that were executed. Statistics are produced every 6 hours, but if necessary, you may also check figures for previous days or months. The MySQL Load section will show you the whole number of database queries per day and on an hourly basis, along with the queries to each individual database which you have within your semi-dedicated account. Comparing this information to your traffic statistics will give you valuable information about how your websites perform and you shall see if you need to take some measures to boost them.