MySQL & Load Stats
Observe what sort of data is gathered in the MySQL & Load Stats area and how it is possible to make the most of it.
If you have an HTML Internet site, most likely it uses a very small amount of system resources due to the fact that it's static, but this isn't the situation with dynamic database-driven websites that use PHP scripts and offer you a lot more capabilities. This sort of Internet sites create load on the website hosting server when somebody browses them, due to the fact that the server requires time to execute the script, to access the database and then to provide the information requested by the visitor's browser. A popular discussion board, as an illustration, stores all usernames and posts within a database, so some load is generated any time a thread is opened or a user searches for a specific word. If lots of people access the forum simultaneously, or if every single search involves checking a large number of database entries, this can create high load and affect the efficiency of the site. In this regard, CPU and MySQL load stats can give you data about the site’s efficiency, as you can compare the numbers with your traffic statistics to decide if the website has to be optimized or migrated to a different kind of website hosting platform that'll be able to bear the high system load in case the website is very popular.
MySQL & Load Stats in Cloud Web Hosting
Our system keeps detailed info about the system resource usage of each cloud web hosting
account which is created on our top-notch cloud platform, so if you opt to host your Internet sites with us, you will have full access to this info from the Hepsia CP, which you will get with the account. The CPU load stats include the CPU time and the actual execution time of your scripts, along with how much system memory they used. You may see what processes produced the load - PHP or Perl scripts, cron jobs, and so on. The MySQL load data section will show you the number of queries to each specific database that you have created in your shared hosting account, the total queries for the account altogether and the normal hourly rate. Comparing these figures to the visitor statistics shall tell you if your sites perform the way they have to or if they need some optimization, that'll improve their efficiency and the overall site visitor experience.
MySQL & Load Stats in Semi-dedicated Servers
Our system produces comprehensive stats about the two different types of load, so if you purchase a semi-dedicated server
for your sites, you can access the data with a few clicks inside your Hepsia hosting CP. Every type of data is listed within its own section. The CPU Load section will show you which processes generated the load and the span of time it took for the hosting server to execute all the requests. Although stats are produced every 6 hours, you can see day-to-day and monthly statistics too. In the MySQL Load section you will find a list of all the databases created within your semi-dedicated account manually and automatically, what amount of queries were sent to each of them, the total daily queries for the account as a whole, as well as the average per hour rate. This information will help you see how well your sites perform and if any one of them needs optimization of some type.