MySQL & Load Stats
View the kind of info is gathered in the MySQL & Load Stats section and how you'll be able to make the most of it.
If you have an HTML Internet site, in all probability it uses a really small amount of system resources simply because it is static, but this isn't the case with dynamic database-driven websites that use PHP scripts and offer considerably more capabilities. Such sites create load on the website hosting server anytime somebody browses them, because the web server needs time to execute the script, to access the database and then to deliver the info requested by the visitor's web browser. A well known discussion board, as an illustration, stores all usernames and posts within a database, so some load is generated every single time a thread is opened or an end user searches for a specific word. If many people connect to the forum concurrently, or if every single search involves checking hundreds of thousands of database entries, this can produce high load and affect the functionality of the Internet site. In this regard, CPU and MySQL load statistics can give you information about the site’s performance, as you can compare the numbers with your traffic data to determine if the site needs to be optimized or moved to another type of website hosting platform that'll be able to bear the high system load in the event that the site is very popular.
-
MySQL & Load Stats in Shared Hosting
Our system keeps comprehensive info about the system resource usage of each
shared hosting account that's created on our top-notch cloud platform, so if you opt to host your sites with us, you'll have full access to this data through the Hepsia Control Panel, which you shall get with the account. The CPU load stats feature the CPU time and the actual execution time of your scripts, along with what amount of system memory they used. You may see what processes generated the load - PHP or Perl scripts, cron jobs, and so forth. The MySQL load data section will show you the number of queries to each individual database which you have created inside your shared hosting account, the total queries for the account as a whole and the standard hourly rate. Comparing these statistics to the website visitor stats will tell you if your websites perform the way they need to or if they require some optimization, that'll improve their overall performance and the overall site visitor experience.
-
MySQL & Load Stats in Semi-dedicated Hosting
Because our system keeps detailed stats for the load which every
semi-dedicated server account generates, you shall be aware of how your websites perform at any time. When you log in to the Hepsia Control Panel, which comes with each and every account, you should check out the section dedicated to the system load. In it, you will see the processing time our system spent on your scripts, the amount of time it took for the scripts to be actually executed and what sorts of processes created the load - cron jobs, PHP pages, Perl scripts, and so forth. Also you can see the amount of queries to each and every database inside your semi-dedicated account, the total daily numbers for the account overall, and also the average hourly rate. With both the CPU and the MySQL load stats, you may always go back to past days or months and compare the performance of your sites after some update or after a substantial boost in the number of your site visitors.