MySQL & Load Stats
What kind of information is accessible in the MySQL & Load Stats section? How can you take full advantage of it?
The CPU load depends on the time a hosting server spends executing a script every time a visitor opens a webpage on a particular script-driven site. Static HTML Internet sites use barely any CPU time, but it is not so with the considerably more complex and functional scripts, that use a database and display dynamic content. The more individuals open this type of an Internet site, the more load shall be produced on the hosting server and if the database is large, the MySQL server shall be loaded as well. An example of what can cause high load is an Internet store with a huge number of products. If it is popular, lots of people shall be browsing it simultaneously and if they look for items, the whole database which contains all the products will also be frequently accessed by the script, resulting in high load. In this light, having CPU and MySQL load statistics can provide an idea of how the website is doing, if it has to be optimized or if you simply need a more effective hosting solution - if the site is extremely popular and the established setup can't handle the load.
-
MySQL & Load Stats in Shared Hosting
If you host your sites within a
shared hosting account with our company, you shall have access to thorough CPU and MySQL stats that will allow you to keep track of their functionality. You can see the stats with a number of clicks within your Hepsia Control Panel. The CPU Load section will show you the total time the web 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 standard one, but you can also see the stats from the previous months. The MySQL Load section will provide you with more info about the number of queries to each and every database that you have set up in the account. Once again, you are able to see monthly, day-to-day and per hour statistics, that'll give you information that's different from the traffic or the number of visitors that you get. In this way, you can identify if the websites require some optimization.
-
MySQL & Load Stats in Semi-dedicated Servers
As our system keeps in depth stats for the load which each
semi-dedicated server account generates, you'll be aware of how your Internet sites perform at any time. When you log in to the Hepsia CP, which comes with every account, you can check out the section dedicated to the system load. In it, you are able to see the processing time our system spent on your scripts, the length of time it took for the scripts to be actually executed and what kinds of processes created the load - cron jobs, PHP pages, Perl scripts, etcetera. Also you can see the amount of queries to every database within your semi-dedicated account, the total day-to-day figures for the account altogether, and also the average hourly rate. With both the CPU and the MySQL load statistics, you could always go back to past days or months and compare the performance of your sites after some update or after a major rise in the number of your website visitors.