MySQL & Load Stats
Discover the kind of information is gathered in the MySQL & Load Stats section and exactly how you'll be able to reap the benefits of it.
If you have an HTML Internet site, in all probability it uses a really small amount of system resources as it's static, but this isn't so with dynamic database-driven sites that use PHP scripts and provide a lot more functions. Such websites generate load on the website hosting server every time someone browses them, as the hosting server requires time to execute the script, to access the database and then to deliver the content requested by the visitor's Internet browser. A well known discussion board, as an illustration, stores all usernames and posts within a database, so some load is created every single time a thread is opened or an end user looks for a specific term. If a lot of people connect to the forum concurrently, or if each and every search involves checking thousands of database entries, this can create high load and affect the performance of the site. In this regard, CPU and MySQL load stats can present you with data about the site’s performance, as you can compare the numbers with your traffic statistics to decide if the website has to be optimized or moved to a new sort of web hosting platform that'll be able to bear the high system load in case the website is extremely popular.
-
MySQL & Load Stats in Hosting
Our system keeps comprehensive info about the system resource usage of each
hosting account which is created on our top-notch cloud platform, so in case you decide to host your Internet sites with us, you will have full access to this info via the Hepsia Control Panel, which you shall get with the account. The CPU load data include the CPU time and the actual execution time of your scripts, and what amount of system memory they used. You can also see what processes created the load - PHP or Perl scripts, cron jobs, and so forth. The MySQL load statistics section will show you the amount of queries to each individual database you have created within your shared hosting account, the total queries for the account overall and the normal hourly rate. Comparing these figures to the site visitor stats shall tell you if your websites perform the way they should or if they require some optimization, that will improve their functionality and the overall site visitor experience.
-
MySQL & Load Stats in Semi-dedicated Hosting
If you have a
semi-dedicated server account with our company, you will be able to access very detailed CPU and MySQL load statistics that will give you more information about the efficiency of your websites. 2 sections of the Hepsia CP are committed to the statistics, one for each kind. Within the CPU Load section you can see the execution time of your scripts and the span of time the server processed them. You can also see the different kinds of processes which were executed. Stats are generated every six hours, but if required, you could also check data for previous days or months. The MySQL Load section shall show you the total number of database queries daily and per hour, along with the queries to each individual database you have in your semi-dedicated account. Comparing this data to your traffic stats will give you useful information about how your websites perform and you will see if you have to take some measures to improve them.