MySQL & Load Stats
What type of information is available in the MySQL & Load Stats section? How could you make use of it?
If you have an HTML site, in all probability it uses a small amount of system resources simply because it is static, but this isn't so with dynamic database-driven Internet sites that use PHP scripts and provide a lot more features. This kind of websites create load on the website hosting server each time somebody browses them, as the server needs time to execute the script, to access the database and then to supply the data requested by the visitor's browser. A widely used discussion board, for example, stores all usernames and posts within a database, so some load is produced any time a thread is opened or a user looks for a specific phrase. If lots of people connect to the forum at the same time, or if every single search involves checking thousands of database entries, this could create high load and affect the efficiency of the Internet site. In this regard, CPU and MySQL load stats can provide information about the site’s performance, as you can compare the numbers with your traffic stats to determine if the website should be optimized or transferred to a different kind of website hosting platform which will be able to bear the high system load if the Internet site is extremely popular.
-
MySQL & Load Stats in Shared Web Hosting
If you host your Internet sites in a
shared web hosting account with our company, you shall have access to comprehensive CPU and MySQL stats which will allow you to monitor their operation. You can easily see the statistics with a number of mouse clicks within your Hepsia CP. The CPU Load section can tell you the total time period the server spent on your scripts and how much memory was needed, and the time it took for the scripts to be executed. The daily view is the standard one, but you could also see the data from the preceding months. The MySQL Load section offer more info about the total amount of queries to each and every database that you have created inside the account. Once again, you can see per month, day-to-day and hourly stats, which will give you data that's different from the traffic or the number of visitors you get. This way, you can determine if the sites need some optimization.
-
MySQL & Load Stats in Semi-dedicated Hosting
As our system keeps comprehensive stats for the load which every
semi-dedicated server account produces, you'll be aware of how your sites perform at any time. As soon as you log in to the Hepsia Control Panel, which comes with each and every account, you should check out the section devoted to the system load. In it, you will 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. You may also see the amount of queries to every database inside your semi-dedicated account, the total daily statistics for the account as a whole, and also the average hourly rate. With both the CPU and the MySQL load data, you may always go back to past days or months and examine the overall performance of your websites after some update or after a sizeable increase in the number of your website visitors.