MySQL & Load Stats
What kind of information is provided in the MySQL & Load Stats section? How can you take advantage of it?
If you have an HTML website, in all probability it uses a small amount of resources as it is static, but this is not the situation with dynamic database-driven Internet sites that use PHP scripts and provide considerably more functions. This sort of websites produce 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 deliver the content requested by the visitor's browser. A widely used discussion board, for example, stores all usernames and posts in a database, so some load is created every single time a thread is opened or an end user looks for a certain term. If a lot 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 functionality of the Internet site. In this regard, CPU and MySQL load stats can provide information about the site’s overall performance, as you can compare the numbers with your traffic stats and see if the website has to be optimized or transferred to a new type of web hosting platform which will be able to bear the high system load in case the website is really popular.
MySQL & Load Stats in Semi-dedicated Servers
If you have a semi-dedicated server account with us, you'll be able to access quite comprehensive CPU and MySQL load stats that'll give you addiitional information about the performance of your websites. 2 sections of the Hepsia Control Panel are committed to the statistics, one for every kind. In the CPU Load section you are able to see the execution time of your scripts and how much time the server processed them. You can even see the different types of processes that were executed. Statistics are produced every six hours, but if needed, you could also check data for previous days or months. The MySQL Load section will show you the entire amount of database queries each day and each hour, and also the queries to each individual database which you have inside your semi-dedicated account. Comparing this info to your traffic stats will give you important information about how your sites perform and you will see if you need to take some measures to improve them.