MySQL & Load Stats
What type of information is provided in the MySQL & Load Stats section? How can you make use of it?
If you have an HTML Internet site, it likely uses a really small amount of system resources because it's static, but that isn't so with dynamic database-driven websites that use PHP scripts and provide considerably more functions. This type of Internet sites create load on the website hosting server every time anyone browses them, simply because the web server requires time to execute the script, to access the database and then to supply the information requested by the visitor's browser. A well known discussion board, for example, stores all usernames and posts inside a database, so some load is produced each time a thread is opened or an end user looks for a particular word. If a lot of people connect to the forum concurrently, or if each and every search involves checking a large number of database entries, this can generate high load and affect the functionality of the Internet site. In this regard, CPU and MySQL load data can present you with data about the site’s performance, as you can compare the numbers with your traffic stats to decide if the website must be optimized or migrated to a new sort of hosting platform that will be able to bear the high system load in case the site is popular.
MySQL & Load Stats in Cloud Hosting
If you host your websites in a cloud hosting
account with our company, you'll have access to comprehensive CPU and MySQL data that will allow you to keep tabs on their overall performance. You could see the stats with a number of mouse clicks within your Hepsia Control Panel. The CPU Load section can tell you the total time the hosting server spent on your scripts and what amount of memory was needed, plus the time it took for the scripts to be executed. The day-to-day view is the standard one, but you can also see the numbers from the past months. The MySQL Load section offer you more details about the amount of queries to each database that you have set up inside the account. Once again, you are able to see month-to-month, day-to-day and hourly data, which will give you information that is different from the traffic or the number of visitors which you get. Thus, you can see if the sites require some optimization.
MySQL & Load Stats in Semi-dedicated Servers
Because our system keeps in depth statistics for the load that every semi-dedicated server
account generates, you will be aware of how your Internet sites perform at any time. Once you log in to the Hepsia CP, supplied with every single account, you should check out the section dedicated to the system load. In it, you can easily 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 generated the load - cron jobs, PHP pages, Perl scripts, etcetera. You can also see the number of queries to each database in your semi-dedicated account, the total daily stats for the account as a whole, and also the average hourly rate. With both the CPU and the MySQL load data, you can always go back to past days or months and assess the functionality of your sites after some update or after a considerable rise in the number of your site visitors.