MySQL & Load Stats
Discover which kind of data is gathered in the MySQL & Load Stats section and the way you'll be able to take advantage of it.
If you have an HTML Internet site, it probably uses a very small amount of resources due to the fact that it is static, but this isn't the situation with dynamic database-driven websites that use PHP scripts and offer much more features. Such sites create load on the hosting server when somebody browses them, simply because the hosting server requires time to execute the script, to access the database and then to provide the data requested by the visitor's web browser. A widely used discussion board, as an illustration, stores all usernames and posts in a database, so some load is generated each time a thread is opened or an end user searches for a certain word. If a lot of people connect to the forum simultaneously, or if each search involves checking a large number of database entries, this could generate high load and affect the efficiency of the website. In this regard, CPU and MySQL load stats can provide info about the site’s overall performance, as you can compare the numbers with your traffic data to make a decision if the website has to be optimized or migrated to a different type of website hosting platform that'll be able to bear the high system load in case the site is very popular.
MySQL & Load Stats in Shared Web Hosting
Our system keeps detailed info about the system resource usage of each shared web hosting
account that's set up on our top-notch cloud platform, so given that you opt to host your Internet sites with our company, you shall have full access to this info through the Hepsia Control Panel, which you shall get with the account. The CPU load data feature the CPU time and the actual execution time of your scripts, and how much system memory they used. You may also see what processes produced the load - PHP or Perl scripts, cron jobs, etc. The MySQL load stats section will show you the number of queries to each specific database you have created within your shared hosting account, the total queries for the account altogether and the standard hourly rate. Comparing these numbers to the visitor statistics will tell you if your websites perform the way they ought to or if they require some optimization, that will improve their functionality and the overall website visitor experience.
MySQL & Load Stats in Semi-dedicated Hosting
Due to the fact that our system keeps thorough stats for the load which every semi-dedicated server
account generates, you will be aware of how your websites perform at any time. After you log in to the Hepsia Control Panel, included with each and every account, you can go to the section committed to the system load. There, you can easily see the processing time our system spent on your scripts, the span of time it took for the scripts to be actually executed and what kinds of processes created the load - cron jobs, PHP pages, Perl scripts, and so on. You could also see the number of queries to each and every database inside your semi-dedicated account, the total everyday numbers for the account as a whole, along with the average hourly rate. With both the CPU and the MySQL load statistics, you could always go back to past days or months and assess the general performance of your websites after some update or after a sizeable increase in the number of your site visitors.