MySQL & Load Stats
See the kind of data is gathered in the MySQL & Load Stats area and the way you can benefit from it.
If you have an HTML site, in all probability it uses a very small amount of system resources due to the fact that it is static, but this isn't the situation with dynamic database-driven sites that use PHP scripts and provide you with considerably more functions. This type of sites create load on the hosting server each time somebody browses them, due to the fact that the hosting server requires time to execute the script, to access the database and then to provide the info requested by the visitor's browser. A popular discussion board, for example, stores all usernames and posts within a database, so some load is generated each time a thread is opened or an end user looks for a particular word. If many people connect to the forum all at once, or if every search involves checking thousands of database entries, this can generate high load and affect the overall performance of the Internet site. In this regard, CPU and MySQL load statistics can give you information about the site’s overall performance, as you can compare the numbers with your traffic data to decide if the website should be optimized or moved to a new type of website hosting platform which will be able to bear the high system load if the Internet site is really popular.
MySQL & Load Stats in Shared Hosting
We create comprehensive data about the system resource usage of every single shared hosting
account, so in case you host your sites on our advanced cloud platform, you shall be able to check out the data with just a few clicks from your Hepsia Control Panel. The data is supplied in two different sections. The first one shall show you how much time our system spent serving your sites, the total time it took for your scripts to be executed, how much memory the sites used and what kinds of processes created the load. Stats are created every six hours. You are able to see day-to-day and month-to-month stats too. In the second section you will discover all of the databases you have created in the account and for each one of them you will see the amount of hourly and day-to-day queries. The info will give you an accurate picture of the overall performance of your sites, specifically if you compare it to the daily traffic and visitor data.
MySQL & Load Stats in Semi-dedicated Servers
Our system generates in depth stats about both different kinds of load, so if you purchase a semi-dedicated server
for your Internet sites, you can access the data with a few clicks in your Hepsia hosting CP. Each type of info is listed in its own section. The CPU Load section shall tell you exactly what processes generated the load and the time it took for the server to execute all the requests. Though stats are produced every six hours, you can see day by day and monthly stats too. In the MySQL Load section you'll find a list of all the databases produced inside your semi-dedicated account manually and automatically, what number of queries were sent to every one of them, the total day-to-day queries for the account overall, as well as the average hourly rate. This information will help you figure out how well your Internet sites perform and if each of them needs optimization of some sort.