MySQL & Load Stats
View what sort of data is gathered in the MySQL & Load Stats area and in what ways it is possible to benefit from it.
If you have an HTML Internet site, it likely uses a small amount of system resources due to the fact that it is static, but this is not so with dynamic database-driven Internet sites that use PHP scripts and offer you considerably more capabilities. Such sites generate load on the web hosting server each and every time someone browses them, as the server requires time to execute the script, to access the database and then to provide the info requested by the visitor's browser. A famous discussion board, for instance, stores all usernames and posts in a database, so some load is produced each time a thread is opened or an end user searches for a specific word. If a lot of people connect to the forum at the same time, or if each and every search involves checking thousands of database entries, this could generate high load and affect the performance of the Internet site. In this regard, CPU and MySQL load statistics can provide you with information about the site’s functionality, as you can compare the numbers with your traffic data and see if the site needs to be optimized or transferred to another kind of website hosting platform that'll be able to bear the high system load if the site is extremely popular.
-
MySQL & Load Stats in Shared Hosting
Our system keeps detailed information about the system resource usage of each and every
shared hosting account which is set up on our top-notch cloud platform, so if you decide to host your websites with us, you shall have full access to this data through the Hepsia CP, which you shall get with the account. The CPU load data include the CPU time and the actual execution time of your scripts, as well as the amount of system memory they used. You could also see what processes produced the load - PHP or Perl scripts, cron jobs, and so forth. The MySQL load stats section will show you the amount of queries to each individual database which you have created inside your shared hosting account, the total queries for the account in general and the typical hourly rate. Comparing these numbers to the site visitor stats will tell you if your sites perform the way they need to or if they need some optimization, that will improve their overall performance and the overall visitor experience.
-
MySQL & Load Stats in Semi-dedicated Hosting
Because our system keeps detailed stats for the load that every
semi-dedicated server account produces, you'll be aware of how your websites perform at any time. As soon as you log in to the Hepsia CP, which comes with every single account, you can go to the section committed to the system load. In it, you are able to see the processing time our system spent on your scripts, the span of time it took for the scripts to be actually executed and what types of processes produced the load - cron jobs, PHP pages, Perl scripts, etc. Additionally you can see the amount of queries to each database in your semi-dedicated account, the total day-to-day numbers for the account altogether, along with the average hourly rate. With both the CPU and the MySQL load stats, you could always go back to past days or months and examine the performance of your Internet sites after some update or after a sizeable boost in the number of your visitors.