MySQL & Load Stats
What sort of info is provided in the MySQL & Load Stats section? How can you take advantage of it?
If you have an HTML site, it likely uses a really small amount of resources simply because it is static, but that isn't so with dynamic database-driven Internet sites that use PHP scripts and offer much more capabilities. This type of websites create load on the website hosting server when anyone browses them, due to the fact that the hosting server needs time to execute the script, to access the database and then to deliver the data requested by the visitor's Internet browser. A well-known discussion board, for example, stores all usernames and posts inside a database, so some load is created each time a thread is opened or a user looks for a specific word. If a lot of people connect to the forum concurrently, or if each and every search involves checking tens of thousands of database entries, this may generate high load and affect the performance of the website. In this regard, CPU and MySQL load statistics can present you with data about the site’s performance, as you can compare the numbers with your traffic data to decide if the website has to be optimized or transferred to a new type of hosting platform which will be able to bear the high system load in the event that the site is extremely popular.
-
MySQL & Load Stats in Website Hosting
We create detailed stats about the system resource usage of every single
website hosting account, so in case you host your websites on our advanced cloud platform, you'll be able to check the data with just a couple of clicks from your Hepsia Control Panel. The data is offered in two different sections. The first one will show you the amount of time our system spent serving your Internet sites, the total time it took for your scripts to be executed, the amount of memory the sites used and what types of processes generated the load. Stats are produced every 6 hours. You are able to see day-to-day and month-to-month stats too. In the second section you shall find all of the databases that you have created in the account and for each and every one of them you'll see the number of per hour and day-to-day queries. The info will give you an accurate picture of the efficiency of your Internet sites, especially if you compare it to the daily traffic and visitor stats.
-
MySQL & Load Stats in Semi-dedicated Servers
As our system keeps thorough statistics for the load that each
semi-dedicated server account produces, you will be aware of how your Internet sites perform at any time. As soon as you log in to the Hepsia Control Panel, provided with each account, you can check out the section dedicated to the system load. There, you can 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 generated the load - cron jobs, PHP pages, Perl scripts, and so on. You could also see the total number of queries to each and every database within your semi-dedicated account, the total everyday numbers for the account overall, plus the average hourly rate. With both the CPU and the MySQL load statistics, you may always go back to past days or months and evaluate the performance of your websites after some update or after a significant boost in the number of your site visitors.