If you have an HTML site, it likely uses a small amount of system resources simply because it is static, but that isn't the situation with dynamic database-driven sites that use PHP scripts and offer considerably more features. This type of websites create load on the website hosting server each time anyone 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 data requested by the visitor's Internet browser. A well known discussion board, for example, stores all usernames and posts in a database, so some load is created every time a thread is opened or a user searches for a particular phrase. If a lot of people connect to the forum concurrently, or if each search involves checking hundreds of 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 provide you with info about the site’s functionality, as you can compare the numbers with your traffic data and see if the Internet site has to be optimized or migrated to a different kind of web hosting platform that will be able to bear the high system load in the event that the site is very popular.
MySQL & Load Stats in Website Hosting
Using the Hepsia Control Panel, bundled with all of our website hosting
offers, you'll be able to see rather comprehensive statistics concerning the system resources that your websites use. One of the sections shall give you information about the CPU load, like how much processing time the server spent, how much time it took for your scripts to be executed and what amount of memory they used. Stats are automatically provided every six hours and you could also see the types of processes that generated the most load - PHP, Perl, and so forth. MySQL load statistics are listed within a different section in which you'll be able to see all the queries on an hourly, daily, and so on. basis. You'll be able to go back and compare stats from various months to find out if some update has altered the resource usage if the number of website visitors hasn't changed much. In this way, you can see if your Internet site needs to be optimized, which will lead to a better performance and an improved user experience.
MySQL & Load Stats in Semi-dedicated Hosting
If you have a semi-dedicated server
account with our company, you'll be able to access quite comprehensive CPU and MySQL load data that will give you more information about the efficiency of your sites. 2 sections of the Hepsia CP are devoted to the statistics, one for each and every type. Within the CPU Load section you are able to see the execution time of your scripts and the amount of time the web server processed them. Additionally you can see the kinds of processes which were executed. Statistics are created every 6 hours, but if needed, you may also check figures for previous days or months. The MySQL Load section will show you the total amount of database queries per day and each hour, along with the queries to each individual database you have within your semi-dedicated account. Comparing this data to your traffic stats shall give you important info about how your Internet sites perform and you will see if you have to take some measures to improve them.