MySQL & Load Stats
What kind of data is available in the MySQL & Load Stats section? How could you benefit from it?
If you have an HTML Internet site, it likely uses a small amount of system resources as it's static, but this isn't so with dynamic database-driven Internet sites that use PHP scripts and offer you far more features. This type of sites generate load on the hosting server anytime someone browses them, since the server requires time to execute the script, to access the database and then to deliver the content requested by the visitor's web browser. A well-known discussion board, for instance, stores all usernames and posts inside a database, so some load is created every time a thread is opened or an end user looks for a certain phrase. If lots of people access the forum concurrently, or if every single search involves checking tens of thousands of database entries, this may produce high load and affect the efficiency of the website. In this regard, CPU and MySQL load data can present you with data about the site’s efficiency, as you can compare the numbers with your traffic data to determine if the site has to be optimized or moved to a different kind of hosting platform that'll be able to bear the high system load in case the website is really popular.
MySQL & Load Stats in Shared Hosting
We generate detailed stats about the system resource usage of every shared hosting
account, so in case you host your Internet sites on our advanced cloud platform, you will be able to check out the data with only a couple of mouse clicks from your Hepsia CP. The data is provided in two different sections. The first one shall show you the length of time our system spent serving your sites, the total time it took for your scripts to be executed, how much memory sites used and what types of processes generated the load. Stats are created every 6 hours. You are able to see everyday and monthly statistics too. In the second section you will find all the databases you have created in the account and for each of them you will see the amount of hourly and daily queries. The info shall give you an accurate picture of the performance of your websites, especially if you compare it to the daily traffic and visitor data.
MySQL & Load Stats in Semi-dedicated Hosting
If you want to see detailed statistics with regards to the load generated by your Internet sites, it will not take more than just a few mouse clicks to do that. The Hepsia hosting CP, which comes with all semi-dedicated servers
we offer, features a section devoted to the system resource usage and the data there will tell you if your sites function properly and if the load they generate corresponds to the amount of received website visitors. The CPU load statistics include the script execution time and the length of time it took for the hosting server to process the requests, as well as what sorts of processes produced the load. The MySQL statistics will show you the number of times each individual database was accessed, and day-to-day and per hour stats for the entire account. With both sorts of stats, you can check the numbers for each of the past days and months, so you can easily see how the websites perform as the traffic to them rises or after you have applied some update.