MySQL & Load Stats
See the kind of data is gathered in the MySQL & Load Stats area and the way you can benefit from it.
If you have an HTML Internet site, it likely uses a really small amount of resources because it's static, but this is not the situation with dynamic database-driven sites that use PHP scripts and provide you with way more features. This sort of websites produce load on the hosting server when somebody browses them, since the web server needs time to execute the script, to access the database and then to deliver the information requested by the visitor's browser. A widely used discussion board, as an illustration, stores all usernames and posts in a database, so some load is generated every single time a thread is opened or a user looks for a given name. If a lot of people connect to the forum simultaneously, or if every single search involves checking thousands of database entries, this can create high load and affect the overall performance of the Internet site. In this regard, CPU and MySQL load statistics can provide information about the site’s functionality, as you can compare the numbers with your traffic statistics to decide if the website must be optimized or migrated to a different kind of hosting platform which will be able to bear the high system load if the website is really popular.
-
MySQL & Load Stats in Shared Web Hosting
Our system keeps comprehensive information about the system resource usage of each and every
shared web hosting account that's set up on our top-notch cloud platform, so if you choose to host your Internet sites with our company, you'll have full access to this information from the Hepsia CP, which you will get with the account. The CPU load stats 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 forth. The MySQL load stats section will show you the total amount queries to each particular database you have created in your shared hosting account, the total queries for the account as a whole and the typical hourly rate. Comparing these numbers to the visitor data will tell you if your sites perform the way they have to or if they require some optimization, that'll improve their performance and the overall website visitor experience.
-
MySQL & Load Stats in Semi-dedicated Hosting
If you would like to see comprehensive statistics regarding the load produced by your websites, it won't take more than a couple of mouse clicks to do this. The Hepsia hosting Control Panel, provided with all
semi-dedicated servers that we offer, features a section committed to the system resource usage and the info there will tell you if your websites perform well and if the load they create corresponds to the total amount of received site visitors. The CPU load statistics include the script execution time and the length of time it took for the server to process the requests, as well as what types of processes generated the load. The MySQL statistics will show you how frequently each individual database was accessed, and everyday and per hour data for the entire account. With both forms of statistics, you can check the numbers for every one of the past days and months, so you could see how sites perform as the traffic to them grows or once you've applied some update.