MySQL & Load Stats
What type of information is available in the MySQL & Load Stats section? How can you take full advantage of it?
If you have an HTML site, it probably uses a really small amount of resources as it is static, but this is not so with dynamic database-driven websites that use PHP scripts and provide you with far more functions. This type of sites produce load on the web hosting server when someone browses them, due to the fact that the server needs time to execute the script, to access the database and then to deliver the info requested by the visitor's Internet browser. A well known discussion board, for example, stores all usernames and posts within a database, so some load is generated every single time a thread is opened or an end user looks for a given word. If lots of people access the forum concurrently, or if every single search involves checking thousands of database entries, this may produce high load and affect the overall performance of the Internet site. In this regard, CPU and MySQL load stats can give you info about the site’s efficiency, as you can compare the numbers with your traffic data and see if the Internet site has to be optimized or migrated to another sort of hosting platform that will be able to bear the high system load in case the website is extremely popular.
MySQL & Load Stats in Hosting
If you host your sites inside a hosting
account with us, you'll have access to in depth CPU and MySQL data which will allow you to keep an eye on their performance. You can easily see the statistics with a number of mouse clicks within your Hepsia CP. The CPU Load section will reveal to you the total time the server spent on your scripts and just how much memory was needed, plus the time it took for the scripts to be executed. The daily view is the default one, but you'll be able to also see the statistics from the preceding months. The MySQL Load section offer more details about the amount of queries to each database that you have created within the account. Once again, you can see per month, daily and hourly stats, that'll give you information that is different from the traffic or the number of visitors you get. In this way, you can determine if the sites require some optimization.
MySQL & Load Stats in Semi-dedicated Hosting
If you need to see comprehensive statistics about the load created 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
which we offer, features a section devoted to the system resource usage and the info there can tell you if your Internet sites perform well and if the load they generate corresponds to the total amount of received website visitors. The CPU load statistics include the script execution time and the length of time it took for the hosting server to process the requests, as well as what sorts of processes produced the load. The MySQL data will show you how frequently each individual database was accessed, as well as everyday and by the hour stats for the whole account. With both kinds of statistics, you'll be able to check the numbers for any 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.