MySQL & Load Stats
What kind of information is accessible in the MySQL & Load Stats section? How do you make use of it?
If you have an HTML website, it likely uses a really small amount of resources due to the fact that it is static, but that isn't so with dynamic database-driven Internet sites that use PHP scripts and offer you far more functions. This type of websites generate load on the web hosting server when somebody browses them, since the hosting server requires time to execute the script, to access the database and then to provide the information requested by the visitor's web browser. A well known discussion board, as an illustration, stores all usernames and posts inside a database, so some load is produced every time a thread is opened or an end user searches for a given name. If a lot of people access the forum concurrently, or if every search involves checking a large number of database entries, this may create high load and affect the functionality of the site. In this regard, CPU and MySQL load statistics can provide information about the site’s performance, as you can compare the numbers with your traffic statistics to decide if the website must be optimized or transferred to a different sort of hosting platform which will be able to bear the high system load if the Internet site is very popular.
MySQL & Load Stats in Hosting
We generate comprehensive data about the system resource usage of every single hosting
account, so in case you host your websites on our sophisticated cloud platform, you will be able to take a look at the data with only a few mouse clicks from your Hepsia CP. The data is available in 2 different sections. The first one will 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 Internet sites used and what different kinds of processes produced the load. Stats are created every 6 hours. You are able to see everyday and monthly stats as well. In the second section you shall find all of the databases that you have created in the account and for each one of them you will see the amount of per hour and daily queries. The info shall give you a definitive picture of the overall performance of your websites, especially if you compare it to the daily traffic and visitor statistics.
MySQL & Load Stats in Semi-dedicated Hosting
If you have a semi-dedicated server
account with our company, you shall be able to access rather comprehensive CPU and MySQL load data which will give you addiitional information about the performance of your websites. Two sections of the Hepsia CP are dedicated to the statistics, one for each type. Within the CPU Load section you can see the execution time of your scripts and the length of time the web server processed them. You can even see the different types of processes that were executed. Stats are created every 6 hours, but if necessary, you can also check statistics for previous days or months. The MySQL Load section shall show you the entire amount of database queries each and every day and on an hourly basis, plus the queries to each individual database which you have within your semi-dedicated account. Comparing this info to your traffic statistics shall give you valuable information about how your Internet sites perform and you will determine if you must take some measures to improve them.