MySQL & Load Stats
Observe the kind of data is gathered in the MySQL & Load Stats section and in what ways you are able to reap the benefits of it.
If you have an HTML Internet site, in all probability it uses a very small amount of system resources because it's static, but this isn't the case with dynamic database-driven websites that use PHP scripts and provide you with a lot more features. This sort of sites produce load on the hosting server each time anyone browses them, due to the fact that the web server requires time to execute the script, to access the database and then to supply the information requested by the visitor's browser. A widely used discussion board, for example, stores all usernames and posts inside a database, so some load is generated every single time a thread is opened or an end user searches for a given term. If lots of people connect to the forum at the same time, or if every single search involves checking thousands of database entries, this could generate high load and affect the performance of the site. In this regard, CPU and MySQL load stats can present you with data about the site’s functionality, as you can compare the numbers with your traffic data to make a decision if the site should be optimized or transferred to a new type of website hosting platform that will be able to bear the high system load in case the site is extremely popular.
-
MySQL & Load Stats in Website Hosting
Our system keeps comprehensive info about the system resource usage of every single
website hosting account which is set up on our top-notch cloud platform, so in case you choose to host your websites with us, you will have full access to this info from the Hepsia CP, which you shall get with the account. The CPU load data feature the CPU time and the actual execution time of your scripts, along with how much system memory they used. You could also see what processes produced the load - PHP or Perl scripts, cron jobs, etcetera. The MySQL load stats section will show you the number of queries to each specific database that you have created within your shared hosting account, the total queries for the account overall and the average hourly rate. Comparing these statistics to the site visitor statistics will tell you if your websites perform the way they should or if they require some optimization, that will improve their efficiency and the overall visitor experience.
-
MySQL & Load Stats in Semi-dedicated Hosting
Since our system keeps in depth statistics for the load which every
semi-dedicated server account produces, you shall be aware of how your websites perform at any time. Once you log in to the Hepsia CP, included with each account, you can go to the section dedicated to the system load. There, you will see the processing time our system spent on your scripts, the time it took for the scripts to be actually executed and what sorts of processes produced the load - cron jobs, PHP pages, Perl scripts, and so forth. You may also see the amount of queries to every single database in your semi-dedicated account, the total everyday figures for the account overall, along with the average hourly rate. With both the CPU and the MySQL load data, you can always go back to past days or months and compare the efficiency of your sites after some update or after a sizeable boost in the number of your site visitors.