MySQL & Load Stats

See what type of data is gathered in the MySQL & Load Stats area and just how you can benefit from it.

If you have an HTML Internet site, it likely uses a small amount of resources because it is static, but this isn't so with dynamic database-driven websites that use PHP scripts and provide considerably more features. Such Internet sites create load on the hosting server each and every time somebody browses them, simply because the server requires 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, as an illustration, stores all usernames and posts in a database, so some load is created every single time a thread is opened or a user searches for a given term. If many people access the forum at the same time, or if every single search involves checking hundreds of thousands of database entries, this could generate high load and affect the performance of the Internet site. In this regard, CPU and MySQL load data can give you information about the site’s performance, as you can compare the numbers with your traffic statistics to decide if the website needs to be optimized or moved to another kind of hosting platform that'll be able to bear the high system load in the event that the site is very popular.

: MySQL & Load Stats in Cloud Website Hosting

If you host your Internet sites within a cloud website hosting account with our company, you will have access to thorough CPU and MySQL data which will allow you to keep an eye on their operation. You are able to see the statistics with a number of clicks inside your Hepsia Control Panel. The CPU Load section will reveal to you the total time the hosting server spent on your scripts and how much memory was required, plus the time it took for the scripts to be executed. The day-to-day view is the default one, but you could also see the numbers from the preceding months. The MySQL Load section offer more details about the number of queries to every single database that you have created inside the account. Once again, you can see per month, daily and hourly data, that shall give you data that is different from the traffic or the number of visitors you get. This way, you can determine if the sites need some optimization.; MySQL & Load Stats in Semi-dedicated Servers

Our system creates in depth statistics about both different types of load, so if you acquire a semi-dedicated server for your websites, you can access the data with just a few mouse clicks in your Hepsia hosting Control Panel. Each kind of info is listed in its own section. The CPU Load section shall tell you which processes created the load and the span of time it took for the web server to execute every one of the requests. Though stats are created every 6 hours, you can see daily and monthly stats as well. In the MySQL Load section you shall find a list of all the databases produced within your semi-dedicated account manually and automatically, what amount of queries were sent to each of them, the total day-to-day queries for the account as a whole, plus the average per hour rate. This info will help you determine how well your Internet sites perform and if any of them needs optimization of some kind.