MySQL & Load Stats
What kind of information is provided in the MySQL & Load Stats section? How could you take advantage of it?
If you have an HTML Internet site, in all probability it uses a small amount of resources simply because it is static, but this is not the case with dynamic database-driven sites that use PHP scripts and offer far more capabilities. This kind of websites create load on the website hosting server anytime somebody browses them, because the web server needs time to execute the script, to access the database and then to deliver the data requested by the visitor's browser. A well known discussion board, for instance, stores all usernames and posts inside a database, so some load is created each time a thread is opened or an end user looks for a particular word. If lots of people access the forum simultaneously, or if every search involves checking thousands of database entries, this could create high load and affect the performance of the Internet site. In this regard, CPU and MySQL load statistics can present you with information about the site’s overall performance, as you can compare the numbers with your traffic data to make a decision if the Internet site needs to be optimized or transferred to a different type of web hosting platform that'll be able to bear the high system load if the Internet site is really popular.
MySQL & Load Stats in Shared Web Hosting
Using the Hepsia Control Panel, included with all our shared web hosting
packages, you shall be able to to see very comprehensive stats regarding the resources your Internet sites use. One of the sections shall give you information regarding the CPU load, such as the amount of processing time the hosting server spent, how much time it took for your scripts to be executed and what amount of memory they used. Statistics are automatically generated every six hours and you can also see the different types of processes that produced the most load - PHP, Perl, etc. MySQL load stats are listed within an individual section where you are able to see all the queries on an hourly, everyday, and so forth. basis. You could go back and compare statistics from different months to see if some update has transformed the resource usage if the number of website visitors hasn't changed much. This way, you can determine if your Internet site needs to be optimized, that will give you a better functionality and an improved user experience.
MySQL & Load Stats in Semi-dedicated Servers
If you want to see thorough statistics about the load generated by your websites, it will not take more than just a few clicks to do this. The Hepsia hosting Control Panel, which comes with all semi-dedicated servers
that we offer, has a section dedicated to the system resource usage and the info there will tell you if your Internet sites function properly and if the load they generate corresponds to the amount of received website visitors. The CPU load data include the script execution time and the time it took for the server to process the requests, as well as what types of processes generated the load. The MySQL data will show you how many times every database was accessed, as well as day-to-day and hourly statistics for the entire account. With both forms of statistics, you are able to check the numbers for each of the past days and months, so you could see how sites perform as the traffic to them increases or once you've applied some update.