MySQL & Load Stats
The MySQL & Load Stats will silently gather data while your website is functioning. See why you should check them out frequently.
If you have an HTML Internet site, it likely uses a really small amount of system resources simply because it's static, but this isn't the case with dynamic database-driven websites that use PHP scripts and provide far more features. This sort of websites create load on the hosting server anytime 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 browser. A famous discussion board, for instance, stores all usernames and posts within a database, so some load is produced each time a thread is opened or an end user searches for a given word. If a lot of people connect to the forum all at once, or if every search involves checking thousands of database entries, this could generate high load and affect the functionality of the Internet site. In this regard, CPU and MySQL load statistics can present you with information about the site’s performance, as you can compare the numbers with your traffic data to make a decision if the website has to be optimized or migrated to a new kind of web hosting platform that will be able to bear the high system load if the website is very popular.
-
MySQL & Load Stats in Website Hosting
Our system keeps detailed information about the system resource usage of each
website hosting account that is created on our top-notch cloud platform, so given that you opt to host your Internet sites with us, you will have full access to this information from the Hepsia CP, which you shall get with the account. The CPU load stats include the CPU time and the actual execution time of your scripts, along with the amount of system memory they used. You may see what processes produced the load - PHP or Perl scripts, cron jobs, and so on. The MySQL load statistics section will show you the total amount queries to each specific database that you have created in your shared hosting account, the total queries for the account altogether and the normal hourly rate. Comparing these figures to the site visitor statistics shall tell you if your Internet sites perform the way they should or if they need some optimization, that will improve their overall performance and the overall site visitor experience.
-
MySQL & Load Stats in Semi-dedicated Hosting
Since our system keeps comprehensive statistics for the load which every
semi-dedicated server account generates, you'll be aware of how your sites perform at any time. After you log in to the Hepsia CP, supplied with every account, you should check out the section committed to the system load. In it, you can easily 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, etcetera. Additionally you can see the amount of queries to every database inside your semi-dedicated account, the total everyday stats for the account as a whole, 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 assess the functionality of your websites after some update or after a major rise in the number of your website visitors.