MySQL & Load Stats
Discover what type of data is gathered in the MySQL & Load Stats section and how it is possible to take full advantage of it.
If you have an HTML website, it probably uses a very small amount of system resources simply because it is static, but this isn't so with dynamic database-driven websites that use PHP scripts and provide you with far more functions. This sort of Internet sites produce load on the website hosting server every time anyone browses them, as the web server needs time to execute the script, to access the database and then to provide the content requested by the visitor's Internet browser. A famous discussion board, as an illustration, stores all usernames and posts in a database, so some load is generated every time a thread is opened or an end user searches for a certain term. If lots of people access the forum all at once, or if each search involves checking tens of thousands of database entries, this can produce high load and affect the overall performance of the Internet site. In this regard, CPU and MySQL load statistics can present you with information about the site’s efficiency, as you can compare the numbers with your traffic statistics and see if the site should be optimized or moved to a new sort of website hosting platform that will be able to bear the high system load in case the site is very popular.
-
MySQL & Load Stats in Cloud Hosting
Our system keeps detailed information about the system resource usage of every single
cloud hosting account that's created on our top-notch cloud platform, so in case you choose to host your sites with our company, you'll have full access to this data via the Hepsia Control Panel, which you'll get with the account. The CPU load statistics feature 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 generated the load - PHP or Perl scripts, cron jobs, and so on. The MySQL load stats section will show you the number of queries to each individual database that you've created within your shared hosting account, the total queries for the account as a whole and the typical hourly rate. Comparing these numbers to the website visitor stats shall tell you if your websites perform the way they should or if they need some optimization, that will improve their performance and the overall visitor experience.
-
MySQL & Load Stats in Semi-dedicated Hosting
If you want to see detailed statistics for the load created by your websites, it will not take more than a couple of mouse clicks to do that. The Hepsia hosting Control Panel, provided with all
semi-dedicated servers we offer, features a section committed to the system resource usage and the data there shall tell you if your websites function properly and if the load they produce corresponds to the amount of received visitors. The CPU load data include the script execution time and the span of time it took for the machine to process the requests, as well as what types of processes produced the load. The MySQL stats will show you how often every single database was accessed, and everyday and per hour statistics for the whole account. With both sorts of statistics, you are able to check the numbers for every one of the past days and months, so you could see how the websites perform as the traffic to them grows or after you have applied some update.