MySQL & Load Stats
Discover what type of information is gathered in the MySQL & Load Stats section and in what ways you'll be able to take advantage of it.
If you have an HTML site, it probably uses a small amount of system resources simply because it's static, but this isn't the situation with dynamic database-driven sites that use PHP scripts and offer you considerably more functions. This type of Internet sites create load on the website hosting server anytime anyone browses them, since the hosting server requires time to execute the script, to access the database and then to supply the information requested by the visitor's browser. A famous discussion board, for instance, stores all usernames and posts within a database, so some load is generated every single time a thread is opened or an end user searches for a particular phrase. If lots of people access the forum concurrently, or if every single search involves checking thousands of database entries, this can create high load and affect the overall performance of the website. In this regard, CPU and MySQL load stats can present you with data about the site’s efficiency, as you can compare the numbers with your traffic data and see if the site should be optimized or moved to a different type of website hosting platform which will be able to bear the high system load if the website is popular.
MySQL & Load Stats in Shared Hosting
If you host your sites inside a shared hosting
account with us, you shall have access to thorough CPU and MySQL stats which will allow you to keep an eye on their functionality. You could see the statistics with a couple of clicks within your Hepsia CP. The CPU Load section will show you the total time the server spent on your scripts and how much memory was required, as well as the time it took for the scripts to be executed. The day-to-day view is the standard one, but you can also see the numbers from the preceding months. The MySQL Load section offer additional information about the total amount of queries to every database that you have created inside the account. Once again, you are able to see month-to-month, daily and hourly data, that will give you data which is different from the traffic or the number of visitors that you get. Thus, you can see if the Internet sites need some optimization.
MySQL & Load Stats in Semi-dedicated Hosting
If you would like to see thorough stats for the load created by your Internet sites, it won't take more than a few mouse clicks to do this. The Hepsia hosting Control Panel, included with all semi-dedicated servers
that we offer, has a section devoted to the system resource usage and the information there will tell you if your sites operate properly and if the load they produce corresponds to the total amount of received website visitors. The CPU load stats include the script execution time and the amount of time it took for the web server to process the requests, plus what kinds of processes created the load. The MySQL statistics shall show you the number of times each individual database was accessed, and everyday and per hour stats for the entire account. With both types of stats, you'll be able to check the numbers for each of the past days and months, so you can easily see how sites perform as the traffic to them grows or once you've applied some update.