MySQL & Load Stats
The MySQL & Load Stats will silently gather data while your website is working. Discover why you should check them out regularly.
If you have an HTML Internet site, most likely it uses a small amount of system resources as it is static, but that isn't so with dynamic database-driven websites that use PHP scripts and offer you far more capabilities. Such websites produce load on the hosting server each time somebody browses them, due to the fact that the web server requires time to execute the script, to access the database and then to provide the info requested by the visitor's Internet browser. A famous discussion board, for example, stores all usernames and posts in a database, so some load is produced every time a thread is opened or an end user looks for a given phrase. If lots of people connect to the forum all at once, or if every single search involves checking thousands of database entries, this could generate high load and affect the performance of the website. In this regard, CPU and MySQL load stats can provide info about the site’s performance, as you can compare the numbers with your traffic statistics to determine if the Internet site needs to be optimized or moved to another sort of website hosting platform that will be able to bear the high system load if the site is very popular.
-
MySQL & Load Stats in Cloud Web Hosting
Our system keeps detailed info about the system resource usage of every single
cloud web hosting account that is created on our top-notch cloud platform, so in case you opt to host your sites with us, you will have full access to this info via the Hepsia Control Panel, which you will get with the account. The CPU load stats feature the CPU time and the actual execution time of your scripts, and how much system memory they used. You can also see what processes generated the load - PHP or Perl scripts, cron jobs, etcetera. The MySQL load statistics section will show you the total amount queries to each particular database you have created inside your shared hosting account, the total queries for the account overall and the typical hourly rate. Comparing these statistics to the visitor stats will tell you if your websites perform the way they need to or if they require some optimization, which will improve their overall performance and the overall visitor experience.
-
MySQL & Load Stats in Semi-dedicated Hosting
If you want to see comprehensive stats regarding the load generated by your websites, it will not take more than several mouse clicks to do that. The Hepsia hosting Control Panel, which comes with all
semi-dedicated servers we offer, features a section committed to the system resource usage and the data there can tell you if your websites function properly and if the load they create corresponds to the number of received site visitors. The CPU load data include the script execution time and the amount of time it took for the hosting server to process the requests, and also what types of processes produced the load. The MySQL data will show you how often every database was accessed, and everyday and by the hour stats for the whole account. With both types of statistics, you'll be able to check the numbers for every one of the past days and months, so you can easily see how the sites perform as the traffic to them increases or once you've applied some update.