MySQL & Load Stats
What sort of info is available in the MySQL & Load Stats section? How could you benefit from it?
If you have an HTML site, most likely it uses a small amount of system resources because it is static, but that isn't so with dynamic database-driven Internet sites that use PHP scripts and offer you way more capabilities. Such sites generate load on the hosting server when somebody browses them, due to the fact that the hosting server requires time to execute the script, to access the database and then to supply the content requested by the visitor's browser. A popular discussion board, for example, stores all usernames and posts within a database, so some load is produced every single time a thread is opened or a user searches for a certain term. If lots of people access the forum concurrently, or if each and every search involves checking a large number of database entries, this may produce high load and affect the functionality of the Internet site. In this regard, CPU and MySQL load data can provide info about the site’s functionality, as you can compare the numbers with your traffic statistics to determine if the site has to be optimized or transferred to another type of website hosting platform that will be able to bear the high system load in the event that the website is popular.
-
MySQL & Load Stats in Website Hosting
If you host your Internet sites in a
website hosting account with us, you will have access to detailed CPU and MySQL statistics which will allow you to keep track of their performance. You are able to see the statistics with a couple of clicks inside your Hepsia Control Panel. The CPU Load section will show you the total time frame the hosting server spent on your scripts and what amount of memory was needed, and the time it took for the scripts to be executed. The daily view is the default one, but you are able to also see the numbers from the previous months. The MySQL Load section give you more info about the number of queries to each database that you have set up inside the account. Once again, you can easily see month-to-month, everyday and per hour stats, that shall give you info that's different from the traffic or the number of visitors that you get. In this way, you can identify if the Internet sites require some optimization.
-
MySQL & Load Stats in Semi-dedicated Hosting
Due to the fact that our system keeps detailed stats for the load that each
semi-dedicated server account generates, you will be aware of how your websites perform at any time. As soon as you log in to the Hepsia Control Panel, provided with each account, you can go to the section dedicated to the system load. In it, you can see the processing time our system spent on your scripts, the 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. Also you can see the number of queries to each database within your semi-dedicated account, the total day-to-day figures for the account altogether, as well as the average hourly rate. With both the CPU and the MySQL load stats, you may always go back to past days or months and evaluate the performance of your Internet sites after some update or after a sizeable rise in the number of your website visitors.