MySQL & Load Stats
See the kind of info is gathered in the MySQL & Load Stats section and just how you'll be able to make the most of it.
If you have an HTML website, in all probability it uses a small amount of resources simply because it's static, but this is not the situation with dynamic database-driven sites that use PHP scripts and offer far more functions. Such sites generate load on the web hosting server each time anyone browses them, simply because the server needs time to execute the script, to access the database and then to deliver the info requested by the visitor's Internet browser. A well known discussion board, for instance, stores all usernames and posts inside a database, so some load is created every single time a thread is opened or an end user looks for a specific name. If lots of people access the forum concurrently, or if every single search involves checking tens of thousands of database entries, this can generate high load and affect the performance of the site. In this regard, CPU and MySQL load statistics can give you information about the site’s functionality, as you can compare the numbers with your traffic data to decide if the site must be optimized or transferred to a different sort of web hosting platform that will be able to bear the high system load in case the Internet site is really popular.
-
MySQL & Load Stats in Website Hosting
Using the Hepsia CP, which comes with all our
website hosting offers, you will be able to see rather comprehensive data regarding the resources your sites use. One of the sections shall give you information regarding the CPU load, like how much processing time the hosting server spent, how much time it took for your scripts to be executed and how much memory they used. Statistics are automatically created every 6 hours and you could also see the types of processes that produced the most load - PHP, Perl, etc. MySQL load data are listed inside a different section in which you could see all the queries on an hourly, day-to-day, etcetera. basis. You could go back and compare stats from different months to see if some update has altered the resource usage if the amount of website visitors has not changed much. Thus, you will see if your Internet site needs to be optimized, which will contribute to a better general performance and an improved user experience.
-
MySQL & Load Stats in Semi-dedicated Hosting
Because our system keeps thorough stats for the load that every
semi-dedicated server account produces, you shall be aware of how your Internet sites perform at any time. Once you log in to the Hepsia CP, which comes with every account, you can go to the section dedicated to the system load. There, you can see the processing time our system spent on your scripts, the time it took for the scripts to be actually executed and what types of processes generated the load - cron jobs, PHP pages, Perl scripts, etc. You may also see the total number of queries to every single database inside your semi-dedicated account, the total everyday numbers for the account altogether, as well as the average hourly rate. With both the CPU and the MySQL load stats, you could always go back to past days or months and evaluate the efficiency of your websites after some update or after a major rise in the number of your site visitors.