MySQL & Load Stats
View what sort of data is gathered in the MySQL & Load Stats section and in what ways it is possible to benefit from it.
If you have an HTML site, in all probability it uses a really small amount of system resources as it's static, but that isn't the situation with dynamic database-driven Internet sites that use PHP scripts and offer considerably more capabilities. This sort of sites generate load on the web hosting server each time somebody browses them, due to the fact that the server needs time to execute the script, to access the database and then to supply the data requested by the visitor's web browser. A popular discussion board, for example, stores all usernames and posts in a database, so some load is generated any time a thread is opened or a user looks for a specific phrase. If a lot of people connect to the forum simultaneously, or if every single search involves checking tens of thousands of database entries, this could produce high load and affect the performance of the site. In this regard, CPU and MySQL load statistics can provide you with data about the site’s efficiency, as you can compare the numbers with your traffic stats to determine if the website needs to be optimized or transferred to a new sort of website hosting platform which will be able to bear the high system load if 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 is created on our top-notch cloud platform, so given that you opt to host your sites with our company, you'll have full access to this info from the Hepsia CP, which you will get with the account. The CPU load statistics include the CPU time and the actual execution time of your scripts, along with how much system memory they used. You may also see what processes created the load - PHP or Perl scripts, cron jobs, and so on. The MySQL load statistics section will show you the total amount queries to each particular database you have created within your shared hosting account, the total queries for the account as a whole and the standard hourly rate. Comparing these figures to the website visitor data will tell you if your sites perform the way they need to or if they require some optimization, which will improve their functionality and the overall visitor experience.
MySQL & Load Stats in Semi-dedicated Hosting
Our system generates in depth statistics about both different types of load, so if you acquire a semi-dedicated server
for your Internet sites, you can access the information with just a few mouse clicks within your Hepsia hosting Control Panel. Every type of info is listed in its own section. The CPU Load section will tell you exactly what processes produced the load and the length of time it took for the server to execute all of the requests. Although statistics are produced every 6 hours, you can see daily and per month stats too. In the MySQL Load section you'll find a list of all the databases created in your semi-dedicated account manually and automatically, how many queries were sent to each one of them, the total day-to-day queries for the account in general, plus the average hourly rate. This data will help you see how well your websites perform and if any one of them requires optimization of some kind.