MySQL & Load Stats
View the kind of information is gathered in the MySQL & Load Stats section and in what ways you can benefit from it.
If you have an HTML website, most likely it uses a very small amount of system resources because it's static, but that isn't so with dynamic database-driven websites that use PHP scripts and provide you with way more features. Such websites produce load on the hosting server each time anyone browses them, as the server needs time to execute the script, to access the database and then to deliver the content requested by the visitor's Internet browser. A popular discussion board, for instance, stores all usernames and posts in a database, so some load is generated every single time a thread is opened or an end user searches for a specific term. If many people connect to the forum concurrently, or if each and every search involves checking tens of thousands of database entries, this could create high load and affect the overall performance of the site. In this regard, CPU and MySQL load statistics can provide data about the site’s performance, as you can compare the numbers with your traffic statistics to decide if the Internet site should be optimized or moved to a different kind of website hosting platform that'll be able to bear the high system load in case the Internet site is very popular.
MySQL & Load Stats in Shared Web Hosting
Our system keeps comprehensive info about the system resource usage of every single shared web hosting account which is created on our top-notch cloud platform, so if you decide to host your sites with us, you'll have full access to this data from the Hepsia CP, which you'll get with the account. The CPU load statistics include the CPU time and the actual execution time of your scripts, as well as how much system memory they used. You may see what processes generated the load - PHP or Perl scripts, cron jobs, etc. The MySQL load stats section will show you the number of queries to each specific database that you have created in your shared hosting account, the total queries for the account as a whole and the typical hourly rate. Comparing these statistics to the site visitor stats shall tell you if your websites perform the way they need to or if they need some optimization, that'll improve their functionality and the overall site visitor experience.