MySQL & Load Stats
What sort of data is available in the MySQL & Load Stats section? How could you take advantage of it?
If you have an HTML website, it likely uses a really small amount of system resources because it is static, but this isn't so with dynamic database-driven websites that use PHP scripts and provide you with far more features. Such websites produce load on the hosting server each and every time someone browses them, as the server requires time to execute the script, to access the database and then to supply the info requested by the visitor's web browser. A famous discussion board, as an illustration, stores all usernames and posts inside a database, so some load is generated every single time a thread is opened or a user looks for a certain name. If a lot of people connect to the forum simultaneously, or if each and every search involves checking hundreds of 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 give you info about the site’s performance, as you can compare the numbers with your traffic statistics to decide if the website has to be optimized or moved to another kind of website hosting platform that will be able to bear the high system load in the event that the site is popular.
MySQL & Load Stats in Shared Web Hosting
Using the Hepsia CP, bundled with all our shared web hosting
packages, you'll be able to see very detailed data concerning the resources which your sites use. One of the sections will give you information about the CPU load, such as the amount of processing time the server spent, how much time it took for your scripts to be executed and exactly how much memory they used. Statistics are automatically generated every 6 hours and you can also see the different kinds of processes that produced the most load - PHP, Perl, and so on. MySQL load data are listed in a separate section in which you can see all the queries on an hourly, daily, and so on. basis. You can go back and compare stats from different months to find out whether some update has altered the resource usage if the amount of visitors has not changed much. That way, you can determine if your Internet site needs to be optimized, that will result in a better general performance and an improved user experience.
MySQL & Load Stats in Semi-dedicated Hosting
As our system keeps detailed statistics for the load that each semi-dedicated server
account produces, you shall be aware of how your websites perform at any time. When you log in to the Hepsia Control Panel, which comes with each and every account, you should check out the section committed to the system load. There, you will see the processing time our system spent on your scripts, the span of time it took for the scripts to be actually executed and what types of processes produced the load - cron jobs, PHP pages, Perl scripts, and so on. You can also see the amount of queries to every database in your semi-dedicated account, the total daily numbers for the account as a whole, as well as the average hourly rate. With both the CPU and the MySQL load statistics, you may always go back to past days or months and review the general performance of your websites after some update or after a major increase in the number of your site visitors.