MySQL & Load Stats
What type of data is provided in the MySQL & Load Stats section? How could you take advantage of it?
If you have an HTML website, most likely it uses a very small amount of system resources because it is static, but that isn't the situation with dynamic database-driven sites that use PHP scripts and provide way more functions. This type of websites create load on the web hosting server when someone browses them, because the hosting server requires time to execute the script, to access the database and then to provide the information requested by the visitor's Internet browser. A well known discussion board, for instance, stores all usernames and posts inside a database, so some load is generated every single time a thread is opened or an end user looks for a particular word. If lots of people connect to the forum all at once, or if every search involves checking a large number of database entries, this can create high load and affect the efficiency of the Internet site. In this regard, CPU and MySQL load statistics can present you with data about the site’s efficiency, as you can compare the numbers with your traffic statistics to determine if the site has to 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 popular.
-
MySQL & Load Stats in Website Hosting
If you host your sites within a
website hosting account with our company, you shall have access to detailed CPU and MySQL stats that will permit you to keep tabs on their performance. You could see the statistics with a few clicks inside your Hepsia CP. The CPU Load section can tell you the total time the server spent on your scripts and what amount of memory was required, plus 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 stats from the previous months. The MySQL Load section offer additional information about the number of queries to every database that you have set up within the account. Once again, you can see month-to-month, everyday and hourly data, that'll give you information that is different from the traffic or the number of visitors which you get. That way, you can determine if the websites need some optimization.
-
MySQL & Load Stats in Semi-dedicated Hosting
Due to the fact that our system keeps comprehensive stats for the load that every
semi-dedicated server account generates, you'll be aware of how your websites perform at any time. As soon as you log in to the Hepsia CP, included with every single account, you can 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 time it took for the scripts to be actually executed and what sorts of processes created the load - cron jobs, PHP pages, Perl scripts, etc. You can also see the amount of queries to each database inside your semi-dedicated account, the total everyday figures for the account as a whole, and also the average hourly rate. With both the CPU and the MySQL load stats, you could always go back to past days or months and evaluate the efficiency of your sites after some update or after a substantial rise in the number of your website visitors.