MySQL & Load Stats
What type of info is available in the MySQL & Load Stats section? How could you take full advantage of it?
If you have an HTML Internet site, it likely uses a very small amount of system resources because it is static, but this isn't the case with dynamic database-driven websites that use PHP scripts and offer way more features. This kind of websites produce load on the hosting server each and every time anyone browses them, as the web server needs time to execute the script, to access the database and then to supply the information requested by the visitor's Internet browser. A well-known discussion board, for instance, 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 particular phrase. If many people access the forum at the same time, or if every single search involves checking hundreds of thousands of database entries, this can produce high load and affect the performance of the Internet site. In this regard, CPU and MySQL load data can provide you with info about the site’s functionality, as you can compare the numbers with your traffic stats and see if the website needs to be optimized or transferred to another type of hosting platform that'll be able to bear the high system load in case the site is really popular.
-
MySQL & Load Stats in Shared Hosting
We generate thorough stats about the system resource usage of every
shared hosting account, so in the event that you host your sites on our highly developed cloud platform, you'll be able to check the statistics with just a few mouse clicks from your Hepsia CP. The data is supplied in 2 different sections. The first one will show you the span of time our system spent serving your Internet sites, the total time it took for your scripts to be executed, how much memory sites used and what types of processes generated the load. Stats are created every six hours. You're able to see day-to-day and per month stats also. In the second section you'll find all the databases that you have created inside the account and for each one of them you'll see the total amount of hourly and daily queries. The data will give you a definitive picture of the performance of your websites, especially if you compare it to the daily traffic and visitor data.
-
MySQL & Load Stats in Semi-dedicated Servers
If you have a
semi-dedicated server account with us, you shall be able to access very comprehensive CPU and MySQL load stats that'll give you additional information about the functionality of your sites. 2 sections of the Hepsia CP are devoted to the stats, one for each and every kind. In the CPU Load section you could see the execution time of your scripts and the length of time the hosting server processed them. Additionally you can see the kinds of processes which were executed. Stats are produced every six hours, but if necessary, you can also check figures for previous days or months. The MySQL Load section shall show you the entire amount of database queries per day and on an hourly basis, as well as the queries to each individual database which you have within your semi-dedicated account. Comparing this info to your traffic statistics will give you valuable information about how your Internet sites perform and you will see if you must take some measures to enhance them.