MySQL & Load Stats
What sort of information is available in the MySQL & Load Stats section? How could you take advantage of it?
If you have an HTML site, it likely uses a small amount of system resources simply because it's static, but that isn't so with dynamic database-driven websites that use PHP scripts and offer far more capabilities. This kind of sites create load on the web hosting server every time anyone browses them, due to the fact that the web server needs time to execute the script, to access the database and then to supply the info requested by the visitor's browser. A well known discussion board, as an illustration, stores all usernames and posts in a database, so some load is produced any time a thread is opened or an end user looks for a certain phrase. If many people access the forum simultaneously, or if each search involves checking a large number of database entries, this may create high load and affect the efficiency of the website. In this regard, CPU and MySQL load statistics can provide you with data about the site’s performance, as you can compare the numbers with your traffic stats to decide if the site must be optimized or migrated to another kind of hosting platform which will be able to bear the high system load in case the Internet site is really popular.
-
MySQL & Load Stats in Website Hosting
We produce detailed stats about the system resource usage of each
website hosting account, so in case you host your websites on our sophisticated cloud platform, you'll be able to take a look at the data with only a few clicks from your Hepsia Control Panel. The data is provided in two different sections. The first one shall show you the amount of time our system spent serving your Internet sites, the total time it took for your scripts to be executed, what amount of memory sites used and what types of processes created the load. Stats are generated every six hours. You are able to see everyday and monthly data as well. In the second section you'll find all the databases that you've created in the account and for each and every one of them you will see the total amount of hourly and day-to-day queries. The data will give you a detailed picture of the efficiency of your sites, especially if you compare it to the daily traffic and visitor statistics.
-
MySQL & Load Stats in Semi-dedicated Servers
Because our system keeps detailed statistics 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, supplied with each and every account, you can go to 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 types of processes created the load - cron jobs, PHP pages, Perl scripts, etc. You can also see the total number of queries to every single database in your semi-dedicated account, the total day-to-day stats for the account as a whole, as well as the average hourly rate. With both the CPU and the MySQL load data, you could always go back to past days or months and assess the performance of your Internet sites after some update or after a considerable boost in the number of your visitors.